//UpdateAccount
public static Boolean EditAccountInfo(AccountViewModel_EditAccountInfo view, string ConnectionString)
{
try
{
DataAccess dataAccess = new DataAccess(ConnectionString, "spAccounts_UpdateInfo");
dataAccess.SetParamater_Input("@AccountID", view.AccountID, SqlDbType.Int);
dataAccess.SetParamater_Input("@FirstName", view.firstname, SqlDbType.VarChar, 100);
dataAccess.SetParamater_Input("@LastName", view.lastname, SqlDbType.VarChar, 100);
dataAccess.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
view.Errors.Add(ex.Message);
return(false);
}
}
//Update Account Info
public static Boolean UpdateAccountInfo(AccountViewModel_EditAccountInfo view, AccountViewModel accountView, string ConnectionString)
{
Boolean Status = true;
view.AccountID = accountView.AccountID;
if (view.firstname == null)
{
view.Errors.Add("Please Input a First Name");
}
if (view.lastname == null)
{
view.Errors.Add("Please Input a Last Name");
}
if (view.AccountID == null)
{
view.Errors.Add("An Unexpected Error Occured");
}
if (view.Errors.Count > 0)
{
return(false);
}
if (view.firstname != accountView.firstname || view.lastname != accountView.lastname)
{
Status = AccountDataAccess.EditAccountInfo(view, ConnectionString) ? Status : false;
}
if (view.email != accountView.email)
{
Status = AccountDataAccess.UpdateAccountEmail(view, ConnectionString) ? Status : false;
}
if (Status)
{
accountView.firstname = view.firstname;
accountView.lastname = view.lastname;
accountView.email = view.email;
}
return(Status);
}
public static Boolean UpdateAccountEmail(AccountViewModel_EditAccountInfo view, string ConnectionString)
{
try
{
DataAccess dataAccess = new DataAccess(ConnectionString, "spAccounts_GenerateEmailVerificationToken");
dataAccess.SetParamater_Input("@AccountID", view.AccountID, SqlDbType.Int);
dataAccess.SetParamater_Input("@UpdatedEmail", view.email, SqlDbType.VarChar, 100);
dataAccess.SetParamater_Output("@outGUID", SqlDbType.VarChar, 100);
dataAccess.SetParamater_Output("@outKey", SqlDbType.VarChar, 100);
dataAccess.ExecuteNonQuery();
view.EmailVerificationToken = (string)(dataAccess.GetParamater("@outGUID"));
view.EmailVerificationKey = (string)(dataAccess.GetParamater("@outKey"));
return(true);
}
catch (Exception ex)
{
view.Errors.Add(ex.Message);
return(false);
}
}
