namespace AndroidApi.Models.Repository
{
    public class AccountRepository : IAccountRepository
    {
        private static string connectionString;

        public AccountRepository()
        {
            if (!string.IsNullOrWhiteSpace(ConfigurationManager.AppSettings["appctxt"]))
                connectionString = ConfigurationManager.AppSettings["appctxt"];
        }

        public AccountViewModel GetByEmailAndPassword(AccountViewModel item)
        {
            AccountViewModel result = null;

            DataSet dsResult = new DataSet();
            string[] tableNames = new string[] { "CustomerAccessKey" };
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@email", item.Email),
                new SqlParameter("@password", item.Password),
            };
            SqlHelper.FillDataset(connectionString, CommandType.StoredProcedure, "UserGetByEmailAndPassword", dsResult, tableNames, sqlParameters);
            if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
            {
                result = SqlHelper.ToType<AccountViewModel>(dsResult.Tables[0].Rows[0]);
                result.StatusCode = 200;
                result.Message = "OK";
            }

            return result;
        }
    }
}