public PartialViewResult CpartialView(int?Lic_id) { LicenseEditView model = new LicenseEditView(); model.country = db.Licenses.Where(z => z.Id == Lic_id.Value).Include(x => x.License_Country.Select(y => y.Country)); var item_list = from itm in db.Countries join lic in db.License_Country on itm.Id equals lic.Country_Id where lic.License_Id == Lic_id.Value select itm; model.Lic_id = Lic_id.Value; // model.Items= new SelectListItem(item_list.ToList(), "Id", "Name") model.Items = db.Countries.Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Name, }) .ToList(); model.SelectedCountries = db.Countries.Select(x => x.Id); return(PartialView("EditCountryPartialView", model)); }
public ActionResult EditLicense(int?Lic_id, string msg) { if (Lic_id == null) { return(Content("lic not found ")); } var model = new LicenseEditView(); model.msg = msg; model.Lic_details = db.Licenses.Where(x => x.Id == Lic_id.Value).Single(); var items = db.Licenses.Where(x => x.Id == Lic_id.Value).Include(z => z.License_Item.Select(y => y.Item)); model.item = items; // ViewBag.t_id = exp_id.Value; if (Request.IsAjaxRequest()) { return(PartialView("Itemdisplay", model)); } var country = db.Licenses.Where(x => x.Id == Lic_id.Value).Include(z => z.License_Country.Select(y => y.Country)); model.country = country; return(View(model)); }
public PartialViewResult itempartialView(int?Lic_id) { TempData["id"] = Lic_id.Value; LicenseEditView model = new LicenseEditView(); model.item = db.Licenses.Where(z => z.Id == Lic_id.Value).Include(x => x.License_Item.Select(y => y.Item)); var item_list = from itm in db.Items join lic in db.License_Item on itm.Id equals lic.Item_Id where lic.License_Id == Lic_id.Value select itm; // model.Items= new SelectListItem(item_list.ToList(), "Id", "Name") model.Items = db.Items.Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Name, }) .ToList(); model.SelectedItems = db.Items.Select(x => x.Id); return(PartialView("EdititemPartialView", model)); }
public ActionResult Saveedit(LicenseEditView values) { if (ModelState.IsValid) { var lic_change = from lic in db.Licenses where lic.Id == values.Lic_details.Id select lic; lic_change.First().License_No = values.Lic_details.License_No; lic_change.First().Expiry_Date = values.Lic_details.Expiry_Date; lic_change.First().Notes = values.Lic_details.Notes; db.SaveChanges(); } return(RedirectToAction("Index")); }
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)); }
public ActionResult GetCDetails(int?Lic_id) { 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(); var items = db.Licenses.Where(x => x.Id == Lic_id.Value).Include(z => z.License_Item.Select(y => y.Item)); model.item = items; 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)); }
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)); }