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(string KeyVal, TSMsilServiceType.TSMailServiceDataType _Update)
{
MySqlCommand oSqlCommand = new MySqlCommand();
string sqlQuery = "Update tblservicetimer Set "
+ "Occurence=@Occurence,"
+ "TriggerDate=@TriggerDate,"
+ "TriggerTime=@TriggerTime,"
+ "NofTime=@NofTime,"
+ "CurrentCount=@CurrentCount,"
+ "TriggerStatus=@TriggerStatus,"
+ "SQLStatement=@SQLStatement,"
+ "WhereC0ndition=@WhereC0ndition,"
+ "SearchText=@SearchText,"
+ "CustomerID=@CustomerID,"
+ "MailListID=@MailListID,"
+ "MailSubject=@MailSubject,"
+ "BoadyHeader=@BoadyHeader,"
+ "MailCategory=@MailCategory"
+ " Where 1=1 "
+ " and SearchValue=@SearchValue";
try
{
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", KeyVal);
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 MakeSqlStatement(TSMsilServiceType.EmailServiceInstance Mailtype, out string ConformNeedToSend, out string AckoneladmentMailBoady)
{
AckoneladmentMailBoady = "";
ConformNeedToSend = "";
try
{
switch (Mailtype)
{
case TSMsilServiceType.EmailServiceInstance.Acknowladement:
ConformNeedToSend = "SELECT count(tblforderacknowladgmentdetails.POLineNumber) as NofTime FROM tsfs.tblfcustomerpodetails "
+ " INNER JOIN tsfs.tblforderacknowladgmentdetails ON tblfcustomerpodetails.DetailRef = tblforderacknowladgmentdetails.POLineNumber where tblfcustomerpo.COrderNumber";
AckoneladmentMailBoady = "Select CustomerPN, CellType, RequiredQty, ShippingDate from tblfcustomerpodetails where CPONumber";
break;
case TSMsilServiceType.EmailServiceInstance.EmployeePermentLetter:
break;
case TSMsilServiceType.EmailServiceInstance.InvoiceClear:
break;
default:
break;
}
return "True";
}
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 MakeTriggerDateAndtime(TSMsilServiceType.EmailServiceInstance InstanceType , DateTime InDate, out DateTime OutDate, out string OutTime)
{
OutDate = new DateTime();
OutTime = "00:00";
try
{
switch (InstanceType)
{
case TSMsilServiceType.EmailServiceInstance.Acknowladement:
DateTime Out1 = InDate.AddDays(2);
OutDate = Out1;
OutTime = "07:30";
break;
case TSMsilServiceType.EmailServiceInstance.EmployeePermentLetter:
break;
default:
break;
}
return "True";
}
catch (Exception ex)
{
return ex.Message;
}
}
