//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 void Insert(int PATitleID,decimal? CartonLength,decimal? CartonWidth,decimal? CartonHeight,decimal? CartonWeight)
{
PublishipAdvanceCartonTable item = new PublishipAdvanceCartonTable();
item.PATitleID = PATitleID;
item.CartonLength = CartonLength;
item.CartonWidth = CartonWidth;
item.CartonHeight = CartonHeight;
item.CartonWeight = CartonWeight;
item.Save(UserName);
}
//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 void CartonUpdate(int PubAdvCartonID, int PATitleID, decimal? CartonLength, decimal? CartonWidth, decimal? CartonHeight, decimal? CartonWeight)
{
PublishipAdvanceCartonTable item = new PublishipAdvanceCartonTable();
item.MarkOld();
item.IsLoaded = true;
item.PubAdvCartonID = PubAdvCartonID;
item.PATitleID = PATitleID;
item.CartonLength = CartonLength;
item.CartonWidth = CartonWidth;
item.CartonHeight = CartonHeight;
item.CartonWeight = CartonWeight;
item.Save(UserName);
}
