/// <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);
        }
Exemplo n.º 2
0
        /// <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);
            }
        }
Exemplo n.º 5
0
        /// <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("");
        }
Exemplo n.º 6
0
        /// <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);
            }
        }
Exemplo n.º 7
0
        ///// <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);
        }