private void Job_New_Save(DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e)
{
DateTime date = DateTime.Now;
string time4 = date.ToString("HHmm");
string jobType = SafeValue.SafeString(cbb_new_jobtype.Value, "CRA");
string jobType1 = jobType;
string jobno = "";
string jobStatus = SafeValue.SafeString(cbb_new_jobstatus.Text, "Quoted");
string user = HttpContext.Current.User.Identity.Name;
string quoteNo = "";
if (jobStatus == "Quoted")
{
quoteNo = C2Setup.GetNextNo("", "CTM_Job_" + jobStatus, date);
}
else
{
jobno = C2Setup.GetNextNo("", "CTM_Job_" + jobType1, date);
quoteNo = jobno;
}
string wh = System.Configuration.ConfigurationManager.AppSettings["Warehosue"];
string sql = string.Format(@"insert into CTM_Job (JobNo,JobDate,EtaDate,EtdDate,CodDate,StatusCode,CreateBy,CreateDatetime,UpdateBy,UpdateDatetime,EtaTime,EtdTime,JobType,ClientId,YardRef,PickupFrom,DeliveryTo,Remark,WarehouseAddress,JobStatus,QuoteNo,QuoteStatus,QuoteDate,WareHouseCode,IsAdhoc) values ('{0}','{4}',getdate(),getdate(),getdate(),'USE','{1}',getdate(),'{1}',getdate(),'{2}','{2}','{3}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','Pending',getdate(),'{13}','Yes')", jobno, user, time4, cbb_new_jobtype.Value, txt_new_JobDate.Date, btn_new_ClientId.Text, "", "", txt_ToAddress.Text, txt_new_remark.Text, "", jobStatus, quoteNo, wh);
int i = ConnectSql_mb.ExecuteNonQuery(sql);
if (i == 1)
{
if (jobStatus == "Quoted")
{
C2Setup.SetNextNo("", "CTM_Job_" + jobStatus, quoteNo, date);
//GetJobRate(quoteNo, btn_new_ClientId.Text, SafeValue.SafeString(cbb_new_jobtype.Value));
e.Result = quoteNo;
}
else
{
C2Setup.SetNextNo("", "CTM_Job_" + jobType1, jobno, date);
e.Result = jobno;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = HttpContext.Current.User.Identity.Name;
elog.fixActionInfo_ByJobNo(jobno);
elog.Remark = "New Job";
elog.log();
}
}
}
