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