public bool ResetCustomerAccountPassword(ResetPasswordModel resetPasswordModel)
{
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (connection)
{
connection.Open();
SqlCommand cmd = new SqlCommand("ChangeCustomerPassword", connection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("Email", resetPasswordModel.Email);
cmd.Parameters.AddWithValue("NewPassword", Password.ConvertToEncrypt(resetPasswordModel.NewPassword));
var returnParameter = cmd.Parameters.Add("@Result", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
CustomerUser customer = new CustomerUser();
SqlDataReader rd = cmd.ExecuteReader();
var result = returnParameter.Value;
if (result != null && result.Equals(1))
{
return(true);
}
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public CustomerUser RegisterDetails(RegisterCustomer registration)
{
try
{
CustomerUser customerUser = new CustomerUser();
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (connection)
{
connection.Open();
//define the SqlCommand Object
SqlCommand cmd = new SqlCommand("spRegisterCustomerDetails", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", registration.CustomerFirstName);
cmd.Parameters.AddWithValue("@LastName", registration.CustomerLastName);
cmd.Parameters.AddWithValue("@PhoneNumber", registration.PhoneNumber);
cmd.Parameters.AddWithValue("@Email", registration.Email);
cmd.Parameters.AddWithValue("@Password", Password.ConvertToEncrypt(registration.Password));
SqlDataReader sqlDataReader = cmd.ExecuteReader();
if (sqlDataReader.HasRows)
{
if (sqlDataReader.Read())
{
customerUser.CustomerID = sqlDataReader.GetInt64(0);
customerUser.CustomerFirstName = sqlDataReader.GetString(1);
customerUser.CustomerLastName = sqlDataReader.GetString(2);
customerUser.Email = sqlDataReader.GetString(3);
customerUser.PhoneNumber = sqlDataReader.GetInt64(4);
}
}
return(customerUser);
//Close Data Reader
sqlDataReader.Close();
connection.Close();
}
}
}
catch (Exception e)
{
throw e;
}
}
public string AdminLogin(LoginAdmin login)
{
try
{
connection.Open();
SqlCommand cmd = new SqlCommand("spInsertAdminLoginDetail", connection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@Email", login.Email);
cmd.Parameters.AddWithValue("@Password", Password.ConvertToEncrypt(login.Password));
var returnParameter = cmd.Parameters.Add("@Result", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
SqlDataReader sqlDataReader = cmd.ExecuteReader();
Admin admin = new Admin();
if (sqlDataReader.HasRows)
{
if (sqlDataReader.Read())
{
admin.AdminID = sqlDataReader.GetInt64(0);
admin.AdminName = sqlDataReader.GetString(1);
admin.PhoneNumber = sqlDataReader.GetInt64(2);
admin.Email = sqlDataReader.GetString(3);
}
}
var result = returnParameter.Value;
if (result != null && result.Equals(2))
{
throw new Exception("AdminID is invalid");
}
if (result != null && result.Equals(3))
{
throw new Exception("wrong password");
}
string token1 = CreateAdminToken(admin);
return(token1);
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
}
public Admin RegisterAdminDetails(RegisterAdmin registration)
{
try
{
Admin admin = new Admin();
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (connection)
{
connection.Open();
//define the SqlCommand Object
SqlCommand cmd = new SqlCommand("RegisterAdminDetails", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AdminName", registration.AdminName);
cmd.Parameters.AddWithValue("@PhoneNumber", registration.PhoneNumber);
cmd.Parameters.AddWithValue("@Email", registration.Email);
cmd.Parameters.AddWithValue("@Password", Password.ConvertToEncrypt(registration.Password));
SqlDataReader sqlDataReader = cmd.ExecuteReader();
if (sqlDataReader.HasRows)
{
if (sqlDataReader.Read())
{
admin.AdminID = sqlDataReader.GetInt64(0);
admin.AdminName = sqlDataReader.GetString(1);
admin.PhoneNumber = sqlDataReader.GetInt64(2);
admin.Email = sqlDataReader.GetString(3);
}
}
return(admin);
//Close Data Reader
sqlDataReader.Close();
connection.Close();
}
}
}
catch (Exception e)
{
throw e;
}
}
public CustomerUser LoginCustomer(LoginCustomer loginCustomerAccount)
{
try
{
loginCustomerAccount.Password = Password.ConvertToEncrypt(loginCustomerAccount.Password);
var result = userRL.LoginCustome(loginCustomerAccount);
if (result != null)
{
result.token = userRL.CreateToken(result);
}
return(result);
}
catch (Exception)
{
throw;
}
}