//Delete public void Delete(string shipmentNo) { TenderedAdjusted tenderedAdjusted = db.TenderedAdjusted.Find(shipmentNo); db.TenderedAdjusted.Remove(tenderedAdjusted); Save(); }
//Update public void Update(TenderedAdjusted tenderedAdjusted) { objDb.Update(tenderedAdjusted); }
//Insert public void Insert(TenderedAdjusted tenderedAdjusted) { objDb.Insert(tenderedAdjusted); }
//Insert public void Insert(TenderedAdjusted tenderedAdjusted) { db.TenderedAdjusted.Add(tenderedAdjusted); Save(); }
//Update public void Update(TenderedAdjusted tenderedAdjusted) { db.Entry(tenderedAdjusted).State = EntityState.Modified; 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/tnrd/"); 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 countSM = 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 sm = dr[0].ToString(); int reasonId = Convert.ToInt32(dr[15].ToString()); string remark = dr[16].ToString(); string reasonName = objBs.ReasonTenderedBs.GetByID(reasonId).Name; bool isadjust = objBs.ReasonTenderedBs.GetByID(Convert.ToInt32(reasonId)).IsAdjust; DWH_ONTIME_SHIPMENT ontimeShipment = objBs.dWH_ONTIME_SHIPMENTBs.GetByID(sm); //Change adjustable here ontimeShipment.TNRD_ADJUST = 0; ontimeShipment.TNRD_ADJUST_BY = User.Identity.Name; ontimeShipment.TNRD_ADJUST_DATE = DateTime.Now; ontimeShipment.TNRD_ONTIME_REASON = reasonName; ontimeShipment.TNRD_ONTIME_REASON_ID = Convert.ToInt32(reasonId); ontimeShipment.TNRD_ONTIME_REMARK = remark; objBs.dWH_ONTIME_SHIPMENTBs.Update(ontimeShipment); TenderedDelay tmp_adjusted = objBs.tenderedDelayBs.GetByID(sm); if (tmp_adjusted == null) { errorRef = errorRef + sm + " , "; } else { TenderedAdjusted tmp_toInsert = new TenderedAdjusted { 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, LAST_SHPG_LOC_NAME = tmp_adjusted.LAST_SHPG_LOC_NAME, VENDOR_CODE = tmp_adjusted.VENDOR_CODE, VENDOR_NAME = tmp_adjusted.VENDOR_NAME, SHCRDATE = tmp_adjusted.SHCRDATE, SHCRDATE_D = tmp_adjusted.SHCRDATE_D, PLNTNRDDATE = tmp_adjusted.PLNTNRDDATE, PLNTNRDDATE_D = tmp_adjusted.PLNTNRDDATE_D, FTNRDDATE = tmp_adjusted.FTNRDDATE, FTNRDDATE_D = tmp_adjusted.FTNRDDATE_D, SHPPOINT = tmp_adjusted.SHPPOINT, TRUCK_TYPE = tmp_adjusted.TRUCK_TYPE, SHPMNTNO = tmp_adjusted.SHPMNTNO, DELVNO = tmp_adjusted.DELVNO, CRTD_USR_CD = tmp_adjusted.CRTD_USR_CD, UPDT_USR_CD = tmp_adjusted.UPDT_USR_CD, LOADED_DATE = DateTime.Now, TNRD_ADJUST = isadjust ? 1 : 0, TNRD_ADJUST_BY = User.Identity.Name, TNRD_ADJUST_DATE = DateTime.Now, TNRD_ONTIME_REASON = reasonName, TNRD_ONTIME_REASON_ID = Convert.ToInt32(reasonId), TNRD_ONTIME_REMARK = remark }; //insert waiting ofr approval objBs.tenderedAdjustedBs.Insert(tmp_toInsert); //delete AcceptedDelays objBs.tenderedDelayBs.Delete(sm); countSM++; } } } Trans.Complete(); if (errorRef != "") { errorRef = "<div style='overflow:auto'> Shipment หมายเลข " + errorRef + "ได้ทำการ adjust ไปแล้ว </div>"; } return(Content("อัพโหลดสำเร็จ " + countSM + " Shipment" + "<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 UpdateTenderReason(List <String> dynamic_select, List <string> txtSM, List <string> txtRemark) { using (TransactionScope Trans = new TransactionScope()) { try { // List<string> listSM = new List<string>(); int countSM = 0; for (int i = 0; i < dynamic_select.Count; i++) { if (!String.IsNullOrEmpty(dynamic_select[i])) { string sm = txtSM[i]; string reasonId = dynamic_select[i]; string remark = txtRemark[i]; string reasonName = objBs.ReasonTenderedBs.GetByID(Convert.ToInt32(reasonId)).Name; bool isadjust = objBs.ReasonTenderedBs.GetByID(Convert.ToInt32(reasonId)).IsAdjust; DWH_ONTIME_SHIPMENT ontimeShipment = objBs.dWH_ONTIME_SHIPMENTBs.GetByID(sm); //Change adjustable here ontimeShipment.TNRD_ADJUST = 0; ontimeShipment.TNRD_ADJUST_BY = User.Identity.Name; ontimeShipment.TNRD_ADJUST_DATE = DateTime.Now; ontimeShipment.TNRD_ONTIME_REASON = reasonName; ontimeShipment.TNRD_ONTIME_REASON_ID = Convert.ToInt32(reasonId); ontimeShipment.TNRD_ONTIME_REMARK = remark; objBs.dWH_ONTIME_SHIPMENTBs.Update(ontimeShipment); TenderedDelay tmp_adjusted = objBs.tenderedDelayBs.GetByID(sm); if (tmp_adjusted == null) { return(Json("shipment " + sm + " ได้ทำการ adjust ไปแล้ว")); } TenderedAdjusted tmp_toInsert = new TenderedAdjusted { 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, LAST_SHPG_LOC_NAME = tmp_adjusted.LAST_SHPG_LOC_NAME, VENDOR_CODE = tmp_adjusted.VENDOR_CODE, VENDOR_NAME = tmp_adjusted.VENDOR_NAME, SHCRDATE = tmp_adjusted.SHCRDATE, SHCRDATE_D = tmp_adjusted.SHCRDATE_D, PLNTNRDDATE = tmp_adjusted.PLNTNRDDATE, PLNTNRDDATE_D = tmp_adjusted.PLNTNRDDATE_D, FTNRDDATE = tmp_adjusted.FTNRDDATE, FTNRDDATE_D = tmp_adjusted.FTNRDDATE_D, SHPPOINT = tmp_adjusted.SHPPOINT, TRUCK_TYPE = tmp_adjusted.TRUCK_TYPE, SHPMNTNO = tmp_adjusted.SHPMNTNO, DELVNO = tmp_adjusted.DELVNO, CRTD_USR_CD = tmp_adjusted.CRTD_USR_CD, UPDT_USR_CD = tmp_adjusted.UPDT_USR_CD, LOADED_DATE = DateTime.Now, TNRD_ADJUST = isadjust ? 1 : 0, TNRD_ADJUST_BY = User.Identity.Name, TNRD_ADJUST_DATE = DateTime.Now, TNRD_ONTIME_REASON = reasonName, TNRD_ONTIME_REASON_ID = Convert.ToInt32(reasonId), TNRD_ONTIME_REMARK = remark }; //insert waiting ofr approval objBs.tenderedAdjustedBs.Insert(tmp_toInsert); //delete AcceptedDelays objBs.tenderedDelayBs.Delete(sm); countSM++; } } Trans.Complete(); return(RedirectToAction("Index", new { sms = countSM + "-Shipment is adjusted Successfully!" })); } catch (Exception ex) { return(RedirectToAction("Index", new { sms = "Operation update reason accepted failed !" + ex.ToString() })); } // return View(); } }