/// <summary>
/// Creates a new Address record
/// </summary>
public static int Create(AddressDO DO)
{
SqlParameter _AddressTypeID = new SqlParameter("AddressTypeID", SqlDbType.VarChar);
SqlParameter _Address1 = new SqlParameter("Address1", SqlDbType.VarChar);
SqlParameter _Address2 = new SqlParameter("Address2", SqlDbType.VarChar);
SqlParameter _POBox = new SqlParameter("POBox", SqlDbType.VarChar);
SqlParameter _City = new SqlParameter("City", SqlDbType.VarChar);
SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar);
SqlParameter _Zipcode = new SqlParameter("Zipcode", SqlDbType.VarChar);
_AddressTypeID.Value = DO.AddressTypeID;
_Address1.Value = DO.Address1;
_Address2.Value = DO.Address2;
_POBox.Value = DO.POBox;
_City.Value = DO.City;
_StateID.Value = DO.StateID;
_Zipcode.Value = DO.Zipcode;
SqlParameter[] _params = new SqlParameter[] {
_AddressTypeID,
_Address1,
_Address2,
_POBox,
_City,
_StateID,
_Zipcode
};
return DataCommon.ExecuteScalar("[dbo].[Address_Insert]", _params, "dbo");
}
/// <summary>
/// Deletes a Address record
/// </summary>
public static int Delete(AddressDO DO)
{
SqlParameter _AddressID = new SqlParameter("AddressID", SqlDbType.Int);
_AddressID.Value = DO.AddressID;
SqlParameter[] _params = new SqlParameter[] {
_AddressID
};
return DataCommon.ExecuteScalar("[dbo].[Address_Delete]", _params, "dbo");
}
/// <summary>
/// Gets all Address records
/// </summary>
public static AddressDO[] GetAll()
{
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Address_GetAll]", new SqlParameter[] { }, "dbo");
List<AddressDO> objs = new List<AddressDO>();
while(sr.Read()){
AddressDO obj = new AddressDO();
obj.AddressID = sr.GetInt32(sr.GetOrdinal("AddressID"));
obj.AddressTypeID = sr.GetString(sr.GetOrdinal("AddressTypeID"));
obj.Address1 = sr.GetString(sr.GetOrdinal("Address1"));
obj.City = sr.GetString(sr.GetOrdinal("City"));
obj.StateID = sr.GetString(sr.GetOrdinal("StateID"));
obj.Zipcode = sr.GetString(sr.GetOrdinal("Zipcode"));
if (sr.IsDBNull(sr.GetOrdinal("Address2"))) { obj.Address2 = null; } else { obj.Address2 = sr.GetString(sr.GetOrdinal("Address2")); }
if (sr.IsDBNull(sr.GetOrdinal("POBox"))) { obj.POBox = null; } else { obj.POBox = sr.GetString(sr.GetOrdinal("POBox")); }
objs.Add(obj);
}
return objs.ToArray();
}
