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"));
}
