Пример #1
0
        public static ResultSet CRUD(Customers cus, Cate cate, Products pro, Orders ord, Signin sign, EntityState state, string table)
        {
            ResultSet r = new ResultSet();

            try {
                switch (table)
                {
                case "customer": r = HelperCustomer.CRUD(cus, state); break;

                case "category": r = HelperCate.CRUD(cate, state); break;

                case "product": r = HelperProduct.CRUD(pro, state); break;

                case "order": r = HelperOrder.CRUD(ord, state); break;

                case "signin": r = HelperSignin.CRUD(sign, state); break;

                default: break;
                }
                if (r.Message != null)
                {
                    MessageBox.Show(r.Message, "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                }
                return(r);
            }
            catch (Exception e) {
                r.Message = e.Message;
            }
            return(r);
        }
Пример #2
0
 private void button4_Click(object sender, EventArgs e)
 {
     //Ürün düzenle butonu
     if (!String.IsNullOrEmpty(textBox2.Text) && !String.IsNullOrEmpty(textBox3.Text))
     {
         Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value));
         p.productName = textBox2.Text;
         p.unitPrice   = Convert.ToDouble(textBox3.Text);
         p.supplierID  = Convert.ToInt32(comboBox2.SelectedValue);
         p.categoryID  = Convert.ToInt32(comboBox3.SelectedValue);
         p.discount    = Convert.ToInt32(textBox4.Text);
         var degistir = HelperProduct.CUD(p, System.Data.Entity.EntityState.Modified);
         if (degistir.Item2)
         {
             MessageBox.Show("Güncelleme başarılı.");
         }
         else
         {
             MessageBox.Show("Güncelleme yapılamadı.");
         }
         Yenile();
     }
     else
     {
         MessageBox.Show("Lütfen tüm alanları doldurunuz.");
     }
 }
Пример #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            //Stok eklemek için ürün arama butonu
            dataGridView1.Rows.Clear();
            List <ProductModel> pm = new List <ProductModel>();

            if (comboBox1.SelectedIndex == 0)
            {
                pm = HelperProduct.GetListByProductname(textBox1.Text);
            }
            else if (comboBox1.SelectedIndex == 1)
            {
                pm = HelperProduct.GetListByCompanyName(textBox1.Text);
            }
            else if (comboBox1.SelectedIndex == 2)
            {
                pm = HelperProduct.GetListByCategoryName(textBox1.Text);
            }

            foreach (var item in pm)
            {
                if (item.IsActive == true)
                {
                    dataGridView1.Rows.Add(item.productID, item.productName, item.Supplier.companyName, item.category.categoryName, item.unitPrice, item.dateOfAdded, item.stringDiscounted);
                }
            }
            textBox1.Clear();
        }
Пример #4
0
 private void button2_Click(object sender, EventArgs e)
 {
     //Stok ekle Butonu
     if (!String.IsNullOrEmpty(textBox2.Text))
     {
         Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value));
         p.stock += Convert.ToInt32(textBox2.Text);
         var   degistir = HelperProduct.CUD(p, System.Data.Entity.EntityState.Modified);
         Stock s        = new Stock()
         {
             productID   = p.productID,
             dateOfAdded = DateTime.Now,
             count       = Convert.ToInt32(textBox2.Text)
         };
         var ekle = HelperStock.CUD(s, System.Data.Entity.EntityState.Added);
         if (ekle.Item2)
         {
             MessageBox.Show("Stok ekleme başarılı.");
         }
         else
         {
             MessageBox.Show("Stok eklenemedi");
         }
         Yenile();
         DataGrid2Yenile();
         textBox2.Clear();
     }
     else
     {
         MessageBox.Show("Lütfen adet giriniz.");
     }
 }
        private void B_UrunGetir(object sender, EventArgs e)
        {
            flowLayoutPanel2.Controls.Clear();
            List <ProductModel> products = HelperProduct.GetListByCategoryName((sender as Button).Text);
            int           urunsayi       = 0;
            List <string> temp3          = new List <string>();

            foreach (var item in products)
            {
                int stock = HelperStock.GetStockByProductID(item.productID);
                if (item.IsActive == true)
                {
                    if (item.discontinued == false)
                    {
                        if (item.stock > 0)
                        {
                            temp3.Add(item.productName);
                        }
                    }
                }
            }
            urunsayi = temp3.Count;
            for (int i = 0; i < urunsayi; i++)
            {
                urun             = new Button();
                urun.Size        = new Size(100, 50);
                urun.Text        = temp3[i];
                urun.BackColor   = Color.Cyan;
                urun.MouseEnter += Urun_Click;
                urun.MouseLeave += Urun_Click2;
                flowLayoutPanel2.Controls.Add(urun);
                urun.Click += Urun_SipariseEkle;
            }
        }
