public Account Validate(Account account) { if (account == null || string.IsNullOrEmpty(account.UserName) || string.IsNullOrEmpty(account.Password)) { return(null); } var query = $"SELECT * FROM Account WHERE LOWER(UserName) = '{account.UserName.ToLower()}'"; var data = _database.ExecuteToTable(query, null, Common.ExecuteTypeEnum.SqlQuery); if (data == null || data.Rows.Count <= 0) { return(null); } var tempAcc = SqlMapper <Account> .Map(data).FirstOrDefault(); if (!AccountUtils.VerifyPassword(tempAcc.Password, account.Password)) { return(null); } return(new Account { AccountId = tempAcc.AccountId, UserName = tempAcc.UserName, AccountType = tempAcc.AccountType, CreatedDate = tempAcc.CreatedDate }); }