private void btnnew_Click(object sender, EventArgs e) { try { dgvSaleBook.DataSource = null; string opration = ""; if (rdbAll.Checked == true) { opration = "All"; } string cashCredit = ""; if (rbtnCash.Checked == true) { opration = "AllCashCredit"; cashCredit = "Cash"; } if (rbtnCredit.Checked == true) { opration = "AllCashCredit"; cashCredit = "Credit"; } DataTable lstSaleBill = TempSaleDetailsController.GetTempSaleBook(Convert.ToDateTime(dtpFromDate.Value.ToShortDateString()), Convert.ToDateTime(dtpToDate.Value.ToShortDateString()), Utility.FinancilaYearId, opration, cashCredit); if (lstSaleBill.Rows.Count > 0) { AddAutoIncrementColumn(lstSaleBill); // DataTable dtSaleBook = SubTot(lstSaleBill); // BindData(dtSaleBook); BindNewData(lstSaleBill); } dgvSaleItems.Rows.Clear(); } catch (Exception ea) { MessageBox.Show(ea.Message); } }
private void dgvSaleBook_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex >= 0) { DataTable dtSaleChallen = TempSaleDetailsController.getTempSaleInvoice(dgvSaleBook.CurrentRow.Cells["salesInvoiceId"].Value.ToString(), Utility.FinancilaYearId); dgvSaleItems.Rows.Clear(); dgvSaleItems.Rows.Add(); foreach (DataRow dr in dtSaleChallen.Rows) { dgvSaleItems.CurrentRow.Cells["itemId"].Value = Convert.ToInt64(dr["itemId"]); dgvSaleItems.CurrentRow.Cells["salesItemDetailsId"].Value = Convert.ToInt64(dr["salesItemDetailsId"]); dgvSaleItems.CurrentRow.Cells["itemName"].ReadOnly = true; dgvSaleItems.CurrentRow.Cells["StockId"].Value = Convert.ToInt64(dr["StockId"]); dgvSaleItems.CurrentRow.Cells["salesChallanId"].Value = 0; dgvSaleItems.CurrentRow.Cells["categoryId"].Value = Convert.ToInt32(dr["categoryId"]); dgvSaleItems.CurrentRow.Cells["companyId"].Value = Convert.ToInt32(dr["companyId"]); dgvSaleItems.CurrentRow.Cells["batchNo"].Value = Convert.ToString(dr["batchNo"]); dgvSaleItems.CurrentRow.Cells["itemName"].Value = dr["itemName"].ToString(); dgvSaleItems.CurrentRow.Cells["HNSCode"].Value = dr["HNSCode"].ToString(); dgvSaleItems.CurrentRow.Cells["Quantity"].Value = dr["quantity"].ToString(); dgvSaleItems.CurrentRow.Cells["unitBy"].Value = dr["unitBy"].ToString(); dgvSaleItems.CurrentRow.Cells["MFD_Date"].Value = dr["MFD_Date"].ToString(); dgvSaleItems.CurrentRow.Cells["expireDate"].Value = dr["expireDate"].ToString(); dgvSaleItems.CurrentRow.Cells["currentstock1"].Value = 0; dgvSaleItems.CurrentRow.Cells["isPesticide"].Value = Convert.ToBoolean(dr["isPesticide"]); dgvSaleItems.CurrentRow.Cells["isFertilizer"].Value = Convert.ToBoolean(dr["isFertilizer"]); dgvSaleItems.CurrentRow.Cells["isSeeds"].Value = Convert.ToBoolean(dr["isSeeds"]); dgvSaleItems.CurrentRow.Cells["isPGROthers"].Value = Convert.ToBoolean(dr["isPGROthers"]); dgvSaleItems.CurrentRow.Cells["invoiceNo"].Value = dr["invoiceNo"].ToString(); dgvSaleItems.CurrentRow.Cells["Rate"].Value = Utility.ParseValue(dr["perQtysalePrice"].ToString()); dgvSaleItems.CurrentRow.Cells["discount"].Value = Utility.ParseValue(dr["discount"].ToString()); dgvSaleItems.CurrentRow.Cells["IGST"].Value = Utility.ParseValue(dr["IGST"].ToString()); dgvSaleItems.CurrentRow.Cells["CGST"].Value = Utility.ParseValue(dr["CGST"].ToString()); dgvSaleItems.CurrentRow.Cells["SGST"].Value = Utility.ParseValue(dr["SGST"].ToString()); double Discount = ((Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["Rate"].Value.ToString()) * Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["discount"].Value.ToString()) / 100)); double saleRateWithDiscount = 0; if (Discount > 0) { saleRateWithDiscount = Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["Rate"].Value.ToString()) - Discount; } else { saleRateWithDiscount = Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["Rate"].Value.ToString()); } dgvSaleItems.CurrentRow.Cells["SaleRatewithGST"].Value = Math.Round(saleRateWithDiscount + (saleRateWithDiscount * Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["IGST"].Value.ToString()) / 100), 2); double purRate = (Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["Quantity"].Value.ToString()) * saleRateWithDiscount); dgvSaleItems.CurrentRow.Cells["SGSTAmt"].Value = Math.Round((Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["SGST"].Value.ToString()) * purRate / 100), 2); dgvSaleItems.CurrentRow.Cells["CGSTAmt"].Value = Math.Round((Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["CGST"].Value.ToString()) * purRate / 100), 2); dgvSaleItems.CurrentRow.Cells["IGSTAmt"].Value = Math.Round((Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["IGST"].Value.ToString()) * purRate / 100), 2); dgvSaleItems.CurrentRow.Cells["CGSTAmt"].Value = Math.Round((Utility.ParseValue(dr["CGST"].ToString()) * purRate / 100), 2); dgvSaleItems.CurrentRow.Cells["SGSTAmt"].Value = Math.Round((Utility.ParseValue(dr["SGST"].ToString()) * purRate / 100), 2); dgvSaleItems.CurrentRow.Cells["IGSTAmt"].Value = Math.Round(Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["CGSTAmt"].Value.ToString()) + Convert.ToDouble(dgvSaleItems.CurrentRow.Cells["SGSTAmt"].Value), 2); // dgvSaleItems.CurrentRow.Cells["totalAmount"].Value = purRate; dgvSaleItems.CurrentRow.Cells["totalAmount"].Value = Math.Round(Convert.ToDouble(purRate + Utility.ParseValue(dgvSaleItems.CurrentRow.Cells["IGSTAmt"].Value.ToString())), 2).ToString(); // dgvSaleItems.Focus(); dgvSaleItems.CurrentCell = dgvSaleItems.CurrentRow.Cells["Quantity"]; dgvSaleItems.BeginEdit(true); int col = dgvSaleItems.CurrentCell.ColumnIndex; int row = dgvSaleItems.CurrentCell.RowIndex; col = 0; row++; if (dgvSaleItems.Rows.Count < dtSaleChallen.Rows.Count) { if (row == dgvSaleItems.RowCount) { dgvSaleItems.Rows.Add(); dgvSaleItems.CurrentCell = dgvSaleItems[col + 5, row]; } else { dgvSaleItems.CurrentCell = dgvSaleItems[col, row]; } } } } dgvSaleItems.ClearSelection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }