protected void btnAtAdd_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
lblAtErrorMsg.Text = "";
if (ViewState["AtTable"] == null)
{
dt.Columns.Add("PlaceOfSupplyCode");
dt.Columns.Add("Place Of Supply");
dt.Columns.Add("Rate");
dt.Columns.Add("Gross Advance Received");
dt.Columns.Add("Cess Amount");
}
else
{
dt = (DataTable)ViewState["AtTable"];
}
DataRow dr = dt.NewRow();
dr["PlaceOfSupplyCode"] = ddlAtPlaceOfSupply.Text;
dr["Place Of Supply"] = ddlAtPlaceOfSupply.SelectedItem.Text;
dr["Rate"] = ddltxtAtRate.SelectedItem.Text.ToString();
dr["Gross Advance Received"] = txtAtGrossAdvReceived.Text.Trim();
dr["Cess Amount"] = txtAtCessAmount.Text.Trim() == "" ? "0" : txtAtCessAmount.Text.Trim();
dt.Rows.Add(dr);
ViewState["AtTable"] = dt;
GridAt.DataSource = dt;
GridAt.DataBind();
ClearAt();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=db_asistencia;User ID=sa;Password=admin08");
con.Open();
string com = "Select dept_name,dept_id from tbl_department";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
ddlDept.DataSource = dt;
ddlDept.DataTextField = "dept_name";
ddlDept.DataValueField = "dept_id";
ddlDept.DataBind();
string com1 = "Select sem_id,sem_name from tbl_semester ";
SqlDataAdapter adpt1 = new SqlDataAdapter(com1, con);
DataTable dt1 = new DataTable();
adpt1.Fill(dt1);
GridAt.DataSource = dt1;
GridAt.DataBind();
con.Close();
}
}
protected void GridAt_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteRecords")
{
DataTable AtTable = (DataTable)ViewState["AtTable"];
AtTable.Rows.RemoveAt(int.Parse(e.CommandArgument.ToString()));
ViewState["AtTable"] = AtTable;
GridAt.DataSource = AtTable;
GridAt.DataBind();
}
}
protected void clearGrid() // clear all grid or view state all tab data
{
grdB2B.DataSource = null;
grdB2B.DataBind();
GridB2cl.DataSource = null;
GridB2cl.DataBind();
GridB2cs.DataSource = null;
GridB2cs.DataBind();
GridCdnr.DataSource = null;
GridCdnr.DataBind();
GridCdnur.DataSource = null;
GridCdnur.DataBind();
GridExp.DataSource = null;
GridExp.DataBind();
GridAt.DataSource = null;
GridAt.DataBind();
GridAtAdj.DataSource = null;
GridAtAdj.DataBind();
GridHsn.DataSource = null;
GridHsn.DataBind();
GridExeMp.DataSource = null;
GridExeMp.DataBind();
GridDocs.DataSource = null;
GridDocs.DataBind();
ViewState["B2BTable"] = null;
ViewState["B2ClTable"] = null;
ViewState["B2CSTable"] = null;
ViewState["CDNRTable"] = null;
ViewState["CDNURTable"] = null;
ViewState["ExpTable"] = null;
ViewState["AtTable"] = null;
ViewState["AtAdjTable"] = null;
ViewState["HsnTable"] = null;
ViewState["ExeMpTable"] = null;
ViewState["DocsTable"] = null;
ClearB2B();
ClearB2cl();
ClearB2cs();
ClearCdnur();
ClearExp();
ClearAt();
ClearDocs();
ClearAtAdj();
ClearExeMp();
ClearHsn();
ClearCdnr();
}