public Add_Product(int PID)
{
InitializeComponent();
ID = PID;
cmbCategory.DataSource = GeneralMethods.GetCategories();
cmbCategory.DisplayMember = "catname";
cmbCategory.SelectedIndex = -1;
cmbVendor.DataSource = GeneralMethods.GetVendors();
cmbVendor.DisplayMember = "vname";
cmbVendor.SelectedIndex = -1;
DataTable ProductDetails = new DataTable();
ProductDetails = GeneralMethods.GetProductByID(PID);
cmbCategory.Text = (string)ProductDetails.Rows[0][0];
cmbVendor.Text = (string)ProductDetails.Rows[0][1];
txtName.Text = (string)ProductDetails.Rows[0][2];
txtProfit.Text = Convert.ToString(ProductDetails.Rows[0][3]);
rtxtDescription.Text = Convert.ToString(ProductDetails.Rows[0][4]);
btnAddProduct.Visible = false;
btnUpdateProduct.Visible = true;
}
public Sales_Order(int ID)
{
InitializeComponent();
CustID = ID;
//ProductsReceivedTable.Columns.Add("rotid");
//ProductsReceivedTable.Columns.Add("roid");
CartTable.Columns.Add("ID");
CartTable.Columns.Add("Product");
CartTable.Columns.Add("Quantity");
CartTable.Columns.Add("Total Price");
Cart.DataSource = CartTable;
dgvCart.DataSource = Cart;
ProductsData.DataSource = GeneralMethods.GetProductsForSalesOrder();
dgvProducts.DataSource = ProductsData;
dgvProducts.ClearSelection();
cmbVendor.DataSource = GeneralMethods.GetVendors();
cmbVendor.DisplayMember = "vname";
cmbVendor.SelectedIndex = -1;
cmbCategory.DataSource = GeneralMethods.GetCategories();
cmbCategory.DisplayMember = "catname";
cmbCategory.SelectedIndex = -1;
}
private void btnEditVendors_Click(object sender, EventArgs e)
{
Form EditVendors = new Edit_Vendors();
EditVendors.ShowDialog();
cmbVendor.DataSource = GeneralMethods.GetVendors();
cmbVendor.SelectedIndex = -1;
ProductsData.DataSource = GeneralMethods.GetProducts();
}
public Edit_Vendors()
{
InitializeComponent();
VendorsData.DataSource = GeneralMethods.GetVendors();
//dgvVendors.DataSource = VendorsData;
lstVendors.DataSource = VendorsData;
lstVendors.DisplayMember = "vname";
lstVendors.ValueMember = "vid";
}
private void lstVendors_MouseDoubleClick(object sender, MouseEventArgs e)
{
//int id = Convert.ToInt32(dgvVendors.Rows[dgvVendors.CurrentCell.RowIndex].Cells[0].FormattedValue.ToString());
int id = ((int)(lstVendors.SelectedValue));
//string vname = (dgvVendors.Rows[dgvVendors.CurrentCell.RowIndex].Cells[1].FormattedValue.ToString());
string vname = ((DataRowView)(lstVendors.SelectedItem)).Row[1].ToString();
Form EditVendor = new Edit_Vendor_By_ID(id, vname);
EditVendor.ShowDialog();
VendorsData.DataSource = GeneralMethods.GetVendors();
}
public Add_Product()
{
InitializeComponent();
cmbCategory.DataSource = GeneralMethods.GetCategories();
cmbCategory.DisplayMember = "catname";
cmbCategory.SelectedIndex = -1;
cmbCategory.Text = "Choose a Category";
cmbVendor.DataSource = GeneralMethods.GetVendors();
cmbVendor.DisplayMember = "vname";
cmbVendor.SelectedIndex = -1;
cmbVendor.Text = "Choose a Vendor";
}
public Products()
{
InitializeComponent();
ProductsData.DataSource = GeneralMethods.GetProducts();
dgvProducts.DataSource = ProductsData;
dgvProducts.ClearSelection();
cmbVendor.DataSource = GeneralMethods.GetVendors();
cmbVendor.DisplayMember = "vname";
cmbVendor.SelectedIndex = -1;
cmbCategory.DataSource = GeneralMethods.GetCategories();
cmbCategory.DisplayMember = "catname";
cmbCategory.SelectedIndex = -1;
}
