public ActionResult Create()
{
LicenseAdd Licenseview = new LicenseAdd();
Licenseview.SelectedCountries = db.Countries.Select(x => x.Id);
Licenseview.Counties = db.Countries
.Select(x => new SelectListItem
{
Value = x.Id.ToString(),
Text = x.Name,
})
.ToList();
Licenseview.SelectedItems = db.Items.Select(x => x.Id);
Licenseview.Items = db.Items
.Select(x => new SelectListItem
{
Value = x.Id.ToString(),
Text = x.Name,
})
.ToList();
var item_unit = new item_units();
Licenseview.Itms_db = new List <item_units>();
item_unit.Itm_names = "item_name";
item_unit.Itm_No_Units = 0;
Licenseview.Itms_db.Add(item_unit);
return(View(Licenseview));
}
public ActionResult Create(LicenseAdd licenseadd)
{
if (ModelState.IsValid)
{
License l = new License();
l.License_No = licenseadd.License_No;
l.Expiry_Date = licenseadd.Expiry_Date;
l.Notes = licenseadd.Notes;
l.UserId = User.Identity.GetUserId();
db.Licenses.Add(l);
db.SaveChanges();
var license_id = from a in db.Licenses
where a.License_No == licenseadd.License_No
select a.Id;
var val = Convert.ToInt32(license_id.FirstOrDefault());
TempData["ID"] = Convert.ToInt32(license_id.FirstOrDefault());
if (licenseadd.SelectedCountries != null)
{
foreach (var i in licenseadd.SelectedCountries)
{
var n = new License_Country();
n.Country_Id = i;
n.License_Id = Convert.ToInt32(license_id.FirstOrDefault());
db.License_Country.Add(n);
}
}
db.SaveChanges();
return(RedirectToAction("Additem", new { lic_id = val }));
}
return(View(licenseadd));
}
// [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));
}
}
