public ActionResult Deleteitem(int?Lic_id, List <int> itemCheckedIds, List <int> countryCheckboxes) { var model = new LicenseEditView(); if (Lic_id == null) { return(Content("lic not found ")); } model.Lic_details = db.Licenses.Where(x => x.Id == Lic_id.Value).Single(); if (itemCheckedIds != null) { foreach (var itm_id in itemCheckedIds) { License_Item lic_item = db.License_Item.Find(itm_id); db.License_Item.Remove(lic_item); db.SaveChanges(); } var item = db.Licenses.Where(x => x.Id == Lic_id.Value).Include(z => z.License_Item.Select(y => y.Item)); model.item = item; return(PartialView("LicItemEdit", model)); } if (countryCheckboxes != null) { foreach (var c_id in countryCheckboxes) { License_Country c_item = db.License_Country.Find(c_id); db.License_Country.Remove(c_item); db.SaveChanges(); } var country = db.Licenses.Where(x => x.Id == Lic_id.Value).Include(z => z.License_Country.Select(y => y.Country)); model.country = country; return(PartialView("LicCounEdit", model)); } return(PartialView("LicCounEdit", model)); }
// [HttpGet] public ActionResult Additem(int?lic_id, LicenseAdd licenseadd) { if (lic_id != null) { LicenseAdd Licenseview1 = new LicenseAdd(); TempData["Lic"] = lic_id.Value; Licenseview1.Id = lic_id.Value; Licenseview1.SelectedItems = db.Items.Select(x => x.Id); Licenseview1.Items = db.Items .Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Name, }) .ToList(); return(View(Licenseview1)); } else { // var license_id = licenseadd.Id; int license_id = Convert.ToInt32(TempData["Lic"]); TempData["Lic"] = license_id; // int val = Convert.ToInt32(license_id.FirstOrDefault()); if (licenseadd.SelectedItems != null) { foreach (var i in licenseadd.SelectedItems) { var items_add = new License_Item(); var item_found = from itm in db.License_Item where itm.Item_Id == i && itm.License_Id == license_id select itm; if (!item_found.Any()) { items_add.Item_Id = i; items_add.License_Id = license_id; items_add.No_Units = licenseadd.No_Units; db.License_Item.Add(items_add); } else { item_found.FirstOrDefault().No_Units = licenseadd.No_Units; } } db.SaveChanges(); } var item_names = from itm in db.Items join lic in db.License_Item on itm.Id equals lic.Item_Id where lic.License_Id == license_id select new { item_name = itm.Name }; var item_units = from lic in db.License_Item where lic.License_Id == license_id select new { no_Units = lic.No_Units }; var name_unit = item_names.ToList().Zip(item_units.ToList(), (n, w) => new { name = n, units = w }); licenseadd.Itms_db = new List <item_units>(); foreach (var n in name_unit.ToList()) { var item_unit = new item_units(); item_unit.Itm_names = n.name.item_name; item_unit.Itm_No_Units = n.units.no_Units; licenseadd.Itms_db.Add(item_unit); } licenseadd.SelectedItems = db.Items.Select(x => x.Id); licenseadd.Items = db.Items .Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Name, }) .ToList(); return(View(licenseadd)); } }
public JsonResult Additem(LicenseEditView Licvalues) { var lic_id = Licvalues.Lic_id; ViewExportAdd model = new ViewExportAdd(); if (Licvalues.SelectedCountries != null) { foreach (var i in Licvalues.SelectedCountries) { var c_add = new License_Country(); var item_found = from itm in db.License_Country where itm.Country_Id == i && itm.License_Id == lic_id select itm; if (item_found.Any()) { var item_name = from itm in db.Countries where itm.Id == i select itm.Name; model.msg = "Item - " + item_name.FirstOrDefault() + "item already added "; //view.msg = model.msg; //return RedirectToAction("GetExpDetails",new { exp_id = exp_id.Value, msg = model.msg }); break; } else { c_add.Country_Id = i; c_add.License_Id = lic_id; db.License_Country.Add(c_add); db.SaveChanges(); model.msg = "country Added"; } } } if (Licvalues.SelectedItems != null) { foreach (var i in Licvalues.SelectedItems) { var items_add = new License_Item(); var item_found = from itm in db.License_Item where itm.Item_Id == i && itm.License_Id == lic_id select itm; if (item_found.Any()) { item_found.First().No_Units = Licvalues.No_Of_Units; db.SaveChanges(); var item_name = from itm in db.Items where itm.Id == i select itm.Name; model.msg = "Item - " + item_name.FirstOrDefault() + "item updated "; //view.msg = model.msg; //return RedirectToAction("GetExpDetails",new { exp_id = exp_id.Value, msg = model.msg }); break; } else { items_add.Item_Id = i; items_add.No_Units = Licvalues.No_Of_Units; items_add.License_Id = lic_id; db.License_Item.Add(items_add); db.SaveChanges(); model.msg = "item Added"; } } } model.lic_id = lic_id; return(Json(new { msg = model.msg }, JsonRequestBehavior.AllowGet)); }