public SoldProductForm()
{
InitializeComponent();
if (LoginForm.USERTYPE == "hqmanager")
{
BranchCollection obj = new BranchCollection();
obj.LoadAll();
BranchnamecomboBox1.DataSource = obj.LoadedTable;
BranchnamecomboBox1.ValueMember = "Branch_ID";
BranchnamecomboBox1.DisplayMember = "Branch_Name";
Branchnamelabel2.Visible = false;
BranchProductColletion bpc = new BranchProductColletion();
bpc.LoadAll();
productidcomboBox2.DataSource = bpc.LoadedTable;
productidcomboBox2.DisplayMember = "PName";
productidcomboBox2.ValueMember = "PID";
SoldproducCollection sp = new SoldproducCollection();
sp.LoadAll();
datecomboBox3.DataSource = sp.LoadedTable;
datecomboBox3.ValueMember = "Sold_Date";
datecomboBox3.DisplayMember = "Sold_Date";
SupplierCollection sc = new SupplierCollection();
sc.LoadAll();
supplieridcomboBox4.DataSource = sc.LoadedTable;
supplieridcomboBox4.ValueMember = "Supplier_ID";
supplieridcomboBox4.DisplayMember = "Supplier_Name";
}
else if (LoginForm.USERTYPE == "manager")
{
Branchnamelabel2.Text = LoginForm.BNAME;
BranchnamecomboBox1.Visible = false;
BranchProductColletion bpc = new BranchProductColletion();
bpc.LoadAll2(LoginForm.BRCHID);
productidcomboBox2.DataSource = bpc.LoadedTable;
productidcomboBox2.DisplayMember = "PName";
productidcomboBox2.ValueMember = "PID";
SoldproducCollection sp = new SoldproducCollection();
sp.LoadAll();
datecomboBox3.DataSource = sp.LoadedTable;
datecomboBox3.ValueMember = "Sold_Date";
datecomboBox3.DisplayMember = "Sold_Date";
SupplierCollection sc = new SupplierCollection();
sc.LoadAll();
supplieridcomboBox4.DataSource = sc.LoadedTable;
supplieridcomboBox4.ValueMember = "Supplier_ID";
supplieridcomboBox4.DisplayMember = "Supplier_Name";
}
}
private void Showbutton1_Click(object sender, EventArgs e)
{
if (LoginForm.USERTYPE == "hqmanager")
{
SoldproducCollection spc = new SoldproducCollection();
if (searchbyproductidcheckBox2.Checked == true)
{
int temp1 = Convert.ToInt32(productidcomboBox2.SelectedValue);
int temp2 = Convert.ToInt32(BranchnamecomboBox1.SelectedValue);
if (spc.searchbypid(temp1, temp2) == true)
{
dataGridView1.DataSource = spc.LoadedTable;
}
else
{
MessageBox.Show("this product is not sold");
}
}
else if (searchbyDatecheckBox3.Checked == true)
{
int temp2 = Convert.ToInt32(BranchnamecomboBox1.SelectedValue);
string s = datecomboBox3.SelectedValue.ToString();
if (spc.searchbydate(s, temp2) == true)
{
dataGridView1.DataSource = spc.LoadedTable;
}
else
{
MessageBox.Show("this branch has no product sell yet");
}
}
else if (searchbysupplieridcheckBox1.Checked == true)
{
int temp2 = Convert.ToInt32(BranchnamecomboBox1.SelectedValue);
int temp1 = Convert.ToInt32(supplieridcomboBox4.SelectedValue);
if (spc.searchbysupid(temp2, temp1) == true)
{
dataGridView1.DataSource = spc.LoadedTable;
}
else
{
MessageBox.Show("this supplier has no sale yet");
}
}
}
else if (LoginForm.USERTYPE == "manager")
{
SoldproducCollection spc = new SoldproducCollection();
if (searchbyproductidcheckBox2.Checked == true)
{
int temp1 = Convert.ToInt32(productidcomboBox2.SelectedValue);
int temp2 = LoginForm.BRCHID;
if (spc.searchbypid(temp1, temp2) == true)
{
dataGridView1.DataSource = spc.LoadedTable;
}
else
{
MessageBox.Show("this product is not sold");
}
}
else if (searchbyDatecheckBox3.Checked == true)
{
int temp2 = LoginForm.BRCHID;
string s = datecomboBox3.SelectedValue.ToString();
if (spc.searchbydate(s, temp2) == true)
{
dataGridView1.DataSource = spc.LoadedTable;
}
else
{
MessageBox.Show("this branch has no product sell yet");
}
}
else if (searchbysupplieridcheckBox1.Checked == true)
{
int temp2 = LoginForm.BRCHID;
int temp1 = Convert.ToInt32(supplieridcomboBox4.SelectedValue);
if (spc.searchbysupid(temp2, temp1) == true)
{
dataGridView1.DataSource = spc.LoadedTable;
}
else
{
MessageBox.Show("this supplier has no sale yet");
}
}
}
}