private void Event_Log(string jobNo, string level, int c, int id, string status)
{
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
if (level == "JOB")
{
elog.ActionLevel_isJOB(id);
elog.setActionLevel(id, CtmJobEventLogRemark.Level.Job, c, status);
}
if (level == "QUOTATION")
{
elog.ActionLevel_isJOB(id);
elog.setActionLevel(id, CtmJobEventLogRemark.Level.Quotation, c, status);
}
if (level == "CONT")
{
elog.ActionLevel_isCONT(id);
elog.setActionLevel(id, CtmJobEventLogRemark.Level.Container, c, status);
}
if (level == "TRIP")
{
elog.ActionLevel_isTRIP(id);
elog.setActionLevel(id, CtmJobEventLogRemark.Level.Trip, c, status);
}
elog.log_edi();
}
protected void gv_tpt_trip_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string action = e.Parameters;
if (action.Equals("Save"))
{
Trip_Update(sender, e, "");
Job_Save(sender, e);
}
if (action.Equals("Complete"))
{
string tripId = SafeValue.SafeString(lbl_TripId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");
C2.CtmJobDet2 trip = C2.Manager.ORManager.GetObject(query) as C2.CtmJobDet2;
trip.Statuscode = "C";
trip.FromDate = trip.BookingDate;
trip.FromTime = trip.BookingTime;
trip.ToDate = trip.BookingDate;
trip.ToTime = trip.BookingTime;
C2.Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(trip);
C2.CtmJobDet2.tripStatusChanged(trip.Id);
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = HttpContext.Current.User.Identity.Name;
elog.Remark = "Update Trip";
elog.ActionLevel_isTRIP(trip.Id);
elog.log();
e.Result = "Success";
}
}
private void Trip_Delete(object sender, ASPxGridViewCustomDataCallbackEventArgs e, string tripId)
{
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = HttpContext.Current.User.Identity.Name;
elog.ActionLevel_isTRIP(SafeValue.SafeInt(tripId, 0));
elog.Remark = "Trip delete";
elog.log();
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");
C2.CtmJobDet2 trip = C2.ManagerEdi.ORManager.GetObject(query) as C2.CtmJobDet2;
C2.ManagerEdi.ORManager.ExecuteDelete(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");
//C2.Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Updated);
//C2.Manager.ORManager.PersistChanges(trip);
//EGL_JobTrip_AfterEndTrip("", SafeValue.SafeString(trip.Det1Id, "0"));
string sql = string.Format(@"delete from job_cost where TripNo='{0}'", tripId);
C2.ManagerEdi.ORManager.ExecuteScalar(sql);
string re = HttpContext.Current.User.Identity.Name + "," + trip.Id + "," + trip.DriverCode;
e.Result = re;
}
public BizResult unVoidJob(string user)
{
BizResult res = new BizResult();
if (this.job != null && this.job.Id > 0)
{
this.job.StatusCode = "USE";
this.job.JobStatus = "Confirmed";
Manager.ORManager.StartTracking(this.job, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(this.job);
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = user;
elog.ActionLevel_isJOB(this.job.Id);
elog.setActionLevel(this.job.Id, CtmJobEventLogRemark.Level.Job, 8);
elog.log();
res.status = true;
}
else
{
res.context = "error: data empty";
}
return(res);
}
protected void grid_Transport_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e)
{
if (e.Parameters == "OK")
{
int update_error_rowcount = 0;
string user = HttpContext.Current.User.Identity.Name;
for (int i = 0; i < list.Count; i++)
{
try
{
Record r = list[i];
List <ConnectSql_mb.cmdParameters> par_list = new List <ConnectSql_mb.cmdParameters>();
par_list.Add(new ConnectSql_mb.cmdParameters("@Id", r.Id, SqlDbType.Int));
par_list.Add(new ConnectSql_mb.cmdParameters("@DriverCode", r.driver, SqlDbType.NVarChar, 100));
par_list.Add(new ConnectSql_mb.cmdParameters("@TptDate", r.TptDate, SqlDbType.NVarChar, 10));
par_list.Add(new ConnectSql_mb.cmdParameters("@TptTime", r.TptTime, SqlDbType.NVarChar, 10));
par_list.Add(new ConnectSql_mb.cmdParameters("@Statuscode", r.progress_new, SqlDbType.NVarChar, 10));
string sql_where = "";
if (r.progress_new == "P" || r.progress_new == "S")
{
sql_where = ",FromDate=@TptDate,FromTime=@TptTime";
}
if (r.progress_new == "C")
{
sql_where = ",ToDate=@TptDate,ToTime=@TptTime";
}
string sql = string.Format(@"update CTM_JobDet2 set DriverCode=@DriverCode,Statuscode=@Statuscode{0} where Id=@Id", sql_where);
// string.Format(@"update tpt_job set Driver='{1}',VehicleNo='{2}' where Id='{0}'", id, driver, progress);
//if (r.progress.Length == 0 && r.driver.Length > 0 && r.progress_new.Length == 0)
//{
// sql = string.Format(@"update tpt_job set Driver='{1}',JobProgress='Confirmed',DeliveryIndex='{2}',TptTime='{3}',TptDate='{4}' where Id='{0}'", r.Id, r.driver, r.index, r.TptTime, r.TptDate);
//}
//else
//{
// sql = string.Format(@"update tpt_job set Driver='{1}',DeliveryIndex='{2}',TptTime='{3}',JobProgress='{4}',TptDate='{5}' where Id='{0}'", r.Id, r.driver, r.index, r.TptTime, r.progress_new, r.TptDate);
//}
ConnectSql_mb.ExecuteNonQuery(sql, par_list);
C2.CtmJobDet2.tripStatusChanged(SafeValue.SafeInt(r.Id, 0));
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isWeb();
lg.Controller = user;
lg.setActionLevel(SafeValue.SafeInt(r.Id, 0), CtmJobEventLogRemark.Level.Trip, 4, ":" + r.progress_new);
lg.log();
}
catch
{
update_error_rowcount++;
}
}
if (update_error_rowcount > 0)
{
e.Result = update_error_rowcount + " Rows Save Error";
}
else
{
btn_Search_Click(null, null);
}
}
}
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, "IMP");
string jobStatus = SafeValue.SafeString(cbb_new_jobstatus.Text, "Quoted");
string jobType1 = jobType;
string jobno = "";
string user = HttpContext.Current.User.Identity.Name;
string quoteNo = "";
string billingType = "None";
if (jobType1 == "TPT")
{
billingType = "Job";
}
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,BillingType) 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}','{14}') select @@identity", jobno, user, time4, cbb_new_jobtype.Value, txt_new_JobDate.Date, btn_new_ClientId.Text, "", txt_FromAddress.Text, txt_ToAddress.Text, txt_new_remark.Text, "", jobStatus, quoteNo, wh, billingType);
int jobId = SafeValue.SafeInt(ConnectSql_mb.ExecuteScalar(sql), 0);
if (jobId > 0)
{
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
if (jobStatus == "Quoted")
{
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Quotation, 1);
elog.ActionLevel_isQuoted(jobId);
C2Setup.SetNextNo("", "CTM_Job_" + jobStatus, quoteNo, date);
//GetJobRate(quoteNo, btn_new_ClientId.Text, SafeValue.SafeString(cbb_new_jobtype.Value));
e.Result = quoteNo;
}
else
{
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Job, 1);
elog.ActionLevel_isJOB(jobId);
C2Setup.SetNextNo("", "CTM_Job_" + jobType1, jobno, date);
e.Result = jobno;
}
elog.log();
}
}
private void Event_Log(string jobNo, string status, string note)
{
ASPxLabel Id = this.grid_job.FindEditFormTemplateControl("lb_Id") as ASPxLabel;
string userId = HttpContext.Current.User.Identity.Name;
int jobId = SafeValue.SafeInt(Id.Text, 0);
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isJOB(jobId);
elog.Remark = note;
elog.log();
}
private void update_ContStatus_trip(int contId, string type, string statucCode)
{
string JobNo = SafeValue.SafeString(Request.QueryString["JobNo"]);
string isWarehouse = SafeValue.SafeString(Request.QueryString["isWarehouse"]);
string sql = "";
string status = "";
if (isWarehouse == "Yes")
{
if (type == "IMP")
{
status = "WHS-LD";
}
if (type == "EXP")
{
status = "WHS-MT";
}
if (type == "RET")
{
status = "Return";
}
sql = string.Format(@"update ctm_jobdet1 set StatusCode='{1}' where Id={0}", contId, status);
ConnectSql_mb.ExecuteNonQuery(sql);
}
if (isWarehouse == "No")
{
if (type == "IMP")
{
status = "Customer-LD";
}
if (type == "EXP")
{
status = "Customer-MT";
}
if (type == "RET")
{
status = "Return";
}
sql = string.Format(@"update ctm_jobdet1 set StatusCode='{1}' where Id={0}", contId, status);
ConnectSql_mb.ExecuteNonQuery(sql);
}
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isCONT(contId);
elog.setActionLevel(contId, CtmJobEventLogRemark.Level.Container, 4, status);
elog.log();
}
private string Trip_New(string jobType, int tripId)
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");
C2.CtmJobDet2 trip = C2.Manager.ORManager.GetObject(query) as C2.CtmJobDet2;
string sql = string.Format(@"select max(TripIndex) from CTM_JobDet2 where JobType=@JobType and JobNo=@JobNo");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@JobNo", no, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@JobType", jobType, SqlDbType.NVarChar, 100));
string maxIdex = SafeValue.SafeString(ConnectSql_mb.ExecuteScalar(sql, list).context, "//00");
int n = SafeValue.SafeInt(maxIdex.Substring(maxIdex.LastIndexOf("/") + 1), 0) + 1;
string str = (100 + n).ToString().Substring(1);
string fromCode = trip.ToCode;
string toCode = trip.FromCode;
trip.BookingDate = DateTime.Today;
trip.TripIndex = no + "/" + jobType + "/" + str;
trip.Self_Ind = "No";
trip.JobNo = no;
//trip.FromDate = DateTime.Today;
//trip.ToDate = DateTime.Today;
trip.CreateUser = HttpContext.Current.User.Identity.Name;
trip.CreateTime = DateTime.Now;
trip.UpdateUser = HttpContext.Current.User.Identity.Name;
trip.UpdateTime = DateTime.Now;
trip.JobType = jobType;
trip.TripCode = jobType;
trip.ReturnType = "Y";
trip.ToCode = toCode;
trip.FromCode = fromCode;
trip.Statuscode = "P";
C2.Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(trip);
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isJOB(trip.Id);
elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Trip, 1, "");
return(trip.Id + "_" + trip.TripIndex);
}
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();
}
}
}
public void ContainerDetail_readyExport(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
bool status = false;
string context = "";
string user = SafeValue.SafeString(job["user"]);
int contId = SafeValue.SafeInt(job["contId"], 0);
decimal wt = SafeValue.SafeDecimal(job["wt"], 0);
string remark = SafeValue.SafeString(job["remark"]);
string mobileNo = SafeValue.SafeString(job["mobileNo"]);
if (contId > 0)
{
C2.CtmJobDet1Biz bz = new C2.CtmJobDet1Biz(contId);
C2.CtmJobDet1 det1 = bz.getData();
if (det1 != null)
{
det1.Weight = wt;
det1.StatusCode = "Customer-LD";
det1.CfsStatus = "Completed";
det1.ScheduleStartDate = DateTime.Now;
det1.ScheduleStartTime = DateTime.Now.ToString("HH:mm");
det1.CompletionDate = det1.ScheduleStartDate;
det1.CompletionTime = det1.ScheduleStartTime;
det1.Remark2 = remark;
C2.BizResult result = bz.update("skip");
if (result.status)
{
status = true;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = user;
elog.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, -1, "Container Ready Export [" + mobileNo + "]: " + (remark.Length > 0 ? " :" + remark : ""));
elog.log();
}
}
}
else
{
context = "Data Error";
}
Common.WriteJsonP(status, Common.StringToJson(context));
}
private string job_void()
{
ASPxLabel Id = this.grid_job.FindEditFormTemplateControl("lb_Id") as ASPxLabel;
string sql = "update CTM_Job set StatusCode=case when StatusCode='CNL' then 'USE' else 'CNL' end where Id=" + Id.Text;
if (ConnectSql.ExecuteSql(sql) > 0)
{
string userId = HttpContext.Current.User.Identity.Name;
int jobId = SafeValue.SafeInt(Id.Text, 0);
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isJOB(jobId);
elog.Remark = "Job Void";
elog.log();
return("");
}
return("error");
}
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, "CONSOL");
string jobStatus = SafeValue.SafeString(cbb_new_jobstatus.Text, "Quoted");
//string jobType1 = "IMP";
//if (jobType.IndexOf("EXP") > -1)
//{
// jobType1 = "EXP";
//}
string jobType1 = jobType;
string jobno = "";
string user = HttpContext.Current.User.Identity.Name;
string quoteNo = "";
jobno = C2Setup.GetNextNo("I", "CI", date);
string wh = txt_new_WareHouseId.Text;// 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,OrderType,ClientId,YardRef,PickupFrom,DeliveryTo,Remark,WarehouseAddress,JobStatus,QuoteNo,QuoteStatus,QuoteDate,WareHouseCode,IsTrucking,IsWarehouse,JobType) 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','No','I') select @@identity", jobno, user, time4, cbb_new_jobtype.Value, txt_new_JobDate.Date, btn_new_ClientId.Text, txt_DepotAddress.Text, txt_FromAddress.Text, txt_ToAddress.Text, txt_new_remark.Text, txt_WarehouseAddress.Text, jobStatus, quoteNo, wh);
int jobId = SafeValue.SafeInt(ConnectSql_mb.ExecuteScalar(sql), 0);
if (jobId > 0)
{
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Job, 1);
elog.ActionLevel_isJOB(jobId);
C2Setup.SetNextNo("I", "CI", jobno, date);
e.Result = jobno;
elog.log();
}
}
public BizResult jobBilling(string user)
{
BizResult res = new BizResult();
if (this.job != null && this.job.Id > 0)
{
string sql = string.Format(@"select * from CTM_JobDet2 as det2
left outer join ctm_job as job on det2.JobNo=job.JobNo
where job.Id=@jobId and det2.Statuscode<>'C'");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@jobId", this.job.Id, SqlDbType.Int));
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
res.context = "Have pending trips need to delivery";
}
else
{
sql = "update CTM_Job set StatusCode='CLS',JobStatus='Completed' where Id=@jobId";
if (ConnectSql_mb.ExecuteNonQuery(sql, list).status)
{
res.status = true;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = user;
elog.ActionLevel_isJOB(this.job.Id);
elog.setActionLevel(this.job.Id, CtmJobEventLogRemark.Level.Job, 7);
elog.log();
}
}
}
else
{
res.context = "error: data empty";
}
return(res);
}
public BizResult voidJob(string user)
{
BizResult res = new BizResult();
if (this.job != null && this.job.Id > 0)
{
System.Collections.ObjectModel.Collection <C2.CtmJobDet1> det1 = C2.Manager.ORManager.GetCollection <C2.CtmJobDet1>("JobNo='" + this.job.JobNo + "'");
C2.CtmJobDet1Biz det1Bz = new CtmJobDet1Biz(0);
foreach (C2.CtmJobDet1 temp in det1)
{
det1Bz.setData(temp);
det1Bz.delete(user);
}
this.job.StatusCode = "CNL";
this.job.JobStatus = "Voided";
Manager.ORManager.StartTracking(this.job, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(this.job);
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = user;
elog.ActionLevel_isJOB(this.job.Id);
elog.setActionLevel(this.job.Id, CtmJobEventLogRemark.Level.Job, 5);
elog.log();
res.status = true;
}
else
{
res.context = "error: data empty";
}
return(res);
}
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, "IMP");
string jobStatus = SafeValue.SafeString(cbb_new_jobstatus.Text, "Quoted");
//string jobType1 = "IMP";
//if (jobType.IndexOf("EXP") > -1)
//{
// jobType1 = "EXP";
//}
string jobType1 = jobType;
string isTrucking = SafeValue.SafeString(cmb_IsTrucking.Value);
string isWarehouse = SafeValue.SafeString(cmb_IsWarehouse.Value);
string subContract = SafeValue.SafeString(cbb_Contractor.Value);
string warehouseCode = SafeValue.SafeString(txt_new_WareHouseId.Text);
string jobno = "";
string user = HttpContext.Current.User.Identity.Name;
string quoteNo = "";
string quoteStatus = "Pending";
if (jobStatus == "Quoted")
{
quoteNo = C2Setup.GetNextNo("", "CTM_Job_" + jobStatus, date);
}
else
{
quoteStatus = "None";
jobno = C2Setup.GetNextNo("", "CTM_Job_" + jobType1, date);
quoteNo = jobno;
}
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,IsTrucking,IsWarehouse,Contractor) values ('{0}','{4}',getdate(),getdate(),getdate(),'USE','{1}',getdate(),'{1}',getdate(),'{2}','{2}','{3}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{14}',getdate(),'{13}','{15}','{16}','{17}') select @@identity", jobno, user, time4, cbb_new_jobtype.Value, txt_new_JobDate.Date, btn_new_ClientId.Text, txt_DepotAddress.Text, txt_FromAddress.Text, txt_ToAddress.Text, txt_new_remark.Text, txt_WarehouseAddress.Text, jobStatus, quoteNo, warehouseCode, quoteStatus, isTrucking, isWarehouse, subContract);
int jobId = SafeValue.SafeInt(ConnectSql_mb.ExecuteScalar(sql), 0);
if (jobId > 0)
{
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
if (jobStatus == "Quoted")
{
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Quotation, 1);
elog.ActionLevel_isQuoted(jobId);
C2Setup.SetNextNo("", "CTM_Job_" + jobStatus, quoteNo, date);
//GetJobRate(quoteNo, btn_new_ClientId.Text, SafeValue.SafeString(cbb_new_jobtype.Value));
e.Result = quoteNo;
}
else
{
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Job, 1);
elog.ActionLevel_isJOB(jobId);
C2Setup.SetNextNo("", "CTM_Job_" + jobType1, jobno, date);
e.Result = jobno;
}
elog.log();
sql = string.Format(@"update CTM_Job set JobNo={0} where Id={0}", jobId);
ConnectSql.ExecuteSql(sql);
}
}
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, "IMP");
string jobStatus = SafeValue.SafeString(cbb_new_jobstatus.Text, "Quoted");
//string jobType1 = "IMP";
//if (jobType.IndexOf("EXP") > -1)
//{
// jobType1 = "EXP";
//}
string jobType1 = jobType;
string isTrucking = SafeValue.SafeString(cmb_IsTrucking.Value);
string isWarehouse = SafeValue.SafeString(cmb_IsWarehouse.Value);
string subContract = SafeValue.SafeString(cbb_Contractor.Value);
subContract = (subContract == "YES" ? "YES" : "NO");
string warehouseCode = SafeValue.SafeString(txt_new_WareHouseId.Text);
string jobno = "";
string user = HttpContext.Current.User.Identity.Name;
string quoteNo = "";
string quoteStatus = "Pending";
if (jobStatus == "Quoted")
{
quoteNo = C2Setup.GetNextNo("", "CTM_Job_" + jobStatus, date);
}
else
{
quoteStatus = "None";
jobno = C2Setup.GetNextNo("", "CTM_Job_" + jobType1, date);
quoteNo = jobno;
}
DateTime now = DateTime.Now;
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,IsTrucking,IsWarehouse,Contractor,DepotCode) values (@JobNo,@JobDate,@EtaDate,@EtdDate,@CodDate,@StatusCode,@CreateBy,@CreateDatetime,@UpdateBy,@UpdateDatetime,@EtaTime,@EtdTime,@JobType,@ClientId,@YardRef,@PickupFrom,@DeliveryTo,@Remark,@WarehouseAddress,@JobStatus,@QuoteNo,@QuoteStatus,@QuoteDate,@WareHouseCode,@IsTrucking,@IsWarehouse,@Contractor,@DepotCode) select @@identity");
if (jobType1 == "WGR" || jobType1 == "WDO" || jobType1 == "TPT")
{
sql = string.Format(@"insert into CTM_Job (JobNo,JobDate,EtaDate,EtdDate,CodDate,StatusCode,CreateBy,CreateDatetime,UpdateBy,UpdateDatetime,EtaTime,EtdTime,JobType,ClientId,YardRef,PickupFrom,DeliveryTo,SpecialInstruction,WarehouseAddress,JobStatus,QuoteNo,QuoteStatus,QuoteDate,WareHouseCode,IsTrucking,IsWarehouse,Contractor,DepotCode) values (@JobNo,@JobDate,@EtaDate,@EtdDate,@CodDate,@StatusCode,@CreateBy,@CreateDatetime,@UpdateBy,@UpdateDatetime,@EtaTime,@EtdTime,@JobType,@ClientId,@YardRef,@PickupFrom,@DeliveryTo,@SpecialInstruction,@WarehouseAddress,@JobStatus,@QuoteNo,@QuoteStatus,@QuoteDate,@WareHouseCode,@IsTrucking,@IsWarehouse,@Contractor,@DepotCode) select @@identity");
}
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@JobNo", jobno, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@JobDate", txt_new_JobDate.Date, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@EtaDate", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@EtdDate", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@CodDate", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@StatusCode", "USE", SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@CreateBy", user, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@CreateDatetime", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@UpdateBy", user, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@UpdateDatetime", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@EtaTime", time4, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@EtdTime", time4, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@JobType", cbb_new_jobtype.Value, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@ClientId", btn_new_ClientId.Text, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@YardRef", txt_DepotAddress.Text, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@PickupFrom", txt_FromAddress.Text, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@DeliveryTo", txt_ToAddress.Text, SqlDbType.NVarChar));
if (jobType1 == "WGR" || jobType1 == "WDO" || jobType1 == "TPT")
{
list.Add(new ConnectSql_mb.cmdParameters("@SpecialInstruction", txt_new_remark.Text, SqlDbType.NVarChar));
}
else
{
list.Add(new ConnectSql_mb.cmdParameters("@Remark", txt_new_remark.Text, SqlDbType.NVarChar));
}
list.Add(new ConnectSql_mb.cmdParameters("@WarehouseAddress", txt_WarehouseAddress.Text, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@JobStatus", jobStatus, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@QuoteNo", quoteNo, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@QuoteStatus", quoteStatus, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@QuoteDate", now, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@WareHouseCode", warehouseCode, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@IsTrucking", isTrucking, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@IsWarehouse", isWarehouse, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@Contractor", cbb_Contractor.Value, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@DepotCode", btn_DepotCode.Text, SqlDbType.NVarChar));
ConnectSql_mb.sqlResult res = ConnectSql_mb.ExecuteScalar(sql, list);
if (res.status)
{
int jobId = SafeValue.SafeInt(res.context, 0);
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
if (jobStatus == "Quoted")
{
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Quotation, 1);
elog.ActionLevel_isQuoted(jobId);
C2Setup.SetNextNo("", "CTM_Job_" + jobStatus, quoteNo, date);
auto_add_trailer_trip(quoteNo, jobType1);
//GetJobRate(quoteNo, btn_new_ClientId.Text, SafeValue.SafeString(cbb_new_jobtype.Value));
e.Result = quoteNo;
}
else
{
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Job, 1);
elog.ActionLevel_isJOB(jobId);
C2Setup.SetNextNo("", "CTM_Job_" + jobType1, jobno, date);
auto_add_trailer_trip(jobno, jobType1);
e.Result = jobno;
}
elog.log();
}
}
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, "IMP");
string jobStatus = SafeValue.SafeString(cbb_new_jobstatus.Text, "Quoted");
//string jobType1 = "IMP";
//if (jobType.IndexOf("EXP") > -1)
//{
// jobType1 = "EXP";
//}
string jobType1 = jobType;
string isTrucking = "No";
if (cb_Trucking.Checked)
{
isTrucking = "Yes";
}
string isWarehouse = "No";
if (cb_Warehouse.Checked)
{
isWarehouse = "Yes";
}
string isTransport = "No";
if (cb_Transport.Checked)
{
isTransport = "Yes";
}
string isCrane = "No";
if (cb_Crane.Checked)
{
isCrane = "Yes";
}
if (jobType == "IMP" || jobType == "EXP" || jobType == "LOC")
{
isTrucking = "Yes";
}
else if (jobType == "WGR" || jobType == "WDO" || jobType == "TPT")
{
isTransport = "Yes";
}
else if (jobType == "CRA")
{
isCrane = "Yes";
}
string warehouseCode = SafeValue.SafeString(txt_new_WareHouseId.Text);
string jobno = "";
string user = HttpContext.Current.User.Identity.Name;
string quoteNo = "";
string quoteStatus = "Pending";
if (jobStatus == "Quoted")
{
quoteNo = C2Setup.GetNextNo("", "CTM_Job_" + jobStatus, txt_new_JobDate.Date);
}
else
{
quoteStatus = "None";
jobno = C2Setup.GetNextNo("", "CTM_Job_" + jobType1, txt_new_JobDate.Date);
quoteNo = jobno;
}
DateTime now = DateTime.Now;
string sql = string.Format(@"insert into CTM_Job (JobNo,JobDate,EtaDate,CodDate,StatusCode,CreateBy,CreateDatetime,UpdateBy,UpdateDatetime,EtaTime,EtdTime,JobType,JobStatus,QuoteNo,QuoteStatus,QuoteDate,WareHouseCode,IsTrucking,IsWarehouse,IsLocal,IsAdhoc)
values (@JobNo,@JobDate,@EtaDate,@CodDate,@StatusCode,@CreateBy,@CreateDatetime,@UpdateBy,@UpdateDatetime,@EtaTime,@EtdTime,@JobType,@JobStatus,@QuoteNo,@QuoteStatus,@QuoteDate,@WareHouseCode,@IsTrucking,@IsWarehouse,@IsLocal,@IsAdhoc) select @@identity");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@JobNo", jobno, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@JobDate", txt_new_JobDate.Date, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@EtaDate", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@CodDate", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@StatusCode", "USE", SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@CreateBy", user, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@CreateDatetime", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@UpdateBy", user, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@UpdateDatetime", now, SqlDbType.DateTime));
list.Add(new ConnectSql_mb.cmdParameters("@EtaTime", time4, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@EtdTime", time4, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@JobType", cbb_new_jobtype.Value, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@JobStatus", jobStatus, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@QuoteNo", quoteNo, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@QuoteStatus", quoteStatus, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@QuoteDate", now, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@WareHouseCode", warehouseCode, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@IsTrucking", isTrucking, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@IsWarehouse", isWarehouse, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@IsLocal", isTransport, SqlDbType.NVarChar));
list.Add(new ConnectSql_mb.cmdParameters("@IsAdhoc", isCrane, SqlDbType.NVarChar));
ConnectSql_mb.sqlResult res = ConnectSql_mb.ExecuteScalar(sql, list);
if (res.status)
{
int jobId = SafeValue.SafeInt(res.context, 0);
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
if (jobStatus == "Quoted")
{
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Quotation, 1);
elog.ActionLevel_isQuoted(jobId);
C2Setup.SetNextNo("", "CTM_Job_" + jobStatus, quoteNo, date);
//GetJobRate(quoteNo, btn_new_ClientId.Text, SafeValue.SafeString(cbb_new_jobtype.Value));
e.Result = quoteNo;
}
else
{
elog.setActionLevel(jobId, CtmJobEventLogRemark.Level.Job, 1);
elog.ActionLevel_isJOB(jobId);
C2Setup.SetNextNo("", "CTM_Job_" + jobType1, jobno, date);
e.Result = jobno;
}
elog.log();
sql = string.Format(@"update CTM_Job set JobNo={0} where Id={0}", jobId);
ConnectSql.ExecuteSql(sql);
}
}
private void Trip_Update(object sender, ASPxGridViewCustomDataCallbackEventArgs e, string jobType)
{
try
{
string tripId = SafeValue.SafeString(lbl_TripId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");
C2.CtmJobDet2 trip = C2.Manager.ORManager.GetObject(query) as C2.CtmJobDet2;
string Driver_old = "";
bool isNew = false;
if (trip == null)
{
isNew = true;
trip = new C2.CtmJobDet2();
}
else
{
Driver_old = trip.DriverCode;
}
//ASPxDropDownEdit dde_Trip_ContNo = gv_tpt_trip.FindEditFormTemplateControl("dde_Trip_ContNo") as ASPxDropDownEdit;
ASPxButtonEdit btn_ChessisCode = gv_tpt_trip.FindEditFormTemplateControl("btn_ChessisCode") as ASPxButtonEdit;
ASPxComboBox cbb_zone = gv_tpt_trip.FindEditFormTemplateControl("cbb_zone") as ASPxComboBox;
ASPxTextBox dde_Trip_ContId = gv_tpt_trip.FindEditFormTemplateControl("dde_Trip_ContId") as ASPxTextBox;
//ASPxButtonEdit btn_CfsCode = gv_tpt_trip.FindEditFormTemplateControl("btn_CfsCode") as ASPxButtonEdit;
//ASPxComboBox cbb_Trip_BayCode = gv_tpt_trip.FindEditFormTemplateControl("cbb_Trip_BayCode") as ASPxComboBox;
//ASPxComboBox cbb_Carpark = gv_tpt_trip.FindEditFormTemplateControl("cbb_Carpark") as ASPxComboBox;
ASPxComboBox cbb_Trip_TripCode = gv_tpt_trip.FindEditFormTemplateControl("cbb_Trip_TripCode") as ASPxComboBox;
ASPxButtonEdit btn_ContNo = gv_tpt_trip.FindEditFormTemplateControl("btn_ContNo") as ASPxButtonEdit;
ASPxButtonEdit btn_DriverCode = gv_tpt_trip.FindEditFormTemplateControl("btn_DriverCode") as ASPxButtonEdit;
ASPxButtonEdit btn_Attended = gv_tpt_trip.FindEditFormTemplateControl("btn_Attended") as ASPxButtonEdit;
ASPxButtonEdit btn_TowheadCode = gv_tpt_trip.FindEditFormTemplateControl("btn_TowheadCode") as ASPxButtonEdit;
//ASPxComboBox cbb_Trip_SubletFlag = gv_tpt_trip.FindEditFormTemplateControl("cbb_Trip_SubletFlag") as ASPxComboBox;
//ASPxTextBox txt_SubletHauliername = gv_tpt_trip.FindEditFormTemplateControl("txt_SubletHauliername") as ASPxTextBox;
//ASPxComboBox cbb_StageCode = gv_tpt_trip.FindEditFormTemplateControl("cbb_StageCode") as ASPxComboBox;
//ASPxComboBox cbb_StageStatus = gv_tpt_trip.FindEditFormTemplateControl("cbb_StageStatus") as ASPxComboBox;
ASPxComboBox cbb_Trip_StatusCode = gv_tpt_trip.FindEditFormTemplateControl("cbb_Trip_StatusCode") as ASPxComboBox;
ASPxComboBox cmb_DoubleMounting = gv_tpt_trip.FindEditFormTemplateControl("cmb_DoubleMounting") as ASPxComboBox;
ASPxDateEdit txt_FromDate = gv_tpt_trip.FindEditFormTemplateControl("txt_FromDate") as ASPxDateEdit;
ASPxTextBox txt_Trip_fromTime = gv_tpt_trip.FindEditFormTemplateControl("txt_Trip_fromTime") as ASPxTextBox;
ASPxDateEdit date_Trip_toDate = gv_tpt_trip.FindEditFormTemplateControl("date_Trip_toDate") as ASPxDateEdit;
ASPxTextBox txt_Trip_toTime = gv_tpt_trip.FindEditFormTemplateControl("txt_Trip_toTime") as ASPxTextBox;
ASPxMemo txt_Trip_Remark = gv_tpt_trip.FindEditFormTemplateControl("txt_Trip_Remark") as ASPxMemo;
ASPxMemo txt_Trip_FromCode = gv_tpt_trip.FindEditFormTemplateControl("txt_Trip_FromCode") as ASPxMemo;
ASPxMemo txt_Trip_ToCode = gv_tpt_trip.FindEditFormTemplateControl("txt_Trip_ToCode") as ASPxMemo;
//ASPxSpinEdit spin_Incentive2 = gv_tpt_trip.FindEditFormTemplateControl("spin_Incentive2") as ASPxSpinEdit;
ASPxMemo txt_driver_remark = gv_tpt_trip.FindEditFormTemplateControl("txt_driver_remark") as ASPxMemo;
ASPxDateEdit date_BookingDate = gv_tpt_trip.FindEditFormTemplateControl("date_BookingDate") as ASPxDateEdit;
ASPxTextBox txt_BookingTime = gv_tpt_trip.FindEditFormTemplateControl("txt_BookingTime") as ASPxTextBox;
ASPxTextBox txt_BookingTime2 = gv_tpt_trip.FindEditFormTemplateControl("txt_BookingTime2") as ASPxTextBox;
ASPxMemo txt_BookingRemark = gv_tpt_trip.FindEditFormTemplateControl("txt_BookingRemark") as ASPxMemo;
ASPxMemo txt_Trip_BillingRemark = gv_tpt_trip.FindEditFormTemplateControl("txt_Trip_BillingRemark") as ASPxMemo;
ASPxMemo txt_delivery_remark = gv_tpt_trip.FindEditFormTemplateControl("txt_delivery_remark") as ASPxMemo;
if (txt_delivery_remark != null)
{
trip.DeliveryRemark = txt_delivery_remark.Text;
}
ASPxMemo txt_billing_remark = gv_tpt_trip.FindEditFormTemplateControl("txt_billing_remark") as ASPxMemo;
if (txt_billing_remark != null)
{
trip.BillingRemark = txt_billing_remark.Text;
}
ASPxMemo txt_Satifaction_Indator = gv_tpt_trip.FindEditFormTemplateControl("txt_Satifaction_Indator") as ASPxMemo;
if (txt_Satifaction_Indator != null)
{
trip.Satisfaction = txt_Satifaction_Indator.Text;
}
ASPxComboBox cmb_Escort_Ind = gv_tpt_trip.FindEditFormTemplateControl("cmb_Escort_Ind") as ASPxComboBox;
ASPxMemo txt_Trip_Escort_Remark = gv_tpt_trip.FindEditFormTemplateControl("txt_Trip_Escort_Remark") as ASPxMemo;
if (cmb_Escort_Ind != null)
{
trip.Escort_Ind = SafeValue.SafeString(cmb_Escort_Ind.Value);
}
if (txt_Trip_Escort_Remark != null)
{
trip.Escort_Remark = SafeValue.SafeString(txt_Trip_Escort_Remark.Text);
}
ASPxSpinEdit txt_TotalHour = gv_tpt_trip.FindEditFormTemplateControl("txt_TotalHour") as ASPxSpinEdit;
ASPxSpinEdit txt_OtHour = gv_tpt_trip.FindEditFormTemplateControl("txt_OtHour") as ASPxSpinEdit;
ASPxTextBox txt_ByUser = gv_tpt_trip.FindEditFormTemplateControl("txt_ByUser") as ASPxTextBox;
ASPxTextBox txt_TrailerType = gv_tpt_trip.FindEditFormTemplateControl("txt_TrailerType") as ASPxTextBox;
ASPxTextBox txt_VehicleType = gv_tpt_trip.FindEditFormTemplateControl("txt_VehicleType") as ASPxTextBox;
ASPxComboBox cbb_VehicleType = gv_tpt_trip.FindEditFormTemplateControl("cbb_VehicleType") as ASPxComboBox;
ASPxMemo txt_DeliveryRemark = gv_tpt_trip.FindEditFormTemplateControl("txt_DeliveryRemark") as ASPxMemo;
if (txt_TrailerType != null)
{
trip.RequestTrailerType = txt_TrailerType.Text;
}
if (txt_VehicleType != null)
{
trip.RequestVehicleType = txt_VehicleType.Text;
}
if (cbb_VehicleType != null)
{
trip.RequestVehicleType = cbb_VehicleType.Text;
}
if (txt_DeliveryRemark != null)
{
trip.DeliveryRemark = txt_DeliveryRemark.Text;
}
ASPxButtonEdit btn_AgentId = gv_tpt_trip.FindEditFormTemplateControl("btn_AgentId") as ASPxButtonEdit;
ASPxTextBox txt_AgentName = gv_tpt_trip.FindEditFormTemplateControl("txt_AgentName") as ASPxTextBox;
if (btn_AgentId != null)
{
trip.AgentId = btn_AgentId.Text;
}
if (txt_AgentName != null)
{
trip.AgentName = txt_AgentName.Text;
}
if (btn_ContNo != null)
{
trip.ContainerNo = SafeValue.SafeString(btn_ContNo.Text);
}
ASPxButtonEdit btn_Trailer = gv_tpt_trip.FindEditFormTemplateControl("btn_Trailer") as ASPxButtonEdit;
if (btn_Trailer != null)
{
trip.ChessisCode = SafeValue.SafeString(btn_Trailer.Text);
}
//if (btn_ChessisCode != null)
// trip.ChessisCode = SafeValue.SafeString(btn_ChessisCode.Value);
//if (cbb_zone != null)
// trip.ParkingZone = SafeValue.SafeString(cbb_zone.Value);
if (dde_Trip_ContId != null)
{
trip.Det1Id = SafeValue.SafeInt(dde_Trip_ContId.Text, 0);
}
//trip.CfsCode = SafeValue.SafeString(btn_CfsCode.Value);
//trip.BayCode = SafeValue.SafeString(cbb_Trip_BayCode.Value);
if (btn_DriverCode != null)
{
if (btn_DriverCode.Text != "")
{
trip.DriverCode = SafeValue.SafeString(btn_DriverCode.Text);
}
else
{
trip.DriverCode = "";
}
}
if (btn_Attended != null)
{
if (btn_Attended.Text != "")
{
trip.DriverCode2 = SafeValue.SafeString(btn_Attended.Text);
}
else
{
trip.DriverCode2 = "";
}
}
if (btn_TowheadCode != null)
{
trip.TowheadCode = SafeValue.SafeString(btn_TowheadCode.Value);
}
//trip.SubletFlag = SafeValue.SafeString(cbb_Trip_SubletFlag.Value);
//trip.SubletHauliername = SafeValue.SafeString(txt_SubletHauliername.Text);
if (cbb_Trip_TripCode != null)
{
trip.TripCode = SafeValue.SafeString(cbb_Trip_TripCode.Value);
}
if (cmb_DoubleMounting != null)
{
trip.DoubleMounting = SafeValue.SafeString(cmb_DoubleMounting.Value, "No");
}
//trip.StageCode = SafeValue.SafeString(cbb_StageCode.Value);
//trip.Carpark = SafeValue.SafeString(cbb_Carpark.Value);
//trip.StageStatus = SafeValue.SafeString(cbb_StageStatus.Value);
if (date_BookingDate != null)
{
trip.BookingDate = SafeValue.SafeDate(date_BookingDate.Date, new DateTime(1900, 1, 1));
}
if (txt_BookingTime != null)
{
trip.BookingTime = SafeValue.SafeString(txt_BookingTime.Text);
}
if (txt_BookingTime2 != null)
{
trip.BookingTime2 = SafeValue.SafeString(txt_BookingTime2.Text);
}
if (cbb_Trip_StatusCode != null)
{
trip.Statuscode = SafeValue.SafeString(cbb_Trip_StatusCode.Value);
}
if (txt_FromDate != null)
{
trip.FromDate = SafeValue.SafeDate(txt_FromDate.Date, new DateTime(1990, 1, 1));
}
if (txt_Trip_fromTime != null)
{
trip.FromTime = SafeValue.SafeString(txt_Trip_fromTime.Text);
}
if (date_Trip_toDate != null)
{
trip.ToDate = SafeValue.SafeDate(date_Trip_toDate.Date, new DateTime(1990, 1, 1));
}
if (txt_Trip_toTime != null)
{
trip.ToTime = SafeValue.SafeString(txt_Trip_toTime.Text);
}
if (txt_Trip_Remark != null)
{
trip.Remark = SafeValue.SafeString(txt_Trip_Remark.Text);
}
if (txt_Trip_FromCode != null)
{
trip.FromCode = SafeValue.SafeString(txt_Trip_FromCode.Text);
}
if (txt_Trip_ToCode != null)
{
trip.ToCode = SafeValue.SafeString(txt_Trip_ToCode.Text);
}
//trip.Overtime = SafeValue.SafeSqlString(cbb_Overtime.Value);
//trip.OverDistance = SafeValue.SafeSqlString(cbb_OverDistance.Value);
if (txt_driver_remark != null)
{
trip.Remark1 = SafeValue.SafeString(txt_driver_remark.Text);
}
//if (fromPackingLot != null)
// trip.FromParkingLot = SafeValue.SafeString(fromPackingLot.Text);
//if (toPackingLot != null)
// trip.ToParkingLot = SafeValue.SafeString(toPackingLot.Text);
if (txt_BookingRemark != null)
{
trip.BookingRemark = txt_BookingRemark.Text;
}
if (txt_Trip_BillingRemark != null)
{
trip.BillingRemark = txt_Trip_BillingRemark.Text;
}
if (txt_OtHour != null)
{
trip.OtHour = SafeValue.SafeDecimal(txt_OtHour.Text);
}
if (txt_TotalHour != null)
{
trip.TotalHour = SafeValue.SafeDecimal(txt_TotalHour.Text);
}
if (txt_ByUser != null)
{
trip.ByUser = SafeValue.SafeString(txt_ByUser.Text);
}
ASPxDateEdit date_WarehouseScheduleDate = gv_tpt_trip.FindEditFormTemplateControl("date_WarehouseScheduleDate") as ASPxDateEdit;
if (date_WarehouseScheduleDate != null)
{
trip.WarehouseScheduleDate = SafeValue.SafeDate(date_WarehouseScheduleDate.Date, new DateTime(1990, 1, 1));
}
ASPxDateEdit date_WarehouseStartDate = gv_tpt_trip.FindEditFormTemplateControl("date_WarehouseStartDate") as ASPxDateEdit;
if (date_WarehouseStartDate != null)
{
trip.WarehouseStartDate = SafeValue.SafeDate(date_WarehouseStartDate.Date, new DateTime(1990, 1, 1));
}
ASPxDateEdit date_WarehouseEndDate = gv_tpt_trip.FindEditFormTemplateControl("date_WarehouseEndDate") as ASPxDateEdit;
if (date_WarehouseEndDate != null)
{
trip.WarehouseEndDate = SafeValue.SafeDate(date_WarehouseEndDate.Date, new DateTime(1990, 1, 1));
}
ASPxMemo memo_WarehouseRemark = gv_tpt_trip.FindEditFormTemplateControl("memo_WarehouseRemark") as ASPxMemo;
if (memo_WarehouseRemark != null)
{
trip.WarehouseRemark = memo_WarehouseRemark.Text;
}
ASPxComboBox cbb_WarehouseStatus = gv_tpt_trip.FindEditFormTemplateControl("cbb_WarehouseStatus") as ASPxComboBox;
if (cbb_WarehouseStatus != null)
{
trip.WarehouseStatus = SafeValue.SafeString(cbb_WarehouseStatus.Value);
}
ASPxCheckBox ckb_epodCB1 = gv_tpt_trip.FindEditFormTemplateControl("ckb_epodCB1") as ASPxCheckBox;
if (ckb_epodCB1 != null)
{
if (ckb_epodCB1.Checked)
{
trip.EpodCB1 = "Yes";
}
else
{
trip.EpodCB1 = "No";
}
}
ASPxCheckBox ckb_epodCB2 = gv_tpt_trip.FindEditFormTemplateControl("ckb_epodCB2") as ASPxCheckBox;
if (ckb_epodCB2 != null)
{
if (ckb_epodCB2.Checked)
{
trip.EpodCB2 = "Yes";
}
else
{
trip.EpodCB2 = "No";
}
}
ASPxCheckBox ckb_epodCB3 = gv_tpt_trip.FindEditFormTemplateControl("ckb_epodCB3") as ASPxCheckBox;
if (ckb_epodCB3 != null)
{
if (ckb_epodCB3.Checked)
{
trip.EpodCB3 = "Yes";
}
else
{
trip.EpodCB3 = "No";
}
}
ASPxCheckBox ckb_epodCB4 = gv_tpt_trip.FindEditFormTemplateControl("ckb_epodCB4") as ASPxCheckBox;
if (ckb_epodCB4 != null)
{
if (ckb_epodCB4.Checked)
{
trip.EpodCB4 = "Yes";
}
else
{
trip.EpodCB4 = "No";
}
}
ASPxCheckBox ckb_epodCB5 = gv_tpt_trip.FindEditFormTemplateControl("ckb_epodCB5") as ASPxCheckBox;
if (ckb_epodCB5 != null)
{
if (ckb_epodCB5.Checked)
{
trip.EpodCB5 = "Yes";
}
else
{
trip.EpodCB5 = "No";
}
}
ASPxCheckBox ckb_epodCB6 = gv_tpt_trip.FindEditFormTemplateControl("ckb_epodCB6") as ASPxCheckBox;
if (ckb_epodCB6 != null)
{
if (ckb_epodCB6.Checked)
{
trip.EpodCB6 = "Yes";
}
else
{
trip.EpodCB6 = "No";
}
}
ASPxComboBox cbb_Self_Ind = gv_tpt_trip.FindEditFormTemplateControl("cbb_Self_Ind") as ASPxComboBox;
if (cbb_Self_Ind != null)
{
trip.Self_Ind = SafeValue.SafeString(cbb_Self_Ind.Value, "No");
}
ASPxButtonEdit btn_SubCon_Code = gv_tpt_trip.FindEditFormTemplateControl("btn_SubCon_Code") as ASPxButtonEdit;
if (btn_SubCon_Code != null)
{
trip.SubCon_Code = btn_SubCon_Code.Text;
}
ASPxComboBox cbb_SubCon_Code = gv_tpt_trip.FindEditFormTemplateControl("cbb_SubCon_Code") as ASPxComboBox;
if (cbb_SubCon_Code != null)
{
trip.SubCon_Ind = SafeValue.SafeString(cbb_SubCon_Code.Value);
}
ASPxComboBox cbb_DirectInf = gv_tpt_trip.FindEditFormTemplateControl("cbb_DirectInf") as ASPxComboBox;
if (cbb_DirectInf != null)
{
trip.DirectInf = cbb_DirectInf.Text;
}
//========= incentive
ASPxSpinEdit spin_Charge_ERP = gv_tpt_trip.FindEditFormTemplateControl("spin_Charge_ERP") as ASPxSpinEdit;
ASPxSpinEdit spin_Charge_ParkingFee = gv_tpt_trip.FindEditFormTemplateControl("spin_Charge_ParkingFee") as ASPxSpinEdit;
ASPxSpinEdit spin_Charge9 = gv_tpt_trip.FindEditFormTemplateControl("spin_Charge9") as ASPxSpinEdit;
ASPxSpinEdit spin_Incentive1 = gv_tpt_trip.FindEditFormTemplateControl("spin_Incentive1") as ASPxSpinEdit;
ASPxSpinEdit spin_Incentive2 = gv_tpt_trip.FindEditFormTemplateControl("spin_Incentive2") as ASPxSpinEdit;
ASPxComboBox cbb_Incentive4 = gv_tpt_trip.FindEditFormTemplateControl("cbb_Incentive4") as ASPxComboBox;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = HttpContext.Current.User.Identity.Name;
trip.UpdateUser = HttpContext.Current.User.Identity.Name;
trip.UpdateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(trip);
//EGL_JobTrip_AfterEndTrip("", dde_Trip_ContId.Text);
elog.Remark = "Update Trip";
elog.ActionLevel_isTRIP(trip.Id);
elog.log();
Dictionary <string, decimal> d = new Dictionary <string, decimal>();
d.Add("Trip", SafeValue.SafeDecimal(spin_Incentive1.Text));
d.Add("OverTime", SafeValue.SafeDecimal(spin_Incentive2.Text));
d.Add("PSA", SafeValue.SafeDecimal(cbb_Incentive4.Text));
C2.CtmJobDet2.Incentive_Save(trip.Id, d);
d = new Dictionary <string, decimal>();
d.Add("ERP", SafeValue.SafeDecimal(spin_Charge_ERP.Text));
d.Add("ParkingFee", SafeValue.SafeDecimal(spin_Charge_ParkingFee.Text));
d.Add("OTHER", SafeValue.SafeDecimal(spin_Charge9.Text));
C2.CtmJobDet2.Claims_Save(trip.Id, d);
Session["CTM_Trip_" + tripId] = "Id='" + tripId + "'";
this.dsTrip.FilterExpression = Session["CTM_Trip_" + tripId].ToString();
if (this.gv_tpt_trip.GetRow(0) != null)
{
this.gv_tpt_trip.StartEdit(0);
}
}
catch { }
e.Result = "Success";
}
private string job_save()
{
string res = "";
try
{
ASPxPageControl pageControl = this.grid_job.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txt_JobNo = this.grid_job.FindEditFormTemplateControl("txt_JobNo") as ASPxTextBox;
string jobNo = SafeValue.SafeString(txt_JobNo.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + jobNo + "'");
C2.CtmJob ctmJob = C2.Manager.ORManager.GetObject(query) as C2.CtmJob;
ASPxDateEdit jobDate = this.grid_job.FindEditFormTemplateControl("txt_JobDate") as ASPxDateEdit;
bool isNew = false;
if (ctmJob == null)
{
isNew = true;
ctmJob = new C2.CtmJob();
ctmJob.JobNo = C2Setup.GetNextNo("", "CTM_Job", jobDate.Date);
}
ASPxComboBox cbb_JobType = this.grid_job.FindEditFormTemplateControl("cbb_JobType") as ASPxComboBox;
ASPxButtonEdit btn_ClientId = this.grid_job.FindEditFormTemplateControl("btn_ClientId") as ASPxButtonEdit;
ASPxTextBox txt_ClientRefNo = this.grid_job.FindEditFormTemplateControl("txt_ClientRefNo") as ASPxTextBox;
ASPxTextBox txt_notifiEmail = this.grid_job.FindEditFormTemplateControl("txt_notifiEmail") as ASPxTextBox;
ASPxButtonEdit btn_SubClientId = this.grid_job.FindEditFormTemplateControl("btn_SubClientId") as ASPxButtonEdit;
ASPxButtonEdit txt_WareHouseId = this.grid_job.FindEditFormTemplateControl("txt_WareHouseId") as ASPxButtonEdit;
ASPxTextBox txt_ClientContact = this.grid_job.FindEditFormTemplateControl("txt_ClientContact") as ASPxTextBox;
ctmJob.ClientContact = SafeValue.SafeString(txt_ClientContact.Text);
ctmJob.JobDate = SafeValue.SafeDate(jobDate.Date, new DateTime(1753, 1, 1));
ctmJob.JobType = cbb_JobType.Text;
ctmJob.ClientId = btn_ClientId.Text;
ctmJob.ClientRefNo = txt_ClientRefNo.Text;
ctmJob.EmailAddress = txt_notifiEmail.Text;
ctmJob.SubClientId = btn_SubClientId.Text;
if (txt_WareHouseId != null)
{
ctmJob.WareHouseCode = txt_WareHouseId.Text;
}
string userId = HttpContext.Current.User.Identity.Name;
if (isNew)
{
ctmJob.StatusCode = "USE";
ctmJob.CreateBy = userId;
ctmJob.CreateDateTime = DateTime.Now;
ctmJob.UpdateBy = userId;
ctmJob.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(ctmJob, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(ctmJob);
}
else
{
ctmJob.UpdateBy = userId;
ctmJob.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(ctmJob, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(ctmJob);
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isJOB(ctmJob.Id);
elog.Remark = "Job Update";
elog.log();
}
if (isNew)
{
txt_JobNo.Text = ctmJob.JobNo;
//txt_search_JobNo.Text = txt_JobNo.Text;
C2Setup.SetNextNo("", "CTM_Job", ctmJob.JobNo, jobDate.Date);
}
//res = Job_Check_JobLevel(ctmJob.JobNo);
Session["CTM_Job_" + txt_search_JobNo.Text] = "JobNo='" + ctmJob.JobNo + "'";
this.dsJob.FilterExpression = Session["CTM_Job_" + txt_search_JobNo.Text].ToString();
if (this.grid_job.GetRow(0) != null)
{
this.grid_job.StartEdit(0);
}
}
catch { }
return(res);
}
protected void grid_wh_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string para = e.Parameters;
if (Request.QueryString["no"] != null)
{
try
{
#region list
if (list.Count > 0)
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
string jobType = SafeValue.SafeString(Request.QueryString["type"]);
string client = SafeValue.SafeString(Request.QueryString["clientId"]);
#region OK
if (para == "OK")
{
string jobNo = "";
string refType = "";
bool action = false;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + no + "'");
C2.CtmJob job = C2.Manager.ORManager.GetObject(query) as C2.CtmJob;
C2.CtmJobDet2 trip = null;
if (job != null)
{
refType = SafeValue.SafeString(Request.QueryString["action"]);
jobNo = C2Setup.GetNextNo("", "CTM_Job_" + refType, DateTime.Today);
job.JobNo = jobNo;
job.QuoteNo = jobNo;
job.JobType = refType;
job.JobDate = DateTime.Now;
job.JobStatus = "Confirmed";
job.QuoteStatus = "None";
C2.Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(job);
C2Setup.SetNextNo("", "CTM_Job_" + refType, jobNo, DateTime.Today);
#region Trip
trip = new C2.CtmJobDet2();
string sql = string.Format(@"select max(TripIndex) from CTM_JobDet2 where JobType=@JobType and JobNo=@JobNo");
List <ConnectSql_mb.cmdParameters> list_cmd = new List <ConnectSql_mb.cmdParameters>();
list_cmd.Add(new ConnectSql_mb.cmdParameters("@JobNo", jobNo, SqlDbType.NVarChar, 100));
list_cmd.Add(new ConnectSql_mb.cmdParameters("@JobType", refType, SqlDbType.NVarChar, 100));
string maxIdex = SafeValue.SafeString(ConnectSql_mb.ExecuteScalar(sql, list_cmd).context, "//00");
int n = SafeValue.SafeInt(maxIdex.Substring(maxIdex.LastIndexOf("/") + 1), 0) + 1;
string str = (100 + n).ToString().Substring(1);
trip.BookingDate = DateTime.Today;
trip.TripIndex = jobNo + "/" + refType + "/" + str;
trip.JobNo = jobNo;
trip.FromDate = DateTime.Today;
trip.ToDate = DateTime.Today;
trip.CreateUser = HttpContext.Current.User.Identity.Name;
trip.CreateTime = DateTime.Now;
trip.UpdateUser = HttpContext.Current.User.Identity.Name;
trip.UpdateTime = DateTime.Now;
trip.JobType = refType;
trip.TripCode = refType;
trip.Remark = job.Remark;
trip.ToCode = job.DeliveryTo;
trip.FromCode = job.PickupFrom;
trip.Statuscode = "P";
C2.Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(trip);
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isCONT(trip.Id);
elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Container, 1, "");
elog.log();
#endregion
}
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
decimal qty = list[i].qty;
decimal weight = list[i].weight;
decimal volume = list[i].volume;
decimal sku_qty = list[i].sku_qty;
decimal l = list[i].l;
decimal h = list[i].h;
decimal w = list[i].w;
string refNo = list[i].refNo;
string toLoc = list[i].toLoc;
if (qty > 0)
{
Wilson.ORMapper.OPathQuery query1 = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id=" + id + "");
C2.JobHouse house = C2.Manager.ORManager.GetObject(query1) as C2.JobHouse;
house.LineId = id;
house.CargoType = "OUT";
house.JobNo = jobNo;
house.ContNo = "";
house.JobType = refType;
house.QtyOrig = qty;
house.PackQty = sku_qty;
house.Weight = weight;
house.Volume = volume;
house.WeightOrig = weight;
house.VolumeOrig = volume;
house.LandStatus = "Normal";
house.DgClass = "Normal";
house.DamagedStatus = "Normal";
house.LengthPack = l;
house.WidthPack = w;
house.HeightPack = h;
house.RefNo = no;
house.Qty = qty;
house.OpsType = "Delivery";
house.ClientId = client;
house.CargoStatus = "P";
house.TripId = trip.Id;
house.TripIndex = trip.TripIndex;
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
int lineId = house.Id;
if (refType == "TR")
{
house.LineId = lineId;
house.Location = toLoc;
house.JobNo = jobNo;
house.TransferNo = jobNo;
house.RefNo = refNo;
house.CargoType = "IN";
house.RefNo = no;
house.CargoStatus = "P";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
}
action = true;
}
else
{
action = false;
}
}
if (action)
{
e.Result = "Action Success! No is " + jobNo;
}
else
{
e.Result = "Action Error!";
}
}
#endregion
#region New WDO Trip
if (para == "NewTrip")
{
bool action = false;
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
decimal qty = list[i].qty;
decimal weight = list[i].weight;
decimal volume = list[i].volume;
decimal sku_qty = list[i].sku_qty;
decimal l = list[i].l;
decimal h = list[i].h;
decimal w = list[i].w;
string refNo = list[i].refNo;
string toLoc = list[i].toLoc;
if (qty > 0)
{
Wilson.ORMapper.OPathQuery query1 = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id=" + id + "");
C2.JobHouse house = C2.Manager.ORManager.GetObject(query1) as C2.JobHouse;
house.LineId = id;
house.CargoType = "OUT";
house.JobNo = no;
house.ContNo = "";
house.JobType = jobType;
house.QtyOrig = qty;
house.PackQty = sku_qty;
house.Weight = weight;
house.Volume = volume;
house.WeightOrig = weight;
house.VolumeOrig = volume;
house.LandStatus = "Normal";
house.DgClass = "Normal";
house.DamagedStatus = "Normal";
house.LengthPack = l;
house.WidthPack = w;
house.HeightPack = h;
house.RefNo = no;
house.Qty = qty;
house.OpsType = "Delivery";
house.ClientId = client;
house.TripIndex = SafeValue.SafeString(cbb_TripNo.Text);
house.TripId = SafeValue.SafeInt(cbb_TripNo.Value, 0);
house.CargoStatus = "P";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
}
action = true;
}
if (action)
{
e.Result = "Success";
}
else
{
e.Result = "Action Error!";
}
}
#endregion
}
else
{
e.Result = "Pls Select at least one Cargo";
}
#endregion
}
catch { }
}
}
protected void grid_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string par = e.Parameters;
string[] ar = par.Split('_');
if (par == "OK")
{
#region Create Inv
if (Request.QueryString["no"] != null)
{
try
{
bool action = false;
string res = "";
string no = SafeValue.SafeString(Request.QueryString["no"]);
string type = SafeValue.SafeString(Request.QueryString["type"]);
if (type == "IMP" || type == "EXP")
{
string sql_c = string.Format(@"select count(*) from ctm_jobdet1 where JobNo='{0}' and StatusCode!='Completed'", no);
int n = SafeValue.SafeInt(ConnectSql.ExecuteScalar(sql_c), 0);
n = 0;
if (n == 0)
{
action = true;
}
else
{
res = "Action Error!Not Completed Container,Can not Create Invoice";
}
}
else
{
action = true;
}
if (action)
{
#region Create Inv
string docId = "";
if (list.Count > 0)
{
string billType = SafeValue.SafeString(cbb_BillType.Value);
string jobNo = SafeValue.SafeString(Request.QueryString["no"]);
string client = SafeValue.SafeString(Request.QueryString["client"]);
string contType = SafeValue.SafeString(Request.QueryString["contType"]);
string user = HttpContext.Current.User.Identity.Name;
string acCode = EzshipHelper.GetAccArCode("", "SGD");
DateTime dtime = txt_DocDt.Date;
string invN = C2Setup.GetNextNo("", "AR-IV", dtime);
string termId = EzshipHelper.GetTerm(client);
string term = EzshipHelper.GetTermCode(termId);
string currency = cmb_CurrencyId.Text;
decimal exrate = SafeValue.SafeDecimal(spin_ExRate.Value);
string sql_att = string.Format(@"select ClientContact from ctm_job where JobNo='{0}'", jobNo);
string contact = SafeValue.SafeString(ConnectSql.ExecuteScalar(sql_att));
string[] currentPeriod = EzshipHelper.GetAccPeriod(dtime);
string acYear = currentPeriod[1];
string acPeriod = currentPeriod[0];
string sql = string.Format(@"insert into XAArInvoice (DocType,DocDate,PartyTo,DocNo,AcYear,AcPeriod,Term,DocDueDate,Description,
CurrencyId,MastType,ExRate,ExportInd,CancelDate,CancelInd,UserId,EntryDate,Eta,AcCode,AcSource,MastRefNo,Contact)
values('IV','{5:yyyy-MM-dd}','{4}','{0}','{6}','{7}','{8}','{5:yyyy-MM-dd}','',
'{9}','CTM',{10},'N','19000101','N','{1}',getdate(),'17530101','{2}','DB','{3}','{11}')
select @@IDENTITY", invN, user, acCode, jobNo, client, dtime, acYear, acPeriod, term, currency, exrate, contact);
docId = ConnectSql_mb.ExecuteScalar(sql);
C2Setup.SetNextNo("", "AR-IV", invN, dtime);
string code = "";
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
string chgCode = list[i].chgCode;
string chgcodeDes = list[i].chgCodedes;
if (IsCostCreated(id))
{
C2.ComMethod.CreateInv(invN, id, docId, i, billType, currency, exrate);
}
else
{
if (list.Count - i > 1)
{
code += chgcodeDes + " / ";
}
else
{
code += chgcodeDes;
}
}
}
for (int i = 0; i < list1.Count; i++)
{
int id = list1[i].id;
string chgCode = list[i].chgCode;
if (IsCostCreated(id))
{
C2.ComMethod.CreateWhInv(invN, id, docId);
}
else
{
if (list.Count - i > 1)
{
code += chgCode + " / ";
}
else
{
code += chgCode;
}
}
}
C2.XAArInvoice.update_invoice_mast(SafeValue.SafeInt(docId, 0));
if (code.Length == 0)
{
e.Result = invN;
}
else
{
e.Result = "Action Error!" + code + " already exist !";
}
}
else
{
e.Result = "Action Error!Please keyin select cost ";
}
#endregion
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isINVOICE(SafeValue.SafeInt(docId, 0));
elog.setActionLevel(SafeValue.SafeInt(docId, 0), CtmJobEventLogRemark.Level.Invoice, 3);
elog.log();
}
else
{
e.Result = res;
}
}
catch { }
}
#endregion
}
if (par == "Update")
{
#region Update Inv
if (Request.QueryString["no"] != null)
{
try
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
if (list.Count > 0)
{
string invN = lbl_DocNo.Text;
string sql = string.Format(@"select SequenceId from XAArInvoice where DocNo='{0}'", invN);
string docId = ConnectSql_mb.ExecuteScalar(sql);
string currency = cmb_CurrencyId.Text;
decimal exrate = SafeValue.SafeDecimal(spin_ExRate.Value);
string code = "";
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
string chgCode = list[i].chgCode;
string chgcodeDes = list[i].chgCodedes;
if (IsCostCreated(id))
{
C2.ComMethod.CreateInv(invN, id, docId, i, "", currency, exrate);
}
else
{
if (list.Count - i > 1)
{
code += chgcodeDes + " / ";
}
else
{
code += chgcodeDes;
}
}
}
if (code.Length == 0)
{
e.Result = invN;
}
else
{
e.Result = "Action Error!" + code + " already exist !";
}
}
else
{
e.Result = "Action Error!Please keyin select cost ";
}
}
catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); }
}
#endregion
}
if (par == "Save")
{
#region Save All
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
string contNo = list[i].contNo;
string contType = list[i].contType;
decimal price = list[i].price;
decimal qty = list[i].qty;
string unit = list[i].unit;
string code = list[i].chgCode;
string des = list[i].chgCodedes;
int lineIndex = list[i].lineIndex;
string remark = list[i].remark;
string groupBy = list[i].groupBy;
decimal locAmt = SafeValue.ChinaRound(qty * SafeValue.SafeDecimal(price, 0), 2);
string sql = string.Format(@"update job_cost set ContNo='{0}',ContType='{1}',Price={2},Qty={3},LocAmt={4},Unit='{6}',ChgCode='{7}',ChgCodeDes='{8}',LineIndex={9},Remark='{10}',GroupBy='{11}' where Id={5}",
contNo, contType, price, qty, locAmt, id, unit, code, des, lineIndex, remark, groupBy);
ConnectSql.ExecuteSql(sql);
}
e.Result = "Save Success";
}
else
{
e.Result = "Action Error!Please keyin select cost ";
}
#endregion
}
if (par == "Delete")
{
#region
if (list.Count > 0)
{
bool action = false;
string no = SafeValue.SafeString(Request.QueryString["no"]);
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
string sql = string.Format(@"select LineSource from job_cost where Id={0}", id);
string status = SafeValue.SafeString(ConnectSql_mb.ExecuteScalar(sql));
if (status != "S")
{
action = true;
sql = string.Format(@"delete from job_cost where Id={0}", id);
ConnectSql.ExecuteSql(sql);
}
else
{
e.Result = "this can not delete ";
}
}
if (action)
{
e.Result = "Action Success";
}
}
else
{
e.Result = "Please keyin select cost ";
}
#endregion
}
if (ar.Length >= 2)
{
if (ar[0].Equals("ChargeUpdateline"))
{
Update_Inline(e);
}
}
}
