// GET: asset_insurance/Create public ActionResult Create(int? id) { asset_insuranceViewModel asset = new asset_insuranceViewModel() { 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(), insurance_list = db.ms_insurance.Where(r => r.fl_active == true && r.deleted_date == null).ToList() }; //Data view asset.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); }
// 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 = "insurance_activa_id, asset_parent_id, insurance_activa_number, insurance_activa_name, insurance_activa_date, insurance_activa_exp_date, insurance_id, insurance_activa_description")] asset_insuranceViewModel asset_ins) { if (asset_ins.insurance_activa_date > DateTime.Today) ModelState.AddModelError("insurance_activa_date", "Please enter a valid date."); if (asset_ins.insurance_activa_date > asset_ins.insurance_activa_exp_date) ModelState.AddModelError("insurance_activa_exp_date", "Insurance activa expired date must be after insurance activa date."); if (ModelState.IsValid && asset_ins.insurance_activa_id > 0) { tr_asset_insurance ass_insurance = db.tr_asset_insurance.Find(asset_ins.insurance_activa_id); ass_insurance.asset_id = asset_ins.asset_parent_id; ass_insurance.insurance_activa_number = asset_ins.insurance_activa_number; ass_insurance.insurance_activa_name = asset_ins.insurance_activa_name; ass_insurance.insurance_activa_date = asset_ins.insurance_activa_date; ass_insurance.insurance_activa_exp_date = asset_ins.insurance_activa_exp_date; ass_insurance.insurance_id = asset_ins.insurance_id; ass_insurance.insurance_activa_description = asset_ins.insurance_activa_description; ass_insurance.fl_active = true; ass_insurance.updated_date = DateTime.Now; ass_insurance.updated_by = UserProfile.UserId; ass_insurance.deleted_date = null; ass_insurance.deleted_int = null; ass_insurance.org_id = UserProfile.OrgId; db.Entry(ass_insurance).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } tr_asset_registration ass_reg = db.tr_asset_registration.Find(asset_ins.asset_parent_id); asset_ins.FormMode = EnumFormModeKey.Form_Edit; asset_ins.asset_parent_id = (int)ass_reg.asset_id; asset_ins.asset_parent = ass_reg; asset_ins.insurance_list = db.ms_insurance.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); //Data view edit asset_ins.detail_insurance_list = (from aw in db.tr_asset_insurance where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_ins.asset_parent_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_ins); }
public ActionResult Create([Bind(Include = "asset_parent_id, insurance_activa_number, insurance_activa_name, insurance_activa_date, insurance_activa_exp_date, insurance_id, insurance_activa_description")] asset_insuranceViewModel asset_ins) { if (asset_ins.insurance_activa_date > DateTime.Today) ModelState.AddModelError("insurance_activa_date", "Please enter a valid date."); if (asset_ins.insurance_activa_date > asset_ins.insurance_activa_exp_date) ModelState.AddModelError("insurance_activa_exp_date", "Insurance activa expired date must be after insurance activa date."); tr_asset_insurance existinsurance = (from exw in db.tr_asset_insurance.Where(exw => exw.insurance_activa_number == asset_ins.insurance_activa_number && exw.asset_id == asset_ins.asset_parent_id) select exw).FirstOrDefault<tr_asset_insurance>(); if (existinsurance == null) { if (ModelState.IsValid) { tr_asset_insurance ass_insurance = new tr_asset_insurance(); ass_insurance.asset_id = asset_ins.asset_parent_id; ass_insurance.insurance_activa_number = asset_ins.insurance_activa_number; ass_insurance.insurance_activa_name = asset_ins.insurance_activa_name; ass_insurance.insurance_activa_date = asset_ins.insurance_activa_date; ass_insurance.insurance_activa_exp_date = asset_ins.insurance_activa_exp_date; ass_insurance.insurance_id = asset_ins.insurance_id; ass_insurance.insurance_activa_description = asset_ins.insurance_activa_description; ass_insurance.fl_active = true; ass_insurance.created_date = DateTime.Now; ass_insurance.created_by = UserProfile.UserId; ass_insurance.updated_date = DateTime.Now; ass_insurance.updated_by = UserProfile.UserId; ass_insurance.deleted_date = null; ass_insurance.deleted_int = null; ass_insurance.org_id = UserProfile.OrgId; ass_insurance = db.tr_asset_insurance.Add(ass_insurance); db.SaveChanges(); //clear ModelState.Clear(); asset_ins.insurance_activa_id = 0; asset_ins.insurance_activa_name = string.Empty; asset_ins.insurance_activa_number = string.Empty; asset_ins.insurance_activa_date = null; asset_ins.insurance_activa_exp_date = null; asset_ins.insurance_id = 0; asset_ins.insurance_activa_description = string.Empty; } } else { //Data view List<asset_insurancedetailViewModel> assetlcslist = (from aw in db.tr_asset_insurance where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_ins.asset_parent_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>(); ModelState.Clear(); asset_ins = new asset_insuranceViewModel(); asset_ins.detail_insurance_list = assetlcslist; asset_ins.insurance_list = db.ms_insurance.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); return View(asset_ins); } //Data view asset_ins.insurance_list = db.ms_insurance.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); asset_ins.detail_insurance_list = (from aw in db.tr_asset_insurance where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_ins.asset_parent_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_ins); }