// 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 DeleteConfirmed(int id)
{
ms_vendor ms_vendor = db.ms_vendor.Find(id);
db.ms_vendor.Remove(ms_vendor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: asset_insurance/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_insuranceViewModel asset_model = new asset_insuranceViewModel()
{
FormMode = EnumFormModeKey.Form_Edit,
asset_parent_id = (int)ass_reg.asset_id,
asset_parent = ass_reg,
insurance_list = db.ms_insurance.Where(r => r.fl_active == true && r.deleted_date == null).ToList()
};
ms_vendor msvendor = db.ms_vendor.Find(ass_reg.vendor_id);
asset_model.vendor_name = msvendor.vendor_name;
tr_asset_insurance ass_insurance = db.tr_asset_insurance.Find(idw);
if (ass_insurance != null)
{
asset_model.insurance_activa_id = ass_insurance.insurance_activa_id;
asset_model.insurance_activa_number = ass_insurance.insurance_activa_number;
asset_model.insurance_activa_name = ass_insurance.insurance_activa_name;
asset_model.insurance_activa_date = ass_insurance.insurance_activa_date;
asset_model.insurance_activa_exp_date = ass_insurance.insurance_activa_exp_date;
asset_model.insurance_id = ass_insurance.insurance_id;
asset_model.insurance_activa_description = ass_insurance.insurance_activa_description;
}
//Data view edit
asset_model.detail_insurance_list = (from aw in db.tr_asset_insurance
where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == id)
join a in db.ms_insurance on aw.insurance_id equals a.insurance_id
where (a.fl_active == true && a.deleted_date == null)
select new asset_insurancedetailViewModel()
{
insurance_activa_id = aw.insurance_activa_id,
insurance_activa_number = aw.insurance_activa_number,
insurance_activa_name = aw.insurance_activa_name,
insurance_activa_date = aw.insurance_activa_date,
insurance_activa_exp_date = aw.insurance_activa_exp_date,
insurance_id = a.insurance_id,
insurance_name = a.insurance_name,
insurance_activa_description = aw.insurance_activa_description
}).ToList<asset_insurancedetailViewModel>();
return View(asset_model);
}
public ActionResult Edit([Bind(Include = "vendor_id,vendor_code,vendor_name,vendor_address,country_id,vendor_phone,vendor_mail,vendor_cp_name,vendor_cp_phone,vendor_cp_mail,vendor_description,fl_active,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,org_id")] ms_vendor ms_vendor)
{
if (ModelState.IsValid)
{
db.Entry(ms_vendor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.country_id = new SelectList(db.ms_country, "country_id", "country_code", ms_vendor.country_id);
return(View(ms_vendor));
}
public ActionResult Edit([Bind(Include = "warranty_id, asset_parent_id, warranty_number, warranty_item_name, warranty_date, warranty_exp_date, warranty_description")] asset_warrantyViewModel asset_wrt)
{
if (asset_wrt.warranty_date > DateTime.Today)
{
ModelState.AddModelError("warranty_date", "Please enter a valid date.");
}
if (asset_wrt.warranty_date > asset_wrt.warranty_exp_date)
{
ModelState.AddModelError("warranty_exp_date", "Warranty expired date must be after warranty date.");
}
if (ModelState.IsValid && asset_wrt.warranty_id > 0)
{
tr_asset_warranty ass_warranty = db.tr_asset_warranty.Find(asset_wrt.warranty_id);
ass_warranty.warranty_number = asset_wrt.warranty_number;
ass_warranty.warranty_item_name = asset_wrt.warranty_item_name;
ass_warranty.warranty_date = asset_wrt.warranty_date;
ass_warranty.warranty_exp_date = asset_wrt.warranty_exp_date;
ass_warranty.warranty_description = asset_wrt.warranty_description;
ass_warranty.fl_active = true;
ass_warranty.updated_date = DateTime.Now;
ass_warranty.updated_by = UserProfile.UserId;
ass_warranty.deleted_date = null;
ass_warranty.deleted_by = null;
ass_warranty.org_id = UserProfile.OrgId;
db.Entry(ass_warranty).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
tr_asset_registration ass_reg = db.tr_asset_registration.Find(asset_wrt.asset_parent_id);
asset_wrt.FormMode = EnumFormModeKey.Form_Edit;
asset_wrt.asset_parent_id = (int)ass_reg.asset_id;
asset_wrt.asset_parent = ass_reg;
ms_vendor msvendor = db.ms_vendor.Find(ass_reg.vendor_id);
asset_wrt.vendor_name = msvendor.vendor_name;
//Data view edit
asset_wrt.asset_warranty_list = (from aw in db.tr_asset_warranty
where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_wrt.asset_parent_id)
select aw).ToList <tr_asset_warranty>();
return(View(asset_wrt));
}
// GET: vendor/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ms_vendor ms_vendor = db.ms_vendor.Find(id);
if (ms_vendor == null)
{
return(HttpNotFound());
}
return(View(ms_vendor));
}
// GET: vendor/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ms_vendor ms_vendor = db.ms_vendor.Find(id);
if (ms_vendor == null)
{
return(HttpNotFound());
}
ViewBag.country_id = new SelectList(db.ms_country, "country_id", "country_code", ms_vendor.country_id);
return(View(ms_vendor));
}
// 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 SaveData(string NewName)
{
int idC;
int.TryParse(Request.Form["vendorID"], out idC);
ms_vendor ms_vendor = new ms_vendor();
ms_vendor.vendor_id = idC;
ms_vendor.vendor_code = Request.Form["vendorCode"];
ms_vendor.vendor_name = Request.Form["vendorName"];
ms_vendor.vendor_address = Request.Form["vendorAddress"];
ms_vendor.country_id = Convert.ToInt32(Request.Form["Country"]);
ms_vendor.vendor_phone = Request.Form["vendorPhone"];
ms_vendor.vendor_mail = Request.Form["vendorMail"];
ms_vendor.vendor_cp_name = Request.Form["vendorCPName"];
ms_vendor.vendor_cp_phone = Request.Form["vendorCPPhone"];
ms_vendor.vendor_cp_mail = Request.Form["vendorCPMail"];
ms_vendor.vendor_description = Request.Form["vendorDescription"];
ms_vendor.fl_active = Request.Form["rec_isactive"] == "Yes" ? true : false;
ms_vendor.deleted_by = null;
ms_vendor.deleted_date = null;
if (idC == 0)
{
ms_vendor.created_by = UserProfile.UserId;
ms_vendor.created_date = DateTime.Now;
ms_vendor.org_id = UserProfile.OrgId;
db.Entry(ms_vendor).State = EntityState.Added;
db.SaveChanges();
return(Json("Insert", JsonRequestBehavior.AllowGet));
}
else
{
ms_vendor.updated_by = UserProfile.UserId;
ms_vendor.updated_date = DateTime.Now;
db.Entry(ms_vendor).State = EntityState.Modified;
db.SaveChanges();
return(Json("Update", JsonRequestBehavior.AllowGet));
}
}
public JsonResult CrudVendor()
{
if (Request.Form["oper"] == "add")
{
//prepare for insert data
ms_vendor ms_vendor = new ms_vendor();
ms_vendor.vendor_code = Request.Form["vendor_code"];
ms_vendor.vendor_name = Request.Form["vendor_name"];
ms_vendor.vendor_address = Request.Form["vendor_address"];
ms_vendor.country_id = Convert.ToInt32(Request.Form["country_id"]);
ms_vendor.vendor_phone = Request.Form["vendor_phone"];
ms_vendor.vendor_mail = Request.Form["vendor_mail"];
ms_vendor.vendor_cp_name = Request.Form["vendor_cp_name"];
ms_vendor.vendor_cp_phone = Request.Form["vendor_cp_phone"];
ms_vendor.vendor_cp_mail = Request.Form["vendor_cp_mail"];
ms_vendor.vendor_description = Request.Form["vendor_description"];
ms_vendor.created_by = 1;
ms_vendor.fl_active = Request.Form["rec_isactive"] == "Yes" ? true : false;
ms_vendor.created_date = DateTime.Now;
ms_vendor.updated_by = 1;
ms_vendor.updated_date = DateTime.Now;
ms_vendor.org_id = 0;
db.ms_vendor.Add(ms_vendor);
db.SaveChanges();
return(Json("Insert Insurance Data Success!", JsonRequestBehavior.AllowGet));
}
else if (Request.Form["oper"] == "edit")
{
if (IsNumeric(Request.Form["vendor_id"].ToString()))
{
//prepare for update data
int id = Convert.ToInt32(Request.Form["vendor_id"]);
ms_vendor ms_vendor = db.ms_vendor.Find(id);
ms_vendor.vendor_code = Request.Form["vendor_code"];
ms_vendor.vendor_name = Request.Form["vendor_name"];
ms_vendor.vendor_address = Request.Form["vendor_address"];
ms_vendor.country_id = Convert.ToInt32(Request.Form["country_id"]);
ms_vendor.vendor_phone = Request.Form["vendor_phone"];
ms_vendor.vendor_mail = Request.Form["vendor_mail"];
ms_vendor.vendor_cp_name = Request.Form["vendor_cp_name"];
ms_vendor.vendor_cp_phone = Request.Form["vendor_cp_phone"];
ms_vendor.vendor_cp_mail = Request.Form["vendor_cp_mail"];
ms_vendor.vendor_description = Request.Form["vendor_description"];
ms_vendor.updated_by = 1;
ms_vendor.updated_date = DateTime.Now;
db.SaveChanges();
return(Json("Update Insurance Data Success!", JsonRequestBehavior.AllowGet));
}
else
{
//prepare for insert data
ms_vendor ms_vendor = new ms_vendor();
ms_vendor.vendor_code = Request.Form["vendor_code"];
ms_vendor.vendor_name = Request.Form["vendor_name"];
ms_vendor.vendor_address = Request.Form["vendor_address"];
ms_vendor.country_id = Convert.ToInt32(Request.Form["country_id"]);
ms_vendor.vendor_phone = Request.Form["vendor_phone"];
ms_vendor.vendor_mail = Request.Form["vendor_mail"];
ms_vendor.vendor_cp_name = Request.Form["vendor_cp_name"];
ms_vendor.vendor_cp_phone = Request.Form["vendor_cp_phone"];
ms_vendor.vendor_cp_mail = Request.Form["vendor_cp_mail"];
ms_vendor.vendor_description = Request.Form["vendor_description"];
ms_vendor.created_by = 1;
ms_vendor.fl_active = Request.Form["rec_isactive"] == "Yes" ? true : false;
ms_vendor.created_date = DateTime.Now;
ms_vendor.updated_by = 1;
ms_vendor.updated_date = DateTime.Now;
ms_vendor.org_id = 0;
db.ms_vendor.Add(ms_vendor);
db.SaveChanges();
return(Json("Insert Insurance Data Success!", JsonRequestBehavior.AllowGet));
}
}
else
{
if (Request.Form["oper"] == "del")
{
//for delete process
string ids = Request.Form["id"];
string[] values = ids.Split(',');
for (int i = 0; i < values.Length; i++)
{
values[i] = values[i].Trim();
//prepare for soft delete data
int id = Convert.ToInt32(values[i]);
ms_vendor cou = db.ms_vendor.Find(id);
cou.deleted_by = 1;
cou.deleted_date = DateTime.Now;
db.SaveChanges();
}
}
return(Json("Deleted Success!"));
}
}
