/// <summary>
/// Saves the EMI request DTL.
/// </summary>
/// <param name="objEMIRequest_DltDTO">The obj EMI request_ DLT DTO.</param>
/// <returns></returns>
/// <remarks></remarks>
public long SaveEMIRequestDtl(CH_EMI_Request_DTO objEMIRequest_DltDTO)
{
CH_EMI_Request_Dtl obj = repCH_EMI_Request_Dtl.SingleOrDefault(c => c.Oracle_EMI_Id == objEMIRequest_DltDTO.Oracle_EMI_Id);
if (obj == null)
{
obj = new CH_EMI_Request_Dtl();
}
obj.Oracle_EMI_Id = objEMIRequest_DltDTO.Oracle_EMI_Id;
obj.Creditcard_acc_number = objEMIRequest_DltDTO.Creditcard_acc_number;
obj.EMI_Loan_Type = objEMIRequest_DltDTO.EMI_Loan_Type;
if (obj.EMI_Id == 0)
{
obj.Created_by = objEMIRequest_DltDTO.Created_by;
obj.Created_dt = objEMIRequest_DltDTO.Created_dt;
}
obj.Updated_by = objEMIRequest_DltDTO.Updated_by;
obj.Updated_dt = objEMIRequest_DltDTO.Updated_dt;
obj.IP_Address = objEMIRequest_DltDTO.IP_Address;
if (obj.EMI_Id == 0)
{
repCH_EMI_Request_Dtl.Add(obj);
}
GeneralManager.Commit();
return(obj.EMI_Id);
}
/// <summary>
/// Saves the card holder payment status bobibanking.
/// </summary>
/// <param name="objCardHolderBobibankingPaymentStatus">The obj card holder bobibanking payment status.</param>
/// <returns></returns>
/// <remarks></remarks>
public string SaveCardHolderPaymentStatusBobibanking(CH_Bobibanking_Payment_Status_DtlDTO objCardHolderBobibankingPaymentStatus)
{
if (objCardHolderBobibankingPaymentStatus.BobiBanking_PaymentStatus_Id == 0)
{
CH_BobibankingPaymentStatus_Dtl obj = new CH_BobibankingPaymentStatus_Dtl();
if (objCardHolderBobibankingPaymentStatus.Creditcard_acc_number != null)
{
obj.Creditcard_acc_number = objCardHolderBobibankingPaymentStatus.Creditcard_acc_number;
}
if (objCardHolderBobibankingPaymentStatus.Credit_card_number != null)
{
obj.Credit_card_number = objCardHolderBobibankingPaymentStatus.Credit_card_number;
}
if (objCardHolderBobibankingPaymentStatus.BankId != null)
{
obj.BankId = objCardHolderBobibankingPaymentStatus.BankId;
}
if (objCardHolderBobibankingPaymentStatus.PID != null)
{
obj.PID = objCardHolderBobibankingPaymentStatus.PID;
}
if (objCardHolderBobibankingPaymentStatus.PRN != null)
{
obj.PRN = objCardHolderBobibankingPaymentStatus.PRN;
}
if (objCardHolderBobibankingPaymentStatus.BID != null)
{
obj.BID = objCardHolderBobibankingPaymentStatus.BID;
}
if (objCardHolderBobibankingPaymentStatus.DebtAccountNo != null)
{
obj.DebtAccountNo = objCardHolderBobibankingPaymentStatus.DebtAccountNo;
}
if (objCardHolderBobibankingPaymentStatus.ITC != null)
{
obj.ITC = objCardHolderBobibankingPaymentStatus.ITC;
}
obj.AmountDue = Convert.ToDouble(objCardHolderBobibankingPaymentStatus.AmountDue);
obj.PaymentStatus = objCardHolderBobibankingPaymentStatus.PaymentStatus;
obj.IP_Address = objCardHolderBobibankingPaymentStatus.IP_Address;
obj.Created_by = objCardHolderBobibankingPaymentStatus.Created_by;
obj.Created_dt = objCardHolderBobibankingPaymentStatus.Created_dt;
repCardHolderBobibankingPaymentStatus.Add(obj);
GeneralManager.Commit();
return(obj.PRN);
}
return("");
}
/// <summary>
/// Sets the card holder parmenent disable.
/// </summary>
/// <param name="CardHolder_Id">The card holder_ id.</param>
/// <returns></returns>
/// <remarks></remarks>
public bool SetCardHolderParmenentDisable(long CardHolder_Id)
{
CardHolder_Mst objCardholder_Mst = repCardHolder_Mst.SingleOrDefault(c => c.CardHolder_Id == CardHolder_Id);
if (objCardholder_Mst != null && objCardholder_Mst.CardHolder_Id == CardHolder_Id)
{
objCardholder_Mst.IsPermanentDisable = true;
GeneralManager.Commit();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Sets the card holder in active.
/// </summary>
/// <param name="CardHolderId">The card holder id.</param>
/// <returns></returns>
/// <remarks></remarks>
public bool SetCardHolderInActive(long CardHolderId)
{
CardHolder_Mst objCardholder_Mst = repCardHolder_Mst.SingleOrDefault(c => c.CardHolder_Id == CardHolderId);
IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork);
if (objCardholder_Mst != null && objCardholder_Mst.CardHolder_Id == CardHolderId)
{
objCardholder_Mst.IsActive = false;
objCardholder_Mst.InvalidLastLoginDt = System.DateTime.Now;
objCardholder_Mst.IP_Address = Convert.ToString(localAddress);
GeneralManager.Commit();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Saves the card holder payment status.
/// </summary>
/// <param name="objCardHolderPaymentStatus">The obj card holder payment status.</param>
/// <returns></returns>
/// <remarks></remarks>
public string SaveCardHolderPaymentStatus(CH_Payment_Status_DtlDTO objCardHolderPaymentStatus)
{
if (objCardHolderPaymentStatus.PaymentStatus_Id == 0)
{
CH_PaymentStatus_Dtl obj = new CH_PaymentStatus_Dtl();
if (objCardHolderPaymentStatus.Creditcard_acc_number != null)
{
obj.Creditcard_acc_number = objCardHolderPaymentStatus.Creditcard_acc_number;
}
if (objCardHolderPaymentStatus.Credit_card_number != null)
{
obj.Credit_card_number = objCardHolderPaymentStatus.Credit_card_number;
}
if (objCardHolderPaymentStatus.Transaction_number != null)
{
obj.Transaction_number = objCardHolderPaymentStatus.Transaction_number;
}
if (objCardHolderPaymentStatus.TxnReferenceNo != null)
{
obj.TxnReferenceNo = objCardHolderPaymentStatus.TxnReferenceNo;
}
else
{
obj.TxnReferenceNo = null;
}
obj.BillDeskOnlineID = objCardHolderPaymentStatus.BillDeskOnlineID;
obj.AmountDue = objCardHolderPaymentStatus.AmountDue;
obj.PaymentStatus = objCardHolderPaymentStatus.PaymentStatus;
obj.BankRefNo = objCardHolderPaymentStatus.BankRefNo;
obj.BankId = objCardHolderPaymentStatus.BankId;
obj.AuthStatus = objCardHolderPaymentStatus.AuthStatus;
obj.IP_Address = objCardHolderPaymentStatus.IP_Address;
obj.Created_by = objCardHolderPaymentStatus.Created_by;
obj.Created_dt = objCardHolderPaymentStatus.Created_dt;
repCardHolderPaymentStatus.Add(obj);
GeneralManager.Commit();
return(obj.Transaction_number);
}
return("");
}
/// <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);
}
}
///// <summary>
///// Updates the card holder.
///// </summary>
///// <param name="userDTO">The user DTO.</param>
///// <returns></returns>
///// <remarks></remarks>
//public string UpdateCardHolderDetails(CardHolder_MstDTO userDTO)
//{
// try
// {
// 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);
// GeneralManager.Commit();
// return "0";
// }
// catch (Exception exp)
// {
// return Constants.GeneralErrorMessage;
// }
//}
//public string UpdateCardHolderPassword(CardHolder_MstDTO userDTO)
//{
// try
// {
// var user = repCardHolder_Mst.SingleOrDefault(u => u.CardHolder_Id == userDTO.CardHolder_Id);
// if (user != null)
// {
// user.MdfHashingPwd = userDTO.MdfHashingPwd;
// GeneralManager.Commit();
// }
// return "0";
// }
// catch (Exception exp)
// {
// return exp.Message;
// }
//}
/// <summary>
/// Updates the card holder access.
/// </summary>
/// <param name="objCardHolder_Mst">The obj card holder_ MST.</param>
/// <returns></returns>
/// <remarks></remarks>
//public int UpdateCardHolderAccess(long CardHolder_Id, bool IsLoggedInCurrently)
//{
// try
// {
// CardHolder_Mst user = repCardHolder_Mst.SingleOrDefault(u => u.CardHolder_Id == CardHolder_Id);
// user.IsLoggedInCurrently = IsLoggedInCurrently;
// GeneralManager.Commit();
// return 1;
// }
// catch (Exception exp)
// {
// return 0;
// }
//}
public long SaveCardHolder(CardHolder_MstDTO objCardHolder_Mst)
{
IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork);
CardHolder_Mst obj = repCardHolder_Mst.SingleOrDefault(c => c.CardHolder_Id == objCardHolder_Mst.CardHolder_Id);
if (obj == null || obj.CardHolder_Id != objCardHolder_Mst.CardHolder_Id)
{
obj = new CardHolder_Mst();
}
//obj.Dept_nm = objDept_MstDTO.Dept_nm;
//obj.Dept_cd = objDept_MstDTO.Dept_cd;
//obj.Oracle_Customer_Id = objCardHolder_Mst.Oracle_Customer_Id;
obj.User_nm = objCardHolder_Mst.User_nm;
obj.User_pwd = objCardHolder_Mst.User_pwd;
obj.UID = objCardHolder_Mst.UID;
if (objCardHolder_Mst.credit_card_number != null)
{
obj.credit_card_number = objCardHolder_Mst.credit_card_number;
}
if (objCardHolder_Mst.creditcard_acc_number != null)
{
obj.creditcard_acc_number = objCardHolder_Mst.creditcard_acc_number;
}
if (objCardHolder_Mst.Profile_Photo != null)
{
obj.Profile_Photo = objCardHolder_Mst.Profile_Photo;
}
if (objCardHolder_Mst.AddOn1_Photo != null)
{
obj.AddOn1_Photo = objCardHolder_Mst.AddOn1_Photo;
}
if (objCardHolder_Mst.AddOn2_Photo != null)
{
obj.AddOn2_Photo = objCardHolder_Mst.AddOn2_Photo;
}
if (objCardHolder_Mst.AddOn3_Photo != null)
{
obj.AddOn3_Photo = objCardHolder_Mst.AddOn3_Photo;
}
obj.Personal_Msg = objCardHolder_Mst.Personal_Msg;
obj.IP_Address = objCardHolder_Mst.IP_Address;
obj.IsActive = objCardHolder_Mst.IsActive == null ? true : objCardHolder_Mst.IsActive;
obj.IsPermanentDisable = objCardHolder_Mst.IsPermanentDisable == null ? false : objCardHolder_Mst.IsPermanentDisable;
if (localAddress != null)
{
obj.Local_IpAddress = Convert.ToString(localAddress);
}
if (obj.CardHolder_Id == 0)
{
obj.Created_by = objCardHolder_Mst.Created_by;
obj.Created_dt = objCardHolder_Mst.Created_dt;
}
obj.Updated_by = objCardHolder_Mst.Updated_by;
obj.Updated_dt = objCardHolder_Mst.Updated_dt;
if (obj.CardHolder_Id == 0)
{
repCardHolder_Mst.Add(obj);
}
GeneralManager.Commit();
return(objCardHolder_Mst.CardHolder_Id);
}