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