Calculation code for CGST,GST & IGST

Question

Hello Everyone, I am doing one project . I have Quantity,Rate Per Price() and amount Quantity=100.00 Rate Per Price()=100.00 amount=10000.00 so dynamically i want to display in invoice copy total Amount = 10000.00 @ 5% through sql quey i am displaying quanity,rate and amount in the invoice but how can i add that cgst,gst and igst amount in the total amount. Requesting to you please send me the asp.net c# code.

Thiyagarajan E · Answer

Hi Debasis, Your master table like ID Name Price SGST CGST IGST 1 Mobile 15000 7 9 2 2 TV 25000 9 9 0 Now your invoice is for mobile You can get Tax percentage from product above master table. You invoice with GST: productId = 1; string Product = “Mobile”: int Quantity = 10; decimal RatePerPrice = 15000.00; decimal Amount = 150000.00; decimal CGSTPercet = 7; // Getfrom Master Table for example now it is 7 decimal CGST = (Amount* CGSTPercet)/100;

Debasis Mohapatra · Answer

Hi Thiyagarajan , Thanks a lot all of you for your support. i didn't try the code which you had sent to me. However that module has done in the different way .i think it's the correct soluton. Keep in touch all of you if i will face any issue.

Kapil Gaur · Answer

Debashish Mohapatra, Hope you have got your answer. I see people have written a lot of code to help you. if you have implemented following code and you are good with these resolution then do accept the answer that has helped you. This helps a contributer in getting satisfaction of full resolution and other contributors that they need not bother about this question anymore. So update questions to help us understand.

Thiyagarajan E · Answer

Yes, it is correct if you get the GST 5 from a database instead of hardcoded for a respective product.

Debasis Mohapatra · Answer

I made the code like this. protected void ddlinvoicetype_SelectedIndexChanged(object sender, EventArgs e) { invoicetypeselectedindex(); double qty = 100.00; double rate = 200.00; double gst = 5; double amount = qty * rate; double gstpercentage = (gst * amount) / 100; }

Debasis Mohapatra · Answer

Dear Thiyagarajan, As you said that add the column CGSt,GST and IGST in master page that i have done in, but only the dynamically is comming but the percenatge is not adding.

Debasis Mohapatra · Answer

Proforma Invoice Invoice Type * Currency * SGST(%) * CGST(%) * IGST(%) * Exporter Ref No * Other Ref No * Consignee * Consignee Address * Buyer(If Other Than Consignee) * Shipping Address * Buyer's Order No * Buyer's Order Date * Country at Origin of Goods * Country at Final Destination * Transport Mode * Place of Lading * Place of Final Discharge * Place of Discharge * Terms of Delivery and Payment * Offer Term * Advance(%) * Bank Details * Corresponding Bank Details * GridLines="None" AutoGenerateColumns="False" ShowFooter="true" > No Record(s) Found. '> ' CssClass="form-control col-md-3 col-xs-12" runat="server"> ' CssClass="form-control col-md-3 col-xs-12" runat="server"> Select ' CssClass="form-control col-md-3 col-xs-12" runat="server"> OnClientClick="javascript:return confirm('Are you sure you want to delete this ?');" CausesValidation="false" data-placement="bottom" title="Delete" CssClass="glyphicon glyphicon-trash" runat="server" onclick="lnkaddnamedelete_Click"> Proforma Invoice GridLines="None" AutoGenerateColumns="False" > No Record(s) Found. '> '> '> '> '> '> '> '> '> '> CssClass="glyphicon glyphicon-print" runat="server"> $(document).ready(function() { $('#datatable').dataTable(); $('#datatable-keytable').DataTable({ keys: true }); $('#datatable-responsive').DataTable(); $('#datatable-scroller').DataTable({ ajax: "js/datatables/json/scroller-demo.json", deferRender: true, scrollY: 380, scrollCollapse: true, scroller: true }); var table = $('#ContentPlaceHolder1_grvrecorddata').DataTable({ fixedHeader: true }); }); TableManageButtons.init(); $(document).ready(function () { $(".select2_single").select2({ placeholder: "Select a state", allowClear: true }); $(".select2_group").select2({}); $(".select2_multiple").select2({ maximumSelectionLength: 4, placeholder: "With Max Selection limit 4", allowClear: true }); });

Debasis Mohapatra · Answer

using System; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class View_proformainvoie : System.Web.UI.Page { Utility ut = new Utility(); decimal d; SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["aspnetdbConnectionString"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { bindrecords(); populateinvoicetype(); populatecurrency(""); populatebankdetails(); populatecountry(); populatetransportmode(); Addname_FirstGridViewRow(); pnladd.Visible = false; pnlview.Visible = true ; } } #region function ----------------------------------------------------------- private void invoicetypeselectedindex() { try { if (ddlinvoicetype.SelectedValue.ToString() == "1") { populatecurrency("India"); divsgst.Visible = true; divcgst.Visible = true; divigst.Visible = false; ddlcurrency.Enabled = false; ddlcurrency.SelectedIndex = 1; } else if (ddlinvoicetype.SelectedValue.ToString() == "2") { populatecurrency("India"); divsgst.Visible = false; divcgst.Visible = false; divigst.Visible = true; ddlcurrency.Enabled = false; ddlcurrency.SelectedIndex = 1; } else if (ddlinvoicetype.SelectedValue.ToString() == "3") { populatecurrency(""); divsgst.Visible = false; divcgst.Visible = false; divigst.Visible = false; ddlcurrency.Enabled = true; ddlcurrency.SelectedIndex = 0; } else { populatecurrency(""); } } catch (Exception ex) { throw; } } private void populatecurrency(string india) { DataTable dt_currency = new DataTable(); DataRow dr; try { string sql = ""; if (!string.IsNullOrEmpty(india)) sql = "select id,[currency] as name from Currency where country='" + india + "' order by [currency]"; else sql = "select id,[currency] as name from Currency where country 'India' order by [currency]"; dt_currency = ut.SelectRecords(sql); if (dt_currency.Rows.Count > 0) { dr = dt_currency.NewRow(); dr.ItemArray = new object[] { 0, "----Select----" }; dt_currency.Rows.InsertAt(dr, 0); ddlcurrency.DataValueField = "id"; ddlcurrency.DataTextField = "name"; ddlcurrency.DataSource = dt_currency; ddlcurrency.DataBind(); } } catch (Exception ex) { } } private void populateinvoicetype() { DataTable dt_invoice = new DataTable(); DataRow dr; try { dt_invoice = ut.SelectRecords("select id,name from invoicetype"); if(dt_invoice.Rows.Count>0) { dr = dt_invoice.NewRow(); dr.ItemArray = new object[] { 0, "----Select----" }; dt_invoice.Rows.InsertAt(dr, 0); ddlinvoicetype.DataValueField = "id"; ddlinvoicetype.DataTextField = "name"; ddlinvoicetype.DataSource = dt_invoice; ddlinvoicetype.DataBind(); } } catch (Exception ex) { } } private void populatecountry() { DataTable dt_invoice = new DataTable(); DataRow dr; try { dt_invoice = ut.SelectRecords("select CountryID as id,CountryName as name from Country"); if (dt_invoice.Rows.Count > 0) { dr = dt_invoice.NewRow(); dr.ItemArray = new object[] { 0, "----Select----" }; dt_invoice.Rows.InsertAt(dr, 0); ddlcoutryorgoods.DataValueField = "id"; ddlcoutryorgoods.DataTextField = "name"; ddlcoutryorgoods.DataSource = dt_invoice; ddlcoutryorgoods.DataBind(); ddlcountryfinaldest.DataValueField = "id"; ddlcountryfinaldest.DataTextField = "name"; ddlcountryfinaldest.DataSource = dt_invoice; ddlcountryfinaldest.DataBind(); } } catch (Exception ex) { } } private void populatetransportmode() { DataTable dt_transport = new DataTable(); DataRow dr; try { dt_transport = ut.SelectRecords("select id,name from transportmode order by name"); if (dt_transport.Rows.Count > 0) { dr = dt_transport.NewRow(); dr.ItemArray = new object[] { 0, "----Select----" }; dt_transport.Rows.InsertAt(dr, 0); ddltransportmode.DataValueField = "id"; ddltransportmode.DataTextField = "name"; ddltransportmode.DataSource = dt_transport; ddltransportmode.DataBind(); } } catch (Exception ex) { } } private void populatebankdetails() { DataTable dt_invoice = new DataTable(); DataRow dr; try { dt_invoice = ut.SelectRecords("select id,bankname as name from bankdetails"); if (dt_invoice.Rows.Count > 0) { dr = dt_invoice.NewRow(); dr.ItemArray = new object[] { 0, "----Select----" }; dt_invoice.Rows.InsertAt(dr, 0); ddlbankdetails.DataValueField = "id"; ddlbankdetails.DataTextField = "name"; ddlbankdetails.DataSource = dt_invoice; ddlbankdetails.DataBind(); } } catch (Exception ex) { } } private void bindrecords() { DataTable dt = new DataTable(); try { string sql = @"select p.id,p.docno,format(p.docdt,'dd/MM/yyyy') as docdate , c.name as custname, p.place_of_lading,p.place_of_discharge,p.place_of_final_discharge,p.buyer_ord_no,p.amount, cur.code as currency from proforma_invoice p inner join customer c on c.custcode = p.cust_code inner join Currency cur on cur.id = p.currency_id"; dt = ut.SelectRecords(sql); if (dt.Rows.Count > 0) { grvrecorddata.DataSource = dt; grvrecorddata.DataBind(); grvrecorddata.HeaderRow.TableSection = TableRowSection.TableHeader; } else { grvrecorddata.DataSource = null; grvrecorddata.DataBind(); grvrecorddata.HeaderRow.TableSection = TableRowSection.TableHeader; } } catch (Exception ex) { } finally { } } private void resetcontrol() { try { ddlinvoicetype.SelectedIndex = 0; ddlcurrency.SelectedIndex = 0; txtsgst.Text = "0"; txtcgst.Text = "0"; txtigst.Text = "0"; txtexporterrefno.Text = ""; txtotherrefno.Text = ""; txtconsignee.Text = ""; txtconsigneeaddress.Text = ""; txtbuyer.Text = ""; txtshippingaddress.Text = ""; txtbuyersorderno.Text = ""; txtbuyerorderdate.Text = ""; ddlcoutryorgoods.SelectedIndex = 0; ddlcountryfinaldest.SelectedIndex = 0; ddltransportmode.SelectedIndex = 0; txtplacelading.Text = ""; txtplaceoffinaldischarge.Text = "0"; txtplceofdischarge.Text = ""; txttermsdeliverypayment.Text = ""; txtofferterm.Text = ""; txtadvancep.Text = "0"; ddlbankdetails.SelectedIndex = 0; lblbankname.Text = ""; lblbranch.Text = ""; lblaccounno.Text = ""; lblswiftcode.Text = ""; Addname_FirstGridViewRow(); HiddenField1.Value = ""; } catch (Exception ex) { } finally { } } private void populatecurbank() { DataTable dt = new DataTable(); try { dt = ut.SelectRecords("select * from beneficiary_bank where curr_id='" + ddlcurrency.SelectedValue.ToString() + "' and bank_id='" + ddlbankdetails.SelectedValue.ToString() + "'"); if (dt.Rows.Count > 0) { lblbankname.Text = dt.Rows[0]["bankname"].ToString(); lblbranch.Text = "Brach : " + dt.Rows[0]["branch"].ToString(); lblaccounno.Text = dt.Rows[0]["acno"].ToString(); lblswiftcode.Text = dt.Rows[0]["swiftcode"].ToString(); } else { lblbankname.Text = "No Record(s) found"; lblbranch.Text = ""; lblaccounno.Text = ""; lblswiftcode.Text = ""; } } catch (Exception ex) { throw; } } private void editrecords(int id) { DataTable dt1 = new DataTable(); try { string sql = "select * from proforma_invoice where id=" + id; dt1 = ut.SelectRecords(sql); if(dt1.Rows.Count>0) { ddlinvoicetype.SelectedValue = dt1.Rows[0]["invoice_type"].ToString(); invoicetypeselectedindex(); ddlcurrency.SelectedValue = dt1.Rows[0]["currency_id"].ToString(); txtsgst.Text = dt1.Rows[0]["sgst"].ToString(); txtcgst.Text = dt1.Rows[0]["cgst"].ToString(); txtigst.Text = dt1.Rows[0]["igst"].ToString(); txtexporterrefno.Text = dt1.Rows[0]["exporter_refno"].ToString(); txtotherrefno.Text = dt1.Rows[0]["oth_refno"].ToString(); DataTable dt_cust = new DataTable(); dt_cust = ut.SelectRecords("select * from customer where custcode='" + dt1.Rows[0]["cust_code"].ToString() + "'"); txtconsignee.Text = dt_cust.Rows[0]["name"].ToString(); txtconsigneeaddress.Text = dt_cust.Rows[0]["addr"].ToString(); DataTable dt_yr = new DataTable(); dt_yr = ut.SelectRecords("select * from customershippingaddress where custcode='" + dt1.Rows[0]["cust_code"].ToString() + "'"); txtshippingaddress.Text = dt_yr.Rows[0]["shipaddress"].ToString(); txtbuyer.Text = dt1.Rows[0]["buyer_othr_consignee"].ToString(); txtbuyersorderno.Text = dt1.Rows[0]["buyer_ord_no"].ToString(); txtbuyerorderdate.Text = dt1.Rows[0]["orddt"].ToString(); ddlcoutryorgoods.SelectedValue = dt1.Rows[0]["ctry_origin_id"].ToString(); ddlcountryfinaldest.SelectedValue = dt1.Rows[0]["ctry_shipping_id"].ToString(); ddltransportmode.SelectedValue = dt1.Rows[0]["Freight_mode"].ToString();//Transport Mode txtplacelading.Text = dt1.Rows[0]["place_of_lading"].ToString(); txtplaceoffinaldischarge.Text = dt1.Rows[0]["place_of_final_discharge"].ToString(); txtplceofdischarge.Text = dt1.Rows[0]["place_of_discharge"].ToString(); txttermsdeliverypayment.Text = dt1.Rows[0]["delv_pmt_terms"].ToString(); txtofferterm.Text = dt1.Rows[0]["offer_terms"].ToString(); txtadvancep.Text = dt1.Rows[0]["advance_pct"].ToString();// ddlbankdetails.SelectedValue = dt1.Rows[0]["bankid"].ToString();// populatecurbank(); DataTable dt = new DataTable(); DataColumn column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.AutoIncrement = true; column.AutoIncrementSeed = 1; column.AutoIncrementStep = 1; column.ColumnName = "id"; dt.Columns.Add(column); dt.Columns.Add(new DataColumn("desc", typeof(string))); dt.Columns.Add(new DataColumn("qty", typeof(decimal))); dt.Columns.Add(new DataColumn("unit", typeof(int))); dt.Columns.Add(new DataColumn("rate", typeof(string))); DataTable dt_new = new DataTable(); dt_new = ut.SelectRecords("select product_name as [desc], qty, uom as unit, rate from proforma_invoice_dtl where docno = '"+ dt1.Rows[0]["docno"].ToString() + "'"); for (int j = 0; j { string desc = dt_new.Rows[j]["desc"].ToString(); string qty = dt_new.Rows[j]["qty"].ToString(); string unit = dt_new.Rows[j]["unit"].ToString(); string rate = dt_new.Rows[j]["rate"].ToString(); DataRow dr = dt.NewRow(); dr["desc"] = desc; dr["qty"] = qty; dr["unit"] = unit; dr["rate"] = rate; dt.Rows.Add(dr); } ViewState["AddnameCurrentTable"] = dt; grvaddname.DataSource = dt; grvaddname.DataBind(); DropDownList ddl = (DropDownList)grvaddname.Rows[0].Cells[4].FindControl("ddlproductunit"); FillDropDownList(ddl); AddName_SetPreviousData(); } } catch (Exception ex) { //throw; } finally { } } protected void lnkprint_Click(object sender, EventArgs e) { LinkButton lnkdit = (LinkButton)sender; GridViewRow Grow = (GridViewRow)lnkdit.NamingContainer; // Label lblid = (Label)Grow.FindControl("lblid"); Label DOC_NO = (Label)Grow.FindControl("lbldocno"); //Response.Redirect("proformainvoice_print.aspx?id="+lblid.Text); Response.Redirect("proformainvoice_print.aspx?docno=" + DOC_NO.Text); } #endregion #region event----------------------------------------------------------------- protected void btnsubmit_Click(object sender, EventArgs e) { string strErrorMsg =""; decimal tot_qty = 0; decimal tot_amnt = 0; decimal due_amnt = 0; try { if (connection.State == ConnectionState.Open) connection.Close(); connection.Open(); DataTable dt_pi_details = new DataTable(); dt_pi_details.Columns.Add("product_name"); dt_pi_details.Columns.Add("qty"); dt_pi_details.Columns.Add("rate"); dt_pi_details.Columns.Add("amount"); dt_pi_details.Columns.Add("uom"); for (int j = 0; j { TextBox txtdecs = (TextBox)grvaddname.Rows[j].FindControl("txtdecs"); TextBox txtproductqty = (TextBox)grvaddname.Rows[j].FindControl("txtproductqty"); DropDownList ddlproductunit = (DropDownList)grvaddname.Rows[j].FindControl("ddlproductunit"); TextBox txtrate = (TextBox)grvaddname.Rows[j].FindControl("txtrate"); decimal d1=0; decimal d2 = 0; if (decimal.TryParse(txtproductqty.Text, out d)) d1 = Convert.ToDecimal(txtproductqty.Text); if (decimal.TryParse(txtrate.Text, out d)) d2 = Convert.ToDecimal(txtrate.Text); decimal d3 = d1 * d2; if ((!string.IsNullOrEmpty(txtdecs.Text.Trim())) && d1 != 0 && d2 != 0) { DataRow dr4 = dt_pi_details.NewRow(); dr4["product_name"] = txtdecs.Text; dr4["qty"] = txtproductqty.Text; dr4["rate"] = txtrate.Text; dr4["amount"] = d3.ToString(); dr4["uom"] = ddlproductunit.Text; dt_pi_details.Rows.Add(dr4); } tot_qty += Convert.ToDecimal(txtproductqty.Text); tot_amnt += Convert.ToDecimal(d3); } due_amnt = tot_amnt - Convert.ToDecimal(txtadvancep.Text.Trim()); if (HiddenField1.Value == "") { SqlCommand cmd = new SqlCommand("Proforma_Invoice_Insert_Final", connection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter sqlParam = new SqlParameter(); cmd.Parameters.AddWithValue("@doc_date", DateTime.Now.ToString("MM/dd/yyyy")); cmd.Parameters.AddWithValue("@invoice_type", ddlinvoicetype.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@buyer_ord_no", txtbuyersorderno.Text.Trim()); cmd.Parameters.AddWithValue("@buyer_othr_consignee", txtbuyer.Text.Trim()); cmd.Parameters.AddWithValue("@orddt", ut.ConvertDate(txtbuyerorderdate.Text.Trim())); // date cmd.Parameters.AddWithValue("@oth_refno", txtotherrefno.Text.Trim()); cmd.Parameters.AddWithValue("@exporter_refno", txtexporterrefno.Text.Trim()); cmd.Parameters.AddWithValue("@cust_name", txtconsignee.Text); cmd.Parameters.AddWithValue("@cust_addr", txtconsigneeaddress.Text); cmd.Parameters.AddWithValue("@ship_addr", txtshippingaddress.Text); cmd.Parameters.AddWithValue("@Freight_mode", ddltransportmode.SelectedValue); cmd.Parameters.AddWithValue("@freight_details", ""); cmd.Parameters.AddWithValue("@place_of_lading", txtplacelading.Text); cmd.Parameters.AddWithValue("@place_of_discharge", txtplceofdischarge.Text); cmd.Parameters.AddWithValue("@place_of_final_discharge", txtplaceoffinaldischarge.Text); cmd.Parameters.AddWithValue("@delv_pmt_terms", txttermsdeliverypayment.Text); cmd.Parameters.AddWithValue("@items", dt_pi_details.Rows.Count); cmd.Parameters.AddWithValue("@qty", tot_qty); cmd.Parameters.AddWithValue("@currency_id", ddlcurrency.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@amount", tot_amnt); cmd.Parameters.AddWithValue("@bank_id", ddlbankdetails.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@ctry_origin_id", ddlcoutryorgoods.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@ctry_shipping_id", ddlcountryfinaldest.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@benificiary_bankid", ddlbankdetails.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@advance_percent", txtadvancep.Text.ToString()); cmd.Parameters.AddWithValue("@offer_terms", txtofferterm.Text.ToString()); cmd.Parameters.AddWithValue("@cgst", txtcgst.Text.Trim()); cmd.Parameters.AddWithValue("@sgst", txtsgst.Text.Trim()); cmd.Parameters.AddWithValue("@igst", txtigst.Text.Trim()); cmd.Parameters.AddWithValue("@advance_amount", Convert.ToDecimal(txtadvancep.Text.Trim())); cmd.Parameters.AddWithValue("@due_amount", due_amnt); cmd.Parameters.AddWithValue("@typ_PI_details", dt_pi_details); cmd.Parameters.AddWithValue("@note", ""); cmd.Parameters.AddWithValue("@cbu", ""); cmd.Parameters.Add("@ret", SqlDbType.VarChar, 250); cmd.Parameters["@ret"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@out_doc_no", SqlDbType.VarChar, 250); cmd.Parameters["@out_doc_no"].Direction = ParameterDirection.Output; int i = cmd.ExecuteNonQuery(); strErrorMsg = cmd.Parameters["@ret"].Value.ToString(); if (strErrorMsg.ToUpper() == "S") { //pnladd.Visible = false; //pnlview.Visible = true; bindrecords(); resetcontrol(); } } else { SqlCommand cmd = new SqlCommand("Proforma_Invoice_Update", connection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter sqlParam = new SqlParameter(); cmd.Parameters.AddWithValue("@docno", HiddenField1.Value); cmd.Parameters.AddWithValue("@doc_date", DateTime.Now.ToString("MM/dd/yyyy")); cmd.Parameters.AddWithValue("@invoice_type", ddlinvoicetype.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@buyer_ord_no", txtbuyersorderno.Text.Trim()); cmd.Parameters.AddWithValue("@buyer_othr_consignee", txtbuyer.Text.Trim()); cmd.Parameters.AddWithValue("@orddt", ut.ConvertDate(txtbuyerorderdate.Text.Trim())); // date cmd.Parameters.AddWithValue("@oth_refno", txtotherrefno.Text.Trim()); cmd.Parameters.AddWithValue("@exporter_refno", txtexporterrefno.Text.Trim()); cmd.Parameters.AddWithValue("@cust_name", txtconsignee.Text); cmd.Parameters.AddWithValue("@cust_addr", txtconsigneeaddress.Text); cmd.Parameters.AddWithValue("@ship_addr", txtshippingaddress.Text); cmd.Parameters.AddWithValue("@Freight_mode", ddltransportmode.SelectedValue); cmd.Parameters.AddWithValue("@freight_details", ""); cmd.Parameters.AddWithValue("@place_of_lading", txtplacelading.Text); cmd.Parameters.AddWithValue("@place_of_discharge", txtplceofdischarge.Text); cmd.Parameters.AddWithValue("@place_of_final_discharge", txtplaceoffinaldischarge.Text); cmd.Parameters.AddWithValue("@delv_pmt_terms", txttermsdeliverypayment.Text); cmd.Parameters.AddWithValue("@items", dt_pi_details.Rows.Count); cmd.Parameters.AddWithValue("@qty", tot_qty); cmd.Parameters.AddWithValue("@currency_id", ddlcurrency.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@amount", tot_amnt); cmd.Parameters.AddWithValue("@bank_id", ddlbankdetails.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@ctry_origin_id", ddlcoutryorgoods.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@ctry_shipping_id", ddlcountryfinaldest.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@benificiary_bankid", 0); cmd.Parameters.AddWithValue("@advance_percent", txtadvancep.Text.ToString()); cmd.Parameters.AddWithValue("@offer_terms", txtofferterm.Text.ToString()); cmd.Parameters.AddWithValue("@cgst", Convert.ToInt32(txtcgst.Text.Trim())); cmd.Parameters.AddWithValue("@sgst", Convert.ToInt32(txtsgst.Text.Trim())); cmd.Parameters.AddWithValue("@igst", Convert.ToInt32(txtigst.Text.Trim())); cmd.Parameters.AddWithValue("@advance_amount", Convert.ToDecimal(txtadvancep.Text.Trim())); cmd.Parameters.AddWithValue("@due_amount", 0); cmd.Parameters.AddWithValue("@typ_PI_details", dt_pi_details); cmd.Parameters.AddWithValue("@note", ""); cmd.Parameters.AddWithValue("@cbu", ""); cmd.Parameters.Add("@ret", SqlDbType.VarChar, 250); cmd.Parameters["@ret"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@out_doc_no", SqlDbType.VarChar, 250); cmd.Parameters["@out_doc_no"].Direction = ParameterDirection.Output; int i = cmd.ExecuteNonQuery(); strErrorMsg = cmd.Parameters["@ret"].Value.ToString(); if (strErrorMsg.ToUpper() == "S") { resetcontrol(); pnladd.Visible = false; pnlview.Visible = true; Response.Redirect("proformainvoie.aspx", false); } } } catch (Exception ex) { Label1.Text = strErrorMsg; } finally { if (connection.State == ConnectionState.Open) connection.Close(); } } protected void btnEdit_Click(object sender, EventArgs e) { LinkButton lnkdit = (LinkButton)sender; GridViewRow Grow = (GridViewRow)lnkdit.NamingContainer; Label lblid = (Label)Grow.FindControl("lblid"); Label DOC_NO = (Label)Grow.FindControl("lbldocno"); int id = Convert.ToInt32(lblid.Text); editrecords(id); pnladd.Visible = true ; pnlview.Visible = false; HiddenField1.Value = DOC_NO.Text; } protected void btncancel_Click(object sender, EventArgs e) { try { resetcontrol(); pnladd.Visible = false; pnlview.Visible = true; Response.Redirect("proformainvoie.aspx",false); } catch (Exception) { throw; } } protected void ddlinvoicetype_SelectedIndexChanged(object sender, EventArgs e) { invoicetypeselectedindex(); //double totalAmount, cgst, gst, igst; //grandTotal = Convert.ToDouble(txtGrandTotal.Text); //percentage = Convert.ToDouble(txtPercentage.Text); //totalAmount = (grandTotal * 100) / (100 + percentage); //taxAmount = totalAmount * (percentage / 100); //lblamount.Text = Convert.ToString(Math.Round(taxAmount, 2)); Double totalamount,cgst, gst, igst; cgst = Convert.ToDouble(txtcgst.Text); gst = Convert.ToDouble(txtsgst.Text); igst = Convert.ToDouble(txtigst.Text); totalamount = (cgst/100) * Convert.ToDouble(txtcgst.Text); } protected void ddlbankdetails_SelectedIndexChanged(object sender, EventArgs e) { populatecurbank(); } protected void btnaddnew_Click(object sender, EventArgs e) { try { resetcontrol(); pnladd.Visible = true; pnlview.Visible = false; } catch (Exception) { throw; } } #endregion #region product grid------------------ private void FillDropDownList(DropDownList ddl) { DataTable dt_unit = new DataTable(); DataRow dr; try { dt_unit = ut.SelectRecords("select id,uom as name from unit "); if (dt_unit.Rows.Count > 0) { ddl.DataValueField = "id"; ddl.DataTextField = "name"; ddl.DataSource = dt_unit; ddl.DataBind(); } else { ddl.DataValueField = "id"; ddl.DataTextField = "name"; ddl.DataSource = null; ddl.DataBind(); } } catch (Exception ex) { } } private void Addname_FirstGridViewRow() { DataTable dt = new DataTable(); DataRow dr = null; DataColumn column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.AutoIncrement = true; column.AutoIncrementSeed = 1; column.AutoIncrementStep = 1; column.ColumnName = "id"; dt.Columns.Add(column); dt.Columns.Add(new DataColumn("desc", typeof(string))); dt.Columns.Add(new DataColumn("qty", typeof(decimal))); dt.Columns.Add(new DataColumn("unit", typeof(int))); dt.Columns.Add(new DataColumn("rate", typeof(string))); dr = dt.NewRow(); dr["desc"] = string.Empty; dr["qty"] = 0; dr["unit"] = 0; dr["rate"] = 0; dt.Rows.Add(dr); ViewState["AddnameCurrentTable"] = dt; grvaddname.DataSource = dt; grvaddname.DataBind(); DropDownList ddl = (DropDownList)grvaddname.Rows[0].Cells[4].FindControl("ddlproductunit"); FillDropDownList(ddl); } private void AddName_AddNewRow() { int rowIndex = 0; if (ViewState["AddnameCurrentTable"] != null) { DataTable dtCurrentTable = (DataTable)ViewState["AddnameCurrentTable"]; DataRow drCurrentRow = null; if (dtCurrentTable.Rows.Count > 0) { for (int i = 1; i { Label lblid = (Label)grvaddname.Rows[rowIndex].Cells[1].FindControl("lblid"); TextBox txtdecs = (TextBox)grvaddname.Rows[rowIndex].Cells[2].FindControl("txtdecs"); TextBox txtproductqty = (TextBox)grvaddname.Rows[rowIndex].Cells[3].FindControl("txtproductqty"); DropDownList ddlproductunit = (DropDownList)grvaddname.Rows[rowIndex].Cells[4].FindControl("ddlproductunit"); TextBox txtrate = (TextBox)grvaddname.Rows[rowIndex].Cells[5].FindControl("txtrate"); drCurrentRow = dtCurrentTable.NewRow(); dtCurrentTable.Rows[i - 1]["id"] = lblid.Text; dtCurrentTable.Rows[i - 1]["desc"] = txtdecs.Text; dtCurrentTable.Rows[i - 1]["qty"] = txtproductqty.Text; dtCurrentTable.Rows[i - 1]["unit"] = ddlproductunit.SelectedValue; dtCurrentTable.Rows[i - 1]["rate"] = txtrate.Text; rowIndex++; } //Added by rahaman on 11/11/2016-------- DataRow dr = null; dr = dtCurrentTable.NewRow(); dr["desc"] = string.Empty; dr["qty"] = 0; dr["unit"] = 0; dr["rate"] = 0; dtCurrentTable.Rows.Add(dr); // dtCurrentTable.Rows.Add(drCurrentRow); ViewState["AddnameCurrentTable"] = dtCurrentTable; grvaddname.DataSource = dtCurrentTable; grvaddname.DataBind(); } } else { Response.Write("ViewState is null"); } AddName_SetPreviousData(); } private void AddName_SetPreviousData() { int rowIndex = 0; if (ViewState["AddnameCurrentTable"] != null) { DataTable dt = (DataTable)ViewState["AddnameCurrentTable"]; if (dt.Rows.Count > 0) { for (int i = 0; i { Label lblid = (Label)grvaddname.Rows[rowIndex].Cells[1].FindControl("lblid"); TextBox txtdecs = (TextBox)grvaddname.Rows[rowIndex].Cells[2].FindControl("txtdecs"); TextBox txtproductqty = (TextBox)grvaddname.Rows[rowIndex].Cells[3].FindControl("txtproductqty"); DropDownList ddlproductunit = (DropDownList)grvaddname.Rows[rowIndex].Cells[4].FindControl("ddlproductunit"); TextBox txtrate = (TextBox)grvaddname.Rows[rowIndex].Cells[5].FindControl("txtrate"); FillDropDownList(ddlproductunit); lblid.Text = dt.Rows[i]["id"].ToString(); txtdecs.Text = dt.Rows[i]["desc"].ToString(); txtproductqty.Text = dt.Rows[i]["qty"].ToString(); //if (i //{ // ddlproductunit.ClearSelection(); // ddlproductunit.Items.FindByText(dt.Rows[i]["unit"].ToString()).Selected = true; //} ddlproductunit.SelectedValue = dt.Rows[i]["unit"].ToString(); txtrate.Text = dt.Rows[i]["rate"].ToString(); rowIndex++; } } } } private void AddNAme_SetRowData() { int rowIndex = 0; if (ViewState["AddnameCurrentTable"] != null) { DataTable dtCurrentTable = (DataTable)ViewState["AddnameCurrentTable"]; DataRow drCurrentRow = null; if (dtCurrentTable.Rows.Count > 0) { for (int i = 1; i { Label lblid = (Label)grvaddname.Rows[rowIndex].Cells[1].FindControl("lblid"); TextBox txtdecs = (TextBox)grvaddname.Rows[rowIndex].Cells[2].FindControl("txtdecs"); TextBox txtproductqty = (TextBox)grvaddname.Rows[rowIndex].Cells[3].FindControl("txtproductqty"); DropDownList ddlproductunit = (DropDownList)grvaddname.Rows[rowIndex].Cells[4].FindControl("ddlproductunit"); TextBox txtrate = (TextBox)grvaddname.Rows[rowIndex].Cells[5].FindControl("txtrate"); drCurrentRow = dtCurrentTable.NewRow(); dtCurrentTable.Rows[i - 1]["id"] = lblid.Text; dtCurrentTable.Rows[i - 1]["desc"] = txtdecs.Text; dtCurrentTable.Rows[i - 1]["qty"] = txtproductqty.Text; dtCurrentTable.Rows[i - 1]["unit"] = ddlproductunit.SelectedValue; dtCurrentTable.Rows[i - 1]["rate"] = txtrate.Text; rowIndex++; } ViewState["AddnameCurrentTable"] = dtCurrentTable; } } else { Response.Write("ViewState is null"); } //SetPreviousData(); } protected void btnaddnamenew_Click(object sender, EventArgs e) { AddName_AddNewRow(); } protected void lnkaddnamedelete_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; // int i = Convert.ToInt32(row.RowIndex); //TextBox txt = (TextBox)row.FindControl("txtype"); //if (txt.Text == "Own") //{ // ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('You can not delete')", true); // return; //} AddNAme_SetRowData(); if (ViewState["AddnameCurrentTable"] != null) { DataTable dt = (DataTable)ViewState["AddnameCurrentTable"]; DataRow drCurrentRow = null; int rowIndex = Convert.ToInt32(row.RowIndex); if (dt.Rows.Count > 1) { dt.Rows.Remove(dt.Rows[rowIndex]); drCurrentRow = dt.NewRow(); ViewState["AddnameCurrentTable"] = dt; grvaddname.DataSource = dt; grvaddname.DataBind(); AddName_SetPreviousData(); } } } protected void grvaddname_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //Label lblidtype = (Label)e.Row.FindControl("lblidtype"); //TextBox txtname = (TextBox)e.Row.FindControl("txtname"); //TextBox txtcompany = (TextBox)e.Row.FindControl("txtcompany"); //TextBox txtphn = (TextBox)e.Row.FindControl("txtphn"); //DropDownList ddlidtype = (DropDownList)e.Row.FindControl("ddlidtype"); //TextBox txtidno = (TextBox)e.Row.FindControl("txtidno"); //LinkButton lnkaddnamedelete = (LinkButton)e.Row.FindControl("lnkaddnamedelete"); //if (Convert.ToString(ViewState["addnew"]) == "new") //{ // lnkaddnamedelete.Visible = true; // txtname.Enabled = true; // txtcompany.Enabled = true; // txtphn.Enabled = true; // ddlidtype.Enabled = true; // txtidno.Enabled = false; //} //else if (Convert.ToString(ViewState["addnew"]) == "v") //{ // lnkaddnamedelete.Visible = false; // if (!string.IsNullOrEmpty(lblidtype.Text)) // { // ddlidtype.SelectedValue = lblidtype.Text; // } // txtname.Enabled = false; // txtcompany.Enabled = false; // txtphn.Enabled = false; // ddlidtype.Enabled = false; // txtidno.Enabled = false; //} //else //{ // lnkaddnamedelete.Visible = false; // if (!string.IsNullOrEmpty(lblidtype.Text)) // { // ddlidtype.SelectedValue = lblidtype.Text; // } // txtname.Enabled = false; // txtcompany.Enabled = false; // txtphn.Enabled = false; // ddlidtype.Enabled = false; // txtidno.Enabled = false; //} } if (e.Row.RowType == DataControlRowType.Footer) { //Button btnaddnamenew = (Button)e.Row.FindControl("btnaddnamenew"); //if (Convert.ToString(ViewState["addnew"]) == "new") // btnaddnamenew.Visible = true; //else if (Convert.ToString(ViewState["addnew"]) == "v") // btnaddnamenew.Visible = false; //else // btnaddnamenew.Visible = false; } } #endregion #region #endregion }

Thiyagarajan E · Answer

Share me the code.

Debasis Mohapatra · Answer

ok i have the 2 page one is profrmainvoice another is proformainvoice_print.now if you want the project code so i can attached to you. is it ok for you.

Thiyagarajan E · Answer

Hi, How do you get the Rate per price of a product? If you have any master table for that then we can add the columns in that table like (CGST, IGST, SGST) to get a percentage of respective tax.