public void UpdatePurchaseRequestDB(PurchaseRequestDataSet aPurchaseRequestDataSet)
 {
     try
     {
         aPurchaseRequestTableAdapter = new PurchaseRequestDataSetTableAdapters.purchaserequestTableAdapter();
         aPurchaseRequestTableAdapter.Update(aPurchaseRequestDataSet.purchaserequest);
     }
     catch (Exception Ex)
     {
         TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Purchase Request Class // Get Purchase Request Info " + Ex.Message);
     }
 }
        public PurchaseRequestDataSet GetPurchaseRequestInfo()
        {
            try
            {
                aPurchaseRequestDataSet      = new PurchaseRequestDataSet();
                aPurchaseRequestTableAdapter = new PurchaseRequestDataSetTableAdapters.purchaserequestTableAdapter();
                aPurchaseRequestTableAdapter.Fill(aPurchaseRequestDataSet.purchaserequest);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Purchase Request Class // Get Purchase Request Info " + Ex.Message);
            }

            return(aPurchaseRequestDataSet);
        }