public ActionResult Edit(int id) { FAgentRateVM FAge = new FAgentRateVM(); ViewBag.ProductTypeID = db.ProductTypes.ToList(); var h = db.ForwardingAgentMasters.ToList(); ViewBag.FAgentID = db.ForwardingAgentMasters.ToList(); ViewBag.ZoneID = db.ZoneCharts.ToList(); ForwardingAgentRate data = (from c in db.ForwardingAgentRates where c.FAgentRateID == id select c).FirstOrDefault(); if (data == null) { return(HttpNotFound()); } else { FAge.FAgentRateID = data.FAgentRateID; FAge.FAgentID = data.FAgentID; FAge.ZoneID = data.ZoneChartID; int countryid = Convert.ToInt32(Session["depotcountry"].ToString()); FAge.CountryID = countryid; FAge.ProductTypeID = data.CourierServiceID.Value; FAge.BaseWeight = data.BaseWeight; FAge.BaseRate = data.BaseRate; } return(View(FAge)); }
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")); }
public ActionResult DeleteConfirmed(int id = 0) { ForwardingAgentRate a = db.ForwardingAgentRates.Find(id); if (a == null) { return(HttpNotFound()); } else { db.ForwardingAgentRates.Remove(a); db.SaveChanges(); List <ForwardingAgentRateDet> lst = (from c in db.ForwardingAgentRateDets where c.FAgentRateDetID == id select c).ToList(); foreach (var item in lst) { db.ForwardingAgentRateDets.Remove(item); db.SaveChanges(); } return(RedirectToAction("Index")); } }