//public IRepository<CH_Sessions_Dtl> repCHSessionDtl
//{
// get
// {
// return ObjectFactory.GetInstance<IRepository<CH_Sessions_Dtl>>();
// }
//}
/// <summary>
/// Updates the card holder.
/// </summary>
/// <param name="userDTO">The user DTO.</param>
/// <returns></returns>
/// <remarks></remarks>
public string UpdateCardHolder(CardHolder_MstDTO userDTO)
{
try
{
//commented by Avani on 21-08-2019
//IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork);
//CardHolder_Mst user = repCardHolder_Mst.SingleOrDefault(u => u.CardHolder_Id == userDTO.CardHolder_Id);
//user.User_pwd = userDTO.User_pwd;
//user.Local_IpAddress = Convert.ToString(localAddress);
//user.Updated_by = CardHolderManager.GetLoggedInUser().CardHolder_Id;
//user.Updated_dt = DateTime.Now;
//GeneralManager.Commit();
//return "0";
/***/
// Added by Avani on 21-08-2019
BOBCardEntities _db = new BOBCardEntities();
IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork);
_db.UpdateCardHolderPasswordDetail(userDTO.CardHolder_Id, userDTO.User_pwd, localAddress.ToString(), CardHolderManager.GetLoggedInUser().CardHolder_Id, DateTime.Now);
return("0");
}
catch (Exception exp)
{
return(Constants.GeneralErrorMessage);
}
}
/// <summary>
/// Saves the card holder login info.
/// </summary>
/// <param name="objCardHolderLogin_InfoDTO">The obj card holder login_ info DTO.</param>
/// <returns></returns>
/// <remarks></remarks>
public long SaveCardHolderLoginInfo(CardHolderLogin_InfoDTO objCardHolderLogin_InfoDTO)
{
//commented by abhijeet 22/08/2019
//CardHolderLogin_Info obj = repCardHolderLogin_Info.SingleOrDefault(c => c.CardHolderLog_InfoId == objCardHolderLogin_InfoDTO.CardHolderLog_InfoId);
//if (obj == null || obj.CardHolderLog_InfoId != objCardHolderLogin_InfoDTO.CardHolderLog_InfoId)
//{
// obj = new CardHolderLogin_Info();
//}
//obj.CardHolder_Id = objCardHolderLogin_InfoDTO.CardHolder_Id;
//obj.Login_Attempts = objCardHolderLogin_InfoDTO.Login_Attempts;
//obj.Login_Attempt_FirstDt = objCardHolderLogin_InfoDTO.Login_Attempt_FirstDt;
//obj.Login_Attempt_SecondDt = objCardHolderLogin_InfoDTO.Login_Attempt_SecondDt;
//obj.Login_Attempt_ThirdDt = objCardHolderLogin_InfoDTO.Login_Attempt_ThirdDt;
//obj.IP_Address = objCardHolderLogin_InfoDTO.IP_Address;
//if (obj.CardHolderLog_InfoId == 0)
//{
// repCardHolderLogin_Info.Add(obj);
//}
//GeneralManager.Commit();
//return objCardHolderLogin_InfoDTO.CardHolderLog_InfoId;
BOBCardEntities _db = new BOBCardEntities();
_db.save_CardHolderLogin_Info(objCardHolderLogin_InfoDTO.CardHolder_Id, objCardHolderLogin_InfoDTO.Login_Attempts,
objCardHolderLogin_InfoDTO.Login_Attempt_FirstDt, objCardHolderLogin_InfoDTO.Login_Attempt_SecondDt,
objCardHolderLogin_InfoDTO.Login_Attempt_ThirdDt, objCardHolderLogin_InfoDTO.IP_Address);
return(0);
}
/// <summary>
/// get total count of pending request based on cardholderid and requesttypeid
/// </summary>
/// <param name="CardHolder_Id"></param>
/// <param name="RequestTypeId"></param>
/// <param name="DEFAULT_STATUS"></param>
/// <returns></returns>
public int CheckRequestPending(long CardHolder_Id, long RequestTypeId, string DEFAULT_STATUS)
{
BOBCardEntities _db = new BOBCardEntities();
var count = _db.getCheckPendingRequestCount(CardHolder_Id, RequestTypeId, DEFAULT_STATUS).FirstOrDefault();
return(count.Value);
}
/// <summary>
/// Gets the card holder login info by ID.
/// </summary>
/// <param name="CardHolderID">The card holder ID.</param>
/// <returns></returns>
/// <remarks></remarks>
public List <CardHolderLogin_InfoDTO> getCardHolderLoginInfoByID(int CardHolderID)
{
//List<CardHolderLogin_InfoDTO> LoginInfo = repCardHolderLogin_Info.Find(u => u.CardHolder_Id == CardHolderID).Select(u => new CardHolderLogin_InfoDTO()
//{
// CardHolder_Id = u.CardHolder_Id,
// CardHolderLog_InfoId = u.CardHolderLog_InfoId,
// Login_Attempt_FirstDt = u.Login_Attempt_FirstDt,
// Login_Attempt_SecondDt = u.Login_Attempt_SecondDt,
// Login_Attempt_ThirdDt = u.Login_Attempt_ThirdDt,
// Login_Attempts = u.Login_Attempts
//}).ToList();
BOBCardEntities db = new BOBCardEntities();
List <CardHolderLogin_InfoDTO> LoginInfo = db.getCardHolderLogin_Info(CardHolderID).Select(u => new CardHolderLogin_InfoDTO()
{
CardHolder_Id = u.CardHolder_Id,
CardHolderLog_InfoId = u.CardHolderLog_InfoId,
Login_Attempt_FirstDt = u.Login_Attempt_FirstDt,
Login_Attempt_SecondDt = u.Login_Attempt_SecondDt,
Login_Attempt_ThirdDt = u.Login_Attempt_ThirdDt,
Login_Attempts = u.Login_Attempts
}).ToList();
return(LoginInfo);
}
/// <summary>
/// Updates the card holder.
/// </summary>
/// <param name="userDTO">The user DTO.</param>
/// <returns></returns>
/// <remarks></remarks>
public string UpdateCardHolderLastLoginDetails(CardHolder_MstDTO userDTO)
{
try
{
IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork);
//start commented by abhijeet on 20/08/2019
/*
* CardHolder_Mst user = repCardHolder_Mst.SingleOrDefault(u => u.CardHolder_Id == userDTO.CardHolder_Id);
* user.CurrentLoginDate = DateTime.Now;
* var UserInfo = GetUserInfoById(userDTO.CardHolder_Id);
* user.LastLoginDate = UserInfo.CurrentLoginDate;
* user.Local_IpAddress = Convert.ToString(localAddress);
* user.IsLoggedInCurrently = true;
* GeneralManager.Commit();
*/
//End start commented by abhijeet on 20/08/2019
//start Added by abhijeet on 20/08/2019
BOBCardEntities _db = new BOBCardEntities();
_db.getCardHolderMst(userDTO.User_nm, localAddress.ToString(), localAddress.ToString());
//End Added by abhijeet on 20/08/2019
return("0");
}
catch (Exception exp)
{
return(Constants.GeneralErrorMessage);
}
}
/// <summary>
/// Updates the card holder payment status.
/// </summary>
/// <param name="transaction_number">The transaction_number.</param>
/// <param name="accountNumber">The account number.</param>
/// <param name="amountDue">The amount due.</param>
/// <param name="TxnRefrenceNo">The TXN refrence no.</param>
/// <returns></returns>
/// <remarks></remarks>
public string UpdateCardHolderPaymentStatus(string transaction_number, string BillDeskOnlineID, double amountDue, string TxnRefrenceNo,
string paymentStatus, string BankRefNo, string BankId, string AuthStatus) // Add BillDeskOnlineID instead of Accnum 20-jan-2015
{
//commented by abhijeet on 21/08/2019
//string Transaction_number = "";
//CH_PaymentStatus_Dtl obj = repCardHolderPaymentStatus.SingleOrDefault(c => c.BillDeskOnlineID == BillDeskOnlineID
// && c.Transaction_number == transaction_number
// && c.AmountDue == amountDue && c.PaymentStatus.Trim().ToLower() == "unsuccessful");
//if (obj != null)
//{
// obj.PaymentStatus = paymentStatus;
// obj.TxnReferenceNo = TxnRefrenceNo;
// obj.Updated_by = CardHolderManager.GetLoggedInUser().CardHolder_Id;
// obj.Updated_dt = DateTime.Now;
// obj.BankRefNo = BankRefNo;
// obj.BankId = BankId;
// obj.AuthStatus = AuthStatus;
// GeneralManager.Commit();
// Transaction_number = obj.Transaction_number;
//}
//return Transaction_number;
//Added by abhijeet on 21/08/2019
BOBCardEntities _db = new BOBCardEntities();
_db.UpdatePaymentStatus_Dtl(BillDeskOnlineID, transaction_number, amountDue, paymentStatus, TxnRefrenceNo,
CardHolderManager.GetLoggedInUser().CardHolder_Id, DateTime.Now, BankRefNo, BankId, AuthStatus);
return(transaction_number);
}
/// <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);
}
}
public bool FindUserByAccountNumber(string Cr_Accnum)
{
//var users = repCardHolder_Mst.Find(u => u.credit_card_number == CreditCardNum.Encrypt()).Select(u => new CardHolder_MstDTO()
try
{
//commented by abhijeet on 21/08/2019
//var users = repCardHolder_Mst.Find(u => u.creditcard_acc_number == Cr_Accnum).FirstOrDefault();
//if (users != null)
// return true;
//else
// return false;
BOBCardEntities _db = new BOBCardEntities();
var users = _db.FindUserByAccountNumber(Cr_Accnum).ToList();
int ISuserExist = Convert.ToInt32(users.Select(x => x).FirstOrDefault());
if (ISuserExist != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// get total count of pending request based on cardholderid and requesttypeid
/// </summary>
/// <param name="CardHolder_Id"></param>
/// <param name="RequestTypeId"></param>
/// <param name="DEFAULT_STATUS"></param>
/// <returns></returns>
/// This code is added by Avani to improve performance 0n 21-08-2019
public int UpdateCardHolderDetailByID(CardHolder_MstDTO userDTO)
{
BOBCardEntities _db = new BOBCardEntities();
IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork);
_db.UpdateCardHolderDetailByID(userDTO.CardHolder_Id, localAddress.ToString(), true, DateTime.Now);
return(0);
}
/// <summary>
/// Gets the dispatch speed post details.
/// </summary>
/// <param name="RefrenceNo">The refrence no.</param>
/// <param name="DDlCardPin">The D dl card pin.</param>
/// <param name="DispatchMonths">The dispatch months.</param>
/// <returns></returns>
/// <remarks></remarks>
public List <Dispatch_SpeedPost_RptDTO> getDispatchSpeedPostDetails(string RefrenceNo, string DDlCardPin, int DispatchMonths)
{
//DateTime startDate = System.DateTime.Now;
//DateTime endDate = System.DateTime.Now.AddMonths(-DispatchMonths);
//string startDate = System.DateTime.Now.ToString();
//string endDate = System.DateTime.Now.AddMonths(-DispatchMonths).ToString();
//lst = (from x in repDispatch_SpeedPost_Rpt.GetAll()
// where Convert.ToDateTime(x.DISPATCH_DATE).Date >= endDate.Date && Convert.ToDateTime(x.DISPATCH_DATE).Date <= startDate.Date
// && x.Reference_No == RefrenceNo && x.CARD_PIN.ToLower() == DDlCardPin.ToLower() && x.IsApproved == true
// //&& GeneralMetods x.DISPATCH_DATE.CompareTo(endDate) >= 0 && x.DISPATCH_DATE.CompareTo(startDate) <= 0
// select new Dispatch_SpeedPost_RptDTO
// {
// Awb_No = x.Awb_No,
// BATCH_NUMBER = x.BATCH_NUMBER,
// CARD_PIN = x.CARD_PIN,
// COName_on_Primary_Card = x.COName_on_Primary_Card,
// Courier = x.Courier,
// Delivery_Status = x.Delivery_Status,
// DISPATCH_DATE = x.DISPATCH_DATE,
// FullAdress = x.MailingAddress1 + "," + x.MailingAddress2 + "," + x.MailingAddress3 + "," + x.MailingAddress4 + "," + x.MailingCity + "," + x.MailingCountry + "," + x.MailingPincode + ".",
// MailingCity = x.MailingCity,
// MailingEmail = x.MailingEmail,
// MailingMobile = x.MailingMobile,
// MailingName = x.MailingName,
// MailingPhone = x.MailingPhone,
// Reference_No = x.Reference_No,
// REQUEST_TYPE = x.REQUEST_TYPE
// }).ToList();
//return lst;
BOBCardEntities _db = new BOBCardEntities();
List <Dispatch_SpeedPost_RptDTO> lst = new List <Dispatch_SpeedPost_RptDTO>();
lst = _db.getDispatchSpeedPostDetails(RefrenceNo, DDlCardPin, DispatchMonths).Select(x => new Dispatch_SpeedPost_RptDTO()
{
Awb_No = x.Awb_No,
BATCH_NUMBER = x.BATCH_NUMBER,
CARD_PIN = x.CARD_PIN,
COName_on_Primary_Card = x.COName_on_Primary_Card,
Courier = x.Courier,
Delivery_Status = x.Delivery_Status,
DISPATCH_DATE = x.DISPATCH_DATE,
//FullAdress = x.MailingAddress1 + "," + x.MailingAddress2 + "," + x.MailingAddress3 + "," + x.MailingAddress4 + "," + x.MailingCity + "," + x.MailingCountry + "," + x.MailingPincode + ".",
FullAdress = x.FullAdress,
MailingCity = x.MailingCity,
MailingEmail = x.MailingEmail,
MailingMobile = x.MailingMobile,
MailingName = x.MailingName,
MailingPhone = x.MailingPhone,
Reference_No = x.Reference_No,
REQUEST_TYPE = x.REQUEST_TYPE
}).ToList();
return(lst);
}
/// <summary>
/// Deletes the card holder login info.
/// </summary>
/// <param name="CardHolderId">The card holder id.</param>
/// <returns></returns>
/// <remarks></remarks>
public bool DeleteCardHolderLoginInfo(int CardHolderId)
{
bool rvalue = false;
//repCardHolderLogin_Info.Delete(c => c.CardHolder_Id == CardHolderId);
//GeneralManager.Commit();
BOBCardEntities _db = new BOBCardEntities();
var obj = _db.deleteCardHolderLogin_Info(CardHolderId);
rvalue = true;
return(rvalue);
}
/// <summary>
/// Updates the card holder login info third.
/// </summary>
/// <param name="objCardHolderLogin_InfoDTO">The obj card holder login_ info DTO.</param>
/// <returns></returns>
/// <remarks></remarks>
public int?UpdateCardHolderLoginInfoThird(CardHolderLogin_InfoDTO objCardHolderLogin_InfoDTO)
{
// Commented by avani to inprove perfromance on 21-08-2019
//CardHolderLogin_Info obj = repCardHolderLogin_Info.SingleOrDefault(c => c.CardHolder_Id == objCardHolderLogin_InfoDTO.CardHolder_Id && c.Login_Attempt_ThirdDt == objCardHolderLogin_InfoDTO.Login_Attempt_ThirdDt);
//if (obj != null)
//{
// obj.Login_Attempts = objCardHolderLogin_InfoDTO.Login_Attempts;
// GeneralManager.Commit();
//}
//return objCardHolderLogin_InfoDTO.Login_Attempts;
//added by Avani on 21-08-2019 to improve performance
BOBCardEntities db = new BOBCardEntities();
var result = db.getCardHolderLogin_InfoThirdAttemptDt(objCardHolderLogin_InfoDTO.CardHolder_Id, objCardHolderLogin_InfoDTO.Login_Attempt_ThirdDt, objCardHolderLogin_InfoDTO.Login_Attempts);
return(objCardHolderLogin_InfoDTO.Login_Attempts);
}
public CardHolder_MstDTO GetUserInfoById(long CardHolder_Id)
{
/*
* var users = repCardHolder_Mst.Find(u => u.CardHolder_Id == CardHolder_Id).Select(u => new CardHolder_MstDTO()
* {
* CardHolder_Id = u.CardHolder_Id,
* User_nm = u.User_nm,
* Personal_Msg = u.Personal_Msg,
* }).ToList();
*
* CardHolder_MstDTO CardHolder = null;
* if (users.Count < 2)
* {
* CardHolder = users.SingleOrDefault();
* }
* else
* {
* CardHolder = users.First();
* }
*/
BOBCardEntities _db = new BOBCardEntities();
var obj = _db.GetUserInfoById(CardHolder_Id).Select(u => new CardHolder_MstDTO()
{
CardHolder_Id = u.CardHolder_Id,
User_nm = u.User_nm,
User_pwd = u.User_pwd,
Created_dt = u.Created_dt,
Updated_dt = u.Updated_dt,
IP_Address = u.IP_Address,
Personal_Msg = u.Personal_Msg,
IsActive = u.IsActive,
IsPermanentDisable = u.IsPermanentDisable,
//IsLoggedInCurrently = u.IsLoggedInCurrently,
Oracle_Customer_Id = u.Oracle_Customer_Id,
credit_card_number = u.credit_card_number,
creditcard_acc_number = u.creditcard_acc_number,
InvalidLastLoginDt = u.InvalidLastLoginDt,
CurrentLoginDate = u.CurrentLoginDate,
LastLoginDate = u.LastLoginDate,
LocalIP_Address = u.Local_IpAddress
});
var Objusers = new CardHolder_MstDTO();
Objusers = obj.First();
return(Objusers);
}
/// <summary>
/// Gets the request UID.
/// </summary>
/// <param name="RequestDtlID">The request DTL ID.</param>
/// <returns></returns>
/// <remarks></remarks>
public List <CH_Request_DtlDTO> GetRequestStatusRecord(long cardholderID)
{
BOBCardEntities _db = new BOBCardEntities();
var requestDtl = _db.getRequestStatusRecord(cardholderID).Select(u => new CH_Request_DtlDTO()
{
RequestType = u.RequestType,
Request_Dtl_Id = u.Request_Dtl_Id,
Request_Status = u.Request_Status,
UID = u.UID,
Remarks = u.Remarks,
RequestorComplaint = u.RequestorComplaint,
Request_Dt = u.Request_Dt,
AdminRemarks = u.AdminRemarks
});
return(requestDtl.ToList());
}
/// <summary>
/// Gets the request UID.
/// </summary>
/// <param name="RequestDtlID">The request DTL ID.</param>
/// <returns></returns>
/// <remarks></remarks>
public CH_Request_DtlDTO getRequestUID(long RequestDtlID)
{
//CardHolderManager chm = new CardHolderManager();
/*
* return (from x in repCH_Request_Dtl.GetAll()
* where RequestDtlID == x.Request_Dtl_Id
* select new CH_Request_DtlDTO()
* {
* UID = x.UID,
* }).FirstOrDefault();
*/
BOBCardEntities _db = new BOBCardEntities();
var requestDtl = _db.getRequest_UID(RequestDtlID).Select(u => new CH_Request_DtlDTO()
{
UID = u.UID
});
return(requestDtl.First());
}
/// <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>
/// This method is use to get unique id of complaint (used for sending emails)
/// </summary>
/// <param name="ComplaintDtlId">The complaint DTL id.</param>
/// <returns>Unique Id of complaint</returns>
/// <remarks></remarks>
public CH_Complaint_DtlDTO getComplaintUID(long ComplaintDtlId)
{
//CardHolderManager chm = new CardHolderManager();
/*
* return (from x in repCH_Complaint_Dtl.GetAll()
* where ComplaintDtlId == x.Complaint_Dtl_Id
* select new CH_Complaint_DtlDTO()
* {
* UID = x.UID,
* }).FirstOrDefault();
*/
BOBCardEntities _db = new BOBCardEntities();
var complaintDtl = _db.getComplaint_UID(ComplaintDtlId).Select(u => new CH_Complaint_DtlDTO()
{
UID = u.UID
});
return(complaintDtl.First());
}
/// <summary>
/// Sets the card holder active.
/// </summary>
/// <param name="CardHolderId">The card holder id.</param>
/// <returns></returns>
/// <remarks></remarks>
public bool SetCardHolderActive(long CardHolderId)
{
/* commented by abhijeet on 23/01/2019
* CardHolder_Mst objCardholder_Mst = repCardHolder_Mst.SingleOrDefault(c => c.CardHolder_Id == CardHolderId);
*
* if (objCardholder_Mst != null && objCardholder_Mst.CardHolder_Id == CardHolderId)
* {
* objCardholder_Mst.IsActive = true;
* GeneralManager.Commit();
* return true;
* }
* else
* {
* return false;
* }*/
BOBCardEntities _db = new BOBCardEntities();
var obj = _db.setCardHolderMst_Active(CardHolderId);
return((bool)obj.ToList()[0]);
}
public long SaveAuditLog(AuditLog_DTO objAuditLog_DltDTO)
{
BOBCardEntities _db = new BOBCardEntities();
var requestDtl = _db.saveAuditLog(
objAuditLog_DltDTO.Id,
objAuditLog_DltDTO.RequestType_Id,
objAuditLog_DltDTO.CardHolder_Id,
objAuditLog_DltDTO.TxnType,
objAuditLog_DltDTO.Credit_card_number,
objAuditLog_DltDTO.RequestReason,
objAuditLog_DltDTO.TxnReferenceNo,
objAuditLog_DltDTO.ResponseStatus,
objAuditLog_DltDTO.Created_by,
objAuditLog_DltDTO.Created_dt,
objAuditLog_DltDTO.Updated_by,
objAuditLog_DltDTO.Updated_dt,
objAuditLog_DltDTO.BankRefNo,
objAuditLog_DltDTO.IP_Address).ToList();
return((long)requestDtl[0]);
}
/// <summary>
/// Updates the card holder payment status bobibanking.
/// </summary>
/// <param name="prn">The PRN.</param>
/// <param name="accountNumber">The account number.</param>
/// <param name="amountDue">The amount due.</param>
/// <param name="bid">The bid.</param>
/// <param name="debtAccountNo">The debt account no.</param>
/// <returns></returns>
/// <remarks></remarks>
public string UpdateCardHolderPaymentStatusBobibanking(string prn, string accountNumber, double amountDue, string PID, string bid,
string debtAccountNo, string status)
{
//commented by abhijeet on 21/08/2019
//string Transaction_number = "";
//CH_BobibankingPaymentStatus_Dtl obj = repCardHolderBobibankingPaymentStatus.SingleOrDefault(c => c.Creditcard_acc_number == accountNumber
// && c.PRN == prn && c.AmountDue == amountDue && c.PaymentStatus.Trim() == "unsuccessful");
//if (obj != null)
//{
// obj.PaymentStatus = status;
// obj.BID = bid;
// obj.DebtAccountNo = debtAccountNo;
// obj.Updated_by = CardHolderManager.GetLoggedInUser().CardHolder_Id;
// obj.Updated_dt = DateTime.Now;
// GeneralManager.Commit();
// Transaction_number = obj.PRN;
//}
//return Transaction_number;
BOBCardEntities _db = new BOBCardEntities();
_db.Update_BobibankingPaymentStatus_Dtl(accountNumber, prn, amountDue, status, bid, debtAccountNo, DateTime.Now, CardHolderManager.GetLoggedInUser().CardHolder_Id.ToString());
return(prn);
}
/// <summary>
/// Gets the user by ID.
/// </summary>
/// <param name="CardHolder_Id">The card holder_ id.</param>
/// <returns></returns>
/// <remarks></remarks>
public CardHolder_MstDTO getUserByID(long CardHolder_Id)
{
//start commented by abhijeet on 20/08/2019
/*
* var users = repCardHolder_Mst.Find(u => u.CardHolder_Id == CardHolder_Id).Select(u => new CardHolder_MstDTO()
* {
* CardHolder_Id = u.CardHolder_Id,
* User_nm = u.User_nm,
* User_pwd = u.User_pwd,
* UID = u.UID,
* Profile_Photo = u.Profile_Photo,
* AddOn1_Photo = u.AddOn1_Photo,
* AddOn2_Photo = u.AddOn2_Photo,
* AddOn3_Photo = u.AddOn3_Photo,
* IsActive = u.IsActive,
* IsPermanentDisable = u.IsPermanentDisable,
* //IsLoggedInCurrently = u.IsLoggedInCurrently,
* Created_dt = u.Created_dt,
* Updated_dt = u.Updated_dt,
* IP_Address = u.IP_Address,
* Personal_Msg = u.Personal_Msg,
* Oracle_Customer_Id = u.Oracle_Customer_Id,
* credit_card_number = u.credit_card_number,
* creditcard_acc_number = u.creditcard_acc_number,
* CurrentLoginDate = u.CurrentLoginDate,
* LastLoginDate = u.LastLoginDate
*
* }).ToList();
*/
//end commented by abhijeet on 20/08/2019
//start added by abhijeet on 20/08/2019
BOBCardEntities _db = new BOBCardEntities();
var obj = _db.GetUserInfoById(CardHolder_Id).Select(u => new CardHolder_MstDTO()
{
CardHolder_Id = u.CardHolder_Id,
User_nm = u.User_nm,
User_pwd = u.User_pwd,
Created_dt = u.Created_dt,
Updated_dt = u.Updated_dt,
IP_Address = u.IP_Address,
Personal_Msg = u.Personal_Msg,
IsActive = u.IsActive,
IsPermanentDisable = u.IsPermanentDisable,
//IsLoggedInCurrently = u.IsLoggedInCurrently,
Oracle_Customer_Id = u.Oracle_Customer_Id,
credit_card_number = u.credit_card_number,
creditcard_acc_number = u.creditcard_acc_number,
InvalidLastLoginDt = u.InvalidLastLoginDt,
CurrentLoginDate = u.CurrentLoginDate,
LastLoginDate = u.LastLoginDate,
LocalIP_Address = u.Local_IpAddress
});
var CardHolder = new CardHolder_MstDTO();
CardHolder = obj.First();
/*
* CardHolder_MstDTO CardHolder = null;
* if (users.Count < 2)
* {
* CardHolder = users.SingleOrDefault();
* }
* else
* {
* CardHolder = users.First();
* }
*/
//end added by abhijeet on 20/08/2019
CardManager cm = new CardManager();
if (CardHolder != null)
{
if (CardHolder.creditcard_acc_number != null)
{
CH_CardDTO card = cm.GetCardByCreditCardNumber(new CH_CardDTO()
{
Cr_Account_Nbr = CardHolder.creditcard_acc_number.Decrypt()
});
if (card != null)
{
CardHolder.CH_Card = card;
CardHolder.FULL_NAME = card.FULL_NAME;
}
}
}
return(CardHolder);
}
/// <summary>
/// This method is used to save the complaint submitted by CardHolder
/// </summary>
/// <param name="objComplaint_DltDTO">The obj complaint_ DLT DTO.</param>
/// <returns></returns>
/// <remarks></remarks>
public long SaveComplaintDetail(CH_Complaint_DtlDTO objComplaint_DltDTO)
{
if (objComplaint_DltDTO.Complaint_Dtl_Id == 0)
{
BOBCardEntities _db = new BOBCardEntities();
var complaintDtl = _db.saveComplaintDtl(
objComplaint_DltDTO.Complaint_Dtl_Id,
objComplaint_DltDTO.Complaint_Dt,
objComplaint_DltDTO.CardHolder_Id,
objComplaint_DltDTO.ComplaintType_Id,
objComplaint_DltDTO.Remarks,
objComplaint_DltDTO.Complaint_Status,
objComplaint_DltDTO.Created_by,
objComplaint_DltDTO.Created_dt,
objComplaint_DltDTO.Updated_by,
objComplaint_DltDTO.Updated_dt,
objComplaint_DltDTO.IP_Address,
null,
null,
objComplaint_DltDTO.Created_dt.ToString("yyyyMMddHHmmssffff"),
objComplaint_DltDTO.AdminRemarks,
null,
null,
null
).ToList();
return((long)complaintDtl[0]);
}
else
{
CH_Complaint_Dtl obj = repCH_Complaint_Dtl.SingleOrDefault(c => c.Complaint_Dtl_Id == objComplaint_DltDTO.Complaint_Dtl_Id);
if (obj == null || obj.Complaint_Dtl_Id != objComplaint_DltDTO.Complaint_Dtl_Id)
{
obj = new CH_Complaint_Dtl();
}
obj.Complaint_Dt = objComplaint_DltDTO.Complaint_Dt;
obj.CardHolder_Id = objComplaint_DltDTO.CardHolder_Id;
obj.ComplaintType_Id = objComplaint_DltDTO.ComplaintType_Id;
obj.IP_Address = objComplaint_DltDTO.IP_Address;
obj.Remarks = objComplaint_DltDTO.Remarks;
obj.Complaint_Status = objComplaint_DltDTO.Complaint_Status;
obj.Remarks = objComplaint_DltDTO.Remarks;
if (obj.Complaint_Dtl_Id == 0)
{
obj.Created_by = objComplaint_DltDTO.Created_by;
obj.Created_dt = objComplaint_DltDTO.Created_dt;
obj.UID = objComplaint_DltDTO.Created_dt.ToString("yyyyMMddHHmmssffff");
}
obj.Updated_by = objComplaint_DltDTO.Updated_by;
obj.Updated_dt = objComplaint_DltDTO.Updated_dt;
if (obj.Complaint_Dtl_Id == 0)
{
repCH_Complaint_Dtl.Add(obj);
}
GeneralManager.Commit();
return(obj.Complaint_Dtl_Id);
}
}
public CardHolder_MstDTO FindActiveUser(string Username, string PublicIP = "")
{
// var obj = repCardHolder_Mst.SingleOrDefault(c => c.User_nm == Username && c.IsActive == true && c.IsPermanentDisable == false);
BOBCardEntities _db = new BOBCardEntities();
IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork);
var users = _db.getCardHolderMst(Username, PublicIP, localAddress.ToString()).Select(u => new CardHolder_MstDTO()
{
CardHolder_Id = u.CardHolder_Id,
User_nm = u.User_nm,
User_pwd = u.User_pwd,
Created_dt = u.Created_dt,
Updated_dt = u.Updated_dt,
IP_Address = u.IP_Address,
Personal_Msg = u.Personal_Msg,
IsActive = u.IsActive,
IsPermanentDisable = u.IsPermanentDisable,
//IsLoggedInCurrently = u.IsLoggedInCurrently,
Oracle_Customer_Id = u.Oracle_Customer_Id,
credit_card_number = u.credit_card_number,
creditcard_acc_number = u.creditcard_acc_number,
InvalidLastLoginDt = u.InvalidLastLoginDt,
CurrentLoginDate = u.CurrentLoginDate,
LastLoginDate = u.LastLoginDate,
LocalIP_Address = u.Local_IpAddress
}).SingleOrDefault();
//var users = repCardHolder_Mst.Find(u => u.User_nm == Username && u.IsActive == true && u.IsPermanentDisable == false).Select(u => new CardHolder_MstDTO()
//{
// CardHolder_Id = u.CardHolder_Id,
// User_nm = u.User_nm,
// User_pwd = u.User_pwd,
// Created_dt = u.Created_dt,
// Updated_dt = u.Updated_dt,
// IP_Address = u.IP_Address,
// Personal_Msg = u.Personal_Msg,
// IsActive = u.IsActive,
// IsPermanentDisable = u.IsPermanentDisable,
// //IsLoggedInCurrently = u.IsLoggedInCurrently,
// Oracle_Customer_Id = u.Oracle_Customer_Id,
// credit_card_number = u.credit_card_number,
// creditcard_acc_number = u.creditcard_acc_number,
// InvalidLastLoginDt = u.InvalidLastLoginDt,
// CurrentLoginDate = u.CurrentLoginDate,
// LastLoginDate = u.LastLoginDate,
// LocalIP_Address = u.Local_IpAddress
//}).ToList();
var Objusers = new CardHolder_MstDTO();
Objusers = users;
////if (users.Count < 2)
//// Objusers = users.SingleOrDefault();
////else
/*
* if (users.Count() > 0)
* Objusers = users.SingleOrDefault();
* else
* Objusers = users.First();
*/
//if (Objusers != null)
//{
// var obj = repCardHolder_Mst.SingleOrDefault(c => c.User_nm == Username && c.IsActive == true && c.IsPermanentDisable == false);
// if (obj != null)
// {
// if (localAddress != null)
// obj.Local_IpAddress = Convert.ToString(localAddress);
// if (PublicIP != "")
// Objusers.IP_Address = PublicIP;
// GeneralManager.Commit();
// }
//}
return(Objusers);
}
/// <summary>
/// Gets the dispatch courier details.
/// </summary>
/// <param name="RefrenceNo">The refrence no.</param>
/// <param name="type">The type.</param>
/// <param name="DispatchMonths">The dispatch months.</param>
/// <returns></returns>
/// <remarks></remarks>
public List <Dispatch_Courier_RptDTO> getDispatchCourierDetails(string RefrenceNo, string DDlCardPin, int DispatchMonths)
{
//DateTime startDate = System.DateTime.Now;
//DateTime endDate = System.DateTime.Now.AddMonths(-DispatchMonths);
//List<Dispatch_Courier_RptDTO> lst = new List<Dispatch_Courier_RptDTO>();
//lst = (from x in repDispatch_Courier_Rpt.GetAll()
// //where Convert.ToDateTime(x.DPUDATEFCH.Substring(6, 2) + "/" + x.DPUDATEFCH.Substring(4, 2) + "/" + x.DPUDATEFCH.Substring(0, 4)).Date >= endDate.Date
// //&& Convert.ToDateTime(x.DPUDATEFCH.Substring(6, 2) + "/" + x.DPUDATEFCH.Substring(4, 2) + "/" + x.DPUDATEFCH.Substring(0, 4)).Date <= startDate.Date
// where Convert.ToDateTime(x.DPUDATEFCH.Substring(0, 4) + "/" + x.DPUDATEFCH.Substring(4, 2) + "/" + x.DPUDATEFCH.Substring(6, 2)).Date >= endDate.Date
// && Convert.ToDateTime(x.DPUDATEFCH.Substring(0, 4) + "/" + x.DPUDATEFCH.Substring(4, 2) + "/" + x.DPUDATEFCH.Substring(6, 2)).Date <= startDate.Date
// && x.CCRCRDREF == RefrenceNo && x.CARD_PIN.ToLower() == type.ToLower() && x.IsApproved == true
// select new Dispatch_Courier_RptDTO
// {
// CAWBNO = x.CAWBNO, //Airwaybill Number
// CCNEENAME = x.CCNEENAME, // Consignee Name
// CCRCRDREF = x.CCRCRDREF, //Reference No
// CCUSTCODE = x.CCUSTCODE, //Customer Code
// CDSTDESC = x.CDSTDESC, //Destination Area Description
// CIDNO = x.CIDNO, //Identity Number
// CIDTYPE = x.CIDTYPE, //Identity Type
// CORGAREA = x.CORGAREA, //Origin Area
// CORGDESC = x.CORGDESC, //Origin Area Description
// CPRODCODE = x.CPRODCODE, //Product code
// CPRODTYPE = x.CPRODTYPE, //Product Type
// CPUTIME = x.CPUTIME, //Pickup Time
// CQRYGRP = x.CQRYGRP, //Group categories
// CRECPID = x.CRECPID, //Received By
// CRELATION = x.CRELATION, //Relation
// CRTOREASON = x.CRTOREASON, // Reason
// CSENDER = x.CSENDER, //Sender
// CSPLINST = x.CSPLINST, //Special Instruction
// CSTATDESC = x.CSTATDESC, //Status Description
// CSTATTIME = x.CSTATTIME, //Status Time
// DEPTDTDLV = x.DEPTDTDLV, //Expected delivery date
// DSTATDATE = x.DSTATDATE, //Status Date
// NEWAWBNO = x.NEWAWBNO, //New waybill number
// NPCS = x.NPCS, // No. of pieces
// NWEIGHT = x.NWEIGHT, //Weight
// CARD_PIN = x.CARD_PIN,
// // DPUDATEFCH = x.DPUDATEFCH == null ? string.Empty : x.DPUDATEFCH.Substring(6, 2) + "/" + x.DPUDATEFCH.Substring(4, 2) + "/" + x.DPUDATEFCH.Substring(0, 4) //Pickup Date
// DPUDATEFCH = x.DPUDATEFCH == null ? string.Empty : x.DPUDATEFCH.Substring(0, 4) + "/" + x.DPUDATEFCH.Substring(4, 2) + "/" + x.DPUDATEFCH.Substring(6, 2)
// }).ToList();
//return lst;
BOBCardEntities _db = new BOBCardEntities();
List <Dispatch_Courier_RptDTO> lst = new List <Dispatch_Courier_RptDTO>();
lst = _db.getDispatchCourierDetail(RefrenceNo, DDlCardPin, DispatchMonths).Select(x => new Dispatch_Courier_RptDTO()
{
CAWBNO = x.CAWBNO, //Airwaybill Number
CCNEENAME = x.CCNEENAME, // Consignee Name
CCRCRDREF = x.CCRCRDREF, //Reference No
CCUSTCODE = x.CCUSTCODE, //Customer Code
CDSTDESC = x.CDSTDESC, //Destination Area Description
CIDNO = x.CIDNO, //Identity Number
CIDTYPE = x.CIDTYPE, //Identity Type
CORGAREA = x.CORGAREA, //Origin Area
CORGDESC = x.CORGDESC, //Origin Area Description
CPRODCODE = x.CPRODCODE, //Product code
CPRODTYPE = x.CPRODTYPE, //Product Type
CPUTIME = x.CPUTIME, //Pickup Time
CQRYGRP = x.CQRYGRP, //Group categories
CRECPID = x.CRECPID, //Received By
CRELATION = x.CRELATION, //Relation
CRTOREASON = x.CRTOREASON, // Reason
CSENDER = x.CSENDER, //Sender
CSPLINST = x.CSPLINST, //Special Instruction
CSTATDESC = x.CSTATDESC, //Status Description
CSTATTIME = x.CSTATTIME, //Status Time
DEPTDTDLV = x.DEPTDTDLV, //Expected delivery date
DSTATDATE = x.DSTATDATE, //Status Date
NEWAWBNO = x.NEWAWBNO, //New waybill number
NPCS = x.NPCS, // No. of pieces
NWEIGHT = x.NWEIGHT, //Weight
CARD_PIN = x.CARD_PIN,
// DPUDATEFCH = x.DPUDATEFCH == null ? string.Empty : x.DPUDATEFCH.Substring(6, 2) + "/" + x.DPUDATEFCH.Substring(4, 2) + "/" + x.DPUDATEFCH.Substring(0, 4) //Pickup Date
DPUDATEFCH = x.DPUDATEFCH == null ? string.Empty : x.DPUDATEFCH.Substring(0, 5) + "/" + x.DPUDATEFCH.Substring(5, 2) + "/" + x.DPUDATEFCH.Substring(7, 2)
}).ToList();
return(lst);
}
/// <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;
*
* }*/
}
