//Delete public void Delete(int Id) { OntimeDocReturnMonth ontimeDocReturnMonth = db.OntimeDocReturnMonths.Find(Id); db.OntimeDocReturnMonths.Remove(ontimeDocReturnMonth); Save(); }
public ActionResult UpdateDocReturnApprove(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.docReturnAdjustedBs.GetByID(dn).SCGL_DOCRET_REASON_ID; bool isadjust = objBs.reasonDocReturnBs.GetByID(Convert.ToInt32(reasonId)).IsAdjust; DWH_ONTIME_DN ontimeDn = objBs.dWH_ONTIME_DNBs.GetByID(dn); ontimeDn.SCGL_DOCRET_ADJUST = isadjust ? 1 : 0; objBs.dWH_ONTIME_DNBs.Update(ontimeDn); //delete OntimedDelays objBs.docReturnAdjustedBs.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.ontimeDocReturnBs.GetAll() .Where(x => x.ActualGiDate == ONTIMEDate && x.DepartmentId == departmentId && x.SectionId == sectionId && x.MatFriGrp == matNameId).FirstOrDefault().Id; OntimeDocReturn ontimeDocReturn = objBs.ontimeDocReturnBs.GetByID(id); int adjOntime = ontimeDocReturn.AdjustDocReturn + 1; ontimeDocReturn.AdjustDocReturn = adjOntime; ontimeDocReturn.SumOfAdjustDocReturn = ontimeDocReturn.OnTime + adjOntime; objBs.ontimeDocReturnBs.Update(ontimeDocReturn); // update sum of adjust monthly int idM = objBs.ontimeDocReturnMonthBs.GetAll() .Where(x => x.Year == yearId && x.Month == monthId && x.DepartmentId == departmentId && x.SectionId == sectionId && x.MatFriGrp == matNameId).FirstOrDefault().Id; OntimeDocReturnMonth ontimeDocReturnMonth = objBs.ontimeDocReturnMonthBs.GetByID(idM); int adjOntimeMonth = ontimeDocReturnMonth.AdjustDocReturn + 1; ontimeDocReturnMonth.AdjustDocReturn = adjOntimeMonth; ontimeDocReturnMonth.SumOfAdjustDocReturn = ontimeDocReturnMonth.OnTime + adjOntimeMonth; objBs.ontimeDocReturnMonthBs.Update(ontimeDocReturnMonth); // update sum of adjust yearly int idY = objBs.ontimeDocReturnYearBs.GetAll() .Where(x => x.Year == yearId && x.DepartmentId == departmentId && x.SectionId == sectionId && x.MatFriGrp == matNameId).FirstOrDefault().Id; OntimeDocReturnYear ontimeDocReturnYear = objBs.ontimeDocReturnYearBs.GetByID(idY); int adjOntimeYear = ontimeDocReturnYear.AdjustDocReturn + 1; ontimeDocReturnYear.AdjustDocReturn = adjOntimeYear; ontimeDocReturnYear.SumOfAdjustDocReturn = ontimeDocReturnYear.OnTime + adjOntimeYear; objBs.ontimeDocReturnYearBs.Update(ontimeDocReturnYear); 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(OntimeDocReturnMonth ontimeDocReturnMonth) { db.Entry(ontimeDocReturnMonth).State = EntityState.Modified; Save(); }
//Insert public void Insert(OntimeDocReturnMonth ontimeDocReturnMonth) { db.OntimeDocReturnMonths.Add(ontimeDocReturnMonth); Save(); }
//Update public void Update(OntimeDocReturnMonth ontimeDocReturnMonth) { objDb.Update(ontimeDocReturnMonth); }
//Insert public void Insert(OntimeDocReturnMonth ontimeDocReturnMonth) { objDb.Insert(ontimeDocReturnMonth); }