// 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!")); } }