Example #1
0
        private void grdGrid_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (type == "Buy Order")
                {
                    Buy.FrmBuyOrder form = (Buy.FrmBuyOrder)Application.OpenForms["FrmBuyOrder"];
                    form.grdGrid.CellValueChanged -= form.grdGrid_CellValueChanged;
                    decimal price = decimal.Parse(grdGrid.GetFocusedRowCellValue("Fiyatı").ToString());
                    for (int i = 0; i < form.grdGrid.RowCount - 1; i++)
                    {
                        if (form.grdGrid.GetRowCellValue(i, "Kart Kodu").ToString() == cardCode)
                        {
                            form.grdGrid.SetRowCellValue(i, "Birim Fiyat", price);
                        }
                    }
                    form.Calculate();
                    form.grdGrid.CellValueChanged += form.grdGrid_CellValueChanged;
                    this.Close();
                }

                else if (type == "Sell Order")
                {
                    Sell.FrmSellOrder form = (Sell.FrmSellOrder)Application.OpenForms["FrmSellOrder"];
                    form.grdGrid.CellValueChanged -= form.grdGrid_CellValueChanged;
                    decimal price = decimal.Parse(grdGrid.GetFocusedRowCellValue("Fiyatı").ToString());
                    for (int i = 0; i < form.grdGrid.RowCount - 1; i++)
                    {
                        if (form.grdGrid.GetRowCellValue(i, "Kart Kodu").ToString() == cardCode)
                        {
                            form.grdGrid.SetRowCellValue(i, "Birim Fiyat", price);
                        }
                    }
                    form.Calculate();
                    form.grdGrid.CellValueChanged += form.grdGrid_CellValueChanged;
                    this.Close();
                }
            }
        }
