internal static bool UpdateCustomerDetails(CustomerDetails customer) { bool result = true; try { SqlParameter email = new SqlParameter() { ParameterName = "Email", Value = customer.Email }; SqlParameter firstName = new SqlParameter() { ParameterName = "FirstName", Value = customer.FirstName }; SqlParameter lastName = new SqlParameter() { ParameterName = "LastName", Value = customer.LastName }; SqlParameter dateOfBirth = new SqlParameter() { ParameterName = "DateOfBirth", Value = customer.DateOfBirth }; SqlParameter gender = new SqlParameter() { ParameterName = "Gender", Value = customer.Gender }; SqlParameter phoneNumber = new SqlParameter() { ParameterName = "PhoneNumber", Value = customer.PhoneNumber }; SqlParameter userID = new SqlParameter() { ParameterName = "UserID", Value = customer.UserID }; SqlParameter userImage = new SqlParameter() { ParameterName = "UserImage", Value = customer.Image }; DBHelper.ExecuteStoredProcedure(StoredProcedure.UpdateCustomer, email, firstName, lastName, dateOfBirth, gender, phoneNumber, userID, userImage); } catch (Exception ex) { result = false; throw ex; } return result; }
internal static bool CreateNewCustomer(CustomerDetails newCustomer) { bool result = true; try { SqlParameter email = new SqlParameter() { ParameterName = "Email", Value = newCustomer.Email }; SqlParameter firstName = new SqlParameter() { ParameterName = "FirstName", Value = newCustomer.FirstName }; SqlParameter lastName = new SqlParameter() { ParameterName = "LastName", Value = newCustomer.LastName }; SqlParameter dateOfBirth = new SqlParameter() { ParameterName = "DateOfBirth", Value = newCustomer.DateOfBirth }; SqlParameter gender = new SqlParameter() { ParameterName = "Gender", Value = newCustomer.Gender }; SqlParameter phoneNumber = new SqlParameter() { ParameterName = "PhoneNumber", Value = newCustomer.PhoneNumber }; SqlParameter password = new SqlParameter() { ParameterName = "Password", Value = newCustomer.Password }; SqlParameter image = new SqlParameter() { ParameterName = "UserImage", Value = newCustomer.Image }; DBHelper.ExecuteStoredProcedure(StoredProcedure.SignUpNewCustomer, email, firstName, lastName, dateOfBirth, gender, phoneNumber, password, image); } catch (Exception ex) { result = false; throw ex; } return result; }
internal static bool CreateNewTempCustomer(CustomerDetails newCustomer) { bool result = true; try { SqlParameter email = new SqlParameter() { ParameterName = "Email", Value = newCustomer.Email }; SqlParameter firstName = new SqlParameter() { ParameterName = "FirstName", Value = newCustomer.FirstName }; SqlParameter lastName = new SqlParameter() { ParameterName = "LastName", Value = newCustomer.LastName }; SqlParameter dateOfBirth = new SqlParameter() { ParameterName = "DateOfBirth", Value = newCustomer.DateOfBirth }; SqlParameter gender = new SqlParameter() { ParameterName = "Gender", Value = newCustomer.Gender }; SqlParameter phoneNumber = new SqlParameter() { ParameterName = "PhoneNumber", Value = newCustomer.PhoneNumber }; SqlParameter password = new SqlParameter() { ParameterName = "Password", Value = newCustomer.Password }; SqlParameter image = null; if (newCustomer.Image == null) { image = new SqlParameter(); image.ParameterName = "UserImage"; image.SqlDbType = SqlDbType.Image; image.Value = new byte[0]; } else { image = new SqlParameter() { ParameterName = "UserImage", Value = newCustomer.Image }; } SqlParameter activationToken = new SqlParameter() { ParameterName = "ActivationToken", Value = newCustomer.ActivationToken }; SqlParameter createdDate = new SqlParameter() { ParameterName = "CreatedDate", Value = newCustomer.CreatedDate }; DBHelper.ExecuteStoredProcedure(StoredProcedure.SignUpNewTempCustomer, email, firstName, lastName, dateOfBirth, gender, phoneNumber, password, image, activationToken, createdDate); } catch (Exception ex) { result = false; throw ex; } return result; }
internal static bool CreateNewTempCustomer(CustomerDetails newCustomer) { bool result = true; try { SqlParameter email = new SqlParameter() { ParameterName = "Email", Value = newCustomer.Email }; SqlParameter firstName = new SqlParameter() { ParameterName = "FirstName", Value = newCustomer.FirstName }; SqlParameter lastName = new SqlParameter() { ParameterName = "LastName", Value = newCustomer.LastName }; SqlParameter dateOfBirth = new SqlParameter() { ParameterName = "DateOfBirth", Value = newCustomer.DateOfBirth }; SqlParameter gender = new SqlParameter() { ParameterName = "Gender", Value = newCustomer.Gender }; SqlParameter phoneNumber = new SqlParameter() { ParameterName = "PhoneNumber", Value = newCustomer.PhoneNumber }; SqlParameter password = new SqlParameter() { ParameterName = "Password", Value = newCustomer.Password }; SqlParameter image = null; if (newCustomer.Image == null) { image = new SqlParameter(); image.ParameterName = "UserImage"; image.SqlDbType = SqlDbType.Image; image.Value = new byte[0]; } else { image = new SqlParameter() { ParameterName = "UserImage", Value = newCustomer.Image }; } SqlParameter activationToken = new SqlParameter() { ParameterName = "ActivationToken", Value = newCustomer.ActivationToken }; SqlParameter createdDate = new SqlParameter() { ParameterName = "CreatedDate", Value = newCustomer.CreatedDate }; DBHelper.ExecuteStoredProcedure(StoredProcedure.SignUpNewTempCustomer, email, firstName, lastName, dateOfBirth, gender, phoneNumber, password, image, activationToken, createdDate); } catch (Exception ex) { result = false; throw ex; } return(result); }