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