Web API Call in Flutter

import 'dart:async';
import 'dart:convert';
import 'dart:io';

class MainController{

//API Access URL
final String url = 'https://xxxxx.com/';

Future CallAPI(String Controler,Map map) async {

HttpClient client = new HttpClient();
client.badCertificateCallback = ((X509Certificate cert, String host, int port) => true);
HttpClientRequest request = await client.postUrl(Uri.parse(url+Controler));
request.headers.set('content-type', 'application/json');
request.add(utf8.encode(json.encode(map)));
HttpClientResponse response = await request.close();
String reply = await response.transform(utf8.decoder).join();
print(reply);
return reply;

}
Future LoginCValidate(String Email,String Password) async {
//Post Request Body
Map map = {
"Email" : Email ,
"Password" : Password
};

//Call API 
//YourControllerName = Rest of the your Request URL
Future Result = CallAPI('YourControllerName',map);
print(Result);
}
}

 

Change SA Password in SQL Server

GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'newpassword' 
GO

Get Sri Lanka Local time in server-side using C#

           
DateTime serverTime = DateTime.Now; // gives you current Time in server timeZone
DateTime utcTime = serverTime.ToUniversalTime(); // convert it to Utc using timezone setting of server computer 
           
DateTime localTime = TimeZoneInfo.ConvertTimeFromUtc(utcTime, TimeZoneInfo.FindSystemTimeZoneById("Sri Lanka Standard Time"));

How to insert values in temp table on multiple times

INSERT INTO [dbo].[tbl_final] (col1, col2, ...) -- not include DateCreated 
EXEC YourSP -- return the field order should be the same as the column order

Remove specific part of the string in SQL Server

declare @value as varchar(100)
set @value = 'The string / unwanted'
select  stuff(@value,1, CHARINDEX('/',@value),'')
select  stuff(@value,CHARINDEX('/',@value), len(@value) ,'')

Split a string and loop in SQL Server

declare @list varchar(max)
declare @pos int
declare @len int
declare @value varchar(max)

set @list = 'a1a1a1,b2b2b2b,c3c3c3c,d4d4d4d4,'

set @pos = 0
set @len = 0

WHILE CHARINDEX(',', @list, @pos+1)>0
BEGIN
set @len = CHARINDEX(',', @list, @pos+1) - @pos
set @value = SUBSTRING(@list, @pos, @len)

print @value 

--Your query

set @pos = CHARINDEX(',', @list, @pos+@len) +1
END

 

Call Sp in Entity Framework C#


SqlParameter SQL_Parameter= new SqlParameter("@ParamName", "Value");

var ResultList= Context.Database.SqlQuery("exec SP_Name @ParamName", SQL_Parameter).ToList();


Convert Table Column Into C# Model Class

SQL

1. CREATE PROCEDURE CREATEMODEL  
2. (  
3.      @TableName SYSNAME ,  
4.      @CLASSNAME VARCHAR(500)   
5. )  
6. AS  
7. BEGIN  
8.     DECLARE @Result VARCHAR(MAX)  
9.   
10.     SET @Result = @CLASSNAME + @TableName + ‘  
11. {‘  
12.   
13. SELECT @Result = @Result + ‘  
14.     public ‘ + ColumnType + NullableSign + ‘ ‘ + ColumnName + ‘ { get; set; }’  
15. FROM  
16. (  
17.     SELECT   
18.         REPLACE(col.NAME, ‘ ‘, ‘_’) ColumnName,  
19.         column_id ColumnId,  
20.         CASE typ.NAME   
21.             WHEN ‘bigint’ THEN ‘long’  
22.             WHEN ‘binary’ THEN ‘byte[]’  
23.             WHEN ‘bit’ THEN ‘bool’  
24.             WHEN ‘char’ THEN ‘string’  
25.             WHEN ‘date’ THEN ‘DateTime’  
26.             WHEN ‘datetime’ THEN ‘DateTime’  
27.             WHEN ‘datetime2’ then ‘DateTime’  
28.             WHEN ‘datetimeoffset’ THEN ‘DateTimeOffset’  
29.             WHEN ‘decimal’ THEN ‘decimal’  
30.             WHEN ‘float’ THEN ‘float’  
31.             WHEN ‘image’ THEN ‘byte[]’  
32.             WHEN ‘int’ THEN ‘int’  
33.             WHEN ‘money’ THEN ‘decimal’  
34.             WHEN ‘nchar’ THEN ‘char’  
35.             WHEN ‘ntext’ THEN ‘string’  
36.             WHEN ‘numeric’ THEN ‘decimal’  
37.             WHEN ‘nvarchar’ THEN ‘string’  
38.             WHEN ‘real’ THEN ‘double’  
39.             WHEN ‘smalldatetime’ THEN ‘DateTime’  
40.             WHEN ‘smallint’ THEN ‘short’  
41.             WHEN ‘smallmoney’ THEN ‘decimal’  
42.             WHEN ‘text’ THEN ‘string’  
43.             WHEN ‘time’ THEN ‘TimeSpan’  
44.             WHEN ‘timestamp’ THEN ‘DateTime’  
45.             WHEN ‘tinyint’ THEN ‘byte’  
46.             WHEN ‘uniqueidentifier’ THEN ‘Guid’  
47.             WHEN ‘varbinary’ THEN ‘byte[]’  
48.             WHEN ‘varchar’ THEN ‘string’  
49.             ELSE ‘UNKNOWN_’ + typ.NAME  
50.         END ColumnType,  
51.         CASE   
52.             WHEN col.is_nullable = 1 and typ.NAME in (‘bigint’, ‘bit’, ‘date’, ‘datetime’, ‘datetime2’, ‘datetimeoffset’, ‘decimal’, ‘float’, ‘int’, ‘money’, ‘numeric’, ‘real’, ‘smalldatetime’, ‘smallint’, ‘smallmoney’, ‘time’, ‘tinyint’, ‘uniqueidentifier’)   
53.             THEN ‘?’   
54.             ELSE ”   
55.         END NullableSign  
56.     FROM SYS.COLUMNS col join sys.types typ on col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id  
57.     where object_id = object_id(@TableName)  
58. ) t  
59. ORDER BY ColumnId  
60. SET @Result = @Result  + ‘  
61. }’  
62.   
63. print @Result  
64.   
65. END

Get your Model Code –> exec CREATEMODEL ‘YourClassName’, ‘public class ‘  

Reference: https://www.c-sharpcorner.com/blogs/table-column-convert-as-c-sharp-model-class

Send Email using C# (Asp.net)

1. Create a HTML page for Email body.
   • • Set some parameters inside html page to send dynamic emails.
2. Call SendMail Method.

Example HTML,

<html>
<body>

<h1>Test Mail #Some_Unic_ID1# </h1>

<p>My test  #Some_Unic_ID2# </p>

</body>
</html>

save this html as tsetMail.html

user this method to send email.Pass tsetMail.html path

public void SendMail(string tsetMailPath)

   {

           try

           {

               //Fetching Settings from WEB.CONFIG file.

               string NameOfEmailSender =    ConfigurationManager.AppSettings[“NameOfEmailSender”].ToString();

               string NameOfSenderPassword = ConfigurationManager.AppSettings[“NameOfSenderPassword”].ToString();

               string emailSenderHost = ConfigurationManager.AppSettings[“NameOfSmtpServer”].ToString();

               int emailSenderPort = Convert.ToInt16(ConfigurationManager.AppSettings[“NameOFPortNumber”]);

               Boolean SSLTrueOrFalse = Convert.ToBoolean(ConfigurationManager.AppSettings[“SSLTrueOrFalse”]);               //Fetching Email Body Text from EmailTemplate File.

               string FilePath = tsetMailPath;

               StreamReader str = new StreamReader(FilePath);

               string MailText = str.ReadToEnd();

               str.Close();

               MailText = MailText.Replace(“#Some_Unic_ID1#”, “Pass Some Vale”);

               MailText = MailText.Replace(“#Some_Unic_ID2#”, “Another value”);

stringsubject=”Mail subject test”;               //Base class for sending email

               MailMessage _mailmsg = new MailMessage();               //Make TRUE because our body text is html

               _mailmsg.IsBodyHtml = true;               //Set From Email ID

               _mailmsg.From = new MailAddress(NameOfEmailSender);               //Set To Email ID

               _mailmsg.To.Add(“Reciver_mail@gmail.com”);               //set CC

               _mailmsg.CC.Add(“CC_Mail@gmail.com”);                    //Set Subject

               _mailmsg.Subject = subject;               //Set Body Text of Email

               _mailmsg.Body = MailText;               //Now set your SMTP

               SmtpClient _smtp = new SmtpClient();

             _smtp.UseDefaultCredentials = false;

            _smtp.Credentials = new System.Net.NetworkCredential(NameOfEmailSender, NameOfSenderPassword);               //Set HOST server SMTP detail

               _smtp.Host = emailSenderHost;               //Set PORT number of SMTP

               _smtp.Port = emailSenderPort;

           _smtp.DeliveryMethod = SmtpDeliveryMethod.Network;

                         //Set Sender UserEmailID, Password

               NetworkCredential _network = new NetworkCredential(NameOfEmailSender, NameOfSenderPassword);

               _smtp.Credentials = _network;               //Send Method will send your MailMessage create above.

               _smtp.Send(_mailmsg);

           }

           catch (Exception ex)

           {

           }

}

 

 

Add this to your web.config

<appSettings>

<add key=”NameOfSmtpServer” value=”yor server ex: 10.10.10.10″/>

<add key=”NameOFPortNumber” value=”your port ex:12″/>

<add key=”NameOfEmailSender” value=”Sender Email”/>

<add key=”NameOfSenderPassword” value=”Sender Email Password”/>

<add key=”SSLTrueOrFalse” value=”True or False”/>

</appSettings>

PHP service call using JavaScript

jQuery.ajax({
type: "POST",
url: 'http://localhost/SampleService/MyService.php',
dataType: 'json',
data: {functionname: 'Function_A',Parameter_A: "value A",Parameter_B: "value B"},
beforeSend: function (jqXHR, Settings) {
jqXHR.url = Settings.url;
$("#ShowPreLoader").show();
},
success: function (obj, textstatus) {

});
},
complete: function () {
$("#ShowPreLoader").hide();

}
});

In your PHP MyService.php

switch($_POST['functionname']) {
case 'Function_A':Function_A($_POST['Parameter_A'],$_POST['Parameter_B']);
break;
case 'Function_B':Function_B($_POST['Parameter_C']);
break;
case 'Function_C':Function_C();
break;
}

function Function_A($Parameter_A,$Parameter_B)
{
print_r(json_encode($ResultArray));
}