public void sendMailApproval(DataTable dtReceiver, string htmlstringtable, string loi_status, string executorname, int requestid, string ApproverRole)
{
try
{
StringBuilder sbResult = new StringBuilder();
string emailsubject = string.Empty;
string fullname = dtReceiver.Rows[0]["Name"].ToString();
string email = dtReceiver.Rows[0]["Email"].ToString();
string paramapproveinemail = string.Concat("true;", requestid.ToString(), ";", ApproverRole, ";", dtReceiver.Rows[0]["USR_ID"].ToString());
string paramrejectinemail = string.Concat("false;", requestid.ToString(), ";", ApproverRole, ";", dtReceiver.Rows[0]["USR_ID"].ToString());
paramapproveinemail = EnDecController.EncryptLinkUrlApproval(paramapproveinemail);
paramrejectinemail = EnDecController.EncryptLinkUrlApproval(paramrejectinemail);
DataTable dtEmail = loi_get_email_data(loi_status, requestid);
DataTable dtDocumentAvailibility = loi_supportingdoc_getall(requestid);
string HtmlTableSupportingDocAvailibility = CreateHtmlTableSupportingDocAvailibility(dtDocumentAvailibility);
if (dtEmail.Rows.Count > 0)
{
emailsubject = dtEmail.Select("config_key like '%subject%'")[0].ItemArray[1].ToString();
string emailbody = dtEmail.Select("config_key like '%body%'")[0].ItemArray[1].ToString();
emailbody = emailbody.Replace("[name]", fullname).Replace("[sourcename]", executorname);
emailbody = emailbody.Replace("[tabledetail]", htmlstringtable);
emailbody = emailbody.Replace("[param approve]", paramapproveinemail);
emailbody = emailbody.Replace("[param reject]", paramrejectinemail);
emailbody = emailbody.Replace("[document_avilibility]", HtmlTableSupportingDocAvailibility);
sbResult.Append(emailbody);
MailController.SendMail(email, emailsubject, sbResult.ToString(), GeneralConfig.MailConfigType());
}
}
catch (Exception ex)
{
EBOQ_Lib_New.DAL.DAL_AppLog.ErrLogInsert("LOIController:SendEmail", ex.Message, "NON-SP");
}
}
public bool ebastusers_loi_iud(string USRType, string Name, int USRRole, string USRLogin, string Email, string PhoneNo, string SignTitle, string CTName, string USR_ID, bool isDelete)
{
string usrPassword = getrandomtext();
usrPassword = EnDecController.newhaspassword(usrPassword); //EnDecController.EncryptLinkUrlApproval(usrPassword);
return(da.ebastusers_loi_iud(USRType, Name, USRRole, USRLogin, Email, PhoneNo, SignTitle, CTName, usrPassword, USR_ID, isDelete));
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('LOI has been Approved Successfully');window.open('../autoclose.html')", true);
string param = Request.QueryString["param"];
param = EnDecController.DecryptLinkUrlApproval(param);
string[] paramarr = param.Split(';');
bool isApprove = bool.Parse(paramarr[0]);
int RequestId = int.Parse(paramarr[1]);
string ApproverRole = paramarr[2];
hdapproverrole.Value = ApproverRole;
hdnReqID.Value = RequestId.ToString();
HttpContext.Current.Session[Resources.Resources.ses_userid] = int.Parse(paramarr[3]);
if (loiControllerr.checking_linkapproval_validity(RequestId))
{
if (isApprove)
{
if (loiControllerr.LOI_Update_Approval_Status(RequestId, true, ApproverRole, ""))
{
try
{
string nextApproval = loiControllerr.get_nextApproverRole_byApproverRole(ApproverRole);
SendEmail(RequestId, nextApproval);
}
catch (Exception ex)
{
}
finally
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('LOI has been Approved Successfully'); window.close();", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Failed to Approved LOI'); window.close();", true);
}
}
else
{
pnlRejection.Visible = true;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('The URL is no longer valid'); window.close();", true);
}
}
catch (Exception ex)
{
}
}
public bool reset_password_all_ct(int USR_ID, string USRPassword, string CTName)
{
USRPassword = EnDecController.newhaspassword(USRPassword);
return(da.reset_password_all_ct(USR_ID, USRPassword, CTName));
}
public bool ebastusers_changepassword(string usr_login, string oldPassword, string newPassword)
{
oldPassword = EnDecController.newhaspassword(oldPassword); //EnDecController.EncryptLinkUrlApproval(oldPassword);
newPassword = EnDecController.newhaspassword(newPassword); //EnDecController.EncryptLinkUrlApproval(newPassword);
return(da.ebastusers_changepassword(usr_login, oldPassword, newPassword));
}
