how to apply CGST,SGST,IGST Tax in Billing Format in window

Jyoti Jodha

how to apply CGST,SGST,IGST Tax in Billing Format in windows Application c#

i Want to my billing formate show like this

S no	item	HSn	QTY	Unit	Rate	total	Discount	Taxable values	CGST		SGST		IGST
									Rate	Amt	Rate	amt	Rate	amt
1	abc	3405898	5	pic	20	100	-	100	18%	10	-	-	18%	10
2	aqw	65656	8	pic	500	400	-	400	15%	60	3%	12	18%	72
Total						500		500	70		12		82

but my Billing formate like this

21 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
add text boxes for
CGST rate,SGST rate,IGST rate
and based on this you have to calculate and display amt respectivly in grid
then you have to save all these (CGST rate,CGST amt,SGST rate,SGST amt,IGST rate,IGST rate) in table for later use so that you will get all the details later
0
Jyoti Jodha9y ago
yes,
we adding 3 dropdown

i am adding 3 dropdown in another form
and i am want to apply in mainform

how to dropdown selete values apply in mainform
and dropdown is a another form
0
Rafnas T P9y ago
sorry, I didn't get you, are you adding 3 dropdown in this form
0
Jyoti Jodha9y ago
select combobox values apply in GST Formate
if we select 1 combobox then apply 1 combobox
if we select 2 combobox then apply 2 combobox
if we select 3 combobox then apply 3 combobox
0
Rafnas T P9y ago
combobox means you wanted to select any one of this and save.
not all of them
0
Jyoti Jodha9y ago
Hello Rafnas
i am want to

add
combobox and text boxes for
CGST rate,SGST rate,IGST rate
in a other form
when we select combobox in insert values in textbox
these values apply in mainbillform ....????

0
Karthi Keyan9y ago
@Jodha,

Read my Previous replay again and again untill you understand.. i told everything you want in that. Just read that again.
0
Jyoti Jodha9y ago
After this
What doing....??
0
Karthi Keyan9y ago
@jodha,

I already post the replay jodha... you want to do like this. tax calclation in diff function and adding values to the grid in your button click. because there are three tax calculation now. but previous you had only one tax calculation. so you added that in button click. but not like that now. so you want to seperate that tax calculation code. when the user enter the values to the three tax textboxes you should call the tax calculation function. for that you want to pass the arguments(tax percentage) to the taxcal function. after calcuate the three taxes add that to your totalamount. and finally add this values to your grid.

public double taxcal(string tax)
{
decimal Qty = Convert.ToDecimal(txtqty.Text);
decimal Unit_Price = Convert.ToDecimal(qtytxtprice.Text);
decimal Tax = Convert.ToDecimal(tax);
decimal Amount = (Qty * Unit_Price);
decimal PercentageAmount = ((Amount * Tax) / 100);
decimal TotalAmount = Amount + PercentageAmount; ///no need this line here. remove.

return PercentageAmount; // Add this.
}

// After calculate the Each tax finally add that values to TotalAmount And Add to grid.

private void addbutton_Click(object sender, EventArgs e)
{
int Sno = dataGridView.Rows.Count + 1;
dataGridView.Rows.Add(Sno, comboBoxproduct.Text, dectxt.Text,txthsn.Text, txtqty.Text, combounit.Text, qtytxtprice.Text, txttax.SelectedValue, Totaltxt.Text, comboBoxproduct.SelectedValue, combounit.SelectedValue);
btnclr_Click(sender, e);
CalculateTotalAmount();
ClearData();
int i = 1;
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
g1.Cells[0].Value = i;
i++;
}
}
0
Jyoti Jodha9y ago
this is my addbutton code

private void addbutton_Click(object sender, EventArgs e)
{
try
{
if (addbutton.Text == "Update" && editrowindex != -1)
{
dataGridView.Rows.RemoveAt(editrowindex);
editrowindex = -1;
addbutton.Text = "Add";
}
}
catch { }
if (comboBoxproduct.Text != "" && qtytxtprice.Text != "" && txtqty.Text != "" && txttax.Text != "" && combounit.Text != "")
{
decimal Qty = Convert.ToDecimal(txtqty.Text);
decimal Unit_Price = Convert.ToDecimal(qtytxtprice.Text);
decimal Tax = Convert.ToDecimal(txttax.SelectedValue);
decimal Amount = (Qty * Unit_Price);
decimal PercentageAmount = ((Amount * Tax) / 100);
return PercentageAmount;
//decimal TotalAmount = Amount + PercentageAmount;
int Sno = dataGridView.Rows.Count + 1;
dataGridView.Rows.Add(Sno, comboBoxproduct.Text, dectxt.Text,txthsn.Text, txtqty.Text, combounit.Text, qtytxtprice.Text, txttax.SelectedValue, Totaltxt.Text, comboBoxproduct.SelectedValue, combounit.SelectedValue);
btnclr_Click(sender, e);
CalculateTotalAmount();
ClearData();
int i = 1;
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
g1.Cells[0].Value = i;
i++;
}
}
}

0
Karthi Keyan9y ago
@jodha,

Can you share your code.
0
Jyoti Jodha9y ago
show this Error

Error 2 Since 'Billform.MainBillfrm.addbutton_Click(object, System.EventArgs)' returns void, a return keyword must not be followed by an object expression
0
Karthi Keyan9y ago
@jodha,

