/// <summary>
 /// update booktitle based in id
 /// </summary>
 /// <param name="booktitle"></param>
 public static void UpdateItem(ItemTable item)
 {
     db4oManager.WithContainer(container =>
     {
         // The office object that is passed to this procedure is not connected to
         // the db4o container so we first have to do that.
         List <ItemTable> _list = (from ItemTable i in container
                                   where i.TitleID == item.TitleID && i.OrderNumber == item.OrderNumber
                                   select i).ToList();
         if (_list != null)
         {
             // Then we should pass the properties from the updated object to the
             // selected one.
             // TODO: Maybe we could make a reflection procedure for this?
             _list[0].OrderNumber = item.OrderNumber;
             _list[0].Title       = item.Title;
             _list[0].Copies      = item.Copies;
             _list[0].Isbn        = item.Isbn;
             _list[0].Impression  = item.Impression;
             _list[0].PONumber    = item.PONumber;
             _list[0].OtherRef    = item.OtherRef;
             _list[0].TotalValue  = item.TotalValue;
             _list[0].SSRNo       = item.SSRNo;
             _list[0].SSRDate     = item.SSRDate;
             _list[0].PerCopy     = item.PerCopy;
             container.Store(_list[0]);
         }
     });
 }
        //end select title
        /// <summary>
        /// returns titleid if save is successful
        /// </summary>
        /// <param name="booktitle"></param>
        /// <returns></returns>
        public static int InsertItem(ItemTable item)
        {
            db4oManager.WithContainer(container =>
            {
                container.Store(item);
            });

            return(item.TitleID);
        }
        public void Update(int TitleID, int?OrderNumber, string Title, string Isbn, string SSRNo, DateTime?SSRDate, string Impression, string PONumber, string OtherRef, int?Copies, DateTime?CopiesLastUpdated, string ItemDesc, int?Packages, int?PackageID, int?Weight, int?Volume, double?PerCopy, decimal?TotalValue, byte[] Ts)
        {
            ItemTable item = new ItemTable();

            item.MarkOld();
            item.IsLoaded = true;

            item.TitleID = TitleID;

            item.OrderNumber = OrderNumber;

            item.Title = Title;

            item.Isbn = Isbn;

            item.SSRNo = SSRNo;

            item.SSRDate = SSRDate;

            item.Impression = Impression;

            item.PONumber = PONumber;

            item.OtherRef = OtherRef;

            item.Copies = Copies;

            item.CopiesLastUpdated = CopiesLastUpdated;

            item.ItemDesc = ItemDesc;

            item.Packages = Packages;

            item.PackageID = PackageID;

            item.Weight = Weight;

            item.Volume = Volume;

            item.PerCopy = PerCopy;

            item.TotalValue = TotalValue;

            item.Ts = Ts;

            item.Save(UserName);
        }
 public bool Destroy(object TitleID)
 {
     return(ItemTable.Destroy(TitleID) == 1);
 }
 public bool Delete(object TitleID)
 {
     return(ItemTable.Delete(TitleID) == 1);
 }