public ActionResult DeleteConfirmed(int id) { tr_asset_image tr_asset_image = db.tr_asset_image.Find(id); db.tr_asset_image.Remove(tr_asset_image); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "asset_id,asset_img_address")] tr_asset_image tr_asset_image) { if (ModelState.IsValid) { db.Entry(tr_asset_image).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tr_asset_image)); }
public ActionResult Create([Bind(Include = "asset_id,asset_img_address")] tr_asset_image tr_asset_image) { if (ModelState.IsValid) { db.tr_asset_image.Add(tr_asset_image); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tr_asset_image)); }
// GET: asset_image/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tr_asset_image tr_asset_image = db.tr_asset_image.Find(id); if (tr_asset_image == null) { return(HttpNotFound()); } return(View(tr_asset_image)); }
public ActionResult Edit([Bind(Include = "asset_parent_id,asset_number,company_id,asset_reg_location_id,asset_reg_pic_id,category_id,asset_po_number,asset_do_number,asset_name,asset_merk,asset_serial_number,vendor_id,asset_receipt_date,location_id,department_id,employee_id,asset_description,asset_file_attach")] subasset_registrationViewModel asset_reg) { int asset_id = Convert.ToInt32(Request.Form["asset_id"]); if (ModelState.IsValid && asset_id > 0) { using (DbContextTransaction dbTran = db.Database.BeginTransaction()) { try { #region SUBASSET tr_asset_registration ass_reg = db.tr_asset_registration.Find(asset_id); ass_reg.asset_type_id = (int)Enum_asset_type_Key.AssetChild; //child ass_reg.asset_parent_id = asset_reg.asset_parent_id; ass_reg.company_id = asset_reg.company_id; asset_reg.company = db.ms_asmin_company.Find(asset_reg.company_id); ass_reg.asset_reg_location_id = asset_reg.asset_reg_location_id; asset_reg.asset_reg_location = db.ms_asset_register_location.Find(asset_reg.asset_reg_location_id); ass_reg.asset_reg_pic_id = asset_reg.asset_reg_pic_id; asset_reg.asset_reg_pic = db.ms_asset_register_pic.Find(asset_reg.asset_reg_pic_id); ass_reg.category_id = asset_reg.category_id; asset_reg.asset_category = db.ms_asset_category.Find(asset_reg.category_id); asset_reg.department = db.ms_department.Find(asset_reg.department_id); if (string.IsNullOrWhiteSpace(ass_reg.asset_number)) //incase nomor belum ada --> koreksi nomornya { /*no aktifa seq*/ int _last_no = db.tr_asset_registration.Where(r => r.asset_parent_id == asset_reg.asset_parent_id).Count(); _last_no++; string no_activa = _last_no.ToString().PadLeft(2, '0'); string[] complex_no = ass_reg.tr_asset_registration2.asset_number.Split(new char[3] { '.', '-', '/' }); ass_reg.asset_number = complex_no[0] + "-" + no_activa; } else { ass_reg.asset_number = asset_reg.asset_number; } ass_reg.asset_po_number = asset_reg.asset_po_number; ass_reg.asset_do_number = asset_reg.asset_do_number; ass_reg.asset_name = asset_reg.asset_name; ass_reg.asset_merk = asset_reg.asset_merk; ass_reg.asset_serial_number = asset_reg.asset_serial_number; ass_reg.vendor_id = asset_reg.vendor_id; ass_reg.asset_description = asset_reg.asset_description; ass_reg.asset_receipt_date = asset_reg.asset_receipt_date; ass_reg.location_id = asset_reg.location_id; ass_reg.department_id = asset_reg.department_id; ass_reg.employee_id = asset_reg.employee_id; ass_reg.fl_active = true; ass_reg.updated_date = DateTime.Now; ass_reg.updated_by = UserProfile.UserId; ass_reg.deleted_date = null; ass_reg.deleted_by = null; ass_reg.org_id = UserProfile.OrgId; db.Entry(ass_reg).State = EntityState.Modified; db.SaveChanges(); #endregion #region FILE SUPBASSET if (Request.Files.Count > 0) { //var file = Request.Files[0]; app_root_path = Server.MapPath("~/"); if (string.IsNullOrWhiteSpace(base_image_path)) { base_image_path = subasset_registrationViewModel.path_file_asset; } string img_path = Server.MapPath(base_image_path); if (!Directory.Exists(img_path)) { Directory.CreateDirectory(img_path); } var file = Request.Files["asset_img_file"]; if (file != null && file.ContentLength > 0) { string fileName = ""; string path = ""; //check existing and delete dari db dan folder tr_asset_image img_db = db.tr_asset_image.SingleOrDefault(c => c.asset_id == asset_id); if (img_db != null) { fileName = img_db.asset_img_address; base_image_path = subasset_registrationViewModel.path_file_asset; img_path = Server.MapPath(base_image_path); path = Path.Combine(img_path, fileName); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } db.tr_asset_image.Remove(img_db); db.SaveChanges(); } //insert new fileName = "asset" + ass_reg.asset_id.ToString() + "_" + Path.GetFileName(file.FileName); path = Path.Combine(img_path, fileName); file.SaveAs(path); tr_asset_image _ass_img = new tr_asset_image() { asset_id = ass_reg.asset_id, asset_img_address = fileName, asset_qrcode = GenerateQRCode(asset_reg.asset_number) }; db.tr_asset_image.Add(_ass_img); db.SaveChanges(); } } #endregion dbTran.Commit(); } catch (Exception _exc) { dbTran.Rollback(); throw new Exception("Fail to save update sub-asset." + _exc.Message); } } return(RedirectToAction("Index")); } #region complete the VM if (asset_reg.asset_parent_list == null) { asset_reg.asset_parent_list = db.tr_asset_registration.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.company_list == null) { asset_reg.company_list = db.ms_asmin_company.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.asset_reg_location_list == null) { asset_reg.asset_reg_location_list = db.ms_asset_register_location.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.asset_reg_pic_list == null) { asset_reg.asset_reg_pic_list = db.ms_asset_register_pic.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.asset_category_list == null) { asset_reg.asset_category_list = db.ms_asset_category.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.vendor_list == null) { asset_reg.vendor_list = db.ms_vendor.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.asset_location_list == null) { asset_reg.asset_location_list = db.ms_asset_location.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.department_list == null) { asset_reg.department_list = db.ms_department.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.employee_list == null) { asset_reg.employee_list = db.ms_employee.AsEnumerable().Where(r => r.fl_active == true && r.deleted_date == null).Select(e => new ms_employee { employee_id = e.employee_id, employee_name = "[" + e.employee_nik + "] - " + e.employee_name, employee_email = e.employee_email }).ToList(); } #endregion return(View(asset_reg)); }
public ActionResult Create([Bind(Include = "asset_parent_id,asset_number,company_id,asset_reg_location_id,asset_reg_pic_id,category_id,asset_po_number,asset_do_number,asset_name,asset_merk,asset_serial_number,vendor_id,asset_receipt_date,location_id,department_id,employee_id,asset_description,asset_file_attach")] subasset_registrationViewModel asset_reg) { if (ModelState.IsValid) { using (DbContextTransaction dbTran = db.Database.BeginTransaction()) { try { #region SUBASSET tr_asset_registration asset_parent = db.tr_asset_registration.Find(asset_reg.asset_parent_id); int _last_no = db.tr_asset_registration.Where(a => a.asset_parent_id == asset_reg.asset_parent_id).Count(); /*no aktifa seq*/ _last_no++; string no_activa = _last_no.ToString().PadLeft(2, '0'); string[] complex_no = asset_parent.asset_number.Split(new char[3] { '.', '-', '/' }); asset_reg.asset_number = complex_no[0] + "-" + no_activa; tr_asset_registration ass_reg = new tr_asset_registration(); ass_reg.asset_type_id = (int)Enum_asset_type_Key.AssetChild; //child ass_reg.asset_parent_id = asset_reg.asset_parent_id; ass_reg.tr_asset_registration2 = asset_parent; ass_reg.asset_number = asset_reg.asset_number; ass_reg.company_id = asset_reg.company_id; ass_reg.asset_reg_location_id = asset_reg.asset_reg_location_id; ass_reg.asset_reg_pic_id = asset_reg.asset_reg_pic_id; ass_reg.category_id = asset_reg.category_id; ass_reg.asset_po_number = asset_reg.asset_po_number; ass_reg.asset_do_number = asset_reg.asset_do_number; ass_reg.asset_name = asset_reg.asset_name; ass_reg.asset_merk = asset_reg.asset_merk; ass_reg.asset_serial_number = asset_reg.asset_serial_number; ass_reg.vendor_id = asset_reg.vendor_id; ass_reg.asset_receipt_date = asset_reg.asset_receipt_date; ass_reg.location_id = asset_reg.location_id; ass_reg.current_location_id = asset_reg.location_id; ass_reg.department_id = asset_reg.department_id; ass_reg.current_department_id = asset_reg.department_id; ass_reg.asset_description = asset_reg.asset_description; ass_reg.employee_id = asset_reg.employee_id; ass_reg.current_employee_id = asset_reg.employee_id; ass_reg.fl_active = true; ass_reg.created_date = DateTime.Now; ass_reg.created_by = UserProfile.UserId; ass_reg.updated_date = DateTime.Now; ass_reg.updated_by = UserProfile.UserId; ass_reg.deleted_date = null; ass_reg.deleted_by = null; ass_reg.org_id = UserProfile.OrgId; ass_reg = db.tr_asset_registration.Add(ass_reg); db.SaveChanges(); #endregion #region FILEASSET //ass_reg.asset_file_attach = asset_reg.asset_file_attach; if (Request.Files.Count > 0) { //var file = Request.Files[0]; app_root_path = Server.MapPath("~/"); if (string.IsNullOrWhiteSpace(base_image_path)) { base_image_path = subasset_registrationViewModel.path_file_asset; } string img_path = Server.MapPath(base_image_path); if (!Directory.Exists(img_path)) { Directory.CreateDirectory(img_path); } var file = Request.Files["asset_img_file"]; if (file != null && file.ContentLength > 0) { var fileName = "asset" + ass_reg.asset_id.ToString() + "_" + Path.GetFileName(file.FileName); var path = Path.Combine(img_path, fileName); file.SaveAs(path); tr_asset_image _ass_img = new tr_asset_image() { asset_id = ass_reg.asset_id, asset_img_address = fileName, asset_qrcode = GenerateQRCode(asset_reg.asset_number) }; db.tr_asset_image.Add(_ass_img); db.SaveChanges(); } } #endregion dbTran.Commit(); } catch (Exception _exc) { dbTran.Rollback(); throw new Exception("Fail to save create new sub-asset." + _exc.Message); } } #region "Send Email Notif to accounting department" try { ms_disposal_type Dept3 = db.ms_disposal_type.Find(3); int acct_id = Convert.ToInt32(Dept3.disposal_by_dept_id); var _qry = (from dept in db.ms_department.Where(dept => dept.department_id == acct_id) select dept).ToList().FirstOrDefault(); if (_qry == null) { throw new Exception("Department not found"); } sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = _qry.department_email; sy_email_log.elog_subject = string.Format("Sub Asset Registration"); sy_email_log.elog_template = "EMAIL_TEMPLATE_90"; var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_90")).FirstOrDefault(); if (_bodymail == null) { throw new Exception("Email Template 01 not found"); } string strBodyMail = _bodymail.app_value; strBodyMail = strBodyMail.Replace("[to]", _qry.department_name + " Department"); strBodyMail = strBodyMail.Replace("[action]", "Dispose"); strBodyMail = strBodyMail.Replace("[assetnumber]", asset_reg.asset_number); strBodyMail = strBodyMail.Replace("[assetname]", asset_reg.asset_name); ms_asset_location loc = db.ms_asset_location.Find(asset_reg.location_id); if (loc == null) { throw new Exception("Sub Asset Location not found"); } strBodyMail = strBodyMail.Replace("[assetlocation]", loc.location_name); ms_department deptment = db.ms_department.Find(asset_reg.department_id); if (deptment == null) { throw new Exception("Department not found"); } strBodyMail = strBodyMail.Replace("[department]", deptment.department_name); sy_email_log.elog_body = strBodyMail; var EmailHelper = new EmailHelper() { ToAddress = sy_email_log.elog_to, Email_Template = sy_email_log.elog_template, MailSubject = sy_email_log.elog_subject, MailBody = sy_email_log.elog_body }; EmailHelper.Send(); } catch { } #endregion return(RedirectToAction("Index")); } #region complete the VM if (asset_reg.asset_parent_list == null) { asset_reg.asset_parent_list = db.tr_asset_registration.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.company_list == null) { asset_reg.company_list = db.ms_asmin_company.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.asset_reg_location_list == null) { asset_reg.asset_reg_location_list = db.ms_asset_register_location.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.asset_reg_pic_list == null) { asset_reg.asset_reg_pic_list = db.ms_asset_register_pic.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.asset_category_list == null) { asset_reg.asset_category_list = db.ms_asset_category.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.vendor_list == null) { asset_reg.vendor_list = db.ms_vendor.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.asset_location_list == null) { asset_reg.asset_location_list = db.ms_asset_location.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.department_list == null) { asset_reg.department_list = db.ms_department.Where(r => r.fl_active == true && r.deleted_date == null).ToList(); } if (asset_reg.employee_list == null) { asset_reg.employee_list = db.ms_employee.AsEnumerable().Where(r => r.fl_active == true && r.deleted_date == null).Select(e => new ms_employee { employee_id = e.employee_id, employee_name = "[" + e.employee_nik + "] - " + e.employee_name, employee_email = e.employee_email }).ToList(); } #endregion return(View(asset_reg)); }