public void InsertUpdateTBScheduler(string username, string module, string strDateTime, string IsScheduledDaily)
{
try
{
string InsertQuery = "Insert into tb_Scheduler_Module (Module, ScheduledDateTime, IsScheduledDaily) VALUES ('" + module + "','" + strDateTime + "','" + IsScheduledDaily + "')";
DataBaseHandler.InsertQuery1(InsertQuery, "tb_Scheduler_Module");
}
catch (Exception)
{
string UpdateQuery = "UPDATE tb_Scheduler_Module SET ScheduledDateTime='" + strDateTime + "', IsScheduledDaily='" + IsScheduledDaily + "', IsAccomplished='" + "0" + "' WHERE Module='" + module + "'";
DataBaseHandler.UpdateQuery(UpdateQuery, "tb_Scheduler_Module");
}
}
public DataSet InsertorUpdateUserDetailsForDirectMessaging(string Screen_name, string FollowerCount, string FollowingCount, string username, string Password)
{
DataSet ds = new DataSet();
try
{
string strQuery = "Insert into tb_AccountSendDirectMessage values('" + username + "','" + Password + "','" + "" + "','" + "" + "','" + "" + "','" + System.DateTime.Now + "')";
DataBaseHandler.InsertQuery1(strQuery, "tb_AccountSendDirectMessage");
}
catch (Exception ex)
{
string query = "select * from tb_AccountSendDirectMessage where UserName='******'";
ds = DataBaseHandler.SelectQuery(query, "tb_AccountSendDirectMessage");
}
return(ds);
}
/// <summary>
/// Inserts Settings in DataBase
/// Updates if Settings already present
/// </summary>
/// <param name="module"></param>
/// <param name="filetype"></param>
/// <param name="filepath"></param>
public void InsertOrUpdateSetting(string module, string filetype, string filepath)
{
try
{
this.Upmodule = module;
this.Upfiletype = filetype;
this.Upfilepath = filepath;
string Upmodule = module;
string UPfiletype = filetype;
string strQuery = "INSERT INTO tb_Setting VALUES ('" + module + "','" + filetype + "','" + filepath + "') ";
DataBaseHandler.InsertQuery1(strQuery, "tb_Setting");
}
catch (Exception)
{
UpdateSettingData(Upmodule, Upfiletype, Upfilepath);
}
}
public DataSet InsertorUpdateUserDetailsForDirectMessaging(string Screen_name, string FollowerCount, string FollowingCount, string username, string Password)
{
DataSet ds = new DataSet();
try
{
string strQuery = "Insert into tb_AccountSendDirectMessage values('" + username + "','" + Password + "','" + "" + "','" + "" + "','" + "" + "','" + System.DateTime.Now + "')";
DataBaseHandler.InsertQuery1(strQuery, "tb_AccountSendDirectMessage");
}
catch (Exception ex)
{
string query = "select * from tb_AccountSendDirectMessage where UserName='******'";
ds = DataBaseHandler.SelectQuery(query, "tb_AccountSendDirectMessage");
//string strQuery = "UPDATE tb_AccountSendDirectMessage SET Screen_name = '" + Screen_name + "' , FollowerCount = '" + FollowerCount + "', FollowingCount = '" + FollowingCount + "' WHERE UserName = '******'";
//DataBaseHandler.UpdateQuery(strQuery, "tb_AccountSendDirectMessage");
//Globussoft.GlobusFileHelper.AppendStringToTextfileNewLine("Error --> InsertScreenNameFollower --> clsDBQueryManager --> " + ex.Message, Globals.Path_TwtErrorLogs);
}
return(ds);
}
