public ActionResult Create([Bind(Include = "elog_from,elog_to,elog_cc,elog_bcc,elog_subject,elog_body")] sy_email_log email_form) { if (ModelState.IsValid) { /* * cara mengirim email : * 1. panggil EmailHelper * 2. lalu kirim email */ var EmailHelper = new EmailHelper() { ToAddress = email_form.elog_to, CcAddress = email_form.elog_cc, BccAddress = email_form.elog_bcc, MailSubject = email_form.elog_subject, MailBody = email_form.elog_body }; bool boolSent = EmailHelper.Send(); if (boolSent) { return(RedirectToAction("Index")); } } return(View(email_form)); }
public ActionResult DeleteConfirmed(int id) { sy_email_log sy_email_log = db.sy_email_log.Find(id); db.sy_email_log.Remove(sy_email_log); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: sy_email_log/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } sy_email_log sy_email_log = db.sy_email_log.Find(id); if (sy_email_log == null) { return(HttpNotFound()); } return(View(sy_email_log)); }
public ActionResult Resend(int id) { sy_email_log sy_email_log = db.sy_email_log.Find(id); if (sy_email_log == null) { return(HttpNotFound()); } var EmailHelper = new EmailHelper() { ToAddress = sy_email_log.elog_to, CcAddress = sy_email_log.elog_cc, BccAddress = sy_email_log.elog_bcc, MailSubject = sy_email_log.elog_subject, MailBody = sy_email_log.elog_body }; bool boolSent = EmailHelper.Send(); return(RedirectToAction("Index")); }
// GET: sy_email_log/Create public ActionResult Create() { List <string> _listTemplate = new List <string>(); var _list = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE")); foreach (sy_app_setting _setting in _list) { _listTemplate.Add(_setting.app_key); } sy_email_log sy_email_log = new sy_email_log() { //elog_template_list = _listTemplate, elog_template = "EMAIL_TEMPLATE_01", elog_from = app_setting.MAIL_FROM, fl_active = true }; return(View(sy_email_log)); }
public ActionResult Approval([Bind(Include = "request_id, approval_id, fl_approval, approval_suggestion_id, approval_noted, asset_number,asset_name, location_name, department_name, fl_SuggestionChanges")] disposalViewModel disposal_req) { if (disposal_req.fl_approval != null) { if (disposal_req.fl_approval == true) { if (disposal_req.approval_suggestion_id == null || disposal_req.approval_suggestion_id == 0) { ModelState.AddModelError("approval_suggestion_id", "Suggestion is Mandatory."); } } } else if (disposal_req.approval_noted == null || disposal_req.approval_noted.Trim() == string.Empty) { ModelState.AddModelError("fl_approval", "Approval is Mandatory."); ModelState.AddModelError("approval_noted", "Reject Reason is Mandatory."); } //update disposal request and approval data with transaction if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { bool iscomplete = false; #region "Save update Request Disposal" tr_disposal_request disposal_request = db.tr_disposal_request.Find(disposal_req.request_id); var doneapp = (from app in db.tr_disposal_approval where (app.approval_date == null && app.fl_active == true && app.deleted_date == null && app.request_id == disposal_req.request_id) select app).ToList(); if (disposal_req.fl_SuggestionChanges == false) { disposal_request.fl_approval = disposal_req.fl_approval; if (disposal_req.fl_approval == true) { if (doneapp.Count == 1) { disposal_request.request_status_id = 5;//complete iscomplete = true; } else { disposal_request.request_status_id = 2;//approve } } else { disposal_request.request_status_id = 3; //reject } disposal_request.approval_date = DateTime.Now; disposal_request.updated_date = DateTime.Now; disposal_request.update_by = UserProfile.UserId; disposal_request.deleted_date = null; disposal_request.deleted_by = null; db.Entry(disposal_request).State = EntityState.Modified; db.SaveChanges(); } #endregion #region "Save update Approval Disposal" tr_disposal_approval disposal_approval = db.tr_disposal_approval.Find(disposal_req.approval_id); if (disposal_req.fl_approval == true) { disposal_approval.approval_status_id = 2;//approve disposal_approval.approval_suggestion_id = disposal_req.approval_suggestion_id; } else { disposal_approval.approval_status_id = 3; //reject disposal_approval.approval_noted = disposal_req.approval_noted; disposal_approval.fl_active = false; //kembalikan status announcement ke suggestion terakhir tr_disposal_announcement disposal_ann_old = (from tda in db.tr_disposal_announcement where tda.request_id == disposal_approval.request_id && tda.fl_suggestion_changes == true select tda).FirstOrDefault(); disposal_ann_old.fl_suggestion_changes = false; disposal_ann_old.fl_active = true; disposal_ann_old.updated_date = DateTime.Now; disposal_ann_old.updated_by = UserProfile.UserId; db.Entry(disposal_ann_old).State = EntityState.Modified; db.SaveChanges(); } disposal_approval.approval_date = DateTime.Now; disposal_approval.approval_location_id = UserProfile.asset_reg_location_id; disposal_approval.updated_date = DateTime.Now; disposal_approval.updated_by = UserProfile.UserId; disposal_approval.deleted_date = null; disposal_approval.deteled_by = null; db.Entry(disposal_approval).State = EntityState.Modified; db.SaveChanges(); #endregion if (disposal_req.fl_approval == true) { //cek untuk disposal changes: site atau ho tr_asset_registration assetreg = db.tr_asset_registration.Find(disposal_request.asset_id); if (doneapp.Count == 1) { iscomplete = true; } if (!iscomplete && ((assetreg.location_id != 1 && disposal_req.fl_SuggestionChanges == true) || (disposal_req.fl_SuggestionChanges == false))) { #region "kirim email ke approval" var next_approval = (from app in db.tr_disposal_approval where (app.approval_date == null && app.fl_active == true && app.deleted_date == null) && app.request_id == disposal_req.request_id orderby app.approval_id ascending join a in db.ms_employee on app.approval_employee_id equals a.employee_id where a.fl_active == true && a.deleted_date == null join b in db.ms_user on a.employee_id equals b.employee_id where b.fl_active == true && b.deleted_date == null select new disposalViewModel { approval_id = app.approval_id, ms_employee = a, ms_user = b }).FirstOrDefault <disposalViewModel>(); if (next_approval != null) { sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = next_approval.ms_employee.employee_email; sy_email_log.elog_subject = string.Format("Asset Disposal Need Approval"); sy_email_log.elog_template = "EMAIL_TEMPLATE_04"; #region "body mail" var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_04")); string strBodyMail = _bodymail.FirstOrDefault().app_value; strBodyMail = strBodyMail.Replace("[to]", next_approval.ms_employee.employee_name); strBodyMail = strBodyMail.Replace("[action]", "Dispose"); strBodyMail = strBodyMail.Replace("[assetnumber]", disposal_req.asset_number); strBodyMail = strBodyMail.Replace("[aseetname]", disposal_req.asset_name); strBodyMail = strBodyMail.Replace("[assetlocation]", disposal_req.location_name); strBodyMail = strBodyMail.Replace("[department]", disposal_req.department_name); //token untuk link approval di email string token = string.Format("DisposalApproval|Approval/{0}|{1}|{2}|{3}", next_approval.approval_id, next_approval.ms_user.user_name, UserProfile.company_id, UserProfile.asset_reg_location_id); token = CryptorHelper.Encrypt(token, "MD5", true).Replace("+", "plus").Replace("=", "equal"); string linkapp = string.Format("{0}://{1}{2}", Request.Url.Scheme, Request.Url.Authority, Url.Content("~/Account/Login?ReturnUrl=%2f&token=" + token)); string strImg = string.Format("http://{0}/Content/EmailImage/button_approval_disposal.png", Request.Url.Authority); linkapp = string.Format(@"<a href={0}><img src=""{1}"" alt=""click for approval""/></a>", linkapp, strImg); strBodyMail = strBodyMail.Replace("[link]", linkapp); sy_email_log.elog_body = strBodyMail; #endregion 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(); } #endregion #region "Save Sy_Message_notification ke approval" sy_message_notification msg = new sy_message_notification(); msg.notif_group = "BALOON_RECEIPT_04"; msg.notify_user = next_approval.ms_user.user_name; msg.notify_ip = next_approval.ms_employee.ip_address; msg.notify_message = "Ada permintaan approval untuk Asset disposal."; msg.fl_active = true; msg.created_date = DateTime.Now; msg.created_by = UserProfile.UserId; msg.fl_shown = 0; db.sy_message_notification.Add(msg); db.SaveChanges(); #endregion } else { #region "Save Update Process Disposal" ms_disposal_type suggestion = db.ms_disposal_type.Find(disposal_req.approval_suggestion_id); tr_disposal_announcement disposalproses = new tr_disposal_announcement(); disposalproses.request_id = disposal_req.request_id; disposalproses.approval_disposal_type_id = disposal_req.approval_suggestion_id; if (disposal_req.approval_suggestion_id != 3) { disposalproses.fl_announcement_status = true; } else { disposalproses.fl_remove_asset = true; disposalproses.remove_asset_dept_id = 5; } disposalproses.fl_active = true; disposalproses.created_date = DateTime.Now; disposalproses.created_by = UserProfile.UserId; disposalproses.updated_date = DateTime.Now; disposalproses.updated_by = UserProfile.UserId; disposalproses.deleted_date = null; disposalproses.deleted_by = null; disposalproses.org_id = UserProfile.OrgId; disposalproses = db.tr_disposal_announcement.Add(disposalproses); db.SaveChanges(); #endregion #region "kirim email ke PIC Process Disposal" string emailsetting = string.Empty; string to_name = string.Empty; switch (disposal_req.approval_suggestion_id) { //resale => procurement case 1: emailsetting = "EMAIL_TO_DISPOSAL_PROCUREMENT"; to_name = "Department Procurement"; break; //donation => CSR case 2: emailsetting = "EMAIL_TO_DISPOSAL_CSR"; to_name = "Department CSR"; break; //destroy => Acounting case 3: emailsetting = "EMAIL_TO_DISPOSAL_ACCOUNTING"; to_name = "Department Accounting"; break; } var _emailto = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains(emailsetting)); sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = _emailto.FirstOrDefault().app_value; sy_email_log.elog_subject = string.Format("Asset Disposal Need Follow Up ({0})", suggestion.disposal_type_name); sy_email_log.elog_template = "EMAIL_TEMPLATE_05"; #region "body mail" var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_05")); string strBodyMail = _bodymail.FirstOrDefault().app_value; strBodyMail = strBodyMail.Replace("[to]", to_name); strBodyMail = strBodyMail.Replace("[assetnumber]", disposal_req.asset_number); strBodyMail = strBodyMail.Replace("[aseetname]", disposal_req.asset_name); strBodyMail = strBodyMail.Replace("[assetlocation]", disposal_req.location_name); strBodyMail = strBodyMail.Replace("[department]", disposal_req.department_name); strBodyMail = strBodyMail.Replace("[suggestion]", suggestion.disposal_type_name); strBodyMail = strBodyMail.Replace("[freetext]", ""); string linkapp = string.Format("{0}://{1}{2}", Request.Url.Scheme, Request.Url.Authority, Url.Content("~/Account/Login?ReturnUrl=%2f")); string strImg = string.Format("http://{0}/Content/EmailImage/button_asmin.png", Request.Url.Authority); linkapp = string.Format(@"<a href={0}><img src=""{1}"" alt=""click for process""/></a>", linkapp, strImg); strBodyMail = strBodyMail.Replace("[link]", linkapp); sy_email_log.elog_body = strBodyMail; #endregion 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(); #endregion } } transaction.Commit(); ViewBag.ResultMessage = "Update table successfully."; return(RedirectToAction("Index")); } catch (Exception) { // roll back all database operations, if any thing goes wrong transaction.Rollback(); ViewBag.ResultMessage = "Error occured, records rolledback."; } } } disposal_req = DataDisposalView(disposal_req.request_id, disposal_req); return(View(disposal_req)); }
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)); }
public ActionResult Approval([Bind(Include = "request_id, asset_id, approval_id, fl_approval, approval_noted, asset_number,asset_name, location_name, department_name, employee_name, transfer_to_location_name, transfer_to_dept_name, transfer_to_emp_name, transfer_to_location_id, transfer_to_dept_id, transfer_to_emp_id")] AssetMutationViewModel mutation_req) { if (mutation_req.fl_approval != null) { if (mutation_req.fl_approval == true) { //if (mutation_req.approval_suggestion_id == null || mutation_req.approval_suggestion_id == 0) // ModelState.AddModelError("approval_suggestion_id", "Suggestion is Mandatory."); } } else if (mutation_req.approval_noted == null || mutation_req.approval_noted.Trim() == string.Empty) { ModelState.AddModelError("fl_approval", "Approval is Mandatory."); ModelState.AddModelError("approval_noted", "Reject Reason is Mandatory."); } //update disposal request and approval data with transaction if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { bool iscomplete = false; #region "Save update Request Asset Mutation" tr_mutation_request mutation_request = db.tr_mutation_request.Find(mutation_req.request_id); mutation_request.fl_approval = mutation_req.fl_approval; if (mutation_req.fl_approval == true) { var doneapp = (from app in db.tr_mutation_approval where (app.approval_date == null && app.fl_active == true && app.deleted_date == null && app.request_id == mutation_req.request_id) select app).ToList(); if (doneapp.Count == 1) { mutation_request.request_status = 5;//complete iscomplete = true; tr_mutation_process tr = new tr_mutation_process(); tr.request_id = mutation_req.request_id; tr.org_id = UserProfile.OrgId; tr.fl_active = true; tr = db.tr_mutation_process.Add(tr); db.SaveChanges(); } else { mutation_request.request_status = 2;//approve } } else { mutation_request.request_status = 3; //reject } mutation_request.approval_date = DateTime.Now; mutation_request.updated_date = DateTime.Now; mutation_request.updated_by = UserProfile.UserId; mutation_request.deleted_date = null; mutation_request.deleted_by = null; db.Entry(mutation_request).State = EntityState.Modified; db.SaveChanges(); #endregion #region "Save update Approval Mutation" tr_mutation_approval mutation_approval = db.tr_mutation_approval.Find(mutation_req.approval_id); if (mutation_req.fl_approval == true) { mutation_approval.approval_status_id = 2;//approve } else { mutation_approval.approval_status_id = 3; //reject mutation_approval.approval_noted = mutation_req.approval_noted; } mutation_approval.approval_date = DateTime.Now; //mutation_approval.approval_location_id = UserProfile.location_id; --> location_id bukan dari login mutation_approval.updated_date = DateTime.Now; mutation_approval.updated_by = UserProfile.UserId; mutation_approval.deleted_date = null; mutation_approval.deteled_by = null; db.Entry(mutation_approval).State = EntityState.Modified; db.SaveChanges(); #endregion if (mutation_req.fl_approval == true) { if (!iscomplete) { #region "kirim email ke approval" var next_approval = (from app in db.tr_mutation_approval where (app.approval_date == null && app.fl_active == true && app.deleted_date == null) && app.request_id == mutation_req.request_id orderby app.approval_id ascending join a in db.ms_employee on app.approval_employee_id equals a.employee_id where a.fl_active == true && a.deleted_date == null select a).FirstOrDefault <ms_employee>(); if (next_approval != null) { sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = next_approval.employee_email; sy_email_log.elog_subject = string.Format("Asset Mutation Need Approval"); sy_email_log.elog_template = "EMAIL_TEMPLATE_02"; #region "body mail" var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_02")); string strBodyMail = _bodymail.FirstOrDefault().app_value; strBodyMail = strBodyMail.Replace("[to]", next_approval.employee_name); strBodyMail = strBodyMail.Replace("[assetnumber]", mutation_req.asset_number); strBodyMail = strBodyMail.Replace("[assetname]", mutation_req.asset_name); strBodyMail = strBodyMail.Replace("[assetlocation]", mutation_req.location_name); strBodyMail = strBodyMail.Replace("[department]", mutation_req.department_name); strBodyMail = strBodyMail.Replace("[employee]", mutation_req.employee_name); //strBodyMail = strBodyMail.Replace("[link]", ""); sy_email_log.elog_body = strBodyMail; #endregion 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(); } #endregion #region "Save Sy_Message_notification ke approval" if (next_approval != null) { int empid = Convert.ToInt32(next_approval.employee_id); ms_user msuser = (from m in db.ms_user where m.employee_id == empid select m).FirstOrDefault(); sy_message_notification msg = new sy_message_notification(); msg.notif_group = "BALOON_RECEIPT_03"; msg.notify_user = msuser.user_name; msg.notify_ip = next_approval.ip_address; msg.notify_message = "Ada permintaan approval untuk asset mutasi."; msg.fl_active = true; msg.created_date = DateTime.Now; msg.created_by = UserProfile.UserId; msg.fl_shown = 0; db.sy_message_notification.Add(msg); db.SaveChanges(); } #endregion } else { //kl dh complete??? } } transaction.Commit(); ViewBag.ResultMessage = "Update table successfully."; return(RedirectToAction("Index")); } catch (Exception) { // roll back all database operations, if any thing goes wrong transaction.Rollback(); ViewBag.ResultMessage = "Error occured, records rolledback."; } } } mutation_req = DataMutationView(mutation_req.request_id, mutation_req); return(View(mutation_req)); }
public Boolean Send() { Boolean returnBool = true; this.PopulateEmailAddress(); EmailSenderUserToken user_token = null; if (this.MAIL_SendMailAsync) { user_token = new EmailSenderUserToken(); } SmtpClient smtp_client = null; MailMessage mail_message = new MailMessage(); //string exMessage = ""; try { if (m_mail_port != 0) { smtp_client = new SmtpClient(m_mail_server, m_mail_port); } else { smtp_client = new SmtpClient(m_mail_server); } smtp_client.EnableSsl = this.MAIL_EnabledSSL; smtp_client.UseDefaultCredentials = this.MAIL_UseDefaultCredentials; smtp_client.Credentials = this.SetCredential(); mail_message.From = this.FromMailAddress; if (this.ToMailAddress.Count > 0) { foreach (MailAddress _emailAddress in this.ToMailAddress) { mail_message.To.Add(_emailAddress); } } if (this.ReplyToMailAddress.Count > 0) { foreach (MailAddress _emailAddress in this.ReplyToMailAddress) { mail_message.ReplyToList.Add(_emailAddress); } } if (this.CcMailAddress.Count > 0) { foreach (MailAddress _emailAddress in this.ToMailAddress) { mail_message.CC.Add(_emailAddress); } } if (this.BccMailAddress.Count > 0) { foreach (MailAddress _emailAddress in this.ToMailAddress) { mail_message.Bcc.Add(_emailAddress); } } if (this.HasAttachment) { foreach (string str_file in this.AttachmentFiles) { mail_message.Attachments.Add(new System.Net.Mail.Attachment(str_file)); } } mail_message.Subject = this.MailSubject; mail_message.Body = this.MailBody; mail_message.IsBodyHtml = true; smtp_client.DeliveryMethod = SmtpDeliveryMethod.Network; if (this.MAIL_SendMailAsync) { smtp_client.SendAsync(mail_message, user_token); user_token.MessageID = this.MessageId; user_token.SendResult = returnBool; user_token.SendResultMessage = "Sucess"; } else { smtp_client.Send(mail_message); } } catch (Exception mail_ex) { string exMessage = "Fail on EmailHelper.Send():" + mail_ex.Message.ToString(); m_error_message.Add(exMessage); returnBool = false; if (this.MAIL_SendMailAsync) { user_token.SendResult = returnBool; user_token.SendResultMessage = exMessage; } //throw mail_ex; } finally { m_mail_sent_time = DateTime.Now; try { using (ModelAsmRemote db = new ModelAsmRemote()) { string exMessage = ""; foreach (string str in this.m_error_message) { exMessage += str + Environment.NewLine; } sy_email_log sy_email_log = new sy_email_log() { elog_template = this.Email_Template, elog_from = this.FromAddress, elog_to = this.ToAddress, elog_cc = this.CcAddress, elog_bcc = this.BccAddress, elog_subject = this.MailSubject, elog_body = this.MailBody, elog_has_attachment = false, //elog_file_attachment = null, fl_active = true, created_date = m_mail_init_time, created_by = ((USER_PROFILE)System.Web.HttpContext.Current.Session["USER_PROFILE"]).UserId, fl_sent = returnBool, sent_date = m_mail_sent_time, err_message = exMessage }; sy_email_log = db.sy_email_log.Add(sy_email_log); db.SaveChanges(); }; } catch { } } return(returnBool); }
public ActionResult DisposalFollowup([Bind(Include = "announcement_id, request_id, announcement_upload_address, announcement_description, asset_number, asset_name, location_name, department_name, fl_SuggestionChanges, approval_suggestion_id")] disposalViewModel disposal_prs) { tr_disposal_announcement disposal_announcement = db.tr_disposal_announcement.Find(disposal_prs.announcement_id); if (disposal_prs.fl_SuggestionChanges == null || disposal_prs.fl_SuggestionChanges == false) { if (Request.Files.Count > 0) { var file = Request.Files["announcement_upload_address"]; if (file == null || file.ContentLength == 0) { ModelState.AddModelError("announcement_upload_address", "Berita Acara is Mandatory."); } } } else { if (disposal_prs.approval_suggestion_id == null || disposal_prs.approval_suggestion_id == 0) { ModelState.AddModelError("approval_suggestion_id", "Suggestion is Mandatory."); } } //update disposal request and approval data with transaction if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { if (disposal_prs.fl_SuggestionChanges == null || disposal_prs.fl_SuggestionChanges == false) { //Process Normal #region "Save update Disposal Announcement" if (Request.Files.Count > 0) { //var file = Request.Files[0]; app_root_path = Server.MapPath("~/"); if (string.IsNullOrWhiteSpace(base_file_path)) { base_file_path = asset_registrationViewModel.path_file_disposal; } string _file = Server.MapPath(base_file_path); if (!Directory.Exists(_file)) { Directory.CreateDirectory(_file); } var file = Request.Files["announcement_upload_address"]; if (file != null && file.ContentLength > 0) { var fileName = "dispose_precurement_" + disposal_prs.request_id.ToString() + "_" + Path.GetFileName(file.FileName); var path = Path.Combine(_file, fileName); file.SaveAs(path); disposal_announcement.announcement_upload_address = fileName; disposal_announcement.announcement_description = disposal_prs.announcement_description; disposal_announcement.announcement_date = DateTime.Now; disposal_announcement.announcement_emp_id = UserProfile.employee_id; disposal_announcement.fl_remove_asset = true; disposal_announcement.remove_asset_dept_id = 5; } } disposal_announcement.updated_date = DateTime.Now; disposal_announcement.updated_by = UserProfile.UserId; disposal_announcement.deleted_date = null; disposal_announcement.deleted_by = null; db.Entry(disposal_announcement).State = EntityState.Modified; db.SaveChanges(); #endregion #region "kirim email ke PIC Process Disposal" string emailsetting = string.Empty; string to_name = string.Empty; string freetext = string.Empty; emailsetting = "EMAIL_TO_DISPOSAL_ACCOUNTING"; to_name = "Department Accounting"; freetext = "Dokumen <strong>Berita Acara</strong> sudah tersedia. Asset menunggu tindak lanjut (<strong>Dispose</strong>) oleh Accounting Department."; var _emailto = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains(emailsetting)); sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = _emailto.FirstOrDefault().app_value; sy_email_log.elog_subject = string.Format("Asset Disposal Need Follow Up (Donation)"); sy_email_log.elog_template = "EMAIL_TEMPLATE_05"; #region "body mail" var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_05")); string strBodyMail = _bodymail.FirstOrDefault().app_value; strBodyMail = strBodyMail.Replace("[to]", to_name); strBodyMail = strBodyMail.Replace("[assetnumber]", disposal_prs.asset_number); strBodyMail = strBodyMail.Replace("[aseetname]", disposal_prs.asset_name); strBodyMail = strBodyMail.Replace("[assetlocation]", disposal_prs.location_name); strBodyMail = strBodyMail.Replace("[department]", disposal_prs.department_name); strBodyMail = strBodyMail.Replace("[suggestion]", "Donation"); strBodyMail = strBodyMail.Replace("[freetext]", freetext); string linkapp = string.Format("{0}://{1}{2}", Request.Url.Scheme, Request.Url.Authority, Url.Content("~/Account/Login?ReturnUrl=%2f")); string strImg = string.Format("http://{0}/Content/EmailImage/button_asmin.png", Request.Url.Authority); linkapp = string.Format(@"<a href={0}><img src=""{1}"" alt=""click for process""/></a>", linkapp, strImg); strBodyMail = strBodyMail.Replace("[link]", linkapp); sy_email_log.elog_body = strBodyMail; #endregion 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(); #endregion } else if (disposal_prs.fl_SuggestionChanges == true) { #region "Update Data Announcement" //update flag active = false disposal_announcement.fl_suggestion_changes = true; disposal_announcement.fl_active = false; disposal_announcement.updated_date = DateTime.Now; disposal_announcement.updated_by = UserProfile.UserId; disposal_announcement.deleted_date = null; disposal_announcement.deleted_by = null; db.Entry(disposal_announcement).State = EntityState.Modified; db.SaveChanges(); #endregion #region "Save create disposal_approval" var refApproval = (from a in db.ms_job_level where (a.fl_active == true && a.deleted_date == null && a.job_level_id == 2) join b in db.ms_employee_detail on a.job_level_id equals b.job_level_id where (b.fl_active == true && b.deleted_date == null && b.department_id == 10 && b.company_id == UserProfile.company_id) join c in db.ms_employee on b.employee_id equals c.employee_id where c.fl_active == true && c.deleted_date == null select new disposalViewModel() { department_id = b.department_id, employee_id = b.employee_id, job_level_id = a.job_level_id, employee_email = c.employee_email, employee_name = c.employee_name }).First <disposalViewModel>(); //approval disposal changes level 1 tr_disposal_approval disposal_approval = new tr_disposal_approval(); disposal_approval.request_id = disposal_prs.request_id; disposal_approval.approval_date = null; disposal_approval.approval_dept_id = refApproval.department_id; disposal_approval.approval_employee_id = refApproval.employee_id; disposal_approval.approval_level_id = refApproval.job_level_id; disposal_approval.approval_status_id = 1;//waiting approval disposal_approval.approval_suggestion_id = disposal_prs.approval_suggestion_id; disposal_approval.fl_active = true; disposal_approval.created_date = DateTime.Now; disposal_approval.created_by = UserProfile.UserId; disposal_approval.updated_date = DateTime.Now; disposal_approval.updated_by = UserProfile.UserId; disposal_approval.deleted_date = null; disposal_approval.deteled_by = null; disposal_approval.org_id = UserProfile.OrgId; disposal_approval = db.tr_disposal_approval.Add(disposal_approval); db.SaveChanges(); int approval_id = disposal_approval.approval_id; //approval disposal changes level 2 tr_disposal_request disposalrequest = db.tr_disposal_request.Find(disposal_prs.request_id); tr_asset_registration assetreg = db.tr_asset_registration.Find(disposalrequest.asset_id); if (assetreg.location_id != 1) { var refApproval2 = (from a in db.ms_job_level where (a.fl_active == true && a.deleted_date == null && a.job_level_id == 3) join b in db.ms_employee_detail on a.job_level_id equals b.job_level_id where (b.fl_active == true && b.deleted_date == null && b.department_id == disposalrequest.request_dept_id && b.company_id == assetreg.company_id) join c in db.ms_employee on b.employee_id equals c.employee_id where c.fl_active == true && c.deleted_date == null select new disposalViewModel() { department_id = b.department_id, employee_id = b.employee_id, job_level_id = a.job_level_id, employee_email = c.employee_email, employee_name = c.employee_name }).First <disposalViewModel>(); disposal_approval = new tr_disposal_approval(); disposal_approval.request_id = disposal_prs.request_id; disposal_approval.approval_date = null; disposal_approval.approval_dept_id = refApproval2.department_id; disposal_approval.approval_employee_id = refApproval2.employee_id; disposal_approval.approval_level_id = refApproval2.job_level_id; disposal_approval.approval_status_id = 1;//waiting approval disposal_approval.approval_suggestion_id = disposal_prs.approval_suggestion_id; disposal_approval.fl_active = true; disposal_approval.created_date = DateTime.Now; disposal_approval.created_by = UserProfile.UserId; disposal_approval.updated_date = DateTime.Now; disposal_approval.updated_by = UserProfile.UserId; disposal_approval.deleted_date = null; disposal_approval.deteled_by = null; disposal_approval.org_id = UserProfile.OrgId; disposal_approval = db.tr_disposal_approval.Add(disposal_approval); db.SaveChanges(); } #endregion #region "Kirim email ke Procurement Head" sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = refApproval.employee_email; sy_email_log.elog_subject = string.Format("Asset Disposal Changes Need Approval"); sy_email_log.elog_template = "EMAIL_TEMPLATE_04"; var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_04")); string strBodyMail = _bodymail.FirstOrDefault().app_value; strBodyMail = strBodyMail.Replace("[to]", refApproval.employee_name); strBodyMail = strBodyMail.Replace("[action]", "Disposal Changes"); strBodyMail = strBodyMail.Replace("[assetnumber]", disposal_prs.asset_number); strBodyMail = strBodyMail.Replace("[aseetname]", disposal_prs.asset_name); strBodyMail = strBodyMail.Replace("[assetlocation]", disposal_prs.location_name); strBodyMail = strBodyMail.Replace("[department]", disposal_prs.department_name); int empid = Convert.ToInt32(refApproval.employee_id); ms_user msuser = (from m in db.ms_user where m.employee_id == empid select m).FirstOrDefault(); //token untuk link approval di email string token = string.Format("DisposalApproval|Approval/{0}|{1}|{2}|{3}", approval_id, msuser.user_name, UserProfile.company_id, UserProfile.asset_reg_location_id); token = CryptorHelper.Encrypt(token, "MD5", true).Replace("+", "plus").Replace("=", "equal"); string linkapp = string.Format("{0}://{1}{2}", Request.Url.Scheme, Request.Url.Authority, Url.Content("~/Account/Login?ReturnUrl=%2f&token=" + token)); string strImg = string.Format("http://{0}/Content/EmailImage/button_approval_disposal.png", Request.Url.Authority); linkapp = string.Format(@"<a href={0}><img src=""{1}"" alt=""click for approval""/></a>", linkapp, strImg); strBodyMail = strBodyMail.Replace("[link]", linkapp); 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(); #endregion } transaction.Commit(); ViewBag.ResultMessage = "Update table successfully."; return(RedirectToAction("Index")); } catch (Exception) { // roll back all database operations, if any thing goes wrong transaction.Rollback(); ViewBag.ResultMessage = "Error occured, records rolledback."; } } } disposal_prs = DataDisposalView(disposal_prs.request_id, disposal_prs); return(View(disposal_prs)); }
public ActionResult request([Bind(Include = "asset_id, asset_number, asset_name, current_location_id, location_name, current_department_id, department_name, current_employee_id, employee_name, transfer_to_location_id, transfer_to_dept_id, transfer_to_emp_id, asset_original_value")] AssetMutationViewModel mutation_req) { //Cek apakah disposal sudah di proses sebelumnya (kecuali reject) var _MutationExist = (from dr in db.tr_mutation_request where (dr.fl_active == true && dr.deleted_date == null) && dr.asset_id == mutation_req.asset_id select dr).ToList <tr_mutation_request>(); if (_MutationExist.Count > 0) { ModelState.AddModelError("asset_number", "Asset Already Exists in Disposal Request Data."); } //input data request disposal with transaction if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { //Save Request Disposal tr_mutation_request mutation_request = new tr_mutation_request(); mutation_request.request_code = MutationNumberNew(mutation_req.asset_id); mutation_request.asset_id = mutation_req.asset_id; mutation_request.request_date = DateTime.Now; //mutation_request.request_location_id = UserProfile.location_id; //mutation_request.request_dept_id = UserProfile.department_id; //mutation_request.request_emp_id = UserProfile.employee_id; mutation_request.request_location_id = mutation_req.current_location_id; mutation_request.request_dept_id = mutation_req.current_department_id; mutation_request.request_emp_id = mutation_req.current_employee_id; mutation_request.request_status = 1; mutation_request.transfer_to_location_id = mutation_req.transfer_to_location_id; mutation_request.transfer_to_dept_id = mutation_req.transfer_to_dept_id; mutation_request.transfer_to_emp_id = mutation_req.transfer_to_emp_id; mutation_request.fl_active = true; mutation_request.created_date = DateTime.Now; mutation_request.created_by = UserProfile.UserId; mutation_request.updated_date = DateTime.Now; mutation_request.updated_by = UserProfile.UserId; mutation_request.deleted_date = null; mutation_request.deleted_by = null; mutation_request.org_id = UserProfile.OrgId; mutation_request = db.tr_mutation_request.Add(mutation_request); db.SaveChanges(); var x = UserProfile.OrgId; //Save Approval List Mutation Untuk Dept Head //Hendy 22 Feb 2020 var _qry = (from sa in db.sy_ref_approval_level where sa.asset_reg_location_id == mutation_req.current_location_id && sa.job_level_id == 2 join a in db.ms_job_level on sa.job_level_id equals a.job_level_id where (a.fl_active == true && a.deleted_date == null) join b in db.ms_employee_detail on a.job_level_id equals b.job_level_id where (b.fl_active == true && b.deleted_date == null //&& b.department_id == UserProfile.department_id && b.org_id == UserProfile.OrgId) && b.department_id == mutation_req.current_department_id && b.company_id == UserProfile.company_id) join c in db.ms_employee on b.employee_id equals c.employee_id orderby sa.order_no ascending select new AssetMutationViewModel() { //request_location_id = b.loca request_dept_id = b.department_id, request_emp_id = b.employee_id, request_level_id = a.job_level_id, current_employee_id = c.employee_id, employee_email = c.employee_email, employee_name = c.employee_name, ip_address = c.ip_address }).ToList <AssetMutationViewModel>(); if (_qry != null) { foreach (AssetMutationViewModel refApproval in _qry) { tr_mutation_approval mutation_approval = new tr_mutation_approval(); mutation_approval.request_id = mutation_request.request_id; mutation_approval.approval_date = null; mutation_approval.approval_location_id = /*refApproval.request_location_id*/ 0; mutation_approval.approval_dept_id = refApproval.request_dept_id; mutation_approval.approval_employee_id = refApproval.request_emp_id; mutation_approval.approval_level_id = refApproval.request_level_id; mutation_approval.approval_status_id = 1;//waiting approval mutation_approval.approval_noted = ""; mutation_approval.fl_active = true; mutation_approval.created_date = DateTime.Now; mutation_approval.created_by = UserProfile.UserId; mutation_approval.updated_date = DateTime.Now; mutation_approval.updated_by = UserProfile.UserId; mutation_approval.deleted_date = null; mutation_approval.deteled_by = null; mutation_approval.org_id = UserProfile.OrgId; mutation_approval = db.tr_mutation_approval.Add(mutation_approval); db.SaveChanges(); } } //Check KTT //check range approval decimal ktt_asset_value = Convert.ToDecimal(mutation_req.asset_original_value); bool isKTTApproval = false; ms_approval_range range_ktt = db.ms_approval_range.Where(r => r.range_code == "M_lv2").FirstOrDefault(); if (range_ktt != null) { isKTTApproval = (range_ktt.range_min <= ktt_asset_value); } if (isKTTApproval) { var x_ktt = UserProfile.OrgId; //Save Approval List Mutation Untuk Dept Head //Hendy 22 Feb 2020 var _qry_ktt = (from sa in db.sy_ref_approval_level where sa.asset_reg_location_id == mutation_req.current_location_id && sa.job_level_id == 3 join a in db.ms_job_level on sa.job_level_id equals a.job_level_id where (a.fl_active == true && a.deleted_date == null) join b in db.ms_employee_detail on a.job_level_id equals b.job_level_id where (b.fl_active == true && b.deleted_date == null) && b.company_id == UserProfile.company_id join c in db.ms_employee on b.employee_id equals c.employee_id where c.employee_id == UserProfile.employee_id orderby sa.order_no ascending select new AssetMutationViewModel() { //request_location_id = b.loca request_dept_id = b.department_id, request_emp_id = b.employee_id, request_level_id = a.job_level_id, current_employee_id = c.employee_id, employee_email = c.employee_email, employee_name = c.employee_name, ip_address = c.ip_address }).ToList <AssetMutationViewModel>(); if (_qry_ktt != null) { foreach (AssetMutationViewModel refApproval in _qry_ktt) { tr_mutation_approval mutation_approval = new tr_mutation_approval(); mutation_approval.request_id = mutation_request.request_id; mutation_approval.approval_date = null; mutation_approval.approval_location_id = /*refApproval.request_location_id*/ 0; mutation_approval.approval_dept_id = refApproval.request_dept_id; mutation_approval.approval_employee_id = refApproval.request_emp_id; mutation_approval.approval_level_id = refApproval.request_level_id; mutation_approval.approval_status_id = 1;//waiting approval mutation_approval.approval_noted = ""; mutation_approval.fl_active = true; mutation_approval.created_date = DateTime.Now; mutation_approval.created_by = UserProfile.UserId; mutation_approval.updated_date = DateTime.Now; mutation_approval.updated_by = UserProfile.UserId; mutation_approval.deleted_date = null; mutation_approval.deteled_by = null; mutation_approval.org_id = UserProfile.OrgId; mutation_approval = db.tr_mutation_approval.Add(mutation_approval); db.SaveChanges(); } } } decimal asset_value = Convert.ToDecimal(mutation_req.asset_original_value); bool isBODApproval = false; ms_approval_range range = db.ms_approval_range.Where(r => r.range_code == "M_BOD").FirstOrDefault(); if (range != null) { isBODApproval = (range.range_min <= asset_value); } if (isBODApproval) { //Approval BOD berdasarkan data ms_department >> employee_bod_id ms_department dept = db.ms_department.Find(UserProfile.department_id); if (dept != null) { tr_mutation_approval mutation_approval = new tr_mutation_approval(); mutation_approval.request_id = mutation_request.request_id; mutation_approval.approval_date = null; mutation_approval.approval_location_id = /*refApproval.request_location_id*/ 0; mutation_approval.approval_dept_id = dept.department_id; mutation_approval.approval_employee_id = dept.employee_bod_id; mutation_approval.approval_level_id = 9; mutation_approval.approval_status_id = 1;//waiting approval mutation_approval.approval_noted = ""; mutation_approval.fl_active = true; mutation_approval.created_date = DateTime.Now; mutation_approval.created_by = UserProfile.UserId; mutation_approval.updated_date = DateTime.Now; mutation_approval.updated_by = UserProfile.UserId; mutation_approval.deleted_date = null; mutation_approval.deteled_by = null; mutation_approval.org_id = UserProfile.company_id; mutation_approval = db.tr_mutation_approval.Add(mutation_approval); db.SaveChanges(); } } #region "kirim email ke approval level 1" sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = _qry.FirstOrDefault().employee_email; sy_email_log.elog_subject = string.Format("Asset Mutation Need Approval"); sy_email_log.elog_template = "EMAIL_TEMPLATE_02"; #region "body mail" var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_02")); string strBodyMail = _bodymail.FirstOrDefault().app_value; strBodyMail = strBodyMail.Replace("[to]", _qry.FirstOrDefault().employee_name); strBodyMail = strBodyMail.Replace("[assetnumber]", mutation_req.asset_number); strBodyMail = strBodyMail.Replace("[assetname]", mutation_req.asset_name); strBodyMail = strBodyMail.Replace("[assetlocation]", mutation_req.location_name); strBodyMail = strBodyMail.Replace("[department]", mutation_req.department_name); strBodyMail = strBodyMail.Replace("[employee]", mutation_req.employee_name); //strBodyMail = strBodyMail.Replace("[link]", ""); sy_email_log.elog_body = strBodyMail; #endregion 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(); #endregion #region "Save Sy_Message_notification ke approval" int empid = Convert.ToInt32(_qry.FirstOrDefault().current_employee_id); ms_user msuser = (from m in db.ms_user where m.employee_id == empid select m).FirstOrDefault(); sy_message_notification msg = new sy_message_notification(); msg.notif_group = "BALOON_RECEIPT_03"; msg.notify_user = msuser.user_name; msg.notify_ip = _qry.FirstOrDefault().ip_address; msg.notify_message = "Ada permintaan approval untuk asset mutasi."; msg.fl_active = true; msg.created_date = DateTime.Now; msg.created_by = UserProfile.UserId; msg.fl_shown = 0; db.sy_message_notification.Add(msg); db.SaveChanges(); #endregion transaction.Commit(); ViewBag.ResultMessage = "Record inserted into table successfully."; return(RedirectToAction("Index")); } catch (Exception ex) { // roll back all database operations, if any thing goes wrong transaction.Rollback(); string msgErr = string.Format("Error occured, records rolledback. {0}", ex.Message); if (ex.InnerException != null) { msgErr += string.Format(" Inner Exception: {0}", ex.InnerException.Message); } ModelState.AddModelError("", msgErr); } } } #region "for dropdown Employee" //var _employeelist = from s in db.ms_disposal_type // select s; var _employeelist = db.ms_employee.Where(t => t.deleted_date == null && t.fl_active == true).Select( t => new { t.employee_id, t.employee_nik, t.employee_name }).ToList(); SelectList itemsType = new SelectList(_employeelist, "employee_id", "employee_name"); ViewBag.transfer_to_emp_id = itemsType; #endregion #region "for dropdown Department" var _departmentlist = db.ms_department.Where(t => t.deleted_date == null && t.fl_active == true).Select( t => new { t.department_id, t.department_code, t.department_name }).ToList(); SelectList itemsType2 = new SelectList(_departmentlist, "department_id", "department_name"); ViewBag.transfer_to_dept_id = itemsType2; #endregion #region "for dropdown Location" var _locationlist = db.ms_asset_location.Where(t => t.deleted_date == null && t.fl_active == true).Select( t => new { t.location_id, t.location_code, t.location_name }).ToList(); SelectList itemsType3 = new SelectList(_locationlist, "location_id", "location_name"); ViewBag.transfer_to_location_id = itemsType3; #endregion return(View(mutation_req)); }
public ActionResult DisposalFollowup([Bind(Include = "announcement_id, request_id, remove_asset_description, asset_id, asset_number, asset_name, location_name, department_name")] disposalViewModel disposal_prs) { //update disposal request and approval data with transaction if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { #region "Save update Disposal Announcement" tr_disposal_announcement disposal_announcement = db.tr_disposal_announcement.Find(disposal_prs.announcement_id); disposal_announcement.remove_asset_description = disposal_prs.remove_asset_description; disposal_announcement.remove_asset_date = DateTime.Now; disposal_announcement.remove_asset_emp_id = UserProfile.employee_id; disposal_announcement.updated_date = DateTime.Now; disposal_announcement.updated_by = UserProfile.UserId; disposal_announcement.deleted_date = null; disposal_announcement.deleted_by = null; db.Entry(disposal_announcement).State = EntityState.Modified; db.SaveChanges(); #endregion tr_asset_registration asset_registration = db.tr_asset_registration.Find(disposal_prs.asset_id); asset_registration.fl_active = false; db.Entry(asset_registration).State = EntityState.Modified; db.SaveChanges(); #region "kirim email ke All PIC" string emailsetting = string.Empty; string emailsettingcc = string.Empty; var _emailapproval = (from app in db.tr_disposal_approval where app.request_id == disposal_prs.request_id && app.fl_active == true && app.deleted_date == null join a in db.ms_employee on app.approval_employee_id equals a.employee_id where a.fl_active == true && a.deleted_date == null select a).ToList <ms_employee>(); foreach (ms_employee employee_app in _emailapproval) { emailsettingcc += employee_app.employee_email + ";"; } var _emailowner_asset = (from app in db.tr_asset_registration where app.asset_id == disposal_prs.asset_id /*&& app.fl_active == true && app.deleted_date == null*/ join a in db.ms_employee on app.employee_id equals a.employee_id where a.fl_active == true && a.deleted_date == null select a).ToList <ms_employee>(); foreach (ms_employee employee_app in _emailowner_asset) { emailsetting += employee_app.employee_email + ";"; } var _emailpic_asset = (from app in db.tr_disposal_request where app.request_id == disposal_prs.request_id && app.fl_active == true && app.deleted_date == null join a in db.ms_employee on app.request_emp_id equals a.employee_id where a.fl_active == true && a.deleted_date == null select a).ToList <ms_employee>(); foreach (ms_employee employee_app in _emailpic_asset) { emailsetting += employee_app.employee_email + ";"; } var _email_announcement = (from app in db.tr_disposal_announcement where app.announcement_id == disposal_prs.announcement_id && app.fl_active == true && app.deleted_date == null join a in db.ms_employee on app.announcement_emp_id equals a.employee_id where a.fl_active == true && a.deleted_date == null select a).ToList <ms_employee>(); foreach (ms_employee employee_app in _email_announcement) { emailsetting += employee_app.employee_email + ";"; } var _email_fin_announcement = (from app in db.tr_disposal_announcement where app.announcement_id == disposal_prs.announcement_id && app.fl_active == true && app.deleted_date == null join a in db.ms_employee on app.fin_announcement_emp_id equals a.employee_id where a.fl_active == true && a.deleted_date == null select a).ToList <ms_employee>(); foreach (ms_employee employee_app in _email_fin_announcement) { emailsetting += employee_app.employee_email + ";"; } sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = emailsetting; sy_email_log.elog_cc = emailsettingcc; sy_email_log.elog_subject = string.Format("Disposal Asset"); sy_email_log.elog_template = "EMAIL_TEMPLATE_06"; #region "body mail" var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_06")); string strBodyMail = _bodymail.FirstOrDefault().app_value; strBodyMail = strBodyMail.Replace("[to]", ""); strBodyMail = strBodyMail.Replace("[assetnumber]", disposal_prs.asset_number); strBodyMail = strBodyMail.Replace("[aseetname]", disposal_prs.asset_name); strBodyMail = strBodyMail.Replace("[assetlocation]", disposal_prs.location_name); strBodyMail = strBodyMail.Replace("[department]", disposal_prs.department_name); string linkapp = string.Format("{0}://{1}{2}", Request.Url.Scheme, Request.Url.Authority, Url.Content("~/Account/Login?ReturnUrl=%2f")); string strImg = string.Format("http://{0}/Content/EmailImage/button_asmin.png", Request.Url.Authority); linkapp = string.Format(@"<a href={0}><img src=""{1}"" alt=""click for process""/></a>", linkapp, strImg); strBodyMail = strBodyMail.Replace("[link]", linkapp); ms_disposal_type suggestion = db.ms_disposal_type.Find(disposal_announcement.approval_disposal_type_id); strBodyMail = strBodyMail.Replace("[suggestion]", suggestion.disposal_type_name); sy_email_log.elog_body = strBodyMail; #endregion var EmailHelper = new EmailHelper() { ToAddress = sy_email_log.elog_to, CcAddress = sy_email_log.elog_cc, Email_Template = sy_email_log.elog_template, MailSubject = sy_email_log.elog_subject, MailBody = sy_email_log.elog_body }; EmailHelper.Send(); #endregion transaction.Commit(); ViewBag.ResultMessage = "Update table successfully."; return(RedirectToAction("Index")); } catch (Exception) { // roll back all database operations, if any thing goes wrong transaction.Rollback(); ViewBag.ResultMessage = "Error occured, records rolledback."; } } } return(View(disposal_prs)); }
public ActionResult Create([Bind(Include = "asset_id, asset_number,asset_name, location_id, location_name, department_name, request_description")] disposalViewModel disposal_req) { if (Request.Files.Count > 0) { var fileexist = Request.Files["asset_img_address"]; if (fileexist == null || fileexist.ContentLength == 0) { ModelState.AddModelError("asset_img_address", "Asset image is mandatory."); } } //input data request disposal with transaction if (ModelState.IsValid) { //Int32 z = Convert.ToInt32("a"); using (var transaction = db.Database.BeginTransaction()) { try { #region "Save Request Disposal" tr_disposal_request disposal_request = new tr_disposal_request(); disposal_request.disposal_number = DisposalNumberNew(disposal_req.asset_id); disposal_request.asset_id = disposal_req.asset_id; disposal_request.request_date = DateTime.Now; disposal_request.request_description = disposal_req.request_description; disposal_request.request_location_id = disposal_req.location_id; disposal_request.request_dept_id = UserProfile.department_id; disposal_request.request_emp_id = UserProfile.employee_id; disposal_request.request_status_id = 1; disposal_request.fl_active = true; disposal_request.created_date = DateTime.Now; disposal_request.created_by = UserProfile.UserId; disposal_request.updated_date = DateTime.Now; disposal_request.update_by = UserProfile.UserId; disposal_request.deleted_date = null; disposal_request.deleted_by = null; disposal_request.org_id = UserProfile.OrgId; disposal_request = db.tr_disposal_request.Add(disposal_request); db.SaveChanges(); //Save Approval Dept. Head var _qry = (from sa in db.sy_ref_approval_level where sa.asset_reg_location_id == disposal_req.location_id && sa.job_level_id == 2 join a in db.ms_job_level on sa.job_level_id equals a.job_level_id where (a.fl_active == true && a.deleted_date == null) join b in db.ms_employee_detail on a.job_level_id equals b.job_level_id where (b.fl_active == true && b.deleted_date == null && b.department_id == UserProfile.department_id && b.company_id == UserProfile.company_id) join c in db.ms_employee on b.employee_id equals c.employee_id where c.fl_active == true && c.deleted_date == null orderby sa.order_no ascending select new disposalViewModel() { department_id = b.department_id, employee_id = b.employee_id, job_level_id = a.job_level_id, employee_email = c.employee_email, employee_name = c.employee_name, ip_address = c.ip_address }).ToList <disposalViewModel>(); int count = 1; int approval_id = 0; if (_qry != null) { foreach (disposalViewModel refApproval in _qry) { tr_disposal_approval disposal_approval = new tr_disposal_approval(); disposal_approval.request_id = disposal_request.request_id; disposal_approval.approval_date = null; disposal_approval.approval_dept_id = refApproval.department_id; disposal_approval.approval_employee_id = refApproval.employee_id; disposal_approval.approval_level_id = refApproval.job_level_id; disposal_approval.approval_status_id = 1;//waiting approval disposal_approval.fl_active = true; disposal_approval.created_date = DateTime.Now; disposal_approval.created_by = UserProfile.UserId; disposal_approval.updated_date = DateTime.Now; disposal_approval.updated_by = UserProfile.UserId; disposal_approval.deleted_date = null; disposal_approval.deteled_by = null; disposal_approval.org_id = UserProfile.OrgId; disposal_approval = db.tr_disposal_approval.Add(disposal_approval); db.SaveChanges(); if (count == 1) { //untuk kebutuhan link email count++; approval_id = disposal_approval.approval_id; } } } //Save Approval Dept. Head var _qry_ktt = (from sa in db.sy_ref_approval_level where sa.asset_reg_location_id == disposal_req.location_id && sa.job_level_id == 3 join a in db.ms_job_level on sa.job_level_id equals a.job_level_id where (a.fl_active == true && a.deleted_date == null) join b in db.ms_employee_detail on a.job_level_id equals b.job_level_id where (b.fl_active == true && b.deleted_date == null && b.company_id == UserProfile.company_id) join c in db.ms_employee on b.employee_id equals c.employee_id where c.fl_active == true && c.deleted_date == null orderby sa.order_no ascending select new disposalViewModel() { department_id = b.department_id, employee_id = b.employee_id, job_level_id = a.job_level_id, employee_email = c.employee_email, employee_name = c.employee_name, ip_address = c.ip_address }).ToList <disposalViewModel>(); int count_ktt = 1; int approval_id_ktt = 0; if (_qry_ktt != null) { foreach (disposalViewModel refApproval in _qry_ktt) { tr_disposal_approval disposal_approval = new tr_disposal_approval(); disposal_approval.request_id = disposal_request.request_id; disposal_approval.approval_date = null; disposal_approval.approval_dept_id = refApproval.department_id; disposal_approval.approval_employee_id = refApproval.employee_id; disposal_approval.approval_level_id = refApproval.job_level_id; disposal_approval.approval_status_id = 1;//waiting approval disposal_approval.fl_active = true; disposal_approval.created_date = DateTime.Now; disposal_approval.created_by = UserProfile.UserId; disposal_approval.updated_date = DateTime.Now; disposal_approval.updated_by = UserProfile.UserId; disposal_approval.deleted_date = null; disposal_approval.deteled_by = null; disposal_approval.org_id = UserProfile.OrgId; disposal_approval = db.tr_disposal_approval.Add(disposal_approval); db.SaveChanges(); if (count_ktt == 1) { //untuk kebutuhan link email count_ktt++; approval_id_ktt = disposal_approval.approval_id; } } } //Approval BOD berdasarkan data ms_department >> employee_bod_id ms_department dept = db.ms_department.Find(UserProfile.department_id); if (dept != null) { tr_disposal_approval disposal_approval = new tr_disposal_approval(); disposal_approval.request_id = disposal_request.request_id; disposal_approval.approval_date = null; disposal_approval.approval_dept_id = dept.department_id; disposal_approval.approval_employee_id = dept.employee_bod_id; disposal_approval.approval_level_id = 9; disposal_approval.approval_status_id = 1;//waiting approval disposal_approval.fl_active = true; disposal_approval.created_date = DateTime.Now; disposal_approval.created_by = UserProfile.UserId; disposal_approval.updated_date = DateTime.Now; disposal_approval.updated_by = UserProfile.UserId; disposal_approval.deleted_date = null; disposal_approval.deteled_by = null; disposal_approval.org_id = UserProfile.OrgId; disposal_approval = db.tr_disposal_approval.Add(disposal_approval); db.SaveChanges(); } if (Request.Files.Count > 0) { //var file = Request.Files[0]; app_root_path = Server.MapPath("~/"); if (string.IsNullOrWhiteSpace(base_image_path)) { base_image_path = asset_registrationViewModel.path_file_disposal; } string img_path = Server.MapPath(base_image_path); if (!Directory.Exists(img_path)) { Directory.CreateDirectory(img_path); } var file = Request.Files["asset_img_address"]; if (file != null && file.ContentLength > 0) { var fileName = "asset" + disposal_req.asset_id.ToString() + "_" + Path.GetFileName(file.FileName); var path = Path.Combine(img_path, fileName); file.SaveAs(path); tr_disposal_image _ass_img = new tr_disposal_image() { request_id = disposal_request.request_id, asset_id = Convert.ToInt32(disposal_req.asset_id), asset_img_address = fileName, }; db.tr_disposal_image.Add(_ass_img); db.SaveChanges(); } } #endregion #region "kirim email ke approval level 1" sy_email_log sy_email_log = new sy_email_log(); sy_email_log.elog_to = _qry.FirstOrDefault().employee_email; sy_email_log.elog_subject = string.Format("Asset Disposal Need Approval"); sy_email_log.elog_template = "EMAIL_TEMPLATE_04"; var _bodymail = app_setting.APPLICATION_SETTING.Where(c => c.app_key.Contains("EMAIL_TEMPLATE_04")); string strBodyMail = _bodymail.FirstOrDefault().app_value; strBodyMail = strBodyMail.Replace("[to]", _qry.FirstOrDefault().employee_name); strBodyMail = strBodyMail.Replace("[action]", "Dispose"); strBodyMail = strBodyMail.Replace("[assetnumber]", disposal_req.asset_number); strBodyMail = strBodyMail.Replace("[aseetname]", disposal_req.asset_name); strBodyMail = strBodyMail.Replace("[assetlocation]", disposal_req.location_name); strBodyMail = strBodyMail.Replace("[department]", disposal_req.department_name); int empid = Convert.ToInt32(_qry.FirstOrDefault().employee_id); ms_user msuser = (from m in db.ms_user where m.employee_id == empid select m).FirstOrDefault(); //token untuk link approval di email string token = string.Format("DisposalApproval|Approval/{0}|{1}|{2}|{3}", approval_id, msuser.user_name, UserProfile.company_id, UserProfile.asset_reg_location_id); token = CryptorHelper.Encrypt(token, "MD5", true).Replace("+", "plus").Replace("=", "equal"); string linkapp = string.Format("{0}://{1}{2}", Request.Url.Scheme, Request.Url.Authority, Url.Content("~/Account/Login?ReturnUrl=%2f&token=" + token)); string strImg = string.Format("http://{0}/Content/EmailImage/button_approval_disposal.png", Request.Url.Authority); linkapp = string.Format(@"<a href={0}><img src=""{1}"" alt=""click for approval""/></a>", linkapp, strImg); strBodyMail = strBodyMail.Replace("[link]", linkapp); 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(); #endregion #region "Save Sy_Message_notification" sy_message_notification msg = new sy_message_notification(); msg.notif_group = "BALOON_RECEIPT_04"; msg.notify_user = msuser.user_name; msg.notify_ip = _qry.FirstOrDefault().ip_address; msg.notify_message = "Ada permintaan approval untuk Asset disposal."; msg.fl_active = true; msg.created_date = DateTime.Now; msg.created_by = UserProfile.UserId; msg.fl_shown = 0; db.sy_message_notification.Add(msg); db.SaveChanges(); #endregion transaction.Commit(); ViewBag.ResultMessage = "Record inserted into table successfully."; return(RedirectToAction("Index")); } catch (Exception ex) { // roll back all database operations, if any thing goes wrong transaction.Rollback(); string msgErr = string.Format("An unknown error has occurred , Please contact your system administrator. {0}", ex.Message); if (ex.InnerException != null) { msgErr += string.Format(" Inner Exception: {0}", ex.InnerException.Message); } ModelState.AddModelError("", msgErr); } } } return(View(disposal_req)); }