Exemplo n.º 1
0
        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";
            }
        }
Exemplo n.º 2
0
        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");
                    }
                }
            }
        }