// GET: asset_license/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tr_asset_registration ass_reg = db.tr_asset_registration.Find(id);
if (ass_reg == null)
{
return(HttpNotFound("Assset not found."));
}
asset_licenseViewModel asset_model = new asset_licenseViewModel()
{
FormMode = EnumFormModeKey.Form_Edit,
asset_parent_id = (int)ass_reg.asset_id,
asset_parent = ass_reg
};
ms_vendor msvendor = db.ms_vendor.Find(ass_reg.vendor_id);
asset_model.vendor_name = msvendor.vendor_name;
//Data view
asset_model.asset_license_list = (from aw in db.tr_asset_license
where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == id)
select aw).ToList <tr_asset_license>();
return(View(asset_model));
}
public ActionResult Edit([Bind(Include = "license_id, asset_parent_id, license_number, license_name, license_issued_by, license_date, license_exp_date, license_description")] asset_licenseViewModel asset_lcs)
{
if (asset_lcs.license_date > DateTime.Today)
{
ModelState.AddModelError("license_date", "Please enter a valid date.");
}
if (asset_lcs.license_date > asset_lcs.license_exp_date)
{
ModelState.AddModelError("license_exp_date", "license expired date must be after license date.");
}
if (ModelState.IsValid && asset_lcs.license_id > 0)
{
tr_asset_license ass_license = db.tr_asset_license.Find(asset_lcs.license_id);
ass_license.license_number = asset_lcs.license_number;
ass_license.license_name = asset_lcs.license_name;
ass_license.license_issued_by = asset_lcs.license_issued_by;
ass_license.license_date = asset_lcs.license_date;
ass_license.license_exp_date = asset_lcs.license_exp_date;
ass_license.license_description = asset_lcs.license_description;
ass_license.fl_active = true;
ass_license.updated_date = DateTime.Now;
ass_license.updated_by = UserProfile.UserId;
ass_license.deleted_date = null;
ass_license.deleted_by = null;
ass_license.org_id = UserProfile.OrgId;
db.Entry(ass_license).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
tr_asset_registration ass_reg = db.tr_asset_registration.Find(asset_lcs.asset_parent_id);
asset_lcs.FormMode = EnumFormModeKey.Form_Edit;
asset_lcs.asset_parent_id = (int)ass_reg.asset_id;
asset_lcs.asset_parent = ass_reg;
//Data view edit
asset_lcs.asset_license_list = (from aw in db.tr_asset_license
where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_lcs.asset_parent_id)
select aw).ToList <tr_asset_license>();
return(View(asset_lcs));
}
// GET: asset_license/Create
public ActionResult Create(int?id)
{
asset_licenseViewModel asset = new asset_licenseViewModel()
{
FormMode = EnumFormModeKey.Form_New,
asset_parent_id = 0,
asset_registration_list = db.tr_asset_registration.Where(r => r.fl_active == true && r.deleted_date == null).ToList()
};
//Data view
asset.asset_license_list = (from aw in db.tr_asset_license
where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == id)
select aw).ToList <tr_asset_license>();
return(View(asset));
}
// GET: asset_license/Edit/5
public ActionResult Edit(int?id, int?idw)
{
if (id == null || idw == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tr_asset_registration ass_reg = db.tr_asset_registration.Find(id);
if (ass_reg == null)
{
return(HttpNotFound("Assset not found."));
}
asset_licenseViewModel asset_model = new asset_licenseViewModel()
{
FormMode = EnumFormModeKey.Form_Edit,
asset_parent_id = (int)ass_reg.asset_id,
asset_parent = ass_reg
};
ms_vendor msvendor = db.ms_vendor.Find(ass_reg.vendor_id);
asset_model.vendor_name = msvendor.vendor_name;
tr_asset_license ass_license = db.tr_asset_license.Find(idw);
if (ass_license != null)
{
asset_model.license_id = ass_license.license_id;
asset_model.license_number = ass_license.license_number;
asset_model.license_name = ass_license.license_name;
asset_model.license_issued_by = ass_license.license_issued_by;
asset_model.license_date = ass_license.license_date;
asset_model.license_exp_date = ass_license.license_exp_date;
asset_model.license_description = ass_license.license_description;
}
//Data view edit
asset_model.asset_license_list = (from aw in db.tr_asset_license
where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == id)
select aw).ToList <tr_asset_license>();
return(View(asset_model));
}
public ActionResult Create([Bind(Include = "asset_parent_id, license_number, license_name, license_issued_by, license_date, license_exp_date, license_description")] asset_licenseViewModel asset_lcs)
{
if (asset_lcs.license_date > DateTime.Today)
{
ModelState.AddModelError("license_date", "Please enter a valid date.");
}
if (asset_lcs.license_date > asset_lcs.license_exp_date)
{
ModelState.AddModelError("license_exp_date", "license expired date must be after license date.");
}
tr_asset_license existLicense = (from exw in db.tr_asset_license.Where(exw => exw.license_number == asset_lcs.license_number && exw.asset_id == asset_lcs.asset_parent_id) select exw).FirstOrDefault <tr_asset_license>();
if (existLicense == null)
{
if (ModelState.IsValid)
{
tr_asset_license ass_license = new tr_asset_license();
ass_license.asset_id = asset_lcs.asset_parent_id;
ass_license.license_number = asset_lcs.license_number;
ass_license.license_name = asset_lcs.license_name;
ass_license.license_issued_by = asset_lcs.license_issued_by;
ass_license.license_date = asset_lcs.license_date;
ass_license.license_exp_date = asset_lcs.license_exp_date;
ass_license.license_description = asset_lcs.license_description;
ass_license.fl_active = true;
ass_license.created_date = DateTime.Now;
ass_license.created_by = UserProfile.UserId;
ass_license.updated_date = DateTime.Now;
ass_license.updated_by = UserProfile.UserId;
ass_license.deleted_date = null;
ass_license.deleted_by = null;
ass_license.org_id = UserProfile.OrgId;
ass_license = db.tr_asset_license.Add(ass_license);
db.SaveChanges();
//clear
ModelState.Clear();
asset_lcs.license_id = 0;
asset_lcs.license_name = "";
asset_lcs.license_issued_by = "";
asset_lcs.license_number = "";
asset_lcs.license_date = null;
asset_lcs.license_exp_date = null;
asset_lcs.license_description = "";
}
}
else
{
//Data view
List <tr_asset_license> assetlcslist = (from aw in db.tr_asset_license
where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_lcs.asset_parent_id)
select aw).ToList <tr_asset_license>();
ModelState.Clear();
asset_lcs = new asset_licenseViewModel();
asset_lcs.asset_license_list = assetlcslist;
return(View(asset_lcs));
}
//Data view
asset_lcs.asset_license_list = (from aw in db.tr_asset_license
where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_lcs.asset_parent_id)
select aw).ToList <tr_asset_license>();
return(View(asset_lcs));
}
