Exemplo n.º 1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (ReturnGrid.Rows.Count > 0)
            {
                bool result = false;
                sqlhelp = new SQLHelper();

                result = sqlhelp.ExecuteNonQuery("insert into Payment(TransactionNo,TotalAmount,DiscountAmount,BillPaid,CreatedBy) values" +
                                                 "('" + lblBillNo.Text + "'," + "-" + TotalActualAmount + "," + lblDiscount.Text + "," + txtTotalRefund.Text + "," + GlobalData.UserID + ")");
                if (result == true)
                {
                    string PaymentId = sqlhelp.ExecuteScalar("select max(PaymentID) from Payment");
                    for (int i = 0; i < ReturnGrid.Rows.Count; i++)
                    {
                        result = sqlhelp.ExecuteNonQuery("Update Transactions set ReturnQty= ((ReturnQty) + (" + int.Parse("-" + ReturnGrid.Rows[i].Cells["Quantity"].Value.ToString()) + ")) where TransactionID=" + ReturnGrid.Rows[i].Cells["TransactionID"].Value.ToString() + "");
                        result = sqlhelp.ExecuteNonQuery("Insert into Transactions(PaymentID,CategoryID,ItemID,Barcode,ItemPrice,SaleQty,ReturnQty,CreatedBy) Values" +
                                                         "(" + PaymentId + "," +
                                                         "" + 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["Item Price"].Value.ToString() + "," +
                                                         "" + int.Parse("-" + ReturnGrid.Rows[i].Cells["Quantity"].Value.ToString()) + "," +
                                                         "" + int.Parse(ReturnGrid.Rows[i].Cells["Quantity"].Value.ToString()) + "," +
                                                         "" + GlobalData.UserID + ")");
                        result = sqlhelp.ExecuteNonQuery("update Stock set StockQuantity= (StockQuantity+" + int.Parse(ReturnGrid.Rows[i].Cells["Quantity"].Value.ToString()) + ")" +
                                                         " where CategoryID=" + ReturnGrid.Rows[i].Cells["CategoryID"].Value.ToString() + "" +
                                                         " and ItemID=" + ReturnGrid.Rows[i].Cells["ItemID"].Value.ToString() + " and Barcode='" + ReturnGrid.Rows[i].Cells["Barcode"].Value.ToString() + "'");
                    }
                }
                if (result == true)
                {
                    FrmMessage.Show("Refund Transaction Successful", caption, OkButton, InformationIcon);
                    SalesReturn f2 = new SalesReturn
                    {
                        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
                    };
                    f2.Show();
                }
            }
            else
            {
                FrmMessage.Show("Please select the Items which you want to return");
            }
        }
Exemplo n.º 2
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            try
            {
                sqlhelp = new SQLHelper();
                ds      = new DataSet();
                dt      = new DataTable();
                if (dt.Columns.Count < 1)
                {
                    dt.Columns.Add("TransactionID");
                    dt.Columns.Add("CategoryID");
                    dt.Columns.Add("Category");
                    dt.Columns.Add("ItemID");
                    dt.Columns.Add("Barcode");
                    dt.Columns.Add("Item");
                    dt.Columns.Add("Quantity");
                    dt.Columns.Add("Item Price");
                    dt.Columns.Add("Total Amount");
                }


                if (string.IsNullOrEmpty(txtSrchTransNo.Text))
                {
                    FrmMessage.Show("Please Enter Your Bill No", caption, OkButton, ErrorIcon);
                }
                else
                {
                    ds = sqlhelp.ExecuteQueries("select * from TransFetch where TransactionNo='" + txtSrchTransNo.Text.Trim() + "'");
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        //dt = ds.Tables[0].Copy();
                        //DataView dView = new DataView(dt);
                        //string[] arrColumns = { "TransactionNo", "Customer Name", "Phone" };
                        //dt = dView.ToTable(true, arrColumns);
                        //dt.AcceptChanges();
                        //if (dt.Rows.Count > 0)
                        //{

                        lblBillNo.Text      = ds.Tables[0].Rows[0]["TransactionNo"].ToString();
                        lblDiscount.Text    = ds.Tables[0].Rows[0]["DiscountAmount"].ToString();
                        lblBookingDate.Text = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedDate"].ToString()).ToString("dd-MM-yyyy");
                        //*************binding values to gridview********************
                        TransGrid.DataSource = ds.Tables[0];
                        TransGrid.Columns["PaymentID"].Visible      = false;
                        TransGrid.Columns["TransactionNo"].Visible  = false;
                        TransGrid.Columns["CategoryID"].Visible     = false;
                        TransGrid.Columns["ItemID"].Visible         = false;
                        TransGrid.Columns["TotalAmount"].Visible    = false;
                        TransGrid.Columns["DiscountAmount"].Visible = false;
                        TransGrid.Columns["BillPaid"].Visible       = false;
                        TransGrid.Columns["CreatedDate"].Visible    = false;
                        TransGrid.Columns["TransactionID"].Visible  = false;
                        TransGrid.Columns["RemainingQty"].Visible   = false;
                        //}
                        //else
                        //{

                        //}

                        ReturnGrid.DataSource = dt;
                        ReturnGrid.Columns["CategoryID"].Visible    = false;
                        ReturnGrid.Columns["ItemID"].Visible        = false;
                        ReturnGrid.Columns["TransactionID"].Visible = false;
                    }
                    else
                    {
                        FrmMessage.Show("No Records found !!!", caption, OkButton, InformationIcon);
                        SalesReturn form = new SalesReturn
                        {
                            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)
            {
            }
        }