Пример #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (ReturnGrid.Rows.Count == 0 || TransGrid.Rows.Count == 0)
                {
                    FrmMessage.Show("No items were selected for return.");
                }
                else if (string.IsNullOrEmpty(txtReason.Text.Trim()))
                {
                    FrmMessage.Show("Please Enter the reason for return.");
                }
                else
                {
                    if (DialogResult.Yes == FrmMessage.Show("Are You Sure You want to return these items.", caption, YesNoButton, QuestionIcon))
                    {
                        bool result = false;
                        for (int i = 0; i < ReturnGrid.Rows.Count; i++)
                        {
                            result = sqlhelp.ExecuteNonQuery("insert into RETURNTOSUPPLIER (StockID,SUPPLIERID,CATEGORYID,ITEMID,Barcode,RETURNQTY,ITEMPRICE,TOTALAMOUNT,Reason,CREATEDBY) Values " +
                                                             "(" + ReturnGrid.Rows[i].Cells["StockID"].Value.ToString() + "," + ReturnGrid.Rows[i].Cells["SupplierID"].Value.ToString() + "," + ReturnGrid.Rows[i].Cells["CategoryID"].Value.ToString() + "," +
                                                             "" + ReturnGrid.Rows[i].Cells["ItemID"].Value.ToString() + ",'" + ReturnGrid.Rows[i].Cells["Barcode"].Value.ToString() + "'," + ReturnGrid.Rows[i].Cells["Quantity"].Value.ToString() + "," +
                                                             "" + ReturnGrid.Rows[i].Cells["Item Price"].Value.ToString() + "," + ReturnGrid.Rows[i].Cells["Total Amount"].Value.ToString() + ",'" + txtReason.Text.Trim() + "'," + GlobalData.UserID + ")");

                            result = sqlhelp.ExecuteNonQuery("update Stock set StockQuantity= (StockQuantity-" + int.Parse(ReturnGrid.Rows[i].Cells["Quantity"].Value.ToString()) + ")" +
                                                             " where SUPPLIERID=" + ReturnGrid.Rows[i].Cells["SupplierID"].Value.ToString() + " and CATEGORYID=" + ReturnGrid.Rows[i].Cells["CategoryID"].Value.ToString() + "" +
                                                             " and ITEMID=" + ReturnGrid.Rows[i].Cells["ItemID"].Value.ToString() + " and StockID=" + ReturnGrid.Rows[i].Cells["StockID"].Value.ToString() + "");
                        }
                        if (result == true)
                        {
                            FrmMessage.Show("Returned Items to Supplier Successfully");
                            ReturnToSupplier form = new ReturnToSupplier
                            {
                                MdiParent = this.MdiParent,
                                Anchor    = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                                                                                   | System.Windows.Forms.AnchorStyles.Left)
                                                                                  | System.Windows.Forms.AnchorStyles.Right))),
                                Dock = DockStyle.Fill
                            };

                            form.Show();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
            }
        }
