//Delete public void Delete(string DELVNO) { DWH_ONTIME_DN ontimeDN = db.DWH_ONTIME_DNs.Find(DELVNO); db.DWH_ONTIME_DNs.Remove(ontimeDN); Save(); }
public ActionResult UpdateOutboundApprove(List <string> thisReasonId, List <string> txtDN, List <string> txtApprove, List <string> txtRemark, string yearId, string monthId) { using (TransactionScope Trans = new TransactionScope()) { try { // List<string> listSM = new List<string>(); int countDN = 0; List <string> DNs = new List <string>(txtApprove.Distinct()); foreach (string dn in DNs) { var reasonId = objBs.outboundAdjustedBs.GetByID(dn).OUTB_REASON_ID; bool isadjust = objBs.reasonOutboundBs.GetByID(Convert.ToInt32(reasonId)).IsAdjust; DWH_ONTIME_DN ontimeDn = objBs.dWH_ONTIME_DNBs.GetByID(dn); ontimeDn.OUTB_ADJUST = isadjust ? 1 : 0; objBs.dWH_ONTIME_DNBs.Update(ontimeDn); //delete OutboundedDelays objBs.outboundAdjustedBs.Delete(dn); //update sum of adjust daily DateTime ONTIMEDate = Convert.ToDateTime(ontimeDn.ACTGIDATE_D); string matNameId = Convert.ToString(ontimeDn.MATFRIGRP); string sectionId = Convert.ToString(ontimeDn.SECTION_ID); string departmentId = Convert.ToString(ontimeDn.DEPARTMENT_ID); if (isadjust) { int id = objBs.ontimeOutboundBs.GetAll() .Where(x => x.ActualGiDate == ONTIMEDate && x.DepartmentId == departmentId && x.SectionId == sectionId && x.MatFriGrp == matNameId).FirstOrDefault().Id; OntimeOutbound ontimeOutbound = objBs.ontimeOutboundBs.GetByID(id); int adjOntime = ontimeOutbound.AdjustOutbound + 1; ontimeOutbound.AdjustOutbound = adjOntime; ontimeOutbound.SumOfAdjustOutbound = ontimeOutbound.OnTime + adjOntime; objBs.ontimeOutboundBs.Update(ontimeOutbound); // update sum of adjust monthly int idM = objBs.ontimeOutboundMonthBs.GetAll() .Where(x => x.Year == yearId && x.Month == monthId && x.DepartmentId == departmentId && x.SectionId == sectionId && x.MatFriGrp == matNameId).FirstOrDefault().Id; OntimeOutboundMonth ontimeOutboundMonth = objBs.ontimeOutboundMonthBs.GetByID(idM); int adjOutboundMonth = ontimeOutboundMonth.AdjustOutbound + 1; ontimeOutboundMonth.AdjustOutbound = adjOutboundMonth; ontimeOutboundMonth.SumOfAdjustOutbound = ontimeOutboundMonth.OnTime + adjOutboundMonth; objBs.ontimeOutboundMonthBs.Update(ontimeOutboundMonth); // update sum of adjust yearly int idY = objBs.ontimeOutboundYearBs.GetAll() .Where(x => x.Year == yearId && x.DepartmentId == departmentId && x.SectionId == sectionId && x.MatFriGrp == matNameId).FirstOrDefault().Id; OntimeOutboundYear ontimeOutboundYear = objBs.ontimeOutboundYearBs.GetByID(idY); int adjOutboundYear = ontimeOutboundYear.AdjustOutbound + 1; ontimeOutboundYear.AdjustOutbound = adjOutboundYear; ontimeOutboundYear.SumOfAdjustOutbound = ontimeOutboundYear.OnTime + adjOutboundYear; objBs.ontimeOutboundYearBs.Update(ontimeOutboundYear); countDN++; } } Trans.Complete(); return(Content(countDN + " - Delivery note is adjusted Successfully!")); } catch (Exception ex) { return(Content("Operation update reason ontimed failed !" + ex.ToString())); } // return View(); } }
//Update public void Update(DWH_ONTIME_DN DWH_ONTIME_DN) { db.Entry(DWH_ONTIME_DN).State = EntityState.Modified; Save(); }
//Insert public void Insert(DWH_ONTIME_DN DWH_ONTIME_DN) { db.DWH_ONTIME_DNs.Add(DWH_ONTIME_DN); Save(); }
public ContentResult UploadReason() { using (TransactionScope Trans = new TransactionScope()) { for (int i = 0; i < Request.Files.Count; i++) { string errorRef = ""; string reference = Request.Files.AllKeys[i]; HttpPostedFileBase FileUpload = Request.Files[i]; //Uploaded file //Use the following properties to get file's name, size and MIMEType string fileName = reference; string targetpath = Server.MapPath("~/Content/Docs/docrtn/"); FileUpload.SaveAs(targetpath + DateTime.Now.ToString("yyyyMMddHHmm", new CultureInfo("th-TH")) + "_adjust.xlsx"); string pathToExcelFile = targetpath + DateTime.Now.ToString("yyyyMMddHHmm", new CultureInfo("th-TH")) + "_adjust.xlsx"; var ext = Path.GetExtension(pathToExcelFile); int countDN = 0; //if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") if (ext == ".xlsx") { DataTable dT = ExcelModels.openExcel(pathToExcelFile, 1); try { foreach (DataRow dr in dT.Rows) { //Do record adjust data - send to approval if (!String.IsNullOrEmpty(dr[0].ToString())) { string dn = dr[0].ToString(); int reasonId = Convert.ToInt32(dr[14].ToString()); string remark = dr[15].ToString(); string reasonName = objBs.reasonDocReturnBs.GetByID(reasonId).Name; bool isadjust = objBs.reasonDocReturnBs.GetByID(Convert.ToInt32(reasonId)).IsAdjust; DWH_ONTIME_DN ontimeDn = objBs.dWH_ONTIME_DNBs.GetByID(dn); ontimeDn.SCGL_DOCRET_ADJUST = isadjust ? 0 : 0; ontimeDn.SCGL_DOCRET_ADJUST_BY = User.Identity.Name; ontimeDn.SCGL_DOCRET_ADJUST_DATE = DateTime.Now; ontimeDn.SCGL_DOCRET_REASON = reasonName; ontimeDn.SCGL_DOCRET_REASON_ID = Convert.ToInt32(reasonId); ontimeDn.SCGL_DOCRET_REMARK = remark; objBs.dWH_ONTIME_DNBs.Update(ontimeDn); DocReturnDelay tmp_adjusted = objBs.docReturnDelayBs.GetByID(dn); if (tmp_adjusted == null) { errorRef = errorRef + dn + " , "; } else { DocReturnAdjusted tmp_toInsert = new DocReturnAdjusted { 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, TO_SHPG_LOC_NAME = tmp_adjusted.TO_SHPG_LOC_NAME, VENDOR_CODE = tmp_adjusted.VENDOR_CODE, VENDOR_NAME = tmp_adjusted.VENDOR_NAME, PLNDOCRETDATE_SCGL = tmp_adjusted.PLNDOCRETDATE_SCGL, PLNDOCRETDATE_SCGL_D = tmp_adjusted.PLNDOCRETDATE_SCGL_D, DOCRETDATE_SCGL = tmp_adjusted.DOCRETDATE_SCGL, DOCRETDATE_SCGL_D = tmp_adjusted.DOCRETDATE_SCGL_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, SCGL_DOCRET_ADJUST = isadjust ? 1 : 0, SCGL_DOCRET_ADJUST_BY = User.Identity.Name, SCGL_DOCRET_ADJUST_DATE = DateTime.Now, SCGL_DOCRET_REASON = reasonName, SCGL_DOCRET_REASON_ID = Convert.ToInt32(reasonId), SCGL_DOCRET_REMARK = remark }; //insert for approval objBs.docReturnAdjustedBs.Insert(tmp_toInsert); //delete AcceptedDelays objBs.docReturnDelayBs.Delete(dn); countDN++; } } } Trans.Complete(); if (errorRef != "") { errorRef = "<div style='overflow:auto'> DN หมายเลข " + errorRef + "ได้ทำการ adjust ไปแล้ว </div>"; } return(Content("อัพโหลดสำเร็จ " + countDN + " DN" + "<br>" + errorRef)); } catch (Exception e) { return(Content("อัพโหลดไม่สำเร็จ กรอกข้อมูลไม่ถูกต้อง")); } } //deleting excel file from folder if ((System.IO.File.Exists(pathToExcelFile))) { System.IO.File.Delete(pathToExcelFile); } } } return(Content("อัพโหลดไม่สำเร็จ ประเภทไฟล์ไม่ถูกต้อง")); }
public ActionResult UpdateDocReturnReason(List <String> dynamic_select, List <string> txtDN, List <string> txtRemark) { using (TransactionScope Trans = new TransactionScope()) { try { // List<string> listSM = new List<string>(); 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.reasonDocReturnBs.GetByID(Convert.ToInt32(reasonId)).Name; bool isadjust = objBs.reasonDocReturnBs.GetByID(Convert.ToInt32(reasonId)).IsAdjust; DWH_ONTIME_DN ontimeDn = objBs.dWH_ONTIME_DNBs.GetByID(dn); ontimeDn.SCGL_DOCRET_ADJUST = isadjust ? 0 : 0; ontimeDn.SCGL_DOCRET_ADJUST_BY = User.Identity.Name; ontimeDn.SCGL_DOCRET_ADJUST_DATE = DateTime.Now; ontimeDn.SCGL_DOCRET_REASON = reasonName; ontimeDn.SCGL_DOCRET_REASON_ID = Convert.ToInt32(reasonId); ontimeDn.SCGL_DOCRET_REMARK = remark; objBs.dWH_ONTIME_DNBs.Update(ontimeDn); DocReturnDelay tmp_adjusted = objBs.docReturnDelayBs.GetByID(dn); if (tmp_adjusted == null) { return(Json("DN " + dn + " ได้ทำการ adjust ไปแล้ว")); } DocReturnAdjusted tmp_toInsert = new DocReturnAdjusted { 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, TO_SHPG_LOC_NAME = tmp_adjusted.TO_SHPG_LOC_NAME, VENDOR_CODE = tmp_adjusted.VENDOR_CODE, VENDOR_NAME = tmp_adjusted.VENDOR_NAME, PLNDOCRETDATE_SCGL = tmp_adjusted.PLNDOCRETDATE_SCGL, PLNDOCRETDATE_SCGL_D = tmp_adjusted.PLNDOCRETDATE_SCGL_D, DOCRETDATE_SCGL = tmp_adjusted.DOCRETDATE_SCGL, DOCRETDATE_SCGL_D = tmp_adjusted.DOCRETDATE_SCGL_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, SCGL_DOCRET_ADJUST = isadjust ? 1 : 0, SCGL_DOCRET_ADJUST_BY = User.Identity.Name, SCGL_DOCRET_ADJUST_DATE = DateTime.Now, SCGL_DOCRET_REASON = reasonName, SCGL_DOCRET_REASON_ID = Convert.ToInt32(reasonId), SCGL_DOCRET_REMARK = remark }; //insert for approval objBs.docReturnAdjustedBs.Insert(tmp_toInsert); //delete AcceptedDelays objBs.docReturnDelayBs.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 doc return failed !" + ex.InnerException.InnerException.Message.ToString() })); } } }
//Update public void Update(DWH_ONTIME_DN DWH_ONTIME_DN) { objDb.Update(DWH_ONTIME_DN); }
//Insert public void Insert(DWH_ONTIME_DN DWH_ONTIME_DN) { objDb.Insert(DWH_ONTIME_DN); }