/// <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; * * }*/ }