/// <summary>
/// Creates a new instance of the Sol_WS_ShippingContainerTypes class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_WS_ShippingContainerType MakeSol_WS_ShippingContainerType(SqlDataReader dataReader)
{
Sol_WS_ShippingContainerType sol_WS_ShippingContainerType = new Sol_WS_ShippingContainerType();
sol_WS_ShippingContainerType.ShippingContainerTypeID = SqlClientUtility.GetInt32(dataReader, "ShippingContainerTypeID", 0);
sol_WS_ShippingContainerType.ShippingContainerType = SqlClientUtility.GetString(dataReader, "ShippingContainerType", String.Empty);
return(sol_WS_ShippingContainerType);
}
/// <summary>
/// Updates a record in the Sol_WS_ShippingContainerTypes table.
/// </summary>
public virtual void Update(Sol_WS_ShippingContainerType sol_WS_ShippingContainerType)
{
ValidationUtility.ValidateArgument("sol_WS_ShippingContainerType", sol_WS_ShippingContainerType);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ShippingContainerTypeID", sol_WS_ShippingContainerType.ShippingContainerTypeID),
new SqlParameter("@ShippingContainerType", sol_WS_ShippingContainerType.ShippingContainerType)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ShippingContainerTypes_Update", parameters);
}
/// <summary>
/// Selects all records from the Sol_WS_ShippingContainerTypes table.
/// </summary>
public virtual List <Sol_WS_ShippingContainerType> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ShippingContainerTypes_SelectAll"))
{
List <Sol_WS_ShippingContainerType> sol_WS_ShippingContainerTypeList = new List <Sol_WS_ShippingContainerType>();
while (dataReader.Read())
{
Sol_WS_ShippingContainerType sol_WS_ShippingContainerType = MakeSol_WS_ShippingContainerType(dataReader);
sol_WS_ShippingContainerTypeList.Add(sol_WS_ShippingContainerType);
}
return(sol_WS_ShippingContainerTypeList);
}
}
