public ActionResult Edit(AgentDeliveryRateVM v) { tblAgentDeliveryRate a = new tblAgentDeliveryRate(); a.ID = v.ID; a.AgentID = v.AgentID; a.ZoneChartID = v.ZoneID; int countryid = Convert.ToInt32(Session["depotcountry"].ToString()); a.CountryID = countryid; a.CourierServiceID = v.ProductTypeID; a.BaseWeight = v.BaseWeight; a.BaseRate = v.BaseRate; db.Entry(a).State = EntityState.Modified; db.SaveChanges(); var data = (from c in db.tblAgentDeliveryRateDetails where c.AgentDeliveryRateID == v.ID select c).ToList(); foreach (var item in data) { db.tblAgentDeliveryRateDetails.Remove(item); db.SaveChanges(); } foreach (var item in v.AgentDeliveryRateDetailVM) { tblAgentDeliveryRateDetail b = new tblAgentDeliveryRateDetail(); b.AgentDeliveryRateID = a.ID; b.AdditionalWeightFrom = item.AddWtFrom; b.AdditionalWeightTo = item.AddWtTo; b.IncrementalWeight = item.IncrWt; b.AdditionalRate = item.AddRate; db.tblAgentDeliveryRateDetails.Add(b); db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Create(AgentDeliveryRateVM v) { tblAgentDeliveryRate a = new tblAgentDeliveryRate(); int max = (from d in db.tblAgentDeliveryRates orderby d.ID descending select d.ID).FirstOrDefault(); a.ID = max + 1; a.AgentID = v.AgentID; a.ZoneChartID = v.ZoneID; int countryid = Convert.ToInt32(Session["depotcountry"].ToString()); a.CountryID = countryid; a.CourierServiceID = v.ProductTypeID; a.BaseWeight = v.BaseWeight; a.BaseRate = v.BaseRate; db.tblAgentDeliveryRates.Add(a); db.SaveChanges(); foreach (var item in v.AgentDeliveryRateDetailVM) { tblAgentDeliveryRateDetail b = new tblAgentDeliveryRateDetail(); b.AgentDeliveryRateID = a.ID; b.AdditionalWeightFrom = item.AddWtFrom; b.AdditionalWeightTo = item.AddWtTo; b.IncrementalWeight = item.IncrWt; b.AdditionalRate = item.AddRate; db.tblAgentDeliveryRateDetails.Add(b); db.SaveChanges(); } return(RedirectToAction("Index")); }