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