Пример #6
0
        private void BtRowDelPro_Click(object sender, EventArgs e)
        {
            var pro = HelperProduct.GetProduct(proID);

            if (pro != null)
            {
                var result = MessageBox.Show("Bu işlem geri alınamaz. Yine de silinsin mi?", "SİL?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                if (result == DialogResult.Yes)
                {
                    r = Helper.CRUD(null, null, pro, null, null, EntityState.Deleted, "product");

                    if (r.isSuccess)
                    {
                        DisplayProducts();
                        DisplayOrders();
                        lblWarningPro.Visible = true;
                        lblWarningPro.Text    = "Ürün silindi!";
                    }
                    else
                    {
                        lblWarningPro.Visible = true;
                        lblWarningPro.Text    = r.Message;
                    }
                }
            }
        }
Пример #7
0
 private void button3_Click(object sender, EventArgs e)
 {
     //Ürün silme butonu
     if (!String.IsNullOrEmpty(textBox2.Text) && !String.IsNullOrEmpty(textBox3.Text))
     {
         var a = MessageBox.Show(" Silmek istediğinize emin misiniz?", "Bilgilendirme", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
         if (a == DialogResult.Yes)
         {
             Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value));
             p.IsActive = false;
             var b = HelperProduct.CUD(p, System.Data.Entity.EntityState.Modified);
             if (b.Item2)
             {
                 MessageBox.Show("Silme işlemi başarılı");
             }
             else
             {
                 MessageBox.Show("Silme yapılamadı");
             }
         }
         Yenile();
     }
     else
     {
         MessageBox.Show("Lütfen silinecek ürünü seçiniz.");
     }
 }
Пример #8
0
 void DisplayProducts()
 {
     dgvProducts.Rows.Clear();
     foreach (var item in HelperProduct.GetProductModelList())
     {
         dgvProducts.Rows.Add(item.proName, item.Cate.cateName, item.prePrice, item.salePrice, item.quantity, item.Cate.explanation);
     }
 }
Пример #9
0
        private void CBoxSubCate_SelectedValueChanged(object sender, EventArgs e)
        {
            int subCateID = Convert.ToInt32(cBoxSubCate.SelectedValue);

            cBoxProduct.ValueMember   = "productID";
            cBoxProduct.DisplayMember = "proName";
            cBoxProduct.DataSource    = HelperProduct.GetProductbySubCateModelList(subCateID);
        }
Пример #10
0
        private void FormDisplayProducts_Load(object sender, EventArgs e)
        {
            var list = HelperProduct.GetProductModelList();

            foreach (var item in list)
            {
                dgvProducts.Rows.Add(item.productID, item.proName, item.SubCate.subCateName, item.Cate.cateName, item.proPrice, item.quantity);
            }
        }
