public async Task <Users> Authenticate([FromBody] string value) { Users _user = new Users(); try { LogiDetails logiDetails = JsonConvert.DeserializeObject <LogiDetails>(value); _user = await _UserRepo.AuthenticateUser(logiDetails); var userEvent = new EventModel("user_events") { EventName = user_login, EntityId = _user.user_id, RefrenceId = _user.user_id, UserId = _user.user_id, EventNoteId = _user.user_id }; await _eventRepo.AddEventAsync(userEvent); } catch (Exception ex) { var logger = _loggerFactory.CreateLogger("internal_error_log"); logger.LogInformation("Problem happened in authenticating user for login attempt with message" + ex.Message); } return(_user); }
/* * Developer: Sajid Khan * Date: 7-7-19 * Action: Get Matched users data by email and password * Input: null * output: List of user */ public async Task <Users> AuthenticateUser(LogiDetails logiDetails) { IEnumerable <Users> user = new List <Users>(); Users Dumy = new Users(); using (IDbConnection conn = Connection) { user = await conn.QueryAsync <Users>("SELECT users.* FROM users where users.email = \"" + logiDetails.UserIdentity + "\" and users.password = \"" + logiDetails.UserPass + "\" ; "); } if (user.Count() < 0) { user.Append(Dumy); } return(user.First()); }