See my previous replay.
0
Jyoti Jodha9y ago
how to modify addbutton_Click code
0
Karthi Keyan9y ago
@jodha,

you want to modify All tax codes and Datagrid codes for that three GST Taxes. so 1st do the plan, you already did something. now you want to inlcude these things into your form. so how you can modify the code without any cause. plan->analyse->implement. Follow this. Take your time to Analyse. that is important.
0
Jyoti Jodha9y ago
// Insert data in Grid view
private void addbutton_Click(object sender, EventArgs e)
{
try
{
if (addbutton.Text == "Update" && editrowindex != -1)
{
dataGridView.Rows.RemoveAt(editrowindex);
editrowindex = -1;
addbutton.Text = "Add";
}
}
catch { }
if (comboBoxproduct.Text != "" && qtytxtprice.Text != "" && txtqty.Text != "" && txttax.Text != "" && combounit.Text != "")
{
decimal Qty = Convert.ToDecimal(txtqty.Text);
decimal Unit_Price = Convert.ToDecimal(qtytxtprice.Text);
decimal Tax = Convert.ToDecimal(txttax.SelectedValue);
decimal Amount = (Qty * Unit_Price);
decimal PercentageAmount = ((Amount * Tax) / 100);
decimal TotalAmount = Amount + PercentageAmount;
int Sno = dataGridView.Rows.Count + 1;
dataGridView.Rows.Add(Sno, comboBoxproduct.Text, dectxt.Text,txthsn.Text, txtqty.Text, combounit.Text, qtytxtprice.Text, txttax.SelectedValue, Totaltxt.Text, comboBoxproduct.SelectedValue, combounit.SelectedValue);
btnclr_Click(sender, e);
CalculateTotalAmount();
ClearData();
int i = 1;
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
g1.Cells[0].Value = i;
i++;
}
}
}
0
Karthi Keyan9y ago
@jodha,

You want seperate that code. Seprate the Tax Calcuation and Adding Values to the grid. like follow.

public double taxcal()
{
decimal Qty = Convert.ToDecimal(txtqty.Text);
decimal Unit_Price = Convert.ToDecimal(qtytxtprice.Text);
decimal Tax = Convert.ToDecimal(txttax.SelectedValue);
decimal Amount = (Qty * Unit_Price);
decimal PercentageAmount = ((Amount * Tax) / 100);
decimal TotalAmount = Amount + PercentageAmount; ///no need this line here. remove.

return PercentageAmount; // Add this.
}

// After calculate the Each tax finally add that values to TotalAmount And Add to grid.

private void addbutton_Click(object sender, EventArgs e)
{
int Sno = dataGridView.Rows.Count + 1;
dataGridView.Rows.Add(Sno, comboBoxproduct.Text, dectxt.Text,txthsn.Text, txtqty.Text, combounit.Text, qtytxtprice.Text, txttax.SelectedValue, Totaltxt.Text, comboBoxproduct.SelectedValue, combounit.SelectedValue);
btnclr_Click(sender, e);
CalculateTotalAmount();
ClearData();
int i = 1;
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
g1.Cells[0].Value = i;
i++;
}
}
+1
Jyoti Jodha9y ago
how to change in this code....

private void addbutton_Click(object sender, EventArgs e)
{
decimal Qty = Convert.ToDecimal(txtqty.Text);
decimal Unit_Price = Convert.ToDecimal(qtytxtprice.Text);
decimal Tax = Convert.ToDecimal(txttax.SelectedValue);
decimal Amount = (Qty * Unit_Price);
decimal PercentageAmount = ((Amount * Tax) / 100);
decimal TotalAmount = Amount + PercentageAmount;
int Sno = dataGridView.Rows.Count + 1;
dataGridView.Rows.Add(Sno, comboBoxproduct.Text, dectxt.Text,txthsn.Text, txtqty.Text, combounit.Text, qtytxtprice.Text, txttax.SelectedValue, Totaltxt.Text, comboBoxproduct.SelectedValue, combounit.SelectedValue);
btnclr_Click(sender, e);
CalculateTotalAmount();
ClearData();
int i = 1;
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
g1.Cells[0].Value = i;
i++;
}
}
}

decimal _subTotal = 0;
public void CalculateTotalAmount()
{
decimal taxtotal=0;
decimal totalamount=0;
for(int i=0;i
{
decimal TotalAmount = (Convert.ToDecimal(dataGridView.Rows[i].Cells[4].Value) * Convert.ToDecimal(dataGridView.Rows[i].Cells[6].Value));
taxtotal = taxtotal + ((Convert.ToDecimal(dataGridView.Rows[i].Cells[7].Value)*TotalAmount)/100); totalamount=totalamount+ TotalAmount;
}
TotalTaxtxt.Text=taxtotal.ToString();
totalamounttxt.Text=totalamount.ToString();
_subTotal = taxtotal + totalamount;
txtNewTotal.Text = (_subTotal).ToString();
Subtxt.Text = (_subTotal).ToString();
CalcDiscountShopCost();
}

0
Karthi Keyan9y ago
@jodha,

do that. All the Best.
0
Jyoti Jodha9y ago
yes @ Karthi
0
Karthi Keyan9y ago
@Jodha,

You want to add textboxes to calculate the CGST, SGST,IGST taxes. Then add that values to the grid. Finaly add that taxes to your Total Amount.
+1