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));
}
