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 bool IsEmailUnique(string email)
        {
            bool result = true;

            DataSet dsResult = new DataSet();
            string[] tableNames = new string[] { "CustomerAccessKey" };
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@email", email)
            };
            SqlHelper.FillDataset(connectionString, CommandType.StoredProcedure, "UserGetByEmail", dsResult, tableNames, sqlParameters);
            if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
            {
                result = false;
            }

            return result;
        }

        public AccountViewModel Save(AccountViewModel item)
        {
            AccountViewModel result = new AccountViewModel();
            result = Save(item.UserId, item);

            return result;

        }

        public AccountViewModel Save(int id, AccountViewModel item)
        {
            AccountViewModel result = null;

            DataSet dsResult = new DataSet();
            string[] tableNames = new string[] { "CustomerAccessKey" };
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@userId", item.UserId),
                new SqlParameter("@username", item.User),
                new SqlParameter("@email", item.Email),
                new SqlParameter("@password", item.Password),
            };
            SqlHelper.FillDataset(connectionString, CommandType.StoredProcedure, "UserSave", 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 = "saved";
            }

            return result;
        }
    }
}