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