public BizResult insert(string user, CtmJobDet2 par)
{
setData(null);
if (par == null)
{
throw new Exception("data is null");
}
BizResult res = new BizResult();
if (inserting_verify(res, user, par))
{
Manager.ORManager.StartTracking(par, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(par);
res.status = true;
trip = par;
resetOldValues();
inserted_to_container(user);
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isBackend();
elog.Controller = user;
elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Trip, 1);
elog.log();
}
return(res);
}
public BizResult delete_RowDeleting(string user)
{
BizResult res = new BizResult();
if (det1 == null || det1.Id == 0)
{
res.context = "Data is empty";
}
else
{
if (updating_verify(res, user, det1))
{
res.status = true;
System.Collections.ObjectModel.Collection <C2.CtmJobDet2> det2 = C2.Manager.ORManager.GetCollection <C2.CtmJobDet2>("det1Id=" + det1.Id);
C2.CtmJobDet2Biz det2Bz = new CtmJobDet2Biz(0);
foreach (C2.CtmJobDet2 temp in det2)
{
det2Bz.setData(temp);
det2Bz.delete(user);
}
//string sql = string.Format(@"delete from ctm_jobdet2 where det1Id=@Id");
//List<ConnectSql_mb.cmdParameters> list = new List<ConnectSql_mb.cmdParameters>();
//list.Add(new ConnectSql_mb.cmdParameters("@Id", det1.Id, SqlDbType.Int));
//ConnectSql_mb.sqlResult sqlRes = ConnectSql_mb.ExecuteNonQuery(sql, list);
}
}
return(res);
}
public BizResult delete(string user)
{
BizResult res = new BizResult();
if (trip == null || trip.Id == 0)
{
res.context = "Data is empty";
}
else
{
if (updating_verify(res, user, trip))
{
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isBackend();
elog.Controller = user;
elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Trip, 2);
//===========
deleting_reSequence_autoFixIncentive();
Manager.ORManager.ExecuteDelete <CtmJobDet2>("Id=" + trip.Id);
res.status = true;
deleted_removeCost();
elog.log();
}
}
return(res);
}
public BizResult update(string user)
{
BizResult res = new BizResult();
if (trip == null)
{
res.context = "Data is empty";
return(res);
}
if (updating_verify(res, user, trip))
{
updated_before(user);
Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(trip);
res.status = true;
updated_Status_changed(user);
updated_reSequence_autoFixIncentive();
updated_to_container(user);
updated_to_house(user);
updated_to_cost(user);
resetOldValues();
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isBackend();
elog.Controller = user;
elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Trip, 3, " Status[" + trip.Statuscode + "]FromDate[" + trip.FromDate.ToString("yyyyMMdd") + "]");
elog.log();
}
return(res);
}
private bool inserting_verify(BizResult bzR, string user, CtmJobDet1 par)
{
bool res = false;
string role = SafeValue.SafeString(ConnectSql.ExecuteScalar(string.Format("select role from [user] where Name='{0}'", user)));
CtmJob job = Manager.ORManager.GetObject(new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + par.JobNo + "'")) as CtmJob;
if (job == null)
{
bzR.context = "Can not find this job";
}
else
{
if (role.ToLower() == "client")
{
switch (job.JobStatus)
{
case "Booked":
res = true;
break;
case "Cancel":
bzR.context = "This job have been cancel";
break;
case "Reject":
case "Confirmed":
case "Completed":
case "Closed":
default:
bzR.context = "No permission";
break;
}
}
else
{
switch (job.JobStatus)
{
case "Booked":
case "Cancel":
bzR.context = "Requair confirm this job";
break;
case "Completed":
case "Closed":
bzR.context = "This Job have completed";
break;
default:
res = true;
break;
}
}
}
return(res);
}
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));
}
public BizResult delete_RowDeleting(string user)
{
BizResult res = new BizResult();
if (trip == null || trip.Id == 0)
{
res.context = "Data is empty";
}
else
{
if (updating_verify(res, user, trip))
{
deleting_reSequence_autoFixIncentive();
res.status = true;
deleted_removeCost();
}
}
return(res);
}
private void updating_verify_diffJobType_tripType(BizResult bzR, CtmJob job, CtmJobDet2 par)
{
if (job != null && trip != null)
{
if (par.TripCode.Equals("IMP") || par.TripCode.Equals("EXP"))
{
if (job != null)
{
if (job.JobType.Equals("EXP") && par.TripCode.Equals("IMP"))
{
bzR.context = "Export Job can not save IMP trip";
}
if (job.JobType.Equals("IMP") && par.TripCode.Equals("EXP"))
{
bzR.context = "Import Job can not save EXP trip";
}
}
}
}
}
public BizResult delete(string user)
{
BizResult res = new BizResult();
if (det1 == null || det1.Id == 0)
{
res.context = "Data is empty";
}
else
{
if (updating_verify(res, user, det1))
{
string sql = string.Format(@"delete from ctm_jobdet1 where Id=@Id");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Id", det1.Id, SqlDbType.Int));
ConnectSql_mb.sqlResult sqlRes = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (sqlRes.status)
{
res.status = true;
CtmJobEventLog lg = new CtmJobEventLog();
lg.Platform_isBackend();
lg.Controller = user;
//lg.JobNo = det1.JobNo;
//lg.ContainerNo = det1.ContainerNo;
//lg.Remark = "ContDelete";
lg.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, 2);
lg.log();
System.Collections.ObjectModel.Collection <C2.CtmJobDet2> det2 = C2.Manager.ORManager.GetCollection <C2.CtmJobDet2>("det1Id=" + det1.Id);
C2.CtmJobDet2Biz det2Bz = new CtmJobDet2Biz(0);
foreach (C2.CtmJobDet2 temp in det2)
{
det2Bz.setData(temp);
det2Bz.delete(user);
}
//sql = string.Format(@"delete from ctm_jobdet2 where det1Id=@Id");
//ConnectSql_mb.ExecuteNonQuery(sql, list);
}
}
}
return(res);
}
public BizResult update(string user)
{
BizResult res = new BizResult();
if (det1 == null)
{
throw new Exception("data is null");
}
if (updating_verify(res, user, det1))
{
det1.ScheduleDate = SafeValue_mb.DateTime_ClearTime(det1.ScheduleDate);
det1.ScheduleTime = SafeValue_mb.convertTimeFormat(det1.ScheduleTime);
det1.ServiceType = (SafeValue.SafeString(det1.ServiceType).Equals("") ? default_ServiceType : det1.ServiceType);
Manager.ORManager.StartTracking(det1, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(det1);
res.status = true;
//========== log container no changed
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isBackend();
elog.Controller = user;
if (oldv_containerNo != null && det1.ContainerNo != null && !oldv_containerNo.Equals(det1.ContainerNo))
{
elog.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, -1, "ContainerNo[" + oldv_containerNo + "]->[" + det1.ContainerNo + "]");
elog.log();
}
updated_Status_changed(user);
updated_to_trip();
updated_to_house(user);
resetOldValues();
elog.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, 3);
elog.log();
}
return(res);
}
public BizResult insert(string user, CtmJobDet1 par)
{
setData(null);
if (par == null)
{
throw new Exception("data is null");
}
BizResult res = new BizResult();
if (inserting_verify(res, user, par))
{
par.ScheduleDate = SafeValue_mb.DateTime_ClearTime(par.ScheduleDate);
par.ScheduleTime = SafeValue_mb.convertTimeFormat(par.ScheduleTime);
par.ScheduleStartDate = SafeValue_mb.DateTime_ClearTime(par.ScheduleStartDate);
par.ServiceType = (SafeValue.SafeString(par.ServiceType).Equals("") ? default_ServiceType : par.ServiceType);
Manager.ORManager.StartTracking(par, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(par);
res.status = true;
det1 = par;
updated_Status_changed(user);
resetOldValues();
oldv_ServiceType = "";//==== update trips by service type.
inserted_auto_CreateTrip(user);
updated_to_trip();
resetOldValues();
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isBackend();
elog.Controller = user;
elog.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, 1);
elog.log();
}
return(res);
}
private void container_new()
{
C2.CtmJob job = C2.Manager.ORManager.GetObject(new Wilson.ORMapper.OPathQuery <C2.CtmJob>("JobNo='" + txt_JobNo.Text + "'"));
if (job != null)
{
string user = HttpContext.Current.User.Identity.Name;
C2.CtmJobDet1Biz det1Bz = new C2.CtmJobDet1Biz(0);
C2.CtmJobDet1 det1 = new C2.CtmJobDet1();
det1.JobNo = job.JobNo;
det1.RequestDate = DateTime.Now;
det1.CfsInDate = DateTime.Now;
det1.CfsOutDate = DateTime.Now;
det1.YardPickupDate = DateTime.Now;
det1.YardReturnDate = DateTime.Now;
det1.CdtDate = DateTime.Now;
det1.YardExpiryDate = DateTime.Now;
det1.F5Ind = "N";
det1.UrgentInd = "N";
det1.StatusCode = "New";
//det1.YardCode = job.YardCode;
//det1.YardAddress = job.YardRef;
#region container sss
string values = "";
if (btn_ContNo.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo.Text;
det1.ContainerType = txt_ContType.Text;
det1.SealNo = txt_SealNo.Text;
det1.YardAddress = btn_YardAddress.Text;
det1.Remark = txt_Remark.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType.Value);
det1.UrgentInd = txt_Urgent.Text;
det1.Permit = txt_Permit.Text;
det1.DgClass = txt_dg.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo1.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo1.Text;
det1.ContainerType = txt_ContType1.Text;
det1.SealNo = txt_SealNo1.Text;
det1.YardAddress = btn_YardAddress1.Text;
det1.Remark = txt_Remark1.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry1.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time1.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight1.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType1.Value);
det1.UrgentInd = txt_Urgent1.Text;
det1.Permit = txt_Permit1.Text;
det1.DgClass = txt_dg1.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo2.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo2.Text;
det1.ContainerType = txt_ContType2.Text;
det1.SealNo = txt_SealNo2.Text;
det1.YardAddress = btn_YardAddress2.Text;
det1.Remark = txt_Remark2.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry2.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time2.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight2.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType2.Value);
det1.UrgentInd = txt_Urgent2.Text;
det1.Permit = txt_Permit2.Text;
det1.DgClass = txt_dg2.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo3.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo3.Text;
det1.ContainerType = txt_ContType3.Text;
det1.SealNo = txt_SealNo3.Text;
det1.YardAddress = btn_YardAddress3.Text;
det1.Remark = txt_Remark3.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry3.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time3.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight3.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType3.Value);
det1.UrgentInd = txt_Urgent3.Text;
det1.Permit = txt_Permit3.Text;
det1.DgClass = txt_dg3.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo4.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo4.Text;
det1.ContainerType = txt_ContType4.Text;
det1.SealNo = txt_SealNo4.Text;
det1.YardAddress = btn_YardAddress4.Text;
det1.Remark = txt_Remark4.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry4.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time4.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight4.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType4.Value);
det1.UrgentInd = txt_Urgent4.Text;
det1.Permit = txt_Permit4.Text;
det1.DgClass = txt_dg4.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo5.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo5.Text;
det1.ContainerType = txt_ContType5.Text;
det1.SealNo = txt_SealNo5.Text;
det1.YardAddress = btn_YardAddress5.Text;
det1.Remark = txt_Remark5.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry5.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time5.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight5.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType5.Value);
det1.UrgentInd = txt_Urgent5.Text;
det1.Permit = txt_Permit5.Text;
det1.DgClass = txt_dg5.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo6.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo6.Text;
det1.ContainerType = txt_ContType6.Text;
det1.SealNo = txt_SealNo6.Text;
det1.YardAddress = btn_YardAddress6.Text;
det1.Remark = txt_Remark6.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry6.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time6.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight6.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType6.Value);
det1.UrgentInd = txt_Urgent6.Text;
det1.Permit = txt_Permit6.Text;
det1.DgClass = txt_dg6.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo7.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo7.Text;
det1.ContainerType = txt_ContType7.Text;
det1.SealNo = txt_SealNo7.Text;
det1.YardAddress = btn_YardAddress7.Text;
det1.Remark = txt_Remark7.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry7.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time7.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight7.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType7.Value);
det1.UrgentInd = txt_Urgent7.Text;
det1.Permit = txt_Permit7.Text;
det1.DgClass = txt_dg7.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo8.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo8.Text;
det1.ContainerType = txt_ContType8.Text;
det1.SealNo = txt_SealNo8.Text;
det1.YardAddress = btn_YardAddress8.Text;
det1.Remark = txt_Remark8.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry8.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time8.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight8.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType8.Value);
det1.UrgentInd = txt_Urgent8.Text;
det1.Permit = txt_Permit8.Text;
det1.DgClass = txt_dg8.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (btn_ContNo9.Text.Trim().Length > 0)
{
det1.ContainerNo = btn_ContNo9.Text;
det1.ContainerType = txt_ContType9.Text;
det1.SealNo = txt_SealNo9.Text;
det1.YardAddress = btn_YardAddress9.Text;
det1.Remark = txt_Remark9.Text;
det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry9.Date, new DateTime(1990, 1, 1));
det1.ScheduleTime = txt_time9.Text;
det1.Weight = SafeValue.SafeDecimal(txt_Weight9.Text);
det1.ServiceType = SafeValue.SafeString(cmb_ServiceType9.Value);
det1.UrgentInd = txt_Urgent9.Text;
det1.Permit = txt_Permit9.Text;
det1.DgClass = txt_dg9.Text;
det1.JobType = job.JobType;
det1.Br = job.CarrierBkgNo;
C2.BizResult bRes = det1Bz.insert(user, det1);
if (!bRes.status)
{
values = bRes.context;
}
}
if (values.Length == 0)
{
values = "Success";
}
Response.Write("<script>parent.Popup_ContainerBatchAdd_callback('" + values + "');</script>");
#endregion
}
}
private bool updating_verify(BizResult bzR, string user, CtmJobDet2 par)
{
bool res = false;
string role = SafeValue.SafeString(ConnectSql.ExecuteScalar(string.Format("select role from [user] where Name='{0}'", user)));
if (role.ToLower() == "client")
{
bzR.context = "No permission";
return(res);
}
if (role.ToLower().Equals("driver"))
{
if (trip.DriverCode.Equals(user) || trip.DriverCode2.Equals(user) || trip.DriverCode11.Equals(user) || trip.DriverCode12.Equals(user))
{
}
else
{
bzR.context = "No permission";
return(res);
}
}
CtmJobDet1 det1 = Manager.ORManager.GetObject <CtmJobDet1>(par.Det1Id);
CtmJob job = Manager.ORManager.GetObject(new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + par.JobNo + "'")) as CtmJob;
if (job == null)
{
bzR.context = "Mast data is empty";
}
else
{
switch (job.StatusCode)
{
case "CLS":
bzR.context = "This Job have been completed";
break;
case "CNL":
bzR.context = "This Job have been Canceled";
break;
default:
break;
}
//switch (job.JobStatus)
//{
// case "Booked":
// bzR.context = "Requair confirm job";
// break;
// case "Cancel":
// bzR.context = "This job have been cancel";
// break;
// case "Reject":
// bzR.context = "This job have been Reject";
// break;
// case "Completed":
// case "Closed":
// bzR.context = "This job have been Completed";
// break;
// default:
// break;
//}
if (det1 != null)
{
//if (det1.StatusCode == "Completed")
//{
// bzR.context = "This container have been Completed";
//}
}
updating_verify_diffJobType_tripType(bzR, job, par);
if (bzR.context.Length == 0)
{
res = true;
}
}
return(res);
}
private bool inserting_verify(BizResult bzR, string user, CtmJobDet2 par)
{
bool res = updating_verify(bzR, user, par);
return(res);
}
