//Delete public void Delete(string deliveryNote) { OutboundDelay outboundDelay = db.OutboundDelays.Find(deliveryNote); db.OutboundDelays.Remove(outboundDelay); Save(); }
//Update public void Update(OutboundDelay outboundDelay) { db.Entry(outboundDelay).State = EntityState.Modified; Save(); }
//Insert public void Insert(OutboundDelay outboundDelay) { db.OutboundDelays.Add(outboundDelay); Save(); }
//Insert public void Insert(OutboundDelay outboundDelay) { objDb.Insert(outboundDelay); }
//Update public void Update(OutboundDelay outboundDelay) { objDb.Update(outboundDelay); }
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() })); } } }