Пример #11
0
        private void BtEditPro_Click(object sender, EventArgs e)
        {
            var pro            = HelperProduct.GetProduct(proID);
            int previousCateID = Convert.ToInt32(pro.cateID);

            if (pro != null)
            {
                int c = 0;
                if (!Helper.I(tbProName1.Text))
                {
                    pro.proName = tbProName1.Text; c++;
                }
                if (!Helper.I(tbPrePrice1.Text))
                {
                    pro.prePrice = Convert.ToDouble(tbPrePrice1.Text); c++;
                }
                if (!Helper.I(tbSalePrice1.Text))
                {
                    pro.salePrice = Convert.ToDouble(tbSalePrice1.Text); c++;
                }
                if (!Helper.I(tbStock1.Text))
                {
                    pro.quantity = Convert.ToInt32(tbStock1.Text); c++;
                }
                pro.cateID = Convert.ToInt32(cbCategory1.SelectedValue);
                if (previousCateID != pro.cateID)
                {
                    c++;
                }

                r = Helper.CRUD(null, null, pro, null, null, EntityState.Modified, "product");
                if (r.isSuccess)
                {
                    tbProName1.Clear(); cbCategory1.SelectedIndex = 0;
                    tbPrePrice1.Clear(); tbSalePrice1.Clear(); tbStock1.Clear();
                    DisplayProducts();
                    DisplayOrders();

                    if (c != 0)
                    {
                        lblWarningPro.Visible = true;
                        lblWarningPro.Text    = "Ürün bilgileri düzenlendi!";
                    }
                }

                else
                {
                    lblWarningPro.Visible = true;
                    lblWarningPro.Text    = r.Message;
                }
            }

            gbEditPro.Enabled = false;
        }
Пример #12
0
        private void BtRowEditPro_Click(object sender, EventArgs e)
        {
            var pro = HelperProduct.GetProductModel(proID);

            if (pro != null)
            {
                gbEditPro.Enabled = true;
                tbProName1.Clear(); cbCategory.SelectedIndex = 0;
                tbPrePrice1.Clear(); tbSalePrice1.Clear(); tbStock1.Clear();
            }
        }
Пример #13
0
        public void DataGrid2Yenile()
        {
            dataGridView2.Rows.Clear();
            List <Product> prlst = HelperProduct.GetList();

            foreach (var item in prlst)
            {
                if (item.stock > 0)
                {
                    dataGridView2.Rows.Add(item.productName, item.stock);
                }
            }
        }
Пример #14
0
        public void Yenile()
        {
            dataGridView1.Rows.Clear();
            List <ProductModel> productmodel = HelperProduct.GetProductModelList();

            foreach (var item in productmodel)
            {
                if (item.IsActive == true)
                {
                    dataGridView1.Rows.Add(item.productID, item.productName, item.Supplier.companyName, item.category.categoryName, item.unitPrice, item.dateOfAdded, item.stock, item.stringDiscounted);
                }
            }
        }
Пример #15
0
        void SubDisplayOrders(List <OrderModel> list)
        {
            foreach (var item in list)
            {
                string ctName = HelperCate.GetCate(Convert.ToInt32(HelperProduct.GetProduct(Convert.ToInt32(item.Products.productID)).cateID)).cateName;

                dgvOrders.Rows.Add(item.Customers.cFirstName + " " + item.Customers.cLastName,
                                   ctName, item.Products.proName, item.piece, item.Products.salePrice,
                                   Convert.ToDateTime(item.orderDate).ToShortDateString());

                profit += (Convert.ToDouble(item.Products.salePrice) - Convert.ToDouble(item.Products.prePrice));
            }
            lblProfit.Text = profit.ToString();
        }
Пример #16
0
        private void BtCompleteOrder_Click(object sender, EventArgs e)
        {
            bool result = Helper.I(tbQuantity.Text);

            if (result)
            {
                MessageBox.Show("Adet bilgisini giriniz!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                int custID = HelperCustomer.GetCustomerID(cbCustomers.GetItemText(cbCustomers.SelectedItem));
                var pro    = HelperProduct.GetProduct(sellProID);

                if (pro != null)
                {
                    if (pro.quantity < Convert.ToInt32(tbQuantity.Text))
                    {
                        if (pro.quantity == 0)
                        {
                            MessageBox.Show("Bu ürün tükenmiştir!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                        else
                        {
                            MessageBox.Show($"Bu üründen stokta {pro.quantity} adet kaldı!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                    }

                    else
                    {
                        Orders ord = new Orders {
                            piece      = Convert.ToInt32(tbQuantity.Text),
                            orderDate  = DateTime.Now.Date,
                            productID  = sellProID,
                            customerID = custID
                        };

                        r = Helper.CRUD(null, null, null, ord, null, EntityState.Added, "order");
                        if (r.isSuccess)
                        {
                            pro.quantity -= Convert.ToInt32(tbQuantity.Text);
                            rr            = Helper.CRUD(null, null, pro, null, null, EntityState.Modified, "product");
                        }

                        tbQuantity.Clear();
                        DisplayProducts();
                        DisplayOrders();
                    }
                }
            }
        }
Пример #17
0
        private void BtListCategories_Click(object sender, EventArgs e)
        {
            dgvSellPro.Visible   = true;
            lblSelectPro.Visible = true;

            dgvSellPro.Rows.Clear();
            foreach (var item in HelperProduct.GetProductModelList())
            {
                if (item.Cate.cateName == cbCategoryList.GetItemText(cbCategoryList.SelectedItem))
                {
                    dgvSellPro.Rows.Add(item.proName, item.salePrice, item.Cate.explanation);
                }
            }
        }
Пример #18
0
        private void dataGridView1_SelectionChanged(object sender, EventArgs e)
        {
            dataGridView1.ClearSelection();
            Product  p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value));
            Category c = HelperCategory.GetByID(p.categoryID);
            Supplier s = HelperSupplier.GetByID(p.supplierID);

            textBox2.Text   = p.productName;
            textBox3.Text   = p.unitPrice.ToString();
            textBox4.Text   = p.discount.ToString();
            comboBox2.Text  = s.companyName;
            comboBox3.Text  = c.categoryName;
            button6.Enabled = true;
            button7.Enabled = true;
        }
Пример #19
0
        private void BtUpdProduct_Click(object sender, EventArgs e)
        {
            if (!Helper.isNumber(tbPrice.Text) || !Helper.isNumber(tbStock.Text))
            {
                MessageBox.Show("Fiyat ve stok bilgilerini sayı olarak giriniz!");
            }

            else
            {
                pro.proPrice = Convert.ToDouble(tbPrice.Text);
                pro.quantity = Convert.ToInt32(tbStock.Text);
                var result = HelperProduct.CUD(pro, EntityState.Modified);
                MessageBox.Show(result == true ? "Ürün başarıyla güncellendi!" : "HATA!");
            }
        }
Пример #20
0
        private void DgvSellPro_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            gbSellPro.Visible = true;
            string sellProName = null, sellProPrice = null, sellProExp = null;

            if (dgvSellPro.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
            {
                dgvSellPro.CurrentRow.Selected = true;
                sellProName  = dgvSellPro.Rows[e.RowIndex].Cells["sellProName"].FormattedValue.ToString();
                sellProPrice = dgvSellPro.Rows[e.RowIndex].Cells["sellProPrice"].FormattedValue.ToString();
                sellProExp   = dgvSellPro.Rows[e.RowIndex].Cells["sellProExp"].FormattedValue.ToString();
            }

            sellProID          = HelperProduct.GetProductID(sellProName, Convert.ToDouble(sellProPrice), sellProExp);
            tbSelectedPro.Text = HelperProduct.GetProduct(sellProID).proName;
        }
Пример #21
0
        private void DgvProducts_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            lblWarningPro.Visible = false;
            string proName = null, proCate = null, prePrice = null, salePrice = null, stock = null, explanation = null;

            if (dgvProducts.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
            {
                dgvProducts.CurrentRow.Selected = true;
                proName     = dgvProducts.Rows[e.RowIndex].Cells["proName"].FormattedValue.ToString();
                proCate     = dgvProducts.Rows[e.RowIndex].Cells["proCate"].FormattedValue.ToString();
                prePrice    = dgvProducts.Rows[e.RowIndex].Cells["prePrice"].FormattedValue.ToString();
                salePrice   = dgvProducts.Rows[e.RowIndex].Cells["salePrice"].FormattedValue.ToString();
                stock       = dgvProducts.Rows[e.RowIndex].Cells["stock"].FormattedValue.ToString();
                explanation = dgvProducts.Rows[e.RowIndex].Cells["explanation"].FormattedValue.ToString();
            }

            proID = HelperProduct.GetProductID(proName, proCate, Convert.ToDouble(prePrice), Convert.ToDouble(salePrice), Convert.ToInt32(stock), explanation);
        }
Пример #22
0
        private void DgvProducts_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (command == "updProduct")
            {
                int proID = 0;
                if (dgvProducts.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
                {
                    dgvProducts.CurrentRow.Selected = true;
                    proID = Convert.ToInt32(dgvProducts.Rows[e.RowIndex].Cells["productID"].FormattedValue.ToString());
                }

                var pro = HelperProduct.GetProduct(proID);
                if (pro != null)
                {
                    FormUpdatePro f = new FormUpdatePro(pro);
                    f.Show();
                    this.Hide();
                }
            }

            else if (command == "delProduct")
            {
                int proID = 0;
                if (dgvProducts.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
                {
                    dgvProducts.CurrentRow.Selected = true;
                    proID = Convert.ToInt32(dgvProducts.Rows[e.RowIndex].Cells["productID"].FormattedValue.ToString());
                }

                var pro = HelperProduct.GetProduct(proID);
                if (pro != null)
                {
                    if (HelperOrderDet.SoldProductsList().Contains(proID))
                    {
                        MessageBox.Show("Bu ürün daha önce satıldığı için listeden çıkaramazsınız!");
                    }
                    else
                    {
                        var result = HelperProduct.CUD(pro, EntityState.Deleted);
                        MessageBox.Show(result == true ? "Ürün başarıyla silindi!" : "HATA!");
                    }
                }
            }
        }
Пример #23
0
        private void BtAddPro_Click(object sender, EventArgs e)
        {
            bool result = Helper.I(tbProName.Text) || Helper.I(tbPrePrice.Text) || Helper.I(tbSalePrice.Text) || Helper.I(tbStock.Text);

            if (result)
            {
                MessageBox.Show("Tüm alanları doldurunuz!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }

            else
            {
                List <string> list = new List <string>();
                foreach (var item in HelperProduct.GetProductModelList())
                {
                    list.Add(item.proName);
                }

                if (list.Contains(tbProName.Text))
                {
                    MessageBox.Show("Bu ürün sistemde kayıtlıdır!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }

                else
                {
                    Products pro = new Products {
                        proName   = tbProName.Text,
                        prePrice  = Convert.ToDouble(tbPrePrice.Text),
                        salePrice = Convert.ToDouble(tbSalePrice.Text),
                        quantity  = Convert.ToInt32(tbStock.Text),
                        addDate   = DateTime.Now.Date,
                        cateID    = Convert.ToInt32(cbCategory.SelectedValue)
                    };

                    r = Helper.CRUD(null, null, pro, null, null, EntityState.Added, "product");
                    if (r.isSuccess)
                    {
                        tbProName.Clear(); cbCategory.SelectedIndex = 0;
                        tbPrePrice.Clear(); tbSalePrice.Clear(); tbStock.Clear();
                        DisplayProducts();
                    }
                }
            }
        }
Пример #24
0
 private void button2_Click(object sender, EventArgs e)
 {
     //Ürün ekleme butonu
     if (!String.IsNullOrEmpty(textBox2.Text) && !String.IsNullOrEmpty(textBox3.Text) && !String.IsNullOrEmpty(textBox4.Text))
     {
         if (!HelperProduct.SearchProductName(textBox2.Text))
         {
             MessageBox.Show("Aynı ürün adı mevcut. Lütfen ürün adını değiştiriniz.");
         }
         else
         {
             Product p = new Product()
             {
                 productName  = textBox2.Text,
                 categoryID   = Convert.ToInt32(comboBox3.SelectedValue),
                 supplierID   = Convert.ToInt32(comboBox2.SelectedValue),
                 unitPrice    = Convert.ToDouble(textBox3.Text),
                 discount     = Convert.ToInt32(textBox4.Text),
                 discontinued = false,
                 dateOfAdded  = DateTime.Now,
                 stock        = 0,
                 IsActive     = true
             };
             var ekle = HelperProduct.CUD(p, System.Data.Entity.EntityState.Added);
             if (ekle.Item2)
             {
                 MessageBox.Show("Ürün ekleme başarılı.");
             }
             else
             {
                 MessageBox.Show("Ürün eklenemedi");
             }
             Yenile();
         }
     }
     else
     {
         MessageBox.Show("Lütfen tüm alanları doldurunuz.");
     }
     textBox2.Clear();
     textBox3.Clear();
     textBox4.Clear();
 }
Пример #25
0
        private void button7_Click(object sender, EventArgs e)
        {
            //Satışı devam ettir
            if (!String.IsNullOrEmpty(textBox2.Text) && !String.IsNullOrEmpty(textBox3.Text))
            {
                Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value));
                p.discontinued = false;

                var degistir = HelperProduct.CUD(p, System.Data.Entity.EntityState.Modified);
                if (degistir.Item2)
                {
                    MessageBox.Show("Güncelleme başarılı.");
                }
                else
                {
                    MessageBox.Show("Güncelleme yapılamadı.");
                }
                Yenile();
            }
            else
            {
                MessageBox.Show("Lütfen seçim yapınız.");
            }
        }
Пример #26
0
        private void BtAddToBasket_Click(object sender, EventArgs e)
        {
            int empID = Convert.ToInt32(cBoxEmployee.SelectedValue);
            int proID = Convert.ToInt32(cBoxProduct.SelectedValue);
            var pro   = HelperProduct.GetProduct(proID);

            if (pro != null)
            {
                if (!Helper.isNumber(tbQuantity.Text) || Convert.ToInt32(tbQuantity.Text) <= 0)
                {
                    btAddToBasket.Enabled = false;
                    MessageBox.Show("Hatalı giriş yaptınız!");
                }

                else if (pro.quantity < Convert.ToInt32(tbQuantity.Text))
                {
                    if (pro.quantity == 0)
                    {
                        MessageBox.Show("Bu ürün tükenmiştir!");
                    }
                    else
                    {
                        MessageBox.Show($"Bu üründen stokta {pro.quantity} adet kaldı!");
                    }
                }

                else
                {
                    if (!openOrder)
                    {
                        Orders ord = new Orders {
                            orderDate   = DateTime.Now.Date,
                            orderStatus = "Açık",
                            amount      = 0,
                            customerID  = cusID
                        };

                        var result1 = HelperOrder.CUD(ord, EntityState.Added);
                        if (result1)
                        {
                            openOrder = true;
                            OrderDetails ordDet = new OrderDetails {
                                productID       = proID,
                                priceEach       = HelperProduct.GetProduct(proID).proPrice,
                                quantityOrdered = Convert.ToInt32(tbQuantity.Text),
                                orderID         = ord.orderID,
                                employeeID      = empID
                            };

                            var result2 = HelperOrderDet.CUD(ordDet, EntityState.Added);
                            if (result2)
                            {
                                btFinishOrder.Enabled = true;
                                MessageBox.Show("Ürün sepete eklendi!");
                                ord.amount += ordDet.priceEach * ordDet.quantityOrdered;
                                HelperOrder.CUD(ord, EntityState.Modified);
                            }
                            else
                            {
                                MessageBox.Show("HATA!");
                            }
                        }
                    }

                    else
                    {
                        OrderDetails ordDet = new OrderDetails {
                            productID       = proID,
                            priceEach       = pro.proPrice,
                            quantityOrdered = Convert.ToInt32(tbQuantity.Text),
                            orderID         = HelperOrder.GetOrderList().Count,
                            employeeID      = empID
                        };

                        var ord    = HelperOrder.GetOrder(Convert.ToInt32(ordDet.orderID));
                        var result = HelperOrderDet.CUD(ordDet, EntityState.Added);
                        if (result)
                        {
                            btFinishOrder.Enabled = true;
                            MessageBox.Show("Ürün sepete eklendi!");
                            ord.amount += ordDet.priceEach * ordDet.quantityOrdered;
                            HelperOrder.CUD(ord, EntityState.Modified);
                        }
                        else
                        {
                            MessageBox.Show("HATA!");
                        }
                    }

                    pro.quantity -= Convert.ToInt32(tbQuantity.Text);
                    HelperProduct.CUD(pro, EntityState.Modified);
                }
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            //Satışı tamamla butonu
            //toplam tutar hesapla
            int totalPrice = 0;

            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                totalPrice += Convert.ToInt32(dataGridView1.Rows[i].Cells[5].Value);
            }
            label1.Text = totalPrice.ToString();

            Cashier cashier = HelperCashier.GetByName(label3.Text);

            customer = HelperCustomer.GetByID(customer.CustomerID);
            Order or = new Order()
            {
                customerID = customer.CustomerID,
                orderDate  = DateTime.Now,
                cashierID  = cashier.cashierID,
                totalPrice = Convert.ToInt32(label1.Text),
            };
            var ekle = HelperOrder.CUD(or, System.Data.Entity.EntityState.Added);

            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                p.Add(HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value)));
            }
            int k = 0;

            foreach (var item in p)
            {
                for (; k < dataGridView1.Rows.Count;)
                {
                    item.stock -= Convert.ToInt32(dataGridView1.Rows[k].Cells[4].Value);
                    var a = HelperProduct.CUD(item, System.Data.Entity.EntityState.Modified);
                    break;
                }
                k++;
            }

            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                //fiş için yapılanlar
                List <string> temp       = new List <string>();
                string        ad         = dataGridView1.Rows[i].Cells[0].Value.ToString();
                string        id         = dataGridView1.Rows[i].Cells[1].Value.ToString();
                string        birimFiyat = dataGridView1.Rows[i].Cells[2].Value.ToString();
                string        indirim    = dataGridView1.Rows[i].Cells[3].Value.ToString();
                string        adet       = dataGridView1.Rows[i].Cells[4].Value.ToString();
                string        tutar      = dataGridView1.Rows[i].Cells[5].Value.ToString();
                temp.Add(ad);
                temp.Add(id);
                temp.Add(birimFiyat);
                temp.Add(indirim);
                temp.Add(adet);
                temp.Add(tutar);
                receipt.Add(temp);
            }
            foreach (var item in p)
            {
                ord = new OrderDetail();

                ord.orderID   = or.orderID;
                ord.productID = item.productID;
                ord.unitPrice = item.unitPrice;
                for (; j < dataGridView1.Rows.Count; j++)
                {
                    ord.count = Convert.ToInt32(dataGridView1.Rows[j].Cells[4].Value);
                    break;
                }
                j++;

                var ekle2 = HelperOrderDetail.CUD(ord, System.Data.Entity.EntityState.Added);
            }

            ReceiptForm rpf = new ReceiptForm(receipt, customer, label1.Text);

            rpf.Show();
            this.Hide();
        }
 private void Urun_SipariseEkle(object sender, EventArgs e)
 {
     productModels = HelperProduct.GetListByProductname((sender as Button).Text);
 }