public ActionResult Edit(FAgentRateVM v) { ForwardingAgentRate obj = new ForwardingAgentRate(); obj.FAgentRateID = v.FAgentRateID; obj.FAgentID = v.FAgentID; obj.ZoneChartID = v.ZoneID; int countryid = Convert.ToInt32(Session["depotcountry"].ToString()); obj.CountryID = countryid; obj.CourierServiceID = v.ProductTypeID; obj.BaseWeight = v.BaseWeight; obj.BaseRate = v.BaseRate; db.Entry(obj).State = EntityState.Modified; db.SaveChanges(); var data = (from c in db.ForwardingAgentRateDets where c.FAgentRateID == v.FAgentRateID select c).ToList(); foreach (var item in data) { db.ForwardingAgentRateDets.Remove(item); db.SaveChanges(); } foreach (var item in v.FAgentRateDetails) { ForwardingAgentRateDet ob = new ForwardingAgentRateDet(); ob.FAgentRateID = v.FAgentRateID; ob.AdditionalWeightFrom = item.AddWtFrom; ob.AdditionalWeightTo = item.AddWtTo; ob.IncrementalWeight = item.IncrWt; ob.AdditionalRate = item.AddRate; db.ForwardingAgentRateDets.Add(ob); db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Create(FAgentRateVM v) { ForwardingAgentRate FAge = new ForwardingAgentRate(); int max = (from d in db.ForwardingAgentRates orderby d.FAgentRateID descending select d.FAgentRateID).FirstOrDefault(); FAge.FAgentRateID = max + 1; FAge.FAgentID = v.FAgentID; FAge.ZoneChartID = v.ZoneID; int countryid = Convert.ToInt32(Session["depotcountry"].ToString()); FAge.CountryID = countryid; FAge.CourierServiceID = v.ProductTypeID; FAge.BaseWeight = v.BaseWeight; FAge.BaseRate = v.BaseRate; db.ForwardingAgentRates.Add(FAge); db.SaveChanges(); foreach (var item in v.FAgentRateDetails) { ForwardingAgentRateDet a = new ForwardingAgentRateDet(); a.FAgentRateID = FAge.FAgentRateID; a.AdditionalWeightFrom = item.AddWtFrom; a.AdditionalWeightTo = item.AddWtTo; a.IncrementalWeight = item.IncrWt; a.AdditionalRate = item.AddRate; db.ForwardingAgentRateDets.Add(a); db.SaveChanges(); } return(RedirectToAction("Index")); }