public ActionResult Edit(int id) { ViewBag.CustRate = db.CustomerRateTypes.ToList(); ViewBag.ProductType = db.ProductTypes.ToList(); ViewBag.ForwardingAgent = db.ForwardingAgentMasters.ToList(); ViewBag.Zones = db.ZoneCharts.ToList(); CustRateVM vm = new CustRateVM(); CustomerRate r = db.CustomerRates.Find(id); if (r != null) { vm.BaseRate = r.BaseRate; vm.BaseWt = r.BaseWeight; vm.ContractRateID = r.CustomerRateID; vm.ContractRateTypeID = r.CustomerRateTypeID; vm.ProductTypeID = r.CourierServiceID; vm.ZoneChartID = r.ZoneChartID; vm.CountryID = r.CountryID.Value; vm.FAgentID = r.FAgentID.Value; vm.CustomerRateID = r.CustomerRateID; vm.AdditionalCharges = r.AdditionalCharges.Value; vm.withtax = r.WithTax.Value; vm.withouttax = r.WithoutTax.Value; } else { return(HttpNotFound()); } return(View(vm)); }
public ActionResult Create(CustRateVM v) { try { CustomerRate r = new CustomerRate(); r.CustomerRateTypeID = v.ContractRateTypeID; r.CourierServiceID = v.ProductTypeID; r.ZoneChartID = v.ZoneChartID; r.FAgentID = v.FAgentID; r.BaseWeight = v.BaseWt; r.WithTax = v.withtax; r.WithoutTax = v.withouttax; r.AdditionalCharges = v.AdditionalCharges; r.BaseRate = v.BaseRate; db.CustomerRates.Add(r); db.SaveChanges(); if (v.CustRateDetails != null) { foreach (var item in v.CustRateDetails) { CustomerRateDet a = new CustomerRateDet(); a.CustomerRateID = r.CustomerRateID; a.AdditionalWeightFrom = item.AddWtFrom; a.AdditionalWeightTo = item.AddWtTo; a.IncrementalWeight = item.IncrWt; a.AdditionalRate = item.AddRate; db.CustomerRateDets.Add(a); db.SaveChanges(); } } return(RedirectToAction("Index")); } catch (Exception ex) { } ViewBag.CustRate = db.CustomerRateTypes.ToList(); ViewBag.ProductType = db.ProductTypes.ToList(); ViewBag.ForwardingAgent = db.ForwardingAgentMasters.ToList(); ViewBag.Zones = db.ZoneCharts.ToList(); return(View()); }
public ActionResult Edit(CustRateVM v) { CustomerRate r = new CustomerRate(); r.CustomerRateID = v.CustomerRateID; r.CustomerRateTypeID = v.ContractRateTypeID; r.CourierServiceID = v.ProductTypeID; r.ZoneChartID = v.ZoneChartID; r.FAgentID = v.FAgentID; r.BaseWeight = v.BaseWt; r.WithTax = v.withtax; r.WithoutTax = v.withouttax; r.AdditionalCharges = v.AdditionalCharges; r.BaseRate = v.BaseRate; db.Entry(r).State = EntityState.Modified; db.SaveChanges(); var data = (from c in db.CustomerRateDets where c.CustomerRateID == v.CustomerRateID select c).ToList(); foreach (var item in data) { db.CustomerRateDets.Remove(item); db.SaveChanges(); } foreach (var item in v.CustRateDetails) { CustomerRateDet a = new CustomerRateDet(); a.CustomerRateID = r.CustomerRateID; a.AdditionalWeightFrom = item.AddWtFrom; a.AdditionalWeightTo = item.AddWtTo; a.IncrementalWeight = item.IncrWt; a.AdditionalRate = item.AddRate; db.CustomerRateDets.Add(a); db.SaveChanges(); } return(RedirectToAction("Index")); }