Ejemplo n.º 1
0
        public DatabaseModule()
        {
            db = new RecordsDataSet();
            dbmgr = new TableAdapterManager();
            qadp = new QueriesTableAdapter();

            //Initialize Adapters for Reference Tables
            dbmgr.ClientTableAdapter = new ClientTableAdapter();
            dbmgr.ItemTableAdapter = new ItemTableAdapter();
            dbmgr.WarehouseTableAdapter = new WarehouseTableAdapter();

            //Initialize Adapters for Transaction Tables
            dbmgr.ItemInventoryTableAdapter = new ItemInventoryTableAdapter();
            dbmgr.ReturnsInventoryTableAdapter = new ReturnsInventoryTableAdapter();
            
            dbmgr.ItemReturnedTableAdapter = new ItemReturnedTableAdapter();

            dbmgr.InvoiceTableAdapter = new InvoiceTableAdapter();
            dbmgr.InvoiceItemTableAdapter = new InvoiceItemTableAdapter();

            dbmgr.InventoryMovementTableAdapter = new InventoryMovementTableAdapter();
            dbmgr.ItemServedTableAdapter = new ItemServedTableAdapter();

            dbmgr.ItemReturnedTableAdapter = new ItemReturnedTableAdapter();
            dbmgr.ReturnServedTableAdapter = new ReturnServedTableAdapter();
        }        
        private void invoice_fillDataGrid(RecordsDataSet.InvoiceRow invoice)
        {
            disp_grid_inv.Rows.Clear();

            if (invoice != null)
            {
                RecordsDataSet.InvoiceItemRow[] rows =
                (from invoiceItem in db.InvoiceItem
                 where invoiceItem.invoiceNo.Equals(invoice.invoiceNo)
                 select invoiceItem).ToArray();

                foreach (RecordsDataSet.InvoiceItemRow r in rows)
                {
                    disp_grid_inv.Rows.Add(r.itemId, r.ItemRow.itemName, r.quantity, r.orderStatus);
                }
            }            
        }
Ejemplo n.º 3
0
 public bool ExcludeItemsInDataSet(IList <string> itemsToExclude)
 {
     try
     {
         if (DataSet != null)
         {
             FilteredDataSet = DataSet.CopyExcludingItems(itemsToExclude);
         }
         else
         {
             return(false);
         }
         return(true);
     }
     catch (Exception ex)
     {
         Logger.Log(ex.Message);
         return(false);
     }
 }
        public void CopyExcludingItemsTest()
        {
            var dataSet = new RecordsDataSet
            {
                Headers = new List <string>
                {
                    "test1",
                    "test2",
                    "test3",
                    "test4",
                    "test5"
                },
                Records = new List <DynamicRecord>
                {
                    new DynamicRecord(),
                    new DynamicRecord(),
                    new DynamicRecord(),
                    new DynamicRecord(),
                    new DynamicRecord(),
                }
            };

            Assert.AreEqual(dataSet.Headers.Count, dataSet.Records.Count);

            var columnsToExlude = new List <string>
            {
                "test2",
                "test3",
                "test4"
            };
            var newDataSet = dataSet.CopyExcludingItems(columnsToExlude);

            Assert.AreEqual(newDataSet.Headers.Count, dataSet.Headers.Count - columnsToExlude.Count);
            Assert.AreEqual(newDataSet.Records.Count, dataSet.Records.Count - columnsToExlude.Count);

            Assert.AreNotEqual(newDataSet.Headers.Count, dataSet.Headers.Count);
            Assert.AreNotEqual(newDataSet.Records.Count, dataSet.Records.Count);
        }
Ejemplo n.º 5
0
 public void LoadItemSet(RecordsDataSet data)
 {
     DataSet         = data;
     FilteredDataSet = data;
 }
Ejemplo n.º 6
0
 /*
  *  METHODS
  */
 public void setWarehouse(RecordsDataSet.WarehouseRow warehouse)
 {
     this.warehouse = warehouse;
 }
 private void showInvoiceInfo(RecordsDataSet.InvoiceRow invoice)
 {
     disp_client.Text = invoice.ClientRow.clientName;
     disp_date.Text = invoice.orderDate.ToShortDateString();
 }
Ejemplo n.º 8
0
        private int addInvoiceItems(RecordsDataSet.InvoiceRow invoice)
        {
            foreach (DataGridViewRow r in disp_grid.Rows)
            {
                DataGridViewCellCollection c = r.Cells;

                db.InvoiceItem.AddInvoiceItemRow(
                    invoice,
                    c["itemName"].Value as RecordsDataSet.ItemRow,
                    (int)c["quantity"].Value,
                    "PENDING");
            }

            return disp_grid.Rows.Count;
        }