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