private ArrayList rfqList; //All RFQs
//CONSTRUCTOR
public RFQ_MainScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
rfqList = new ArrayList();
//---ADJUST DATAGRIDVIEW APPEARANCE
//Center column headings
dgvRFQ.Columns["RequestDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQ.Columns["RFQNo"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
//Center column cell contents
dgvRFQ.Columns["RFQNo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQ.Columns["RequestDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//---STREAM READER
sql.SelectAllRFQDGV(dgvRFQ); //Populate DGV
sql.SelectAllRFQ(rfqList);
//Sort datagridview by LATEST RFQ Number (Note: When you add an RFQ, it should appear at the top of the DGV)
dgvRFQ.Sort(dgvRFQ.Columns["RFQNo"], ListSortDirection.Descending);
//Default selected row is the first row
if (dgvRFQ.Rows.Count != 0)
{
dgvRFQ.Rows[0].Selected = true;
}
}
public SPR_MainScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
cbbFromMonth.SelectedIndex = 0; //"Select Month"
txtToMonth.Text = DateTime.Now.ToString("MMMM"); //Format shows full month name
txtToYear.Text = DateTime.Now.Year.ToString();
//---ADJUST DATAGRIDVIEW APPEARANCE
//REQUESTS FOR PRICE QUOTATION
dgvRFQStatus.Columns["RequestDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQStatus.Columns["RFQNo"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQStatus.Columns["RFQNo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQStatus.Columns["RequestDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//PRICE QUOTATIONS
dgvPQStatus.Columns["Date"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPQStatus.Columns["PQNo"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPQStatus.Columns["ValidityPeriod"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvPQStatus.Columns["Date"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPQStatus.Columns["PQNo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPQStatus.Columns["ValidityPeriod"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
//PURCHASE ORDERS
dgvPOStatus.Columns["POOrderDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPOStatus.Columns["PODeliveryDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPOStatus.Columns["PONo"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPOStatus.Columns["POOrderDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPOStatus.Columns["PODeliveryDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPOStatus.Columns["PONo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
public PO_MainScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
poList = new ArrayList();
//ADJUST DATAGRIDVIEW COLUMN ALIGNMENT
//Center column headers
dgvPO.Columns["OrderDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPO.Columns["DeliveryDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPO.Columns["PONumber"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
//Center column contents
dgvPO.Columns["OrderDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPO.Columns["DeliveryDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPO.Columns["PONumber"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//TEST CODE (For the purpose of customizing the DGV and checking out its appearance)
/*dgvPO.Rows.Add("09/24/2015", "09/30/2015", "Fat Shaolin Jaideite Kiosk", "BPO#1609-018", "Lucid Co.");
* dgvPO.Rows.Add("11/30/2015", "12/30/2015", "St. Theresa School of Novaliches", "BPO#1611-002", "Fluora’s Shop");
* dgvPO.Rows.Add("09/30/2015", "10/30/2015", "Basic Co.", "BPO#1609-001", "Cinco Company");
* dgvPO.Rows.Add("08/23/2015", "09/15/2015", "Basic Co.", "BPO#1608-041", "Mayers Balay");*/
sql.SelectAllPODGV(dgvPO);
dgvPO.Sort(dgvPO.Columns["PONumber"], ListSortDirection.Descending); //Sort datagridview by LATEST PO Number (Note: When you add a PO, it should appear at the top of the DGV)
sql.SelectAllPO(poList);
}
public PQ_CreateForm()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
itemList = new ArrayList();
sql.SelectAllItems(itemList);
for (int i = 0; i < itemList.Count; i++)
{
Item itemToAdd = (Item)itemList[i];
dgvItemSelection.Rows.Add(itemToAdd.PartNumber,
itemToAdd.ItemName,
itemToAdd.ItemDescription,
itemToAdd.Uom,
itemToAdd.ReicUnitPrice.ToString("0.00"));
}
cbbBillTo.SelectedIndex = 0;
cbbShipTo.SelectedIndex = 0;
cbbInFavorOf.SelectedIndex = 0;
cbbPaymentTerms.SelectedIndex = 0;
cbbDeliveryTerms.SelectedIndex = 0;
customerList = new ArrayList();
//sql.SelectAllSuppliers(customerList);
//customerDropdownList = new ArrayList();
//sql.SelectAllCustomerNames(customerDropdownList);
//customerDropdownList.Sort();
//customerDropdownList.Insert(0, "Select Customer");
//cbbCustomerName.DataSource = customerDropdownList;
pqOrderLineList = new ArrayList();
}
public PQ_MainScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
pqList = new ArrayList();
//---ADJUST DATAGRIDVIEW COLUMN ALIGNMENT
//Center column header
dgvPQ.Columns["Date"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPQ.Columns["PQNumber"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
//Center column contents
dgvPQ.Columns["Date"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPQ.Columns["PQNumber"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//---TEST CODE (For the purpose of customizing the DGV and checking out its appearance)
/*dgvPQ.Rows.Add("11/20/2015", "ABC Company", "ATPI 1611-016", "01/01/2015 - 11/05/2017");
* dgvPQ.Rows.Add("06/10/2015", "Zen Nutrients Co.", "ATPI 1606-005", "02/01/2015 - 12/03/2017");
* dgvPQ.Rows.Add("09/07/2015", "Colette’s Company", "ATPI 1609-048", "03/01/2015 - 09/05/2017");
* dgvPQ.Rows.Add("07/12/2015", "Joy Luck Club", "ATPI 1607-004", "04/01/2015 - 08/02/2017");*/
sql.SelectAllPQDGV(dgvPQ);
dgvPQ.Sort(dgvPQ.Columns["PQNumber"], ListSortDirection.Descending); //Sort datagridview by LATEST PQ Number (Note: When you add a PQ, it should appear at the top of the DGV)
sql.SelectAllPQ(pqList);
}
public LoginScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
//sql.Restore();
ConnectionStringManager.SetMySQLConString("localhost", "root", "", "reicpoms");
}
public Item_MainScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
itemList = new ArrayList();
supplierList = new ArrayList();
sql.SelectAllItemsDGV(dgvItems);
sql.SelectAllItems(itemList);
}
public PQ_CreateFromRFQForm()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
pqList = new ArrayList();
rfqList = new ArrayList();
selectedRFQList = new ArrayList();
sql.SelectAllRFQDGV(dgvRFQSelection);
sql.SelectAllRFQ(rfqList);
}
public RFQ_ViewForm()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
//---ADJUST DATAGRIDVIEW COLUMN ALIGNMENT
//Center column headings
dgvRFQItems.Columns["UOM"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQItems.Columns["Qty"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
//Center column cell contents
dgvRFQItems.Columns["UOM"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQItems.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
public PO_CreateFromPQ()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
pqList = new ArrayList();
poList = new ArrayList();
pqOrderLineList = new ArrayList();
selectedPQList = new ArrayList();
itemList = new ArrayList();
sql.PopulatePOFromPQ(dgvPQSelection);
sql.SelectAllPQ(pqList);
}
public Item_UpdateForm()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
supplierList = new ArrayList();
sql.SelectAllSuppliers(supplierList);
supplierDropdownList = new ArrayList();
sql.SelectAllSupplierNames(supplierDropdownList);
supplierDropdownList.Sort(); //Sort list alphabetically
supplierDropdownList.Insert(0, "Select Supplier");
cbbSupplierName.DataSource = supplierDropdownList;
}
public Supplier_MainScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
supplierIDCounter = 0;
supplierList = new ArrayList();
/*
* //---STREAM READER
* try
* {
* FileStream fs = new FileStream(@"supplier.txt", FileMode.Open);
* StreamReader readin = new StreamReader(fs);
* while (!readin.EndOfStream)
* {
* string[] text = readin.ReadLine().Split('|');
* supplierList.Add(new Supplier(text[0], text[1], text[2], text[3], text[4], text[5])); //Recreate the Supplier
* dgvSuppliers.Rows.Add(text[1], text[2], text[3]);
* supplierIDCounter++;
* }
* readin.Close();
* fs.Close();
* }
* catch (Exception e) { }*/
/*
* //ADJUST DATAGRIDVIEW COLUMN ALIGNMENT
* dgvSuppliers.Columns["PartNo"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //Center column header
* dgvSuppliers.Columns["PartNo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //Center column contents
*/
//TEST CODE (For the purpose of customizing the DGV and checking out its appearance)
/*dgvSuppliers.Rows.Add("Lucid Co.", "Victoria Carpio", "09133933371");
* dgvSuppliers.Rows.Add("Fluora’s Shop", "Marvin Sta. Ana", "09253902271");
* dgvSuppliers.Rows.Add("Cinco Company", "Royce Goden", "09153903125");
* dgvSuppliers.Rows.Add("Mayers Balay", "Angelo Mercado", "09169833371");*/
sql.SelectAllSuppliers(supplierList);
for (int i = 0; i < supplierList.Count; i++)
{
Supplier s = (Supplier)supplierList[i];
dgvSuppliers.Rows.Add(s.SupplierName,
s.SupplierPerson,
s.SupplierNumber,
s.SupplierEmail);
}
supplierIDCounter = supplierList.Count + 1;
}
private int supplierIDFK; //RFQ Foreign Key 2
//CONSTRUCTOR
public RFQ_CreateForm()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
//Instantiate ArrayLists and populate them
customerDropdownList = new ArrayList();
sql.SelectAllCustomerNames(customerDropdownList);
customerDropdownList.Sort(); //Sort list alphabetically
customerDropdownList.Insert(0, "Select Customer");
cbbCustomerName.DataSource = customerDropdownList; //Populate the dropdown
supplierItemList = new ArrayList();
supplierList = new ArrayList(); //Need all the Supplier Details, since there's Supplier auto-complete
sql.SelectAllSuppliers(supplierList);
supplierDropdownList = new ArrayList();
sql.SelectAllSupplierNames(supplierDropdownList);
supplierDropdownList.Sort(); //Sort list alphabetically
supplierDropdownList.Insert(0, "Select Supplier");
cbbSupplierName.DataSource = supplierDropdownList; //Populate the dropdown
//Set default Combo Box values
cbbFilterBy.SelectedIndex = 0; //"Filter by..."
cbbPaymentTerms.SelectedIndex = 0; //"Select"
cbbDeliveryTerms.SelectedIndex = 0; // "Select"
//txtItemName.Text = dgvItemSelection.SelectedRows[0].Cells["ItemName"].Value.ToString(); --> Moved to cbbSupplierName_SelectedIndexChanged
rfqOrderLineList = new ArrayList();
//---ADJUST DATAGRIDVIEW COLUMN ALIGNMENT
//Center column headings
dgvItemSelection.Columns["UOM"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvItemSelection.Columns["UOM"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQItems.Columns["RFQUOM"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQItems.Columns["Qty"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
//Center column cell contents
dgvItemSelection.Columns["PartNo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvItemSelection.Columns["UOM"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQItems.Columns["RFQUOM"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvRFQItems.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//Right-align column headings
dgvItemSelection.Columns["UnitPrice"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
//Right-align column cell contents
dgvItemSelection.Columns["UnitPrice"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
private int customerIDCounter; //Will be used for customer ID
//CONSTRUCTOR
public Customer_MainScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
customerIDCounter = 0;
customerList = new ArrayList();
//---STREAMREADER (MYSQL DATABASE -> ARRAYLIST -> DGV)
sql.SelectAllCustomers(customerList);
for (int i = 0; i < customerList.Count; i++)
{
Customer c = (Customer)customerList[i];
dgvCustomers.Rows.Add(c.CustomerName,
c.CustomerPerson,
c.CustomerNumber,
c.CustomerEmail);
}
customerIDCounter = customerList.Count + 1;
}
public SIDR_MainScreen()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
//ADJUST DATAGRIDVIEW COLUMN ALIGNMENT
dgvSIDR.Columns["Date"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //Center column header
dgvSIDR.Columns["Date"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //Center column contents
dgvSIDR.Columns["SONumber"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //Center column header
dgvSIDR.Columns["SONumber"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //Center column contents
dgvSIDR.Columns["TotalAmount"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; //Right-align column header
dgvSIDR.Columns["TotalAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //Right-align column contents
//TEST CODE (For the purpose of customizing the DGV and checking out its appearance)
dgvSIDR.Rows.Add("11/20/2015", "2327", "ABC Company", "8,692.24");
dgvSIDR.Rows.Add("09/24/2015", "1321", "Fat Shaolin Jaideite Kiosk", "9,243.25");
dgvSIDR.Rows.Add("09/30/2015", "1332", "Balay Dako", "5,555.10");
dgvSIDR.Rows.Add("10/03/2015", "1552", "MGE Transport", "4,351.20");
//Sort datagridview by LATEST SO Number (Note: When you add an SIDR, it should appear at the top of the DGV)
dgvSIDR.Sort(dgvSIDR.Columns["SONumber"], ListSortDirection.Descending);
}
public PO_CreateForm()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
itemList = new ArrayList();
poList = new ArrayList();
pqOrderLineList = new ArrayList();
sql.SelectAllItems(itemList);
for (int i = 0; i < itemList.Count; i++)
{
Item itemToAdd = (Item)itemList[i];
dgvItemSelection.Rows.Add(itemToAdd.PartNumber,
itemToAdd.ItemName,
itemToAdd.ItemDescription,
itemToAdd.Uom,
itemToAdd.ReicUnitPrice.ToString("0.00"));
}
// cbbInFavorOf.SelectedIndex = 0;
// cbbPaymentTerms.SelectedIndex = 0;
// cbbDeliveryTerms.SelectedIndex = 0;
}
public PQ_ViewForm()
{
InitializeComponent();
sql = new MySQLDatabaseDriver();
}
