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