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);
}
}
