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