public void UpdatePurchaseReqeustItemsDB(PurchaseRequestItemsDataSet aPurchaseRequestItemsDataSet)
 {
     try
     {
         aPurchaseRequestItemsTableAdapter = new PurchaseRequestItemsDataSetTableAdapters.purchaserequestitemsTableAdapter();
         aPurchaseRequestItemsTableAdapter.Update(aPurchaseRequestItemsDataSet.purchaserequestitems);
     }
     catch (Exception Ex)
     {
         TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Purchase Request Items Class // Update Purchase Request Items DB " + Ex.Message);
     }
 }
        public PurchaseRequestItemsDataSet GetPurchaseRequestItemsInfo()
        {
            try
            {
                aPurchaseRequestItemsDataSet      = new PurchaseRequestItemsDataSet();
                aPurchaseRequestItemsTableAdapter = new PurchaseRequestItemsDataSetTableAdapters.purchaserequestitemsTableAdapter();
                aPurchaseRequestItemsTableAdapter.Fill(aPurchaseRequestItemsDataSet.purchaserequestitems);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Purchase Request Items Class // Get Purchase Request Items Info " + Ex.Message);
            }

            return(aPurchaseRequestItemsDataSet);
        }