// Insert User \/
public CUser.ActionStatusTypes InsertUser(CUser User)
{
try
{
SqlConnection Connection = null;
if (OpenDBConnection(ref Connection) == 0)
{
SqlCommand Command = new SqlCommand("uspAddUser", Connection);
int ReturnValue = -1;
int intEmailList = 0;
if (User.blnEmailList == true)
{
intEmailList = 1;
}
SetParameter(ref Command, "@intUserID", User.UserID, SqlDbType.Int, Direction: ParameterDirection.Output);
SetParameter(ref Command, "@strFirstName", User.FirstName, SqlDbType.VarChar);
SetParameter(ref Command, "@strLastName", User.LastName, SqlDbType.VarChar);
SetParameter(ref Command, "@strEmailAddress", User.EmailAddress, SqlDbType.VarChar);
SetParameter(ref Command, "@dtmDateOfBirth", User.dtmDateOfBirth, SqlDbType.DateTime);
SetParameter(ref Command, "@strPassword", User.Password, SqlDbType.VarChar);
SetParameter(ref Command, "@intStateID", User.intStateID, SqlDbType.Int);
SetParameter(ref Command, "@intGenderID", User.intGenderID, SqlDbType.Int);
SetParameter(ref Command, "@strCity", User.strCity, SqlDbType.VarChar);
SetParameter(ref Command, "@strStreetAddress", User.strAddress, SqlDbType.VarChar);
SetParameter(ref Command, "@strZipCode", User.strZipCode, SqlDbType.VarChar);
SetParameter(ref Command, "@blnAdmin", 0, SqlDbType.Int);
SetParameter(ref Command, "@blnEmailList", intEmailList, SqlDbType.Int);
SetParameter(ref Command, "ReturnValue", 0, SqlDbType.Int, Direction: ParameterDirection.ReturnValue);
Command.ExecuteReader();
ReturnValue = (int)Command.Parameters["ReturnValue"].Value;
CloseDBConnection(ref Connection);
switch (ReturnValue)
{
case 1: // User Updated
User.UserID = (int)Command.Parameters["@intUserID"].Value;
return(CUser.ActionStatusTypes.UserUpdated);
case 2: // User Already Exists
return(CUser.ActionStatusTypes.UserAlreadyExists);
default:
return(CUser.ActionStatusTypes.Unknown);
}
}
else
{
return(CUser.ActionStatusTypes.Unknown);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static CUser GetUser(int intUserID)
{
try
{
CUser User = new CUser();
CDatabase db = new CDatabase();
User = db.GetUser(intUserID);
return(User);
}
catch (Exception)
{
return(null);
}
}
// Update User \
public CUser.ActionStatusTypes UpdateUser(CUser User)
{
try
{
SqlConnection Connection = null;
if (OpenDBConnection(ref Connection) == 0)
{
SqlCommand Command = new SqlCommand("uspEditUser", Connection);
int ReturnValue = -1;
SetParameter(ref Command, "@intUserID", User.UserID, SqlDbType.Int);
SetParameter(ref Command, "@strFirstName", User.FirstName, SqlDbType.VarChar);
SetParameter(ref Command, "@strLastName", User.LastName, SqlDbType.VarChar);
SetParameter(ref Command, "@strEmailAddress", User.EmailAddress, SqlDbType.VarChar);
SetParameter(ref Command, "@strPassword", User.Password, SqlDbType.VarChar);
SetParameter(ref Command, "ReturnValue", 0, SqlDbType.Int, Direction: ParameterDirection.ReturnValue);
Command.ExecuteReader();
ReturnValue = (int)Command.Parameters["ReturnValue"].Value;
CloseDBConnection(ref Connection);
switch (ReturnValue)
{
case 1: // User Updated
return(CUser.ActionStatusTypes.UserUpdated);
case 2: // User Already Exists
return(CUser.ActionStatusTypes.UserAlreadyExists);
default:
return(CUser.ActionStatusTypes.Unknown);
}
}
else
{
return(CUser.ActionStatusTypes.Unknown);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// Insert Address \
public int InsertAddress(CAddress Address)
{
try
{
SqlConnection Connection = null;
if (OpenDBConnection(ref Connection) == 0)
{
int intReturnID = 0;
CUser User = new CUser();
User = User.GetCurrentUser();
SqlCommand cm = new SqlCommand("uspAddAddress", Connection);
SetParameter(ref cm, "@intUserID", User.UserID, SqlDbType.Int);
SetParameter(ref cm, "@strStreetAddress", Address.strAddress, SqlDbType.VarChar);
SetParameter(ref cm, "@strCity", Address.strCity, SqlDbType.VarChar);
SetParameter(ref cm, "@intStateID", Address.intStateID, SqlDbType.Int);
SetParameter(ref cm, "@strZipCode", Address.strZipCode, SqlDbType.VarChar);
SetParameter(ref cm, "ReturnValue", 0, SqlDbType.Int, Direction: ParameterDirection.ReturnValue);
cm.ExecuteReader();
CloseDBConnection(ref Connection);
if (!Convert.IsDBNull(cm.Parameters["ReturnValue"].Value))
{
intReturnID = (int)cm.Parameters["ReturnValue"].Value;
}
return(intReturnID); //success
}
else
{
return(-1); // No database connection
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// Get User \/
public CUser GetUser(int intUserID)
{
SqlConnection Connection = new SqlConnection();
CUser User = new CUser();
int intAdmin = 0;
//List<CUser> UserList = new List<CUser>();
try
{
if (OpenDBConnection(ref Connection) == 0)
{
SqlDataAdapter da = new SqlDataAdapter("uspSelectUser", Connection);
da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
DataSet ds = new DataSet();
if (intUserID != 0)
{
SetParameter(ref da, "@intUserID", intUserID, SqlDbType.Int);
}
else
{
SetParameter(ref da, "@intUserID", null, SqlDbType.Int);
}
try
{
da.Fill(ds);
foreach (DataTable dt in ds.Tables)
{
foreach (DataRow dr in dt.Rows)
{
User.UserID = Convert.ToInt32((dr["intUserID"]));
User.FirstName = (dr["strFirstName"]).ToString();
User.LastName = (dr["strLastName"]).ToString();
User.EmailAddress = (dr["strEmailAddress"]).ToString();
intAdmin = (int)dr["blnAdmin"];
if (intAdmin == 1)
{
User.blnAdmin = true;
}
//UserList.Add(User);
}
}
}
finally
{
CloseDBConnection(ref Connection);
}
}
// return UserList;
return(User);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
