//end save cartons
/// <summary>
/// append cartons stored in cache datatable
/// </summary>
/// <returns>number of rows</returns>
protected Int32 append_cartons_DEPRECATED(Int32 titleid)
{
Int32 _cartons = 0;
//append cartons with title id
PublishipAdvanceCartonTableCollection _c = new PublishipAdvanceCartonTableCollection();
DataTable _dt = (DataTable)Cache["cartontable"];
if (_dt != null)
{
for (int _ix = 0; _ix < _dt.Rows.Count; _ix++)
{
PublishipAdvanceCartonTable _n = new PublishipAdvanceCartonTable();
_n.PATitleID = titleid;
_n.CartonLength = (decimal)_dt.Rows[_ix]["length"];
_n.CartonWidth = (decimal)_dt.Rows[_ix]["width"];
_n.CartonWeight = (decimal)_dt.Rows[_ix]["weight"];
_n.CartonHeight = (decimal)_dt.Rows[_ix]["height"];
_c.Add(_n);
}
}
_c.SaveAll();
_cartons = _dt.Rows.Count;
return(_cartons);
}
public PublishipAdvanceCartonTableCollection CartonsFetchAll()
{
PublishipAdvanceCartonTableCollection coll = new PublishipAdvanceCartonTableCollection();
Query qry = new Query(PublishipAdvanceCartonTable.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
//end update title
protected Int32 append_carton(Int32 titleid)
{
Int32 _cartons = 0;
int _copies = wwi_func.vint(this.dxtxtcount.Text.ToString());
//append N cartons with title id
PublishipAdvanceCartonTableCollection _c = new PublishipAdvanceCartonTableCollection();
for (int _ix = 0; _ix < _copies; _ix++)
{
PublishipAdvanceCartonTable _n = new PublishipAdvanceCartonTable();
_n.PATitleID = titleid;
_n.CartonLength = Convert.ToDecimal(this.dxtxtlength.Text.ToString());
_n.CartonWidth = Convert.ToDecimal(this.dxtxtwidth.Text.ToString());
_n.CartonWeight = Convert.ToDecimal(this.dxtxtweight.Text.ToString());
_n.CartonHeight = Convert.ToDecimal(this.dxtxtheight.Text.ToString());
_c.Add(_n);
}
_c.SaveAll();
_cartons = _c.Count;
return(_cartons);
}
//end save cartons
/// <summary>
/// append cartons stored in cache datatable
/// </summary>
/// <returns>number of rows</returns>
protected Int32 append_cartons_DEPRECATED(Int32 titleid)
{
Int32 _cartons = 0;
//append cartons with title id
PublishipAdvanceCartonTableCollection _c = new PublishipAdvanceCartonTableCollection();
DataTable _dt = (DataTable)Cache["cartontable"];
if (_dt != null)
{
for (int _ix = 0; _ix < _dt.Rows.Count; _ix++)
{
PublishipAdvanceCartonTable _n = new PublishipAdvanceCartonTable();
_n.PATitleID = titleid;
_n.CartonLength = (decimal)_dt.Rows[_ix]["length"];
_n.CartonWidth = (decimal)_dt.Rows[_ix]["width"];
_n.CartonWeight = (decimal)_dt.Rows[_ix]["weight"];
_n.CartonHeight = (decimal)_dt.Rows[_ix]["height"];
_c.Add(_n);
}
}
_c.SaveAll();
_cartons = _dt.Rows.Count;
return _cartons;
}
//end update title
protected Int32 append_carton(Int32 titleid)
{
Int32 _cartons = 0;
int _copies = wwi_func.vint(this.dxtxtcount.Text.ToString());
//append N cartons with title id
PublishipAdvanceCartonTableCollection _c = new PublishipAdvanceCartonTableCollection();
for (int _ix = 0; _ix < _copies; _ix++)
{
PublishipAdvanceCartonTable _n = new PublishipAdvanceCartonTable();
_n.PATitleID = titleid;
_n.CartonLength = Convert.ToDecimal( this.dxtxtlength.Text.ToString());
_n.CartonWidth = Convert.ToDecimal( this.dxtxtwidth.Text.ToString());
_n.CartonWeight = Convert.ToDecimal( this.dxtxtweight.Text.ToString());
_n.CartonHeight = Convert.ToDecimal( this.dxtxtheight.Text.ToString());
_c.Add(_n);
}
_c.SaveAll();
_cartons = _c.Count;
return _cartons;
}
public PublishipAdvanceCartonTableCollection CartonsFetchByQuery(Query qry)
{
PublishipAdvanceCartonTableCollection coll = new PublishipAdvanceCartonTableCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public PublishipAdvanceCartonTableCollection CartonsFetchByPATitleID(object PATitleID)
{
PublishipAdvanceCartonTableCollection coll = new PublishipAdvanceCartonTableCollection().Where("PATitleID", PATitleID).Load();
return coll;
}
public PublishipAdvanceCartonTableCollection FetchByID(object PubAdvCartonID)
{
PublishipAdvanceCartonTableCollection coll = new PublishipAdvanceCartonTableCollection().Where("PubAdvCartonID", PubAdvCartonID).Load();
return coll;
}
