private void SendEmail(ProposalFeesApprovalModel model, bool status) { try { string currentUrl = Request.Url.AbsoluteUri; Common.Log.ServicLog(currentUrl.ToString()); var response = homeApiController.GetCompanyNoBySiteUrl(currentUrl); int CompanyNo = response.Data[0]; CompanyDetailForEmailEntity objCompany = CommonFunction.CompanyDetailForEmail(CompanyNo); string subject = "Proposal Fees Request Status " + Convert.ToString(model.orderno) + "-" + Convert.ToString(model.part); string body = string.Empty; using (System.IO.StreamReader reader = new System.IO.StreamReader(AppDomain.CurrentDomain.BaseDirectory + "/MailTemplate/ProposalFeesReply.html")) { body = reader.ReadToEnd(); } if (status) { body = body.Replace("{STATUS}", "APPROVED"); } else { body = body.Replace("{STATUS}", "NOT APPROVED"); } body = body.Replace("{UserName}", model.accExecutiveName); body = body.Replace("{ORDERNO}", model.orderno); body = body.Replace("{PARTNO}", model.part); body = body.Replace("{LOCATION}", model.location); body = body.Replace("{PAGES}", model.pages); body = body.Replace("{COST}", model.amount); body = body.Replace("{LogoURL}", objCompany.Logopath); body = body.Replace("{ThankYou}", objCompany.ThankYouMessage); body = body.Replace("{CompanyName}", objCompany.CompName); body = body.Replace("{Link}", objCompany.SiteURL); EmailHelper.Email.Send(CompanyNo: objCompany.CompNo , mailTo: model.accExecutiveEmail , body: body , subject: subject , ccMail: "" , bccMail: "[email protected],[email protected]"); var feeStatus = status ? 1 : 2; SqlParameter[] sqlparam = { new SqlParameter("ProposalFeesID", (object)model.proposalFeesID ?? (object)DBNull.Value), new SqlParameter("FeesStatus", (object)feeStatus ?? (object)DBNull.Value), new SqlParameter("Comments", (object)model.comment ?? (object)DBNull.Value) }; _repository.ExecuteSQL <int>("UpdateProposalFeeApproval", sqlparam).FirstOrDefault(); } catch (Exception ex) { Common.Log.ServicLog("2"); Common.Log.ServicLog(ex.ToString()); } }
public ActionResult UpdateProposalFeeApproval(ProposalFeesApprovalModel model) { try { string currentUrl = Request.Url.AbsoluteUri; var response = homeApiController.GetCompanyNoBySiteUrl(currentUrl); int CompanyNo = response.Data[0]; CompanyDetailForEmailEntity objCompany = CommonFunction.CompanyDetailForEmail(CompanyNo); string subject = "Proposal Fees Request Status - Edit Scope " + Convert.ToString(model.orderno) + "-" + Convert.ToString(model.part); string body = string.Empty; using (System.IO.StreamReader reader = new System.IO.StreamReader(AppDomain.CurrentDomain.BaseDirectory + "/MailTemplate/ProposalFeesReplyEditScope.html")) { body = reader.ReadToEnd(); } body = body.Replace("{UserName}", model.accExecutiveName); body = body.Replace("{ORDERNO}", model.orderno); body = body.Replace("{LOCATION}", model.location); body = body.Replace("{PAGES}", model.pages); body = body.Replace("{COST}", model.amount); body = body.Replace("{EDITEDPAGES}", model.Newpages); body = body.Replace("{EDITEDCOST}", model.Newamount); body = body.Replace("{COMMENTS}", model.comment); body = body.Replace("{LogoURL}", objCompany.Logopath); body = body.Replace("{ThankYou}", objCompany.ThankYouMessage); body = body.Replace("{CompanyName}", objCompany.CompName); body = body.Replace("{Link}", objCompany.SiteURL); EmailHelper.Email.Send(CompanyNo: objCompany.CompNo , mailTo: model.accExecutiveEmail , body: body , subject: subject , ccMail: "" , bccMail: "[email protected],[email protected]"); SqlParameter[] saveparam = { new SqlParameter("ProposalFeesID", (object)model.proposalFeesID ?? (object)DBNull.Value), new SqlParameter("FeesStatus", (object)3 ?? (object)DBNull.Value), new SqlParameter("Comments", (object)model.comment ?? (object)DBNull.Value) }; var proposalId = _repository.ExecuteSQL <int>("UpdateProposalFeeApproval", saveparam).FirstOrDefault(); if (proposalId > 0) { model.isUpdated = true; } model.CompanyNo = objCompany.CompNo.ToString(); model.CompanyName = objCompany.CompName; model.LogoPath = objCompany.Logopath; } catch (Exception ex) { Common.Log.ServicLog(ex.ToString()); } return(View("~/Views/Home/ProposalFeeApproval.cshtml", model)); }
public ActionResult ProposalFeeApproval(string type, string value) { var model = new ProposalFeesApprovalModel(); try { if (!string.IsNullOrEmpty(value)) { string[] querystring = HttpUtility.UrlDecode(EncryptDecrypt.Decrypt(Convert.ToString(value))).Split(','); try { model.accExecutiveEmail = Convert.ToString(querystring[0]); model.accExecutiveName = Convert.ToString(querystring[1]); model.orderno = Convert.ToString(querystring[2]); model.location = Convert.ToString(querystring[3]); model.pages = Convert.ToString(querystring[4]); model.amount = Convert.ToString(querystring[5]); model.proposalFeesID = Convert.ToString(querystring[6]); model.part = Convert.ToString(querystring[7]); model.Newamount = model.amount; model.Newpages = model.pages; model.operation = HttpUtility.UrlDecode(EncryptDecrypt.Decrypt(type)).ToString().ToLower(); model.isUpdated = false; model.CompanyNo = Convert.ToString(querystring[8]); model.CompanyName = Convert.ToString(querystring[9]); model.LogoPath = Convert.ToString(querystring[10]); } catch (Exception ex) { } if (!string.IsNullOrEmpty(type)) { if (model.operation == "a") { SendEmail(model, true); } else if (model.operation == "n") { SendEmail(model, false); } } } } catch (Exception ex) { Common.Log.ServicLog("--------- 1 ----------"); Common.Log.ServicLog(ex.ToString()); } return(View(model)); }