/// <summary>
/// Loads the given ShipZoneProvince object from the given database data reader.
/// </summary>
/// <param name="shipZoneProvince">The ShipZoneProvince object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(ShipZoneProvince shipZoneProvince, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
shipZoneProvince.ShipZoneId = dr.GetInt32(0);
shipZoneProvince.ProvinceId = dr.GetInt32(1);
shipZoneProvince.IsDirty = false;
}
public static ShipZoneProvinceCollection LoadForProvince(Int32 provinceId)
{
ShipZoneProvinceCollection ShipZoneProvinces = new ShipZoneProvinceCollection();
//CREATE THE DYNAMIC SQL TO LOAD OBJECT
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT ShipZoneId");
selectQuery.Append(" FROM ac_ShipZoneProvinces");
selectQuery.Append(" WHERE ProvinceId = @provinceId");
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@provinceId", System.Data.DbType.Int32, provinceId);
//EXECUTE THE COMMAND
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read())
{
ShipZoneProvince shipZoneProvince = new ShipZoneProvince();
shipZoneProvince.ProvinceId = provinceId;
shipZoneProvince.ShipZoneId = dr.GetInt32(0);
ShipZoneProvinces.Add(shipZoneProvince);
}
dr.Close();
}
return(ShipZoneProvinces);
}
public static ShipZoneProvince Load(Int32 shipZoneId, Int32 provinceId)
{
ShipZoneProvince shipZoneProvince = new ShipZoneProvince();
shipZoneProvince.ShipZoneId = shipZoneId;
shipZoneProvince.ProvinceId = provinceId;
shipZoneProvince.IsDirty = false;
return(shipZoneProvince);
}
public static bool Delete(Int32 shipZoneId, Int32 provinceId)
{
ShipZoneProvince shipZoneProvince = new ShipZoneProvince();
if (shipZoneProvince.Load(shipZoneId, provinceId))
{
return(shipZoneProvince.Delete());
}
return(false);
}
public static SaveResult Insert(ShipZoneProvince shipZoneProvince)
{
return(shipZoneProvince.Save());
}
public static bool Delete(ShipZoneProvince shipZoneProvince)
{
return(shipZoneProvince.Delete());
}
public static SaveResult Update(ShipZoneProvince shipZoneProvince)
{
return(shipZoneProvince.Save());
}
){kind=link}