protected void grdTax_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
clsTaxMaster obj = new clsTaxMaster();
HiddenField hdID = (HiddenField)grdTax.Rows[e.RowIndex].FindControl("hdID");
obj.ID = Convert.ToInt32(hdID.Value);
obj.Op = 2;
obj.TaxMaster(obj);
msg.Text = "<script type='text/javascript'>alert('Deleted');</script>";
LoadData();
}
void LoadData()
{
clsTaxMaster obj = new clsTaxMaster();
obj.Op = 3;
DataTable dt = obj.TaxMaster(obj).Tables[0];
grdTax.DataSource = dt;
grdTax.DataBind();
if (grdTax.Rows.Count > 0)
{
lblError.Text = "";
}
else
{
lblError.Text = "No Records Found";
}
}
void LoadTax()
{
clsTaxMaster obj = new clsTaxMaster();
obj.Op = 3;
DataTable dt = obj.TaxMaster(obj).Tables[0];
dt.Columns.Add("TaxAmount");
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["TaxAmount"] = (dt.Rows[i]["CGST"].ToString() + ":" + dt.Rows[i]["SGST"].ToString() + ":" + dt.Rows[i]["IGST"].ToString()).ToString();
}
ddlTax.DataSource = dt;
ddlTax.DataTextField = "TaxAmount";
ddlTax.DataValueField = "TaxAmount";
ddlTax.DataBind();
MapData();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
clsTaxMaster obj = new clsTaxMaster();
obj.CGST = Convert.ToDouble(txtCGST.Text);
obj.SGST = Convert.ToDouble(txtSGST.Text);
obj.IGST = Convert.ToDouble(txtIGST.Text);
obj.Op = 1;
obj.TaxMaster(obj);
msg.Text = "<script type='text/javascript'>alert('Saved');</script>";
LoadData();
txtCGST.Text = "";
txtSGST.Text = "";
txtIGST.Text = "";
pnlExisting.Visible = true;
}
catch
{
msg.Text = "<script type='text/javascript'>alert('Check the entered data. Not Saved.');</script>";
}
}
/*
* Op=1 Insert Data
* Op=2 Delete Data
* Op=3 Read All Data*/
//ID, TaxName, TaxPercent
public DataSet TaxMaster(clsTaxMaster obj)
{
try
{
connect();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@ID", obj._ID);
param[1] = new SqlParameter("@CGST", obj._CGST);
param[2] = new SqlParameter("@SGST", obj._SGST);
param[3] = new SqlParameter("@IGST", obj._IGST);
param[4] = new SqlParameter("@Op", obj._Op);
DataSet ds = SqlHelper.ExecuteDataset(co, "procTaxMaster", param);
return(ds);
}
catch
{
return(null);
}
finally
{
co.Close();
}
}
