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