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); }