/// <summary>
/// Deletes a User record
/// </summary>
public static int Delete(UserDO DO)
{
SqlParameter _UserId = new SqlParameter("UserId", SqlDbType.Int);
_UserId.Value = DO.UserId;
SqlParameter[] _params = new SqlParameter[] {
_UserId
};
return DataCommon.ExecuteScalar("[dbo].[User_Delete]", _params, "dbo");
}
public UserVM(UserDO data)
{
this.UserId = data.UserId;
this.FirstName = data.FirstName;
this.LastName = data.LastName;
this.MiddleInitial = data.MiddleInitial;
this.EmailAddress = data.EmailAddress;
this.PhoneNumber = data.PhoneNumber;
this.Address1 = data.Address1;
this.Address2 = data.Address2;
this.City = data.City;
this.State = data.State;
this.ZipCode = data.ZipCode;
}
/// <summary>
/// Creates a new User record
/// </summary>
public static int Create(UserDO DO)
{
SqlParameter _FirstName = new SqlParameter("FirstName", SqlDbType.VarChar);
SqlParameter _LastName = new SqlParameter("LastName", SqlDbType.VarChar);
SqlParameter _MiddleInitial = new SqlParameter("MiddleInitial", SqlDbType.Char);
SqlParameter _EmailAddress = new SqlParameter("EmailAddress", SqlDbType.VarChar);
SqlParameter _PhoneNumber = new SqlParameter("PhoneNumber", SqlDbType.VarChar);
SqlParameter _Address1 = new SqlParameter("Address1", SqlDbType.VarChar);
SqlParameter _Address2 = new SqlParameter("Address2", SqlDbType.VarChar);
SqlParameter _City = new SqlParameter("City", SqlDbType.VarChar);
SqlParameter _State = new SqlParameter("State", SqlDbType.Char);
SqlParameter _ZipCode = new SqlParameter("ZipCode", SqlDbType.VarChar);
_FirstName.Value = DO.FirstName;
_LastName.Value = DO.LastName;
_MiddleInitial.Value = DO.MiddleInitial;
_EmailAddress.Value = DO.EmailAddress;
_PhoneNumber.Value = DO.PhoneNumber;
_Address1.Value = DO.Address1;
_Address2.Value = DO.Address2;
_City.Value = DO.City;
_State.Value = DO.State;
_ZipCode.Value = DO.ZipCode;
SqlParameter[] _params = new SqlParameter[] {
_FirstName,
_LastName,
_MiddleInitial,
_EmailAddress,
_PhoneNumber,
_Address1,
_Address2,
_City,
_State,
_ZipCode
};
return DataCommon.ExecuteScalar("[dbo].[User_Insert]", _params, "dbo");
}
public ActionResult Delete(UserDO user)
{
UserBLL.Delete(user);
return RedirectToAction("Index");
}
/// <summary>
/// Gets all User records
/// </summary>
public static UserDO[] GetAll()
{
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[User_GetAll]", new SqlParameter[] { }, "dbo");
List<UserDO> objs = new List<UserDO>();
while(sr.Read()){
UserDO obj = new UserDO();
obj.UserId = sr.GetInt32(sr.GetOrdinal("UserId"));
obj.FirstName = sr.GetString(sr.GetOrdinal("FirstName"));
obj.LastName = sr.GetString(sr.GetOrdinal("LastName"));
obj.Address1 = sr.GetString(sr.GetOrdinal("Address1"));
obj.City = sr.GetString(sr.GetOrdinal("City"));
obj.State = sr.GetString(sr.GetOrdinal("State"));
obj.ZipCode = sr.GetString(sr.GetOrdinal("ZipCode"));
if (sr.IsDBNull(sr.GetOrdinal("MiddleInitial"))) { obj.MiddleInitial = null; } else { obj.MiddleInitial = sr.GetString(sr.GetOrdinal("MiddleInitial")); }
if (sr.IsDBNull(sr.GetOrdinal("EmailAddress"))) { obj.EmailAddress = null; } else { obj.EmailAddress = sr.GetString(sr.GetOrdinal("EmailAddress")); }
if (sr.IsDBNull(sr.GetOrdinal("PhoneNumber"))) { obj.PhoneNumber = null; } else { obj.PhoneNumber = sr.GetString(sr.GetOrdinal("PhoneNumber")); }
if (sr.IsDBNull(sr.GetOrdinal("Address2"))) { obj.Address2 = null; } else { obj.Address2 = sr.GetString(sr.GetOrdinal("Address2")); }
objs.Add(obj);
}
return objs.ToArray();
}