Пример #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (dataGridView1.Rows.Count == 0 || dataGridView2.Rows.Count == 0)
                {
                    FrmMessage.Show("No items were selected for return.");
                }
                else if (string.IsNullOrEmpty(textBox1.Text.Trim()))
                {
                    FrmMessage.Show("Please Enter the reason for return.");
                }
                else
                {
                    if (DialogResult.Yes == FrmMessage.Show("Are You Sure You want to return these items to Supplier.", caption, YesNoButton, QuestionIcon))
                    {
                        bool result = false;
                        for (int i = 0; i < dataGridView2.Rows.Count; i++)
                        {
                            result = sqlhelp.ExecuteNonQuery("insert into RETURNITEMSTOSUPPLIER (POID,SUPPLIERID,CATEGORYID,ITEMNAME,RETURNQTY,ITEMPRICE,TOTALAMOUNT,Reason,CREATEDBY) Values " +
                                                             "(" + dataGridView2.Rows[i].Cells["POID"].Value.ToString() + "," + dataGridView2.Rows[i].Cells["SupplierID"].Value.ToString() + "," + dataGridView2.Rows[i].Cells["CategoryID"].Value.ToString() + "," +
                                                             "'" + dataGridView2.Rows[i].Cells["ItemName"].Value.ToString() + "'," + dataGridView2.Rows[i].Cells["Qty"].Value.ToString() + "," +
                                                             "" + dataGridView2.Rows[i].Cells["UnitPrice"].Value.ToString() + "," + dataGridView2.Rows[i].Cells["AfterVat"].Value.ToString() + ",'" + textBox1.Text.Trim() + "'," + GlobalData.UserID + ")");

                            result = sqlhelp.ExecuteNonQuery("update SupplierOrder set Qty= (Qty-" + dataGridView2.Rows[i].Cells["Qty"].Value + "),TotalAmount = (TotalAmount-" + dataGridView2.Rows[i].Cells["BeforeVat"].Value + ")" +
                                                             " where SUPPLIERID=" + dataGridView2.Rows[i].Cells["SupplierID"].Value.ToString() + " and CATEGORYID=" + dataGridView2.Rows[i].Cells["CategoryID"].Value.ToString() + "" +
                                                             " and POID=" + dataGridView2.Rows[i].Cells["POID"].Value.ToString() + " and ItemName='" + dataGridView2.Rows[i].Cells["ItemName"].Value.ToString() + "'");
                        }
                        if (result == true)
                        {
                            FrmMessage.Show("Returned Items to Supplier Successfully Make Sure you Return the Items from Stock for this Item !!");
                            ReturnToSupplier form = new ReturnToSupplier
                            {
                                MdiParent = this.MdiParent,
                                Anchor    = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                                                                                   | System.Windows.Forms.AnchorStyles.Left)
                                                                                  | System.Windows.Forms.AnchorStyles.Right))),
                                Dock = DockStyle.Fill
                            };

                            form.Show();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
            }
        }
Пример #3
0
        private void btnSrchItems_Click(object sender, EventArgs e)
        {
            try
            {
                dtTran  = new DataTable();
                dtTran1 = new DataTable();

                dtTran = sqlhelp.ExecuteTables("Select GS.*,(SH.InvoiceAmount/SH.Qty) as [ItemPrice] from GetStock GS, StockHistory SH where GS.StockID=SH.StockID and GS.SupplierID like'" + ddlsrchsupp.SelectedValue + "' and GS.CategoryID like'" + ddlSrchCat.SelectedValue + "' and GS.ItemID like'" + ddlsrchitem.SelectedValue + "'");
                if (dtTran.Rows.Count > 0)
                {
                    dtTran1 = sqlhelp.ExecuteTables("Select * from ItemSplit where SupplierID like'" + ddlsrchsupp.SelectedValue + "' and CategoryID like'" + ddlSrchCat.SelectedValue + "' and ItemName ='" + ddlsrchitem.Text + "'");
                    if (dtTran1.Rows.Count > 0)
                    {
                        FrmMessage.Show("You can not return this Item, Beacuse This Item Has Splited to lesser Qty !!!");
                    }
                    else
                    {
                        TransGrid.DataSource = dtTran;
                        TransGrid.Columns["ItemPrice"].HeaderText     = "Item Price";
                        TransGrid.Columns["StockID"].Visible          = false;
                        TransGrid.Columns["SupplierID"].Visible       = false;
                        TransGrid.Columns["ItemID"].Visible           = false;
                        TransGrid.Columns["CategoryID"].Visible       = false;
                        TransGrid.Columns["ImageName"].Visible        = false;
                        TransGrid.Columns["ReOrder Qty"].Visible      = false;
                        TransGrid.Columns["StockDescription"].Visible = false;
                    }
                }
                else
                {
                    FrmMessage.Show("No Records Found !!!");
                    ReturnToSupplier rtnStock = new ReturnToSupplier
                    {
                        MdiParent = this,
                        Anchor    = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                                                                           | System.Windows.Forms.AnchorStyles.Left)
                                                                          | System.Windows.Forms.AnchorStyles.Right))),
                        Dock = DockStyle.Fill
                    };

                    rtnStock.Show();
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
            }
        }