/// <summary>
/// Gets the CH request details.
/// </summary>
/// <param name="cardholderId">The cardholder id.</param>
/// <param name="SkipCount">The skip count.</param>
/// <param name="PageSize">Size of the page.</param>
/// <param name="RecordCount">The record count.</param>
/// <returns></returns>
/// <remarks></remarks>
public List <CH_Request_DtlDTO> getCHRequestDetails(long cardholderId, int SkipCount, int PageSize, ref int RecordCount)
{
try
{
List <CH_Request_DtlDTO> lst = new List <CH_Request_DtlDTO>();
BOBCardEntities _db = new BOBCardEntities();
var result = _db.getCHRequestDetails(cardholderId).ToList();
foreach (var item in result)
{
CH_Request_DtlDTO cH_Request_DtlDTO = new CH_Request_DtlDTO()
{
Request_Dtl_Id = item.Request_Dtl_Id,
Request_Dt = item.Request_Dt,
CardHolder_Id = item.CardHolder_Id,
RequestType_Id = item.RequestType_Id,
RequestType = item.RequestType_nm,
Remarks = item.Remarks,
RequestReason_Id = item.RequestReason_Id,
UID = item.UID,
Request_Status = item.Request_Status,
AdminRemarks = item.AdminRemarks
};
lst.Add(cH_Request_DtlDTO);
}
RecordCount = lst.Count();
lst = lst.Skip(SkipCount).Take(PageSize).ToList();
return(lst);
}
catch (Exception ex)
{
string str = ex.Message;
return(null);
}
}
/// <summary>
/// Mailfunctions the specified request DTL ID.
/// </summary>
/// <param name="RequestDtlID">The request DTL ID.</param>
/// <remarks></remarks>
private void Mailfunction(long RequestDtlID)
{
bool IsMailSent = false;
CHRequestDetailManager cdm = new CHRequestDetailManager();
CH_Request_DtlDTO chdto = new CH_Request_DtlDTO();
chdto = cdm.getRequestUID(RequestDtlID);
string RequestNumber = chdto.UID;
string CardHolderName = lblCardHolder.Text;
string Email = CardHolderManager.GetLoggedInUser().CH_Card.EMAIL_ID;
string BOBMail = ConfigurationManager.AppSettings["BOB_EMAIL"].ToString();
string EMAIL_Subject = ConfigurationManager.AppSettings["REQUEST_EMAIL_SUBJECT"].ToString();
string OverRideEmail = ConfigurationManager.AppSettings["OverRideUserEmail"];
long CardHolderId = CardHolderManager.GetLoggedInUser().CardHolder_Id;
if (!string.IsNullOrEmpty(OverRideEmail))
{
Email = OverRideEmail;
}
try
{
StringBuilder bodyString = new StringBuilder();
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.ATM_PIN_RegenerationTemplatepath));
bodyString.Replace("@@CardHolderName", CardHolderName);
bodyString.Replace("@@CreditCard", ddlcardlist.SelectedItem.Text);
// bodyString.Replace("@@Reason", ddlReasons.SelectedItem.Text);
//bodyString.Replace("@@Rupee", lblCharge.Text);
bodyString.Replace("@@ReqNum", RequestNumber);
bodyString.Replace("@@ImagePath", UrlHelper.GetAbsoluteUri() + "/images/mailer-banner.jpg");
List <string> CCemail = new List <string>();
IsMailSent = SendMailfunction.SendMail(BOBMail, new List <string>()
{
Email
}, CCemail, "", "", EMAIL_Subject, bodyString.ToString(), true, CardHolderId, null);
if (IsMailSent)
{
LblSuccessMessage.Text = "Your Request has been sent.";
DivSuccess.Attributes.CssStyle.Add("display", "block");
}
else
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
catch (Exception)
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
/// <summary>
/// Mailfunctions the specified request DTL ID.
/// </summary>
/// <param name="RequestDtlID">The request DTL ID.</param>
/// <remarks></remarks>
private void Mailfunction(long RequestDtlID)
{
string CardHolderName = CardHolderManager.GetLoggedInUser().CH_Card.Embossed_Name;
string Email = CardHolderManager.GetLoggedInUser().CH_Card.EMAIL_ID;
string BOBMail = ConfigurationManager.AppSettings["BOB_EMAIL"].ToString();
string EMAIL_Subject = ConfigurationManager.AppSettings["REQUEST_EMAIL_SUBJECT"].ToString();
CHRequestDetailManager cdm = new CHRequestDetailManager();
CH_Request_DtlDTO chdto = new CH_Request_DtlDTO();
chdto = cdm.getRequestUID(RequestDtlID);
string RequestNumber = chdto.UID;
string OverRideEmail = ConfigurationManager.AppSettings["OverRideUserEmail"];
if (!string.IsNullOrEmpty(OverRideEmail))
{
Email = OverRideEmail;
}
try
{
StringBuilder bodyString = new StringBuilder();
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.EMIRequestTemplatepath));
bodyString.Replace("@@CardHolderName", CardHolderName);
bodyString.Replace("@@Amount", hdnIntTot.Value);
bodyString.Replace("@@terms", ddlterms.SelectedItem.Text);
bodyString.Replace("@@Rate", txtInterest.Text);
bodyString.Replace("@@EMI", hdnEMI.Value);
bodyString.Replace("@@ReqNum", RequestNumber);
bodyString.Replace("@@ImagePath", UrlHelper.GetAbsoluteUri() + "/images/bob-logo.png");
List <string> CCemail = new List <string>();
long CardHolderId = CardHolderManager.GetLoggedInUser().CardHolder_Id;
bool IsMailSent = SendMailfunction.SendMail(BOBMail, new List <string>()
{
Email
}, CCemail, "", "", EMAIL_Subject, bodyString.ToString(), true, CardHolderId, null);
if (IsMailSent)
{
LblSuccessMessage.Text = "Your EMI Request for Unbilled transactions has been successfully registered";
DivSuccess.Attributes.CssStyle.Add("display", "block");
}
else
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
catch (Exception)
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
/// <summary>
/// Mailfunctions the specified request DTL ID.
/// </summary>
/// <param name="RequestDtlID">The request DTL ID.</param>
/// <remarks></remarks>
private void Mailfunction(long RequestDtlID)
{
string OtherCreditcardnumber = txtCRnum1.Text + txtCRnum2.Text + txtCRnum3.Text + txtCRnum4.Text;
string CardHolderName = lblCardHolder.Text;
string Email = CardHolderManager.GetLoggedInUser().CH_Card.EMAIL_ID;
string BOBMail = ConfigurationManager.AppSettings["BOB_EMAIL"].ToString();
string EMAIL_Subject = ConfigurationManager.AppSettings["REQUEST_EMAIL_SUBJECT"].ToString();
CHRequestDetailManager cdm = new CHRequestDetailManager();
CH_Request_DtlDTO chdto = new CH_Request_DtlDTO();
chdto = cdm.getRequestUID(RequestDtlID);
string RequestNumber = chdto.UID;
string OverRideEmail = ConfigurationManager.AppSettings["OverRideUserEmail"];
if (!string.IsNullOrEmpty(OverRideEmail))
{
Email = OverRideEmail;
}
try
{
StringBuilder bodyString = new StringBuilder();
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.BalanceTransferRequestTemplatepath));
bodyString.Replace("@@CardHolderName", CardHolderName);
bodyString.Replace("@@CreditCard", OtherCreditcardnumber);
bodyString.Replace("@@Bankname", ddlIssueBank.SelectedItem.Text);
bodyString.Replace("@@Amount", txtAmtTransfered.Text);
bodyString.Replace("@@ReqNum", RequestNumber);
bodyString.Replace("@@ImagePath", UrlHelper.GetAbsoluteUri() + "/images/mailer-banner.jpg");
List <string> CCemail = new List <string>();
long CardHolderId = CardHolderManager.GetLoggedInUser().CardHolder_Id;
bool IsMailSent = SendMailfunction.SendMail(BOBMail, new List <string>()
{
Email
}, CCemail, "", "", EMAIL_Subject, bodyString.ToString(), true, CardHolderId, null);
if (IsMailSent)
{
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('" + Constants.ErrorMailButRqstLogged + "');", true);
}
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('" + Constants.ErrorMailButRqstLogged + "');", true);
}
}
/// <summary>
/// Find Request By Primary Key Request_Dtl_Id
/// </summary>
/// <param name="Request_Dtl_Id">The request_ DTL_ id.</param>
/// <returns></returns>
/// <remarks></remarks>
public CH_Request_DtlDTO FindRequestDetail(long Request_Dtl_Id)
{
CH_Request_DtlDTO req_detail = repCH_Request_Dtl.Find(c => c.Request_Dtl_Id == Request_Dtl_Id).Select(
x => new CH_Request_DtlDTO()
{
Request_Dtl_Id = x.Request_Dtl_Id,
Request_Dt = x.Request_Dt,
CardHolder_Id = x.CardHolder_Id,
RequestType_Id = x.RequestType_Id,
IP_Address = x.IP_Address,
RequestReason_Id = x.RequestReason_Id,
Mode_Send_Statment = x.Mode_Send_Statment,
Statement_month = x.Statement_month,
Statement_year = x.Statement_year,
DOB = x.DOB,
Relation = x.Relation,
Gender = x.Gender,
Addon_Profile_Photo = x.Addon_Profile_Photo,
Payment_Type = x.Payment_Type,
Specific_Monthly_due = x.Specific_Monthly_due,
Points_Wants_Redeem = x.Points_Wants_Redeem,
Bank_nm = x.Bank_nm,
Transferred_Amt = x.Transferred_Amt,
Balance_Transferred_Plan = x.Balance_Transferred_Plan,
EMI_Principal_Amt = x.EMI_Principal_Amt,
EMI_Terms = x.EMI_Terms,
Remarks = x.Remarks,
Request_Status = x.Request_Status,
Add_On_Card_Applicant = x.Add_On_Card_Applicant,
EMI_Amount = x.EMI_Amount,
EMI_InterestRate = x.EMI_InterestRate,
OtherCreditCardNumber = x.OtherCreditCardNumber,
HotlistingCardNumber = x.HotlistingCardNumber,
Loan_Amount = x.Loan_Amount,
Loan_InterestRate = x.Loan_InterestRate,
Loan_Principal_Amt = x.Loan_Principal_Amt,
Loan_Terms = x.Loan_Terms,
Created_by = x.Created_by,
Created_dt = x.Created_dt,
Updated_by = x.Updated_by,
Updated_dt = x.Updated_dt,
UID = x.UID,
}
).Single();
return(req_detail);
}
/// <summary>
/// This method is used for getting International Limit amount
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public CH_Request_DtlDTO GetInternationalLimitAmount(long CardHolder_Id, long RequestTypeId, string HotlistingCardNumber)
{
BOBCardEntities _db = new BOBCardEntities();
var lst = _db.GetInternationalLimitAmount(CardHolder_Id, RequestTypeId, HotlistingCardNumber).FirstOrDefault();
if (lst != null)
{
CH_Request_DtlDTO result = new CH_Request_DtlDTO()
{
Loan_Principal_Amt = lst.Loan_Principal_Amt,
Request_Status = lst.Request_Status,
RequestFlag = lst.RequestFlag
};
return(result);
}
else
{
return(null);
}
}
/// <summary>
/// Mail functions used to send an email to the specified request DTL ID.
/// </summary>
/// <param name="RequestDtlID">The request DTL ID.</param>
/// <remarks></remarks>
private void Mailfunction(long RequestDtlID)
{
string mode = string.Empty;
string CardHolderName = lblCardHolder.Text;
string AccNum = CardHolderManager.GetLoggedInUser().CH_Card.Cr_Account_Nbr;
string Email = CardHolderManager.GetLoggedInUser().CH_Card.EMAIL_ID;
string FromDate = txtFromDate.Text;
string ToDate = txtToDate.Text;
CHRequestDetailManager cdm = new CHRequestDetailManager();
CH_Request_DtlDTO chdto = new CH_Request_DtlDTO();
chdto = cdm.getRequestUID(RequestDtlID);
string RequestNumber = chdto.UID;
string BOBMail = ConfigurationManager.AppSettings["BOB_EMAIL"].ToString();
string EMAIL_Subject = ConfigurationManager.AppSettings["REQUEST_EMAIL_SUBJECT"].ToString();
string OverRideEmail = ConfigurationManager.AppSettings["OverRideUserEmail"];
if (!string.IsNullOrEmpty(OverRideEmail))
{
Email = OverRideEmail;
}
if (chkMode.Items[0].Selected == true && chkMode.Items[1].Selected == true)
{
mode = chkMode.Items[0].Text.ToString() + " & " + chkMode.Items[1].Text.ToString();
}
else if (chkMode.Items[0].Selected == true && chkMode.Items[1].Selected == false)
{
mode = chkMode.Items[0].Text.ToString();
}
else if (chkMode.Items[0].Selected == false && chkMode.Items[1].Selected == true)
{
mode = chkMode.Items[1].Text.ToString();
}
try
{
StringBuilder bodyString = new StringBuilder();
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.StatementRequestTemplatepath));
bodyString.Replace("@@CardHolderName", CardHolderName);
bodyString.Replace("@@AccNum", AccNum);
bodyString.Replace("@@mode", mode);
bodyString.Replace("@@FromDate", FromDate);
bodyString.Replace("@@ToDate", ToDate);
bodyString.Replace("@@ReqNum", RequestNumber);
bodyString.Replace("@@ImagePath", UrlHelper.GetAbsoluteUri() + "/images/mailer-banner.jpg");
List <string> CCemail = new List <string>();
long CardHolderId = CardHolderManager.GetLoggedInUser().CardHolder_Id;
bool IsMailSent = SendMailfunction.SendMail(BOBMail, new List <string>()
{
Email
}, CCemail, "", "", EMAIL_Subject, bodyString.ToString(), true, CardHolderId, null);
if (IsMailSent)
{
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('" + Constants.ErrorMailButRqstLogged + "');", true);
}
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('" + Constants.ErrorMailButRqstLogged + "');", true);
}
}
/// <summary>
/// Mailfunctions the specified request DTL ID.
/// </summary>
/// <param name="RequestDtlID">The request DTL ID.</param>
/// <remarks></remarks>
private void Mailfunction(long RequestDtlID)
{
string CardHolderName = CardHolderManager.GetLoggedInUser().CH_Card.Embossed_Name;
string Email = CardHolderManager.GetLoggedInUser().CH_Card.EMAIL_ID;
string BOBMail = ConfigurationManager.AppSettings["BOB_EMAIL"].ToString();
string EMAIL_Subject = ConfigurationManager.AppSettings["REQUEST_EMAIL_SUBJECT"].ToString();
string strInterest = HttpContext.Current.Request.Form[txtInterest.UniqueID];
string strEMIMonths = HttpContext.Current.Request.Form[txttermInMonth.UniqueID];
if (string.IsNullOrEmpty(strInterest))
{
strInterest = txtInterest.Text;
}
if (string.IsNullOrEmpty(strInterest))
{
strEMIMonths = txttermInMonth.Text;
}
CHRequestDetailManager cdm = new CHRequestDetailManager();
CH_Request_DtlDTO chdto = new CH_Request_DtlDTO();
chdto = cdm.getRequestUID(RequestDtlID);
string RequestNumber = chdto.UID;
string OverRideEmail = ConfigurationManager.AppSettings["OverRideUserEmail"];
if (!string.IsNullOrEmpty(OverRideEmail))
{
Email = OverRideEmail;
}
try
{
StringBuilder bodyString = new StringBuilder();
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.LoanRequestTemplatepath));
bodyString.Replace("@@CardHolderName", CardHolderName);
bodyString.Replace("@@Amount", hdnIntTot.Value);
bodyString.Replace("@@terms", strEMIMonths);
bodyString.Replace("@@Rate", strInterest);
bodyString.Replace("@@EMI", hdnEMI.Value);
bodyString.Replace("@@ReqNum", RequestNumber);
bodyString.Replace("@@ImagePath", UrlHelper.GetAbsoluteUri() + "/images/mailer-banner.jpg");
List <string> CCemail = new List <string>();
long CardHolderId = CardHolderManager.GetLoggedInUser().CardHolder_Id;
bool IsMailSent = SendMailfunction.SendMail(BOBMail, new List <string>()
{
Email
}, CCemail, "", "", EMAIL_Subject, bodyString.ToString(), true, CardHolderId, null);
if (IsMailSent)
{
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('" + Constants.ErrorMailButRqstLogged + "');", true);
}
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('" + Constants.ErrorMailButRqstLogged + "');", true);
}
}
/// <summary>
/// Mailfunctions the specified request compliant DTL id.
/// </summary>
/// <param name="requestCompliantDtlId">The request compliant DTL id.</param>
/// <remarks></remarks>
private void Mailfunction(long requestCompliantDtlId)
{
var cdm = new CHRequestDetailManager();
var ChRequestDto = new CH_Request_DtlDTO();
var ccm = new CardHolderComplaintManager();
var ChComplaintDTO = new CH_Complaint_DtlDTO();
string EMAIL_Subject = string.Empty;
string CardHolderName = lblCardHolder.Text;
string Email = CardHolderManager.GetLoggedInUser().CH_Card.EMAIL_ID;
string RequestComplType = ddlAppropRequestComplaint.SelectedItem.Text;
string RequestComplaintDtl = txtremarks.Text;
string BOBMail = ConfigurationManager.AppSettings["BOB_EMAIL"];
// long cardHolderID = CardHolderManager.GetLoggedInUser().CardHolder_Id;
string OverRideEmail = ConfigurationManager.AppSettings["OverRideUserEmail"];
if (!string.IsNullOrEmpty(OverRideEmail))
{
Email = OverRideEmail;
}
try
{
var bodyString = new StringBuilder();
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.OtherReqComplTemplatepath));
if (RadioRequestComplaint.SelectedValue == "1")
{
ChComplaintDTO = ccm.getComplaintUID(requestCompliantDtlId);
string ComplaintNumber = ChComplaintDTO.UID;
bodyString.Replace("Request Type", "Complaint Type");
//bodyString.Replace("Request Details", "Complaint Details");
bodyString.Replace("@@reqcom", "Complaint");
bodyString.Replace("@@ReqNum", ComplaintNumber);
EMAIL_Subject = ConfigurationManager.AppSettings["COMPLAINT_EMAIL_SUBJECT"].ToString();
}
else
{
ChRequestDto = cdm.getRequestUID(requestCompliantDtlId);
string RequestNumber = ChRequestDto.UID;
bodyString.Replace("@@reqcom", "Request");
bodyString.Replace("@@ReqNum", RequestNumber);
EMAIL_Subject = ConfigurationManager.AppSettings["REQUEST_EMAIL_SUBJECT"].ToString();
}
bodyString.Replace("@@CardHolderName", CardHolderName);
bodyString.Replace("@@Creditcard", lblCreditCardNumber.Text);
bodyString.Replace("@@RequestType", RequestComplType);
bodyString.Replace("@@RequestDetails", RequestComplaintDtl);
bodyString.Replace("@@ImagePath", UrlHelper.GetAbsoluteUri() + "/images/mailer-banner.jpg");
var CCemail = new List <string>();
long CardHolderId = CardHolderManager.GetLoggedInUser().CardHolder_Id;
bool IsMailSent = SendMailfunction.SendMail(BOBMail, new List <string>()
{
Email
}, CCemail, "", "", EMAIL_Subject, bodyString.ToString(), true, CardHolderId, null);
if (IsMailSent)
{
LblSuccessMessage.Text = "Your Request/Complaint has been successfully registered";
DivSuccess.Attributes.CssStyle.Add("display", "block");
}
else
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
catch (Exception)
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
/// <summary>
/// Mailfunctions the specified request DTL ID.
/// </summary>
/// <param name="RequestDtlID">The request DTL ID.</param>
/// <remarks></remarks>
private void Mailfunction(long RequestDtlID)
{
string CardHolderName = lblCardHolder.Text;
string Email = CardHolderManager.GetLoggedInUser().CH_Card.EMAIL_ID;
string BOBMail = ConfigurationManager.AppSettings["BOB_EMAIL"].ToString();
string EMAIL_Subject = ConfigurationManager.AppSettings["REQUEST_EMAIL_SUBJECT"].ToString();
string OverRideEmail = ConfigurationManager.AppSettings["OverRideUserEmail"];
if (!string.IsNullOrEmpty(OverRideEmail))
{
Email = OverRideEmail;
}
CHRequestDetailManager cdm = new CHRequestDetailManager();
CH_Request_DtlDTO chdto = new CH_Request_DtlDTO();
chdto = cdm.getRequestUID(RequestDtlID);
string RequestNumber = chdto.UID;
try
{
StringBuilder bodyString = new StringBuilder();
if (ddlRequestService.SelectedItem.Text == @"Request/Renewal")
{
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.CreditCardReplacementRenewalTemplatepath));
}
else if (ddlRequestService.SelectedItem.Text == "De-Register Credit Card")
{
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.DeRegisterCreditCardTemplatepath));
}
else if (ddlRequestService.SelectedItem.Text == "Request for Add-On card")
{
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.AddonRequestTemplatepath));
}
bodyString.Replace("@@CardHolderName", CardHolderName);
bodyString.Replace("@@CreditCard", ddlcardlist.SelectedItem.Text);
bodyString.Replace("@@RepRen", ddlRequestService.SelectedItem.Text);
if (ddlReasons.SelectedItem != null)
{
bodyString.Replace("@@Reason", ddlReasons.SelectedItem.Text);
}
bodyString.Replace("@@ReqNum", RequestNumber);
bodyString.Replace("@@ImagePath", UrlHelper.GetAbsoluteUri() + "/images/bob-logo.png");
List <string> CCemail = new List <string>();
long CardHolderId = CardHolderManager.GetLoggedInUser().CardHolder_Id;
bool IsMailSent = SendMailfunction.SendMail(BOBMail, new List <string>()
{
Email
}, CCemail, "", "", EMAIL_Subject, bodyString.ToString(), true, CardHolderId, null);
if (IsMailSent)
{
LblSuccessMessage.Text = string.Format("Credit Card {0} Request has been sent", ddlRequestService.SelectedItem.Text);
DivSuccess.Attributes.CssStyle.Add("display", "block");
}
else
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
catch (Exception ex)
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
public static string ProcessTemplate(object CommandArgument)
{
string detail = "";
///STEP 1 Split Details & Fetch Request Detail
string[] p = Convert.ToString(CommandArgument).Split(';');
long req_dlt_id = Convert.ToInt64(p[0]);
CHRequestDetailManager cdm = new CHRequestDetailManager();
CH_Request_DtlDTO request_dlt = cdm.FindRequestDetail(req_dlt_id);
if (string.IsNullOrEmpty(p[5]))
{
p[5] = "No Remark";
}
///STEP 2 Get Card Details Using Card Holder
//long created_by = request_dlt.Created_by;
//CardHolderManager chm = new CardHolderManager();
//CardHolder_MstDTO ch = chm.getUserByID(created_by);
//CardManager cm = new CardManager();
//CH_CardDTO card = cm.GetCardByCreditCardNumber(new CH_CardDTO()
//{
// card_number = ch.creditcard_acc_number
//});
//detail += GetRowTemplate("Name of Card-Holder", card.Embossed_Name);
//detail += GetRowTemplate("Card Number", card.card_number);
//detail += GetRowTemplate("Credit Account Number", card.Cr_Account_Nbr);
detail += GetRowTemplate("Request Date", GeneralMethods.FormatDate(Convert.ToDateTime(p[1]))); //.ToString("dd/MM/yyyy"));
detail += GetRowTemplate("Request Number", p[2]);
detail += GetRowTemplate("RequestType Name", p[3]);
detail += GetRowTemplate("Request Status", p[4]);
///STEP 3 Load Fields As Per
string request_type = p[3];
XElement root = XDocument.Load(AppDomain.CurrentDomain.BaseDirectory + "Filters\\CH-Request.xml").Root;
var request = from x in root.Descendants("Request") where x.Attribute("type").Value == request_type select x;
var fields = from y in request.Descendants("field")
select new Field()
{
Text = y.Attribute("Text").Value,
Value = y.Value,
};
///STEP 4 Convert To DataDictionary & Compare
Dictionary <string, string> FD = (from x in request_dlt.GetType().GetProperties() select x).ToDictionary(x => x.Name, x => (x.GetGetMethod().Invoke(request_dlt, null) == null ? "" : x.GetGetMethod().Invoke(request_dlt, null).ToString()));
foreach (var field in fields)
{
detail += ProcessSwitch(FD, field);
}
detail += GetRowTemplate("Your Remark", p[5]);
if (!string.IsNullOrEmpty(p[4]) && p[4].ToLower() == "pending")
{
detail += GetRowTemplate("Back-Office's Remark", "No Remark");
}
else if (!string.IsNullOrEmpty(p[4]) && p[4].ToLower() == "Approved")
{
detail += GetRowTemplate("Back-Office's Remark", p[6]);
}
else if (!string.IsNullOrEmpty(p[4]) && p[4].ToLower() == "Rejected")
{
detail += GetRowTemplate("Back-Office's Remark", p[6]);
}
else
{
detail += GetRowTemplate("Back-Office's Remark", p[6]);
}
return(detail);
}
/// <summary>
/// Saves the request detail.
/// </summary>
/// <param name="objRequest_DltDTO">The obj request_ DLT DTO.</param>
/// <returns></returns>
/// <remarks></remarks>
//Commented by abhijeet on 24/01/2019 for performance
/*
* public long SaveRequestDetail(CH_Request_DtlDTO objRequest_DltDTO)
* {
* CH_Request_Dtl obj = repCH_Request_Dtl.SingleOrDefault(c => c.Request_Dtl_Id == objRequest_DltDTO.Request_Dtl_Id);
*
*
* if (obj == null || obj.Request_Dtl_Id != objRequest_DltDTO.Request_Dtl_Id)
* {
* obj = new CH_Request_Dtl();
* }
*
* obj.Request_Dt = objRequest_DltDTO.Request_Dt;
* obj.CardHolder_Id = objRequest_DltDTO.CardHolder_Id;
* obj.RequestType_Id = objRequest_DltDTO.RequestType_Id;
* obj.IP_Address = objRequest_DltDTO.IP_Address;
* obj.RequestReason_Id = objRequest_DltDTO.RequestReason_Id;
* obj.Mode_Send_Statment = objRequest_DltDTO.Mode_Send_Statment;
* obj.Statement_month = objRequest_DltDTO.Statement_month;
* obj.Statement_year = objRequest_DltDTO.Statement_year;
* obj.DOB = objRequest_DltDTO.DOB;
* obj.Relation = objRequest_DltDTO.Relation;
* obj.Gender = objRequest_DltDTO.Gender;
* obj.Addon_Profile_Photo = objRequest_DltDTO.Addon_Profile_Photo;
* obj.Payment_Type = objRequest_DltDTO.Payment_Type;
* obj.Specific_Monthly_due = objRequest_DltDTO.Specific_Monthly_due;
* obj.Points_Wants_Redeem = objRequest_DltDTO.Points_Wants_Redeem;
* obj.Bank_nm = objRequest_DltDTO.Bank_nm;
* obj.Transferred_Amt = objRequest_DltDTO.Transferred_Amt;
* obj.Balance_Transferred_Plan = objRequest_DltDTO.Balance_Transferred_Plan;
* obj.EMI_Principal_Amt = objRequest_DltDTO.EMI_Principal_Amt;
* obj.EMI_Terms = objRequest_DltDTO.EMI_Terms;
* obj.Remarks = objRequest_DltDTO.Remarks;
* obj.Request_Status = objRequest_DltDTO.Request_Status;
* obj.Add_On_Card_Applicant = objRequest_DltDTO.Add_On_Card_Applicant;
* obj.EMI_Amount = objRequest_DltDTO.EMI_Amount;
* obj.EMI_InterestRate = objRequest_DltDTO.EMI_InterestRate;
* obj.OtherCreditCardNumber = objRequest_DltDTO.OtherCreditCardNumber;
* obj.HotlistingCardNumber = objRequest_DltDTO.HotlistingCardNumber;
* obj.Loan_Amount = objRequest_DltDTO.Loan_Amount;
* obj.Loan_InterestRate = objRequest_DltDTO.Loan_InterestRate;
* obj.Loan_Principal_Amt = objRequest_DltDTO.Loan_Principal_Amt;
* obj.Loan_Terms = objRequest_DltDTO.Loan_Terms;
*
* if (obj.Request_Dtl_Id == 0)
* {
* obj.Created_by = objRequest_DltDTO.Created_by;
* obj.Created_dt = objRequest_DltDTO.Created_dt;
* obj.UID = objRequest_DltDTO.Created_dt.ToString("yyyyMMddHHmmssffff");
* }
*
* obj.Updated_by = objRequest_DltDTO.Updated_by;
* obj.Updated_dt = objRequest_DltDTO.Updated_dt;
*
* if (obj.Request_Dtl_Id == 0)
* {
* repCH_Request_Dtl.Add(obj);
* }
*
*
* GeneralManager.Commit();
*
* return obj.Request_Dtl_Id;
*
* }
*/
public long SaveRequestDetail(CH_Request_DtlDTO objRequest_DltDTO)
{
//commented and rewritten by abhijeet on 22/08/2019 for doing Add and Update in same SP
/*if (objRequest_DltDTO.Request_Dtl_Id == 0)
* {*/
BOBCardEntities _db = new BOBCardEntities();
var requestDtl = _db.saveRequestDtl(
objRequest_DltDTO.Request_Dtl_Id,
objRequest_DltDTO.Request_Dt,
objRequest_DltDTO.CardHolder_Id,
objRequest_DltDTO.RequestType_Id,
objRequest_DltDTO.RequestReason_Id,
objRequest_DltDTO.Mode_Send_Statment,
objRequest_DltDTO.DOB,
objRequest_DltDTO.Relation,
objRequest_DltDTO.Gender,
objRequest_DltDTO.Addon_Profile_Photo,
objRequest_DltDTO.Payment_Type,
objRequest_DltDTO.Specific_Monthly_due,
objRequest_DltDTO.Points_Wants_Redeem,
objRequest_DltDTO.Bank_nm,
objRequest_DltDTO.Transferred_Amt,
objRequest_DltDTO.Balance_Transferred_Plan,
objRequest_DltDTO.EMI_Principal_Amt,
objRequest_DltDTO.EMI_Terms,
objRequest_DltDTO.EMI_InterestRate,
objRequest_DltDTO.EMI_Amount,
objRequest_DltDTO.Remarks,
objRequest_DltDTO.Request_Status,
objRequest_DltDTO.Created_by,
objRequest_DltDTO.Created_dt,
objRequest_DltDTO.Updated_by,
objRequest_DltDTO.Updated_dt,
objRequest_DltDTO.IP_Address,
objRequest_DltDTO.Statement_month,
objRequest_DltDTO.Statement_year,
objRequest_DltDTO.Add_On_Card_Applicant,
objRequest_DltDTO.OtherCreditCardNumber,
objRequest_DltDTO.HotlistingCardNumber,
null,
null,
objRequest_DltDTO.Created_dt.ToString("yyyyMMddHHmmssffff"),
objRequest_DltDTO.AdminRemarks,
null,
null,
null,
objRequest_DltDTO.Loan_Terms,
objRequest_DltDTO.Loan_InterestRate,
objRequest_DltDTO.Loan_Amount,
objRequest_DltDTO.Loan_Principal_Amt,
objRequest_DltDTO.RequestFlag,
objRequest_DltDTO.request_Microfilm_Ref_NumberParameter).ToList();
return((long)requestDtl[0]);
/*}
* else
* {
* CH_Request_Dtl obj = repCH_Request_Dtl.SingleOrDefault(c => c.Request_Dtl_Id == objRequest_DltDTO.Request_Dtl_Id);
*
*
* if (obj == null || obj.Request_Dtl_Id != objRequest_DltDTO.Request_Dtl_Id)
* {
* obj = new CH_Request_Dtl();
* }
*
* obj.Request_Dt = objRequest_DltDTO.Request_Dt;
* obj.CardHolder_Id = objRequest_DltDTO.CardHolder_Id;
* obj.RequestType_Id = objRequest_DltDTO.RequestType_Id;
* obj.IP_Address = objRequest_DltDTO.IP_Address;
* obj.RequestReason_Id = objRequest_DltDTO.RequestReason_Id;
* obj.Mode_Send_Statment = objRequest_DltDTO.Mode_Send_Statment;
* obj.Statement_month = objRequest_DltDTO.Statement_month;
* obj.Statement_year = objRequest_DltDTO.Statement_year;
* obj.DOB = objRequest_DltDTO.DOB;
* obj.Relation = objRequest_DltDTO.Relation;
* obj.Gender = objRequest_DltDTO.Gender;
* obj.Addon_Profile_Photo = objRequest_DltDTO.Addon_Profile_Photo;
* obj.Payment_Type = objRequest_DltDTO.Payment_Type;
* obj.Specific_Monthly_due = objRequest_DltDTO.Specific_Monthly_due;
* obj.Points_Wants_Redeem = objRequest_DltDTO.Points_Wants_Redeem;
* obj.Bank_nm = objRequest_DltDTO.Bank_nm;
* obj.Transferred_Amt = objRequest_DltDTO.Transferred_Amt;
* obj.Balance_Transferred_Plan = objRequest_DltDTO.Balance_Transferred_Plan;
* obj.EMI_Principal_Amt = objRequest_DltDTO.EMI_Principal_Amt;
* obj.EMI_Terms = objRequest_DltDTO.EMI_Terms;
* obj.Remarks = objRequest_DltDTO.Remarks;
* obj.Request_Status = objRequest_DltDTO.Request_Status;
* obj.Add_On_Card_Applicant = objRequest_DltDTO.Add_On_Card_Applicant;
* obj.EMI_Amount = objRequest_DltDTO.EMI_Amount;
* obj.EMI_InterestRate = objRequest_DltDTO.EMI_InterestRate;
* obj.OtherCreditCardNumber = objRequest_DltDTO.OtherCreditCardNumber;
* obj.HotlistingCardNumber = objRequest_DltDTO.HotlistingCardNumber;
* obj.Loan_Amount = objRequest_DltDTO.Loan_Amount;
* obj.Loan_InterestRate = objRequest_DltDTO.Loan_InterestRate;
* obj.Loan_Principal_Amt = objRequest_DltDTO.Loan_Principal_Amt;
* obj.Loan_Terms = objRequest_DltDTO.Loan_Terms;
* obj.RequestFlag = objRequest_DltDTO.RequestFlag;
*
* if (obj.Request_Dtl_Id == 0)
* {
* obj.Created_by = objRequest_DltDTO.Created_by;
* obj.Created_dt = objRequest_DltDTO.Created_dt;
* obj.UID = objRequest_DltDTO.Created_dt.ToString("yyyyMMddHHmmssffff");
* }
*
* obj.Updated_by = objRequest_DltDTO.Updated_by;
* obj.Updated_dt = objRequest_DltDTO.Updated_dt;
*
* if (obj.Request_Dtl_Id == 0)
* {
* repCH_Request_Dtl.Add(obj);
* }
*
*
* GeneralManager.Commit();
*
* return obj.Request_Dtl_Id;
*
* }*/
}
