public UserViewModel GetUserByUserNameAndPassword(string UserName, string Password) { UserModel objUserModel = new UserModel(); UserViewModel objUserViewModel = new UserViewModel(); try { objUserModel = objUserDB.GetUserByUserNameAndPassword(UserName, Password); Mapper.CreateMap<UserModel, UserViewModel>(); objUserViewModel = Mapper.Map<UserModel, UserViewModel>(objUserModel); } catch (Exception ex) { throw; } return objUserViewModel; }
public UserModel GetUserByUserNameAndPassword(string UserName, string Password) { UserModel objUserModel = new UserModel(); try { using (SqlDataReader reader = SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "stp_GetUserByUserNameAndPassword", new SqlParameter("@UserName", UserName), new SqlParameter("@Password", Password))) { if (reader.HasRows) { while (reader.Read()) { objUserModel.UserId = Convert.ToInt32(reader["UserId"].ToString()); objUserModel.UserRoleId = Convert.ToInt32(reader["UserRoleId"].ToString()); objUserModel.UserName = reader["UserName"].ToString(); objUserModel.FirstName = reader["FirstName"].ToString(); objUserModel.LastName = reader["LastName"].ToString(); objUserModel.EmailId = reader["EmailId"].ToString(); objUserModel.MobileNumber = reader["MobileNumber"].ToString(); objUserModel.Address = reader["Address"].ToString(); objUserModel.Password = reader["Password"].ToString(); objUserModel.IsActive = Convert.ToBoolean(reader["IsActive"].ToString()); } } } return objUserModel; } catch (Exception ex) { throw; } finally { } }