public ActionResult Create(ZoneChartVM v)
{
ZoneChart z = new ZoneChart();
if (v.country != null && v.StatusZone == "I")
{
z.ZoneCategoryID = v.ZoneCategoryID;
z.ZoneID = v.ZoneID;
//char []sep={','};
//string [] lst = v.countries.Split(sep);
List <ZoneChartDetail> l = new List <ZoneChartDetail>();
foreach (var i in v.country)
{
ZoneChartDetail s = new ZoneChartDetail();
s.CountryID = Convert.ToInt32(i);
l.Add(s);
}
z.ZoneChartDetails = l;
db.ZoneCharts.Add(z);
db.SaveChanges();
}
if (v.StatusZone == "D" && v.city != null)
{
z.ZoneCategoryID = v.ZoneCategoryID;
z.ZoneID = v.ZoneID;
List <ZoneChartDetail> l = new List <ZoneChartDetail>();
foreach (var i in v.city)
{
ZoneChartDetail s = new ZoneChartDetail();
s.CountryID = Convert.ToInt32(Session["depotcountry"].ToString());
s.CityID = Convert.ToInt32(i);
l.Add(s);
}
z.ZoneChartDetails = l;
db.ZoneCharts.Add(z);
db.SaveChanges();
}
TempData["SuccessMsg"] = "You have successfully added Zone Chart.";
return(RedirectToAction("Index"));
}
public ActionResult Edit(ZoneChartVM v)
{
var list = db.ZoneChartDetails.Where(x => x.ZoneChartID == v.ZoneChartID).ToList();
foreach (var item in list)
{
db.ZoneChartDetails.Remove(item);
db.SaveChanges();
}
ZoneChart z = new ZoneChart();
z.ZoneChartID = v.ZoneChartID;
z.ZoneCategoryID = v.ZoneCategoryID;
z.ZoneID = v.ZoneID;
db.Entry(z).State = EntityState.Modified;
if (v.country != null && v.StatusZone == "I")
{
foreach (var i in v.country)
{
ZoneChartDetail s = new ZoneChartDetail();
s.CountryID = Convert.ToInt32(i);
s.ZoneChartID = z.ZoneChartID;
db.ZoneChartDetails.Add(s);
db.SaveChanges();
}
}
if (v.StatusZone == "D" && v.city != null)
{
foreach (var i in v.city)
{
ZoneChartDetail s = new ZoneChartDetail();
s.CountryID = Convert.ToInt32(Session["depotcountry"].ToString());
s.CityID = Convert.ToInt32(i);
s.ZoneChartID = z.ZoneChartID;
db.ZoneChartDetails.Add(s);
db.SaveChanges();
}
}
TempData["SuccessMsg"] = "You have successfully Updated Zone Chart.";
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
ZoneChartVM v = new ZoneChartVM();
ZoneChart z = db.ZoneCharts.Find(id);
if (z == null)
{
return(HttpNotFound());
}
else
{
v.ZoneChartID = z.ZoneChartID;
v.StatusZone = (from c in db.ZoneMasters where c.ZoneID == z.ZoneID select c.StatusZone).FirstOrDefault();
v.ZoneCategoryID = z.ZoneCategoryID;
v.ZoneID = z.ZoneID;
if (v.StatusZone == "I")
{
var lst = (from c in db.ZoneChartDetails where c.ZoneChartID == z.ZoneChartID select c.CountryID).ToList();
v.country = new List <int>();
foreach (var i in lst)
{
v.country.Add(Convert.ToInt32(i));
v.countrylist = v.countrylist + i + ",";
}
v.countrylist = v.countrylist.Substring(0, v.countrylist.Length - 1);
}
else if (v.StatusZone == "D")
{
var lst = (from c in db.ZoneChartDetails where c.ZoneChartID == z.ZoneChartID select c.CityID).ToList();
v.city = new List <int>();
foreach (var i in lst)
{
v.city.Add(Convert.ToInt32(i));
v.citylist = v.citylist + i + ",";
}
v.citylist.Substring(0, v.citylist.Length - 1);
}
}
ViewBag.ZoneCategory = db.ZoneCategories.ToList();
ViewBag.Zones = db.ZoneMasters.ToList();
return(View(v));
}
public ActionResult DeleteConfirmed(int id)
{
ZoneChart z = db.ZoneCharts.Find(id);
if (z == null)
{
return(HttpNotFound());
}
else
{
var list = db.ZoneChartDetails.Where(x => x.ZoneChartID == id).ToList();
foreach (var item in list)
{
db.ZoneChartDetails.Remove(item);
db.SaveChanges();
}
db.ZoneCharts.Remove(z);
db.SaveChanges();
TempData["SuccessMsg"] = "You have successfully deleted Zone Chart.";
return(RedirectToAction("Index"));
}
}