Example #2
0
        private void gridView1_KeyDown(object sender, KeyEventArgs e)
        {
            try
            {
                if (e.KeyCode == Keys.Space)
                {
                    if (gridView1.GetFocusedRowCellValue("Seçim").ToString() == "True")
                    {
                        gridView1.SetFocusedRowCellValue("Seçim", false);
                    }
                    else
                    {
                        gridView1.SetFocusedRowCellValue("Seçim", true);
                    }
                }
                else if (e.KeyCode == Keys.Enter)
                {
                    string  barcode = "";
                    string  oldBarcode, state = "";
                    int     miktar;
                    int     LastListRef;
                    DataRow row;
                    gridView1.Columns[2].UnGroup();

                    #region Plug
                    if (gelen == "Plug")
                    {
                        FrmOperation form = (FrmOperation)Application.OpenForms["FrmOperation"];
                        for (int i = 0; i < gridView1.RowCount; i++)
                        {
                            if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
                            {
                                if (form.grdGrid.RowCount - 1 > 0)
                                {
                                    for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
                                    {
                                        barcode    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
                                        if (barcode == oldBarcode)
                                        {
                                            miktar = int.Parse(form.grdGrid.GetRowCellValue(a, "Miktar").ToString());
                                            miktar++;
                                            form.grdGrid.SetRowCellValue(a, "Miktar", miktar);
                                            state = "true";
                                            break;
                                        }
                                        else
                                        {
                                            state = "false";
                                        }
                                    }
                                    if (state == "false")
                                    {
                                        row               = form.dtBox.NewRow();
                                        row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                        row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                        row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                        row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                        row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                        row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                        row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                        row["Miktar"]     = 1;
                                        form.dtBox.Rows.Add(row);
                                    }
                                }
                                else
                                {
                                    row               = form.dtBox.NewRow();
                                    row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                    row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                    row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                    row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                    row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                    row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                    row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                    row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                    row["Miktar"]     = 1;
                                    form.dtBox.Rows.Add(row);
                                }
                            }
                        }
                    }
                    #endregion

                    #region Sell List
                    else if (gelen == "List")
                    {
                        Sell.FrmSellPrices form = (Sell.FrmSellPrices)Application.OpenForms["FrmSellPrices"];
                        for (int i = 0; i < gridView1.RowCount; i++)
                        {
                            if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
                            {
                                if (form.grdGrid.RowCount - 1 > 0)
                                {
                                    for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
                                    {
                                        barcode    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
                                        if (barcode == oldBarcode)
                                        {
                                            state = "true";
                                            break;
                                        }
                                        else
                                        {
                                            state = "false";
                                        }
                                    }
                                    if (state == "false")
                                    {
                                        row               = form.dtBox.NewRow();
                                        row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                        row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                        row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                        row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                        row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                        row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                        row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                        row["Fiyat"]      = 1;
                                        form.dtBox.Rows.Add(row);
                                    }
                                }
                                else
                                {
                                    row               = form.dtBox.NewRow();
                                    row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                    row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                    row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                    row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                    row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                    row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                    row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                    row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                    row["Fiyat"]      = 1;
                                    form.dtBox.Rows.Add(row);
                                }
                            }
                        }
                    }
                    #endregion

                    #region Kampanya

                    else if (gelen == "Campaing")
                    {
                        Sell.FrmCampaings form = (Sell.FrmCampaings)Application.OpenForms["FrmCampaings"];
                        for (int i = 0; i < gridView1.RowCount; i++)
                        {
                            if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
                            {
                                if (form.grdGrid.RowCount - 1 > 0)
                                {
                                    for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
                                    {
                                        barcode    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
                                        if (barcode == oldBarcode)
                                        {
                                            state = "true";
                                            break;
                                        }
                                        else
                                        {
                                            state = "false";
                                        }
                                    }
                                    if (state == "false")
                                    {
                                        row              = form.dtBox.NewRow();
                                        row["Kart Ref"]  = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                        row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                        row["Kart Adı"]  = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                        row["Renk"]      = gridView1.GetRowCellValue(i, "Renk").ToString();
                                        row["Beden"]     = gridView1.GetRowCellValue(i, "Beden").ToString();
                                        row["Barkod"]    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        form.dtBox.Rows.Add(row);
                                    }
                                }
                                else
                                {
                                    row              = form.dtBox.NewRow();
                                    row["Kart Ref"]  = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                    row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                    row["Kart Adı"]  = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                    row["Renk"]      = gridView1.GetRowCellValue(i, "Renk").ToString();
                                    row["Beden"]     = gridView1.GetRowCellValue(i, "Beden").ToString();
                                    row["Barkod"]    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                    form.dtBox.Rows.Add(row);
                                }
                            }
                        }
                    }

                    #endregion

                    #region İndirim

                    else if (gelen == "Discount")
                    {
                        Sell.FrmDiscount form = (Sell.FrmDiscount)Application.OpenForms["FrmDiscount"];
                        for (int i = 0; i < gridView1.RowCount; i++)
                        {
                            if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
                            {
                                if (form.grdGrid.RowCount - 1 > 0)
                                {
                                    for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
                                    {
                                        barcode    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
                                        if (barcode == oldBarcode)
                                        {
                                            state = "true";
                                            break;
                                        }
                                        else
                                        {
                                            state = "false";
                                        }
                                    }
                                    if (state == "false")
                                    {
                                        row = form.dtBox.NewRow();
                                        row["İndirim Tipi"] = 400;
                                        row["Kart Ref"]     = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                        row["Kart Kodu"]    = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                        row["Kart Adı"]     = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                        row["Renk"]         = gridView1.GetRowCellValue(i, "Renk").ToString();
                                        row["Beden"]        = gridView1.GetRowCellValue(i, "Beden").ToString();
                                        row["Barkod"]       = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        row["Birim Ref"]    = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                        row["Birim Kodu"]   = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();


                                        string paramBarcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        db.AddParameterValue("@branchRef", branchRef);
                                        db.AddParameterValue("@barcode", paramBarcode);
                                        row["Eski Fiyat"] = decimal.Parse(db.GetScalarValue("select  dbo.Tools_GetLastActiveSellPrice(@barcode,@branchRef)").ToString());



                                        form.dtBox.Rows.Add(row);
                                    }
                                }
                                else
                                {
                                    row = form.dtBox.NewRow();
                                    row["İndirim Tipi"] = 400;
                                    row["Kart Ref"]     = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                    row["Kart Kodu"]    = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                    row["Kart Adı"]     = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                    row["Renk"]         = gridView1.GetRowCellValue(i, "Renk").ToString();
                                    row["Beden"]        = gridView1.GetRowCellValue(i, "Beden").ToString();
                                    row["Barkod"]       = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                    row["Birim Ref"]    = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                    row["Birim Kodu"]   = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();



                                    string paramBarcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                    db.AddParameterValue("@branchRef", branchRef);
                                    db.AddParameterValue("@barcode", paramBarcode);
                                    row["Eski Fiyat"] = decimal.Parse(db.GetScalarValue("select  dbo.Tools_GetLastActiveSellPrice(@barcode,@branchRef)").ToString());



                                    form.dtBox.Rows.Add(row);
                                }
                            }
                        }
                    }

                    #endregion

                    #region Buy List
                    else if (gelen == "Buy")
                    {
                        Buy.FrmBuyList form = (Buy.FrmBuyList)Application.OpenForms["FrmBuyList"];
                        for (int i = 0; i < gridView1.RowCount; i++)
                        {
                            if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
                            {
                                if (form.grdGrid.RowCount - 1 > 0)
                                {
                                    for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
                                    {
                                        barcode    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
                                        if (barcode == oldBarcode)
                                        {
                                            state = "true";
                                            break;
                                        }
                                        else
                                        {
                                            state = "false";
                                        }
                                    }
                                    if (state == "false")
                                    {
                                        row               = form.dtBox.NewRow();
                                        row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                        row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                        row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                        row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                        row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                        row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                        row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                        row["Fiyat"]      = 1;
                                        form.dtBox.Rows.Add(row);
                                    }
                                }
                                else
                                {
                                    row               = form.dtBox.NewRow();
                                    row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                    row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                    row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                    row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                    row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                    row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                    row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                    row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                    row["Fiyat"]      = 1;
                                    form.dtBox.Rows.Add(row);
                                }
                            }
                        }
                    }
                    #endregion

                    #region Buy Order
                    if (gelen == "Buy Order")
                    {
                        Buy.FrmBuyOrder form = (Buy.FrmBuyOrder)Application.OpenForms["FrmBuyOrder"];
                        for (int i = 0; i < gridView1.RowCount; i++)
                        {
                            if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
                            {
                                if (form.grdGrid.RowCount - 1 > 0)
                                {
                                    for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
                                    {
                                        barcode    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
                                        if (barcode == oldBarcode)
                                        {
                                            miktar = int.Parse(form.grdGrid.GetRowCellValue(a, "Miktar").ToString());
                                            miktar++;
                                            form.grdGrid.SetRowCellValue(a, "Miktar", miktar);
                                            state = "true";
                                            break;
                                        }
                                        else
                                        {
                                            state = "false";
                                        }
                                    }
                                    if (state == "false")
                                    {
                                        row               = form.dtBox.NewRow();
                                        row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                        row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                        row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                        row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                        row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                        row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                        row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                        row["Miktar"]     = 1;

                                        db.AddParameterValue("@barcode", gridView1.GetRowCellValue(i, "Barkod").ToString());
                                        db.AddParameterValue("@branchRef", form.ledBranch.GetValue());
                                        string price = db.GetScalarValue("select  dbo.Tools_GetLastActiveBuyPrice(@barcode,@branchRef)").ToString();
                                        row["Birim Fiyat"] = price;
                                        decimal total = 1 * decimal.Parse(price);
                                        row["Toplam Tutar"] = total;

                                        form.dtBox.Rows.Add(row);
                                    }
                                }
                                else
                                {
                                    row               = form.dtBox.NewRow();
                                    row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                    row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                    row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                    row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                    row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                    row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                    row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                    row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                    row["Miktar"]     = 1;
                                    db.AddParameterValue("@barcode", gridView1.GetRowCellValue(i, "Barkod").ToString());
                                    db.AddParameterValue("@branchRef", form.ledBranch.GetValue());
                                    string price = db.GetScalarValue("select  dbo.Tools_GetLastActiveBuyPrice(@barcode,@branchRef)").ToString();
                                    row["Birim Fiyat"] = price;
                                    decimal total = 1 * decimal.Parse(price);
                                    row["Toplam Tutar"] = total;
                                    form.dtBox.Rows.Add(row);
                                }
                            }
                        }
                        form.Calculate();
                    }
                    #endregion

                    #region Sell Order
                    if (gelen == "Sell Order")
                    {
                        Sell.FrmSellOrder form = (Sell.FrmSellOrder)Application.OpenForms["FrmSellOrder"];
                        for (int i = 0; i < gridView1.RowCount; i++)
                        {
                            if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
                            {
                                if (form.grdGrid.RowCount - 1 > 0)
                                {
                                    for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
                                    {
                                        barcode    = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
                                        if (barcode == oldBarcode)
                                        {
                                            miktar = int.Parse(form.grdGrid.GetRowCellValue(a, "Miktar").ToString());
                                            miktar++;
                                            form.grdGrid.SetRowCellValue(a, "Miktar", miktar);
                                            state = "true";
                                            break;
                                        }
                                        else
                                        {
                                            state = "false";
                                        }
                                    }
                                    if (state == "false")
                                    {
                                        row               = form.dtBox.NewRow();
                                        row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                        row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                        row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                        row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                        row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                        row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                        row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                        row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                        row["Miktar"]     = 1;

                                        db.AddParameterValue("@barcode", gridView1.GetRowCellValue(i, "Barkod").ToString());
                                        db.AddParameterValue("@branchRef", form.ledBranch.GetValue());
                                        string price = db.GetScalarValue("select  dbo.Tools_GetLastActiveSellPrice(@barcode,@branchRef)").ToString();
                                        row["Birim Fiyat"] = price;
                                        decimal total = 1 * decimal.Parse(price);
                                        row["Toplam Tutar"] = total;

                                        form.dtBox.Rows.Add(row);
                                    }
                                }
                                else
                                {
                                    row               = form.dtBox.NewRow();
                                    row["Kart Ref"]   = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
                                    row["Kart Kodu"]  = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
                                    row["Kart Adı"]   = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
                                    row["Renk"]       = gridView1.GetRowCellValue(i, "Renk").ToString();
                                    row["Beden"]      = gridView1.GetRowCellValue(i, "Beden").ToString();
                                    row["Barkod"]     = gridView1.GetRowCellValue(i, "Barkod").ToString();
                                    row["Birim Ref"]  = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
                                    row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
                                    row["Miktar"]     = 1;
                                    db.AddParameterValue("@barcode", gridView1.GetRowCellValue(i, "Barkod").ToString());
                                    db.AddParameterValue("@branchRef", form.ledBranch.GetValue());
                                    string price = db.GetScalarValue("select  dbo.Tools_GetLastActiveSellPrice(@barcode,@branchRef)").ToString();
                                    row["Birim Fiyat"] = price;
                                    decimal total = 1 * decimal.Parse(price);
                                    row["Toplam Tutar"] = total;
                                    form.dtBox.Rows.Add(row);
                                }
                            }
                        }
                        form.Calculate();
                    }
                    #endregion

                    this.DialogResult = DialogResult.OK;
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                helper.WriteLog(ex);
            }
        }