public int sendSMS()
{
try
{
var accountSid = "AC194a875ea62f4ccaba8400b3df223acd";
// Your Auth Token from twilio.com/console
var authToken = "4234556c7698862e49c7ac8867c3443f";
TwilioClient.Init(accountSid, authToken);
var message = MessageResource.Create(
to: new PhoneNumber("+19522974157"),
from: new PhoneNumber("+19522220256"),
body: "Hello from Common DLL");
Console.WriteLine(message.Sid);
Console.Write("Press any key to continue.");
Console.ReadKey();
}
catch (Exception objEx)
{
Helpers.LogExceptionInFlatFile(objEx);
}
return(0);
}
//http://csharp.net-informations.com/dataadapter/updatecommand-sqlserver.htm
public static void getDataSet()
{
try
{
}
catch (Exception objEx)
{
Helpers.LogExceptionInFlatFile(objEx);
}
}
private static void updateData(string strLoginID, string strHashedPwdText)
{
string connetionString = null;
SqlConnection connection;
SqlDataAdapter adapter = new SqlDataAdapter();
string sql = null;
connetionString = "data source=103.235.104.24;initial catalog=VishwakarmaMugurtham;user id=VishMugAdmin;password=Swingsys@!1";
connection = new SqlConnection(connetionString);
sql = "update portaluser set password = '******' where loginid = '" + strLoginID + "'";
try
{
connection.Open();
adapter.UpdateCommand = connection.CreateCommand();
adapter.UpdateCommand.CommandText = sql;
adapter.UpdateCommand.ExecuteNonQuery();
//MessageBox.Show("Row updated !! ");
}
catch (Exception objEx)
{
Helpers.LogExceptionInFlatFile(objEx);
}
}
private int getConnectionString()
{
try
{
if (_CommunityID == "1")
{
_CommunityName = "Aadhidhravidar";
_AppKeyConnectionstring = "AdidravidarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "2")
{
_CommunityName = "Agamudayar";
_AppKeyConnectionstring = "AgamudayarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "3")
{
_CommunityName = "Brahmin";
_AppKeyConnectionstring = "BrahminMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "4")
{
_CommunityName = "Christian";
_AppKeyConnectionstring = "ChristianMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "5")
{
_CommunityName = "Gounder";
_AppKeyConnectionstring = "GounderMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "6")
{
_CommunityName = "Maruthuvar";
_AppKeyConnectionstring = "MaruthuvarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "7")
{
_CommunityName = "Mudaliyar";
_AppKeyConnectionstring = "MudaliyarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "8")
{
_CommunityName = "Mukkulathor";
_AppKeyConnectionstring = "MukkulathorMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "9")
{
_CommunityName = "Nadar";
_AppKeyConnectionstring = "NadarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "10")
{
_CommunityName = "Naidu";
_AppKeyConnectionstring = "NaiduMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "11")
{
_CommunityName = "Others";
_AppKeyConnectionstring = "OthersMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "12")
{
_CommunityName = "Padayachi";
_AppKeyConnectionstring = "PadayachiMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "13")
{
_CommunityName = "Parvatharajakulam";
_AppKeyConnectionstring = "ParvatharajakulamMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "14")
{
_CommunityName = "Pillai";
_AppKeyConnectionstring = "PillaiMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "15")
{
_CommunityName = "Reddiar";
_AppKeyConnectionstring = "ReddiarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "16")
{
_CommunityName = "ReMarriage";
_AppKeyConnectionstring = "ReMarriageMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "17")
{
_CommunityName = "Thevar";
_AppKeyConnectionstring = "ThevarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "18")
{
_CommunityName = "Udayar";
_AppKeyConnectionstring = "UdayarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "19")
{
_CommunityName = "vanniyar";
_AppKeyConnectionstring = "VanniyarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "20")
{
_CommunityName = "Vellalar";
_AppKeyConnectionstring = "VellalarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "21")
{
_CommunityName = "Vishwakarma";
_AppKeyConnectionstring = "VishwakarmaMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "22")
{
_CommunityName = "Yadava";
_AppKeyConnectionstring = "YadavaMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
else if (_CommunityID == "23")
{
_CommunityName = "CasteNoBar";
_AppKeyConnectionstring = "CasteNoBarMugurtham";
_Connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings[_AppKeyConnectionstring].ConnectionString;
}
}
catch (Exception objEx)
{
Helpers.LogExceptionInFlatFile(objEx);
}
return(0);
}
public static void getDataSet1()
{
string connetionString = null;
SqlConnection connection;
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
int i = 0;
string firstSql = null;
string secondSql = null;
connetionString = "data source=103.235.104.24;initial catalog=VishwakarmaMugurtham;user id=VishMugAdmin;password=Swingsys@!1";
firstSql = "Select * from portaluser";
secondSql = "Select * from profilebasicinfo";
connection = new SqlConnection(connetionString);
//SqlDataAdapter objUpdateadapter = new SqlDataAdapter();
string strSQL = string.Empty;
try
{
connection.Open();
command = new SqlCommand(firstSql, connection);
adapter.SelectCommand = command;
adapter.Fill(ds, "First Table");
adapter.SelectCommand.CommandText = secondSql;
adapter.Fill(ds, "Second Table");
adapter.Dispose();
command.Dispose();
connection.Close();
//retrieve first table data
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
//MessageBox.Show(ds.Tables[0].Rows[i].ItemArray[0] + " -- " + ds.Tables[0].Rows[i].ItemArray[1]);
//Helpers.LogMessage(ds.Tables[0].Rows[i].ItemArray[3] + " -- " + Helpers.EncodePasswordToBase64(ds.Tables[0].Rows[i].ItemArray[3].ToString()));
//updateData(ds.Tables[0].Rows[i].ItemArray[2].ToString(), Helpers.EncodePasswordToBase64(ds.Tables[0].Rows[i].ItemArray[3].ToString()));
strSQL = "update portaluser set password = '******' where loginid = '" + ds.Tables[0].Rows[i].ItemArray[2].ToString() + "'";
Helpers.LogMessageInFlatFile1(strSQL);
//objUpdateadapter.UpdateCommand = connection.CreateCommand();
//objUpdateadapter.UpdateCommand.CommandText = strSQL;
//objUpdateadapter.UpdateCommand.ExecuteNonQuery();
}
//objUpdateadapter.Dispose();
//retrieve second table data
for (i = 0; i <= ds.Tables[1].Rows.Count - 1; i++)
{
//MessageBox.Show(ds.Tables[1].Rows[i].ItemArray[0] + " -- " + ds.Tables[1].Rows[i].ItemArray[1]);
}
}
catch (Exception objEx)
{
Helpers.LogExceptionInFlatFile(objEx);
}
}