public string SaveTSMailService(TSMsilServiceType.TSMailServiceDataType _SaveData) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Insert Into tblservicetimer (" + "TimerID," + "Occurence," + "TriggerDate," + "TriggerTime," + "NofTime," + "CurrentCount," + "TriggerStatus," // + "SQLStatement," + "WhereC0ndition," + "SearchText," + "SearchValue," + "CustomerID,MailListID,MailSubject,BoadyHeader,MailCategory)" + " Values (" + "@TimerID," + "@Occurence," + "@TriggerDate," + "@TriggerTime," + "@NofTime," + "@CurrentCount," + "@TriggerStatus," // + "@SQLStatement," + "@WhereC0ndition," + "@SearchText," + "@SearchValue," + "@CustomerID,@MailListID,@MailSubject,@BoadyHeader,@MailCategory)"; try { oSqlCommand.Parameters.AddWithValue("@TimerID", _SaveData.TimerID); oSqlCommand.Parameters.AddWithValue("@Occurence", _SaveData.Occurence); oSqlCommand.Parameters.AddWithValue("@TriggerDate", _SaveData.TriggerDate); oSqlCommand.Parameters.AddWithValue("@TriggerTime", _SaveData.TriggerTime); oSqlCommand.Parameters.AddWithValue("@NofTime", _SaveData.NofTime); oSqlCommand.Parameters.AddWithValue("@CurrentCount", _SaveData.CurrentCount); oSqlCommand.Parameters.AddWithValue("@TriggerStatus", _SaveData.TriggerStatus); // oSqlCommand.Parameters.AddWithValue("@SQLStatement", _SaveData.SQLStatement); oSqlCommand.Parameters.AddWithValue("@WhereC0ndition", _SaveData.WhereC0ndition); oSqlCommand.Parameters.AddWithValue("@SearchText", _SaveData.SearchText); oSqlCommand.Parameters.AddWithValue("@SearchValue", _SaveData.SearchValue); oSqlCommand.Parameters.AddWithValue("@CustomerID", _SaveData.CustomerID); oSqlCommand.Parameters.AddWithValue("@MailListID", _SaveData.MailListID); //MailSubject,BoadyHeader,MailCategory oSqlCommand.Parameters.AddWithValue("@MailSubject", _SaveData.MailSubject); oSqlCommand.Parameters.AddWithValue("@BoadyHeader", _SaveData.BoadyHeader); oSqlCommand.Parameters.AddWithValue("@MailCategory", _SaveData.MailCategory); string respond = Mycommon.ExicuteAnyCommand(sqlQuery, oSqlCommand, null, "Save TSMailService"); return(respond); } catch (Exception ex) { return(ex.Message); } }
public string UpdateTSMailService(TSMsilServiceType.TSMailServiceDataType _Update) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Update tblservicetimer Set " + "TimerID=@TimerID," + "Occurence=@Occurence," + "TriggerDate=@TriggerDate," + "TriggerTime=@TriggerTime," + "NofTime=@NofTime," + "CurrentCount=@CurrentCount," + "TriggerStatus=@TriggerStatus," + "SQLStatement=@SQLStatement," + "WhereC0ndition=@WhereC0ndition," + "SearchText=@SearchText," + "SearchValue=@SearchValue," + "CustomerID=@CustomerID," + "MailListID=@MailListID," + "MailSubject=@MailSubject," + "BoadyHeader=@BoadyHeader," + "MailCategory=@MailCategory" + " Where 1=1 " + " and TimerID=@TimerID"; try { oSqlCommand.Parameters.AddWithValue("@TimerID", _Update.TimerID); oSqlCommand.Parameters.AddWithValue("@Occurence", _Update.Occurence); oSqlCommand.Parameters.AddWithValue("@TriggerDate", _Update.TriggerDate); oSqlCommand.Parameters.AddWithValue("@TriggerTime", _Update.TriggerTime); oSqlCommand.Parameters.AddWithValue("@NofTime", _Update.NofTime); oSqlCommand.Parameters.AddWithValue("@CurrentCount", _Update.CurrentCount); oSqlCommand.Parameters.AddWithValue("@TriggerStatus", _Update.TriggerStatus); oSqlCommand.Parameters.AddWithValue("@SQLStatement", _Update.SQLStatement); oSqlCommand.Parameters.AddWithValue("@WhereC0ndition", _Update.WhereC0ndition); oSqlCommand.Parameters.AddWithValue("@SearchText", _Update.SearchText); oSqlCommand.Parameters.AddWithValue("@SearchValue", _Update.SearchValue); oSqlCommand.Parameters.AddWithValue("@CustomerID", _Update.CustomerID); oSqlCommand.Parameters.AddWithValue("@MailListID", _Update.MailListID); oSqlCommand.Parameters.AddWithValue("@MailSubject", _Update.MailSubject); oSqlCommand.Parameters.AddWithValue("@BoadyHeader", _Update.BoadyHeader); oSqlCommand.Parameters.AddWithValue("@MailCategory", _Update.MailCategory); string respond = Mycommon.ExicuteAnyCommand(sqlQuery, oSqlCommand, null, "Update TSMailService"); return(respond); } catch (Exception ex) { return(ex.Message); } }
public string GetExistTSMailService(string TimerID, out TSMsilServiceType.TSMailServiceDataType _ExistData) { _ExistData = new TSMsilServiceType.TSMailServiceDataType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "SysID," + "TimerID," + "Occurence," + "TriggerDate," + "TriggerTime," + "NofTime," + "CurrentCount," + "TriggerStatus," + "SQLStatement," + "WhereC0ndition," + "SearchText," + "SearchValue," + "CustomerID,MailListID" + " from tblservicetimer" + " Where 1=1 " + " and TimerID=@TimerID"; oSqlCommand.Parameters.AddWithValue("@TimerID", TimerID); DataRow r = Mycommon.GetDataRow(sqlQuery, oSqlCommand, null, "Get Exist data TSMailService"); if (r != null) { try { bool resp = false; int inSysID = 0; resp = int.TryParse(r["SysID"].ToString(), out inSysID); _ExistData.SysID = inSysID; _ExistData.TimerID = r["TimerID"].ToString(); _ExistData.Occurence = r["Occurence"].ToString(); DateTime dtTriggerDate = new DateTime(1900, 1, 1); resp = DateTime.TryParse(r["TriggerDate"].ToString(), out dtTriggerDate); if (resp) { _ExistData.TriggerDate = dtTriggerDate; } else { _ExistData.TriggerDate = new DateTime(1900, 1, 1); } _ExistData.TriggerTime = r["TriggerTime"].ToString(); int inNofTime = 0; resp = int.TryParse(r["NofTime"].ToString(), out inNofTime); _ExistData.NofTime = inNofTime; int inCurrentCount = 0; resp = int.TryParse(r["CurrentCount"].ToString(), out inCurrentCount); _ExistData.CurrentCount = inCurrentCount; int inTriggerStatus = 0; resp = int.TryParse(r["TriggerStatus"].ToString(), out inTriggerStatus); _ExistData.TriggerStatus = inTriggerStatus; _ExistData.SQLStatement = r["SQLStatement"].ToString(); _ExistData.WhereC0ndition = r["WhereC0ndition"].ToString(); _ExistData.SearchText = r["SearchText"].ToString(); _ExistData.SearchValue = r["SearchValue"].ToString(); int inCustomerID = 0; resp = int.TryParse(r["CustomerID"].ToString(), out inCustomerID); _ExistData.CustomerID = inCustomerID; _ExistData.MailListID = r["MailListID"].ToString(); return("True"); } catch (Exception ex) { return(ex.Message); } } else { return("Data not Found "); } }
public string GetExistTSMailService(string TimerID, out TSMsilServiceType.TSMailServiceDataType _ExistData) { _ExistData = new TSMsilServiceType.TSMailServiceDataType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "SysID," + "TimerID," + "Occurence," + "TriggerDate," + "TriggerTime," + "NofTime," + "CurrentCount," + "TriggerStatus," + "SQLStatement," + "WhereC0ndition," + "SearchText," + "SearchValue," + "CustomerID,MailListID" + " from tblservicetimer" + " Where 1=1 " + " and TimerID=@TimerID"; oSqlCommand.Parameters.AddWithValue("@TimerID", TimerID); DataRow r = Mycommon.GetDataRow(sqlQuery, oSqlCommand, null, "Get Exist data TSMailService"); if (r != null) { try { bool resp = false; int inSysID = 0; resp = int.TryParse(r["SysID"].ToString(), out inSysID); _ExistData.SysID = inSysID; _ExistData.TimerID = r["TimerID"].ToString(); _ExistData.Occurence = r["Occurence"].ToString(); DateTime dtTriggerDate = new DateTime(1900, 1, 1); resp = DateTime.TryParse(r["TriggerDate"].ToString(), out dtTriggerDate); if (resp) _ExistData.TriggerDate = dtTriggerDate; else _ExistData.TriggerDate = new DateTime(1900, 1, 1); _ExistData.TriggerTime = r["TriggerTime"].ToString(); int inNofTime = 0; resp = int.TryParse(r["NofTime"].ToString(), out inNofTime); _ExistData.NofTime = inNofTime; int inCurrentCount = 0; resp = int.TryParse(r["CurrentCount"].ToString(), out inCurrentCount); _ExistData.CurrentCount = inCurrentCount; int inTriggerStatus = 0; resp = int.TryParse(r["TriggerStatus"].ToString(), out inTriggerStatus); _ExistData.TriggerStatus = inTriggerStatus; _ExistData.SQLStatement = r["SQLStatement"].ToString(); _ExistData.WhereC0ndition = r["WhereC0ndition"].ToString(); _ExistData.SearchText = r["SearchText"].ToString(); _ExistData.SearchValue = r["SearchValue"].ToString(); int inCustomerID = 0; resp = int.TryParse(r["CustomerID"].ToString(), out inCustomerID); _ExistData.CustomerID = inCustomerID; _ExistData.MailListID =r["MailListID"].ToString(); return "True"; } catch (Exception ex) { return ex.Message; } } else return "Data not Found "; }