//Delete
public void Delete(string deliveryNote)
{
OutboundAdjusted outboundAdjusted = db.OutboundAdjusted.Find(deliveryNote);
db.OutboundAdjusted.Remove(outboundAdjusted);
Save();
}
//Update
public void Update(OutboundAdjusted outboundAdjusted)
{
objDb.Update(outboundAdjusted);
}
//Insert
public void Insert(OutboundAdjusted outboundAdjusted)
{
objDb.Insert(outboundAdjusted);
}
//Update
public void Update(OutboundAdjusted outboundAdjusted)
{
db.Entry(outboundAdjusted).State = EntityState.Modified;
Save();
}
//Insert
public void Insert(OutboundAdjusted outboundAdjusted)
{
db.OutboundAdjusted.Add(outboundAdjusted);
Save();
}
public ActionResult UpdateOutboundReason(List <String> dynamic_select, List <string> txtDN, List <string> txtRemark)
{
using (TransactionScope Trans = new TransactionScope())
{
try
{
//Write to Adjested table
int countDN = 0;
for (int i = 0; i < dynamic_select.Count; i++)
{
if (!String.IsNullOrEmpty(dynamic_select[i]))
{
string dn = txtDN[i];
string reasonId = dynamic_select[i];
string remark = txtRemark[i];
string reasonName = objBs.reasonOutboundBs.GetByID(Convert.ToInt32(reasonId)).Name;
bool isadjust = objBs.reasonOutboundBs.GetByID(Convert.ToInt32(reasonId)).IsAdjust;
DWH_ONTIME_DN ontimeDn = objBs.dWH_ONTIME_DNBs.GetByID(dn);
ontimeDn.OUTB_ADJUST = isadjust ? 0 : 0;
ontimeDn.OUTB_ADJUST_BY = User.Identity.Name;
ontimeDn.OUTB_ADJUST_DATE = DateTime.Now;
ontimeDn.OUTB_REASON = reasonName;
ontimeDn.OUTB_REASON_ID = Convert.ToInt32(reasonId);
ontimeDn.OUTB_REMARK = remark;
objBs.dWH_ONTIME_DNBs.Update(ontimeDn);
OutboundDelay tmp_adjusted = new OutboundDelay();
tmp_adjusted = objBs.outboundDelayBs.GetByID(dn);
if (tmp_adjusted == null)
{
return(Json("DN " + dn + " ได้ทำการ adjust ไปแล้ว"));
}
OutboundAdjusted tmp_toInsert = new OutboundAdjusted
{
CARRIER_ID = tmp_adjusted.CARRIER_ID,
DEPARTMENT_ID = tmp_adjusted.DEPARTMENT_ID,
DEPARTMENT_NAME = tmp_adjusted.DEPARTMENT_NAME,
SECTION_ID = tmp_adjusted.SECTION_ID,
SECTION_NAME = tmp_adjusted.SECTION_NAME,
MATFRIGRP = tmp_adjusted.MATFRIGRP,
MATNAME = tmp_adjusted.MATNAME,
REGION_ID = tmp_adjusted.REGION_ID,
REGION_NAME_EN = tmp_adjusted.REGION_NAME_EN,
REGION_NAME_TH = tmp_adjusted.REGION_NAME_TH,
SOLDTO = tmp_adjusted.SOLDTO,
SOLDTO_NAME = tmp_adjusted.SOLDTO_NAME,
SHIPTO = tmp_adjusted.SHIPTO,
SEGMENT = tmp_adjusted.SEGMENT,
SUBSEGMENT = tmp_adjusted.SUBSEGMENT,
TO_SHPG_LOC_NAME = tmp_adjusted.TO_SHPG_LOC_NAME,
VENDOR_CODE = tmp_adjusted.VENDOR_CODE,
VENDOR_NAME = tmp_adjusted.VENDOR_NAME,
PLNOUTBDATE = tmp_adjusted.PLNOUTBDATE,
PLNOUTBDATE_D = tmp_adjusted.PLNOUTBDATE_D,
ACDLVDATE = tmp_adjusted.ACDLVDATE,
ACDLVDATE_D = tmp_adjusted.ACDLVDATE_D,
ACTGIDATE = tmp_adjusted.ACTGIDATE,
ACTGIDATE_D = tmp_adjusted.ACTGIDATE_D,
SHPPOINT = tmp_adjusted.SHPPOINT,
TRUCK_TYPE = tmp_adjusted.TRUCK_TYPE,
DELVNO = tmp_adjusted.DELVNO,
SHPMNTNO = tmp_adjusted.SHPMNTNO,
LOADED_DATE = DateTime.Now,
OUTB_ADJUST = isadjust ? 1 : 0,
OUTB_ADJUST_BY = User.Identity.Name,
OUTB_ADJUST_DATE = DateTime.Now,
OUTB_REASON = reasonName,
OUTB_REASON_ID = Convert.ToInt32(reasonId),
OUTB_REMARK = remark
};
//insert waiting for approval
objBs.outboundAdjustedBs.Insert(tmp_toInsert);
//delete OntimeDelays
objBs.outboundDelayBs.Delete(dn);
countDN++;
}
}
Trans.Complete();
return(RedirectToAction("Index", new { sms = countDN + "-DN is adjusted Successfully!" }));
}
catch (Exception ex)
{
return(RedirectToAction("Index", new { sms = "Operation update reason accepted failed !" + ex.InnerException.InnerException.Message.ToString() }));
}
}
}
