public void FSL_Container_ReadyReturn(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
int contId = SafeValue.SafeInt(job["contId"], 0);
string Time = SafeValue.SafeString(job["Time"]);
string Location = SafeValue.SafeString(job["Location"]);
string user = SafeValue.SafeString(job["user"]);
C2.CtmJobDet1Biz det1Bz = new C2.CtmJobDet1Biz(contId);
C2.CtmJobDet1 det1 = det1Bz.getData();
bool status = false;
string context = Common.StringToJson("");
if (det1 != null)
{
try
{
det1.WhsReadyInd = "Y";
det1.WhsReadyTime = Time;
det1.WhsReadyLocation = Location;
C2.Manager.ORManager.StartTracking(det1, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(det1);
status = true;
#region lot alert
string sql = string.Format(@"select ClientId,EmailAddress
from CTM_JobDet1 as det1
left outer join CTM_Job as job on det1.JobNo=job.JobNo
where det1.Id=@contId");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@contId", contId, SqlDbType.Int));
string client = "";
string EmailAddress = "";
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
client = SafeValue.SafeString(dt.Rows[0]["ClientId"]);
EmailAddress = SafeValue.SafeString(dt.Rows[0]["EmailAddress"]);
}
C2.CtmJobEventLog log = new C2.CtmJobEventLog();
log.Platform_isMobile();
log.Controller = user;
log.ActionLevel_isCONT(contId);
log.isAlert(client);
log.setRemark(CtmJobEventLogRemark.Level.Container, -1, user + " set ready to return [" + Time + "]");
log.log();
#endregion
C2.Email.SendEmail(EmailAddress, "[email protected],[email protected]", "", "TSL Customer Alert", "Dear Customer:Container:[" + det1.ContainerNo + "] is ready to return.", "");
context = "{\"Client\":\"" + client + "\",\"text\":\"" + det1.ContainerNo + " ready to return\"}";
}
catch { }
}
Common.WriteJsonP(status, context);
}
private void updated_to_container(string user)
{
CtmJobDet1Biz det1Bz = new CtmJobDet1Biz(trip.Det1Id);
CtmJobDet1 det1 = det1Bz.getData();
if (det1 != null)
{
bool canSave = false;
canSave = canSave || updated_to_container_contNo(det1);
canSave = canSave || updated_to_container_status(det1);
if (canSave)
{
det1Bz.update(user);
}
}
}
private void inserted_to_container(string user)
{
C2.CtmJobDet1Biz bz = new CtmJobDet1Biz(this.trip.Det1Id);
C2.CtmJobDet1 det1 = bz.getData();
if (det1 != null)
{
string sql = string.Format(@"select count(*) from ctm_jobdet2 where (StatusCode='P' or StatusCode='S') and Det1Id=@Det1Id");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Det1Id", det1.Id, SqlDbType.Int));
int cc = SafeValue.SafeInt(ConnectSql_mb.ExecuteScalar(sql, list), 0);
if (cc > 0)
{
det1.StatusCode = "InTransit";
bz.update(user);
}
}
}
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 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
}
}
