// 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); } }