//Delete public void Delete(int Id) { OntimeTenderYear ontimeTenderYear = db.OntimeTenderYears.Find(Id); db.OntimeTenderYears.Remove(ontimeTenderYear); Save(); }
public ActionResult UpdateTenderApprove(List <string> thisReasonId, List <string> txtSM, List <string> txtApprove, List <string> txtRemark, string yearId, string monthId) { using (TransactionScope Trans = new TransactionScope()) { try { // List<string> listSM = new List<string>(); int countSM = 0; List <string> SMs = new List <string>(txtApprove.Distinct()); foreach (string sm in SMs) { var reasonId = objBs.tenderedAdjustedBs.GetByID(sm).TNRD_ONTIME_REASON_ID; 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 = isadjust ? 1 : 0; objBs.dWH_ONTIME_SHIPMENTBs.Update(ontimeShipment); //delete TenderedDelays objBs.tenderedAdjustedBs.Delete(sm); //update sum of adjust daily DateTime FTNRDDate = Convert.ToDateTime(ontimeShipment.FTNRDDATE_D); string matName = ontimeShipment.MATFRIGRP; string segmentId = ontimeShipment.DATA_SUBGRP; string sectionId = ontimeShipment.SECTION_ID; string departmentId = ontimeShipment.DEPARTMENT_ID; string UserId = ontimeShipment.CRTD_USR_CD; string UpdateUserId = ontimeShipment.UPDT_USR_CD; if (isadjust) { int id = objBs.ontimeTenderBs.GetAll() .Where(x => x.ActualGiDate == FTNRDDate && x.MatFriGrp == matName && x.SubSegment == segmentId && x.SectionId == sectionId && x.CRTD_USR_CD == UserId && x.UPDT_USR_CD == UpdateUserId && x.DepartmentId == departmentId).FirstOrDefault().Id; OntimeTender ontimeTender = objBs.ontimeTenderBs.GetByID(id); int adjTNRD = ontimeTender.AdjustTender + 1; ontimeTender.AdjustTender = adjTNRD; ontimeTender.SumOfAdjustTender = ontimeTender.OnTime + adjTNRD; objBs.ontimeTenderBs.Update(ontimeTender); // update sum of adjust monthly int idM = objBs.ontimeTenderMonthBs.GetAll() .Where(x => x.Year == yearId && x.MatFriGrp == matName && x.Month == monthId && x.SubSegment == segmentId && x.SectionId == sectionId && x.CRTD_USR_CD == UserId && x.UPDT_USR_CD == UpdateUserId && x.DepartmentId == departmentId).FirstOrDefault().Id; OntimeTenderMonth ontimeTenderMonth = objBs.ontimeTenderMonthBs.GetByID(idM); int adjTNRDMonth = ontimeTenderMonth.AdjustTender + 1; ontimeTenderMonth.AdjustTender = adjTNRDMonth; ontimeTenderMonth.SumOfAdjustTender = ontimeTenderMonth.OnTime + adjTNRDMonth; objBs.ontimeTenderMonthBs.Update(ontimeTenderMonth); // update sum of adjust yearly int idY = objBs.ontimeTenderYearBs.GetAll() .Where(x => x.Year == yearId && x.MatFriGrp == matName && x.SubSegment == segmentId && x.SectionId == sectionId && x.CRTD_USR_CD == UserId && x.UPDT_USR_CD == UpdateUserId && x.DepartmentId == departmentId).FirstOrDefault().Id; OntimeTenderYear ontimeTenderYear = objBs.ontimeTenderYearBs.GetByID(idY); int adjTNRDYear = ontimeTenderYear.AdjustTender + 1; ontimeTenderYear.AdjustTender = adjTNRDYear; ontimeTenderYear.SumOfAdjustTender = ontimeTenderYear.OnTime + adjTNRDYear; objBs.ontimeTenderYearBs.Update(ontimeTenderYear); } countSM++; } Trans.Complete(); return(Content(countSM + " - Shipment is adjusted Successfully!")); } catch (Exception ex) { return(Content("Operation update reason ontimed failed !" + ex.ToString())); } // return View(); } }
//Update public void Update(OntimeTenderYear ontimeTenderYear) { objDb.Update(ontimeTenderYear); }
//Insert public void Insert(OntimeTenderYear ontimeTenderYear) { objDb.Insert(ontimeTenderYear); }
//Update public void Update(OntimeTenderYear ontimeTenderYear) { db.Entry(ontimeTenderYear).State = EntityState.Modified; Save(); }
//Insert public void Insert(OntimeTenderYear ontimeTenderYear) { db.OntimeTenderYears.Add(ontimeTenderYear); Save(); }