private void BindGrid()
{
try
{
string listItem = string.Empty;
DataTable dt = new DataTable();
if (HttpContext.Current.Cache["Balance"] == null)
{
foreach (ListItem item in lstProjectCode.Items)
{
if (item.Selected)
{
listItem += "'" + item.Value + "',";
}
}
listItem = listItem.TrimEnd(',');
objSanction = new Sanction();
objSanction.Division = ddlDevision.SelectedValue;
objSanction.ProjectCode = listItem;
if (rdSiteSanction.Checked)
{
dt = objSanction.GeSitetSanctionBalance(Request.QueryString["env"]);
}
else if (rdTravelSanction.Checked)
{
dt = objSanction.GeTraveltSanctionBalance(Request.QueryString["env"]);
}
else
{
}
HttpContext.Current.Cache.Insert("Balance", dt, null, DateTime.Now.AddMinutes(20), TimeSpan.Zero);
}
else
{
dt = (DataTable)HttpContext.Current.Cache["Balance"];
}
if (dt.Rows.Count > 0)
{
gvBalnaceReport.DataSource = dt;
gvBalnaceReport.DataBind();
btnExportToExcel.Visible = true;
btnPrint.Visible = true;
}
else
{
btnExportToExcel.Visible = false;
btnPrint.Visible = false;
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Record not found');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found.');", true);
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "callJSFunction", "onchangeDivision();", true);
}
private void BindDevision()
{
try
{
objSanction = new Sanction();
DataTable dt = objSanction.GetDivision(Request.QueryString["env"]);
ddlDevision.DataSource = dt;
ddlDevision.DataTextField = "Division";
ddlDevision.DataValueField = "Division";
ddlDevision.DataBind();
ddlDevision.Items.Insert(0, "Select Devision");
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found.');", true);
}
}
private void BindProjectCode()
{
try
{
objSanction = new Sanction();
objSanction.Division = ddlDevision.SelectedValue;
DataTable dt = objSanction.GetProjectCode(Request.QueryString["env"]);
lstProjectCode.DataSource = dt;
lstProjectCode.DataTextField = "ProjectCode";
lstProjectCode.DataValueField = "ProjectCode";
lstProjectCode.DataBind();
lstProjectCode.Visible = true;
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found.');", true);
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "callJSFunction", "onchangeDivision();", true);
}
