//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; }