public SalesDashboard()
{
InitializeComponent();
StringBuilder where = new StringBuilder();
where.Append("gc_from_tbl='sales'");
DataTable dt = db.GCSelectFromDb("transact", null, where);
cryrpt.Load(@"" + view.folderMain + "sales.rpt");
cryrpt.SetDataSource(dt);
crySalesRept.ReportSource = cryrpt;
this.WindowState = FormWindowState.Maximized;
}
public Inventory_Report()
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
StringBuilder where = new StringBuilder();
where.Append("gc_from_tbl='inventory' OR gc_action_name='moved to inventory'");
DataTable dt = db.GCSelectFromDb("transact", null, where);
cryrpt.Load(@"" + view.folderMain + "inventory.rpt");
cryrpt.SetDataSource(dt);
inventoryRpt.ReportSource = cryrpt;
}
private void ProductList_Load(object sender, EventArgs e)
{
StringBuilder paramSupp = new StringBuilder();
StringBuilder paramType = new StringBuilder();
StringBuilder paramBrand = new StringBuilder();
DataTable dt = db.GCSelectFromDb("products", null, null, "ORDER BY id DESC");
dgProducts.DataSource = dt;
cmbSupp.Items.Clear();
cmbItemType.Items.Clear();
paramSupp.Append("DISTINCT gc_supp_name");
paramType.Append("DISTINCT gc_item_type");
paramBrand.Append("DISTINCT gc_item_brand");
DataTable dtSupp = db.GCSelectFromDb("suppliers", paramSupp, null);
DataTable dtType = db.GCSelectFromDb("products", paramType, null);
DataTable dtBrand = db.GCSelectFromDb("products", paramBrand, null);
foreach (DataRow typeRow in dtType.Rows)
{
cmbItemType.Items.Add(typeRow[0].ToString());
}
foreach (DataRow row in dtSupp.Rows)
{
cmbSupp.Items.Add(row[0].ToString());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtSuppName.Text != "" && txtContact.Text != "")
{
StringBuilder whereSearch = new StringBuilder();
whereSearch.Append("gc_supp_name LIKE '" + txtSuppName.Text + "'");
int resSupp = db.searchData("suppliers", null, whereSearch);
if (resSupp >= 1)
{
notification = new notification("Supplier already existing.", notification.AlertType.error);
notification.ShowDialog();
}
else
{
StringBuilder param = new StringBuilder();
StringBuilder values = new StringBuilder();
param.Append(
"gc_supp_name," +
"gc_supp_add," +
"gc_contact," +
"gc_email," +
"gc_other_info"
);
values.Append(
txtSuppName.Text + "," +
txtAddress.Text + "," +
txtContact.Text + "," +
txtEmail.Text + "," +
txtOtherInfo.Text
);
db.GCInsertToDb("suppliers", param, values);
DataTable dt = db.GCSelectFromDb("suppliers", null, null);
dgSuppliers.DataSource = null;
dgSuppliers.DataSource = dt;
notification = new notification("Supplier saved to the database.", notification.AlertType.success);
notification.ShowDialog();
}
}
}
private void LowOnStockDashboard_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'gcDataSet.stock' table. You can move, or remove it, as needed.
this.stockTableAdapter.Fill(this.gcDataSet.stock);
StringBuilder whereLow = new StringBuilder();
whereLow.Append("gc_item_qty < 10");
DataTable dt = db.GCSelectFromDb("stock", null, whereLow);
dgLowStock.DataSource = null;
dgLowStock.DataSource = dt;
}
private void inventoryList_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'gcDataSet.inventory' table. You can move, or remove it, as needed.
DataTable dt = db.GCSelectFromDb("inventory", null, null, "ORDER BY id DESC");
dgStock.DataSource = dt;
}
private void editItem_Load(object sender, EventArgs e)
{
StringBuilder paramSupp = new StringBuilder();
cmbSupp.Items.Clear();
paramSupp.Append("gc_supp_name");
DataTable dtSupp = db.GCSelectFromDb("suppliers", paramSupp, null, "ORDER BY id DESC");
foreach (DataRow row in dtSupp.Rows)
{
cmbSupp.Items.Add(row[0].ToString());
}
}
private void receipt_Load(object sender, EventArgs e)
{
StringBuilder where = new StringBuilder();
if (transID != "")
{
where.Append("gc_unique_id='" + transID + "'");
}
DataTable dt = db.GCSelectFromDb("transact", null, where);
cryrpt.Load(@"" + view.folderMain + "receipt.rpt");
cryrpt.SetDataSource(dt);
rptReceipt.ReportSource = cryrpt;
}
public Transaction()
{
InitializeComponent();
DataTable dt = db.GCSelectFromDb("stock", null, null);
dgStock.DataSource = dt;
lvCart.Columns.Add("Item Name");
lvCart.Columns.Add("Item Code");
lvCart.Columns.Add("Quantity");
lvCart.Columns.Add("Price");
lvCart.Columns.Add("Cost");
lvCart.Columns.Add("U/M");
lvCart.Columns.Add("Description");
lvCart.Columns.Add("Current Quantity");
lvCart.Columns[0].Width = 120;
lvCart.Columns[1].Width = 120;
lvCart.Columns[2].Width = 70;
lvCart.Columns[3].Width = 70;
lvCart.Columns[4].Width = 70;
lvCart.Columns[6].Width = 120;
lvCart.Columns[7].Width = 90;
}
private void Inventory_Main_Load(object sender, EventArgs e)
{
footerLastCode.ForeColor = Color.DarkBlue;
dbGc db = new dbGc();
StringBuilder param = new StringBuilder();
param.Append("gc_item_code");
DataTable dt = db.GCSelectFromDb("products", param, null, " ORDER BY id ASC");
foreach (DataRow row in dt.Rows)
{
footerLastCode.Text = "Last item ID : " + row[0].ToString();
}
prodPage.btnSave.Click += BtnSave_Click;
}
private void Transaction_History_Load(object sender, EventArgs e)
{
StringBuilder where = new StringBuilder();
StringBuilder param = new StringBuilder();
param.Append("DISTINCT gc_unique_id,gc_customer_name,gc_customer_add,gc_trans_date,gc_cust_cash,gc_cust_change");
where.Append("gc_from_tbl='sales'");
DataTable dt = db.GCSelectFromDb("transact", param, where);
dgTransHistory.DataSource = dt;
}
private void Delivery_Load(object sender, EventArgs e)
{
DataTable dt = db.GCSelectFromDb("delivery", null, null, "ORDER BY id DESC");
dgDelivery.DataSource = dt;
StringBuilder param = new StringBuilder();
param.Append("DISTINCT gc_item_name");
DataTable dtRes = db.GCSelectFromDb("inventory", param, null);
foreach (DataRow row in dtRes.Rows)
{
txtItemName.Items.Add(row[0].ToString());
}
}
private void UsersList_Load(object sender, EventArgs e)
{
DataTable dt = db.GCSelectFromDb("users", null, null);
dgUsers.DataSource = dt;
}
private void DeliveryStatusDashboard_Load(object sender, EventArgs e)
{
DataTable dt = db.GCSelectFromDb("delivery", null, null, "ORDER BY id DESC");
dgDelivery.DataSource = dt;
}
private void stockList_Load(object sender, EventArgs e)
{
DataTable dt = db.GCSelectFromDb("stock", null, null, "ORDER BY id DESC");
dgStock.DataSource = dt;
}
