/// <summary>
/// Method Name:BtnDetails_Click
/// Description:Show the Data in Grid control while clicking Details Button
/// Author:Bhumi
/// Created On:10/7/2015
/// </summary>
protected void BtnDetails_Click(object sender, EventArgs e)
{
try
{
if (DdlEmployee.SelectedValue == "0")
{
objconst = new ConstantMessages();
ClientScript.RegisterStartupScript(this.GetType(), "msgbox", "alert('" + objconst.strAlertEmployeeName + "');", true);
}
else
{
strBrSelectQuery = new StringBuilder("SELECT EmployeeDetailID,Address,Email,Salary ");
strBrSelectQuery.Append(" FROM EmployeeDetail");
strBrSelectQuery.Append(" WHERE Name= '" + DdlEmployee.SelectedValue + "'");
objfunction = new CommonFunction();
gvEmployee.DataSource = objfunction.ConnectionGenerate(strBrSelectQuery.ToString());
gvEmployee.DataBind();
}
}
catch (Exception)
{
objconst = new ConstantMessages();
Response.Redirect(objconst.strErrorPage, false);
}
finally
{
strBrSelectQuery = null;
objfunction = null;
}
}
/// <summary>
/// Method Name:BindData
/// Description:Fill the Data in Dropdownlist from Database table
/// Author:Bhumi
/// Created On:10/7/2015
/// </summary>
public void BindData()
{
try
{
strBrSelectQuery = new StringBuilder("SELECT Name ");
strBrSelectQuery.Append(" FROM EmployeeDetail");
objfunction = new CommonFunction();
DdlEmployee.DataSource = objfunction.ConnectionGenerate(strBrSelectQuery.ToString());
DdlEmployee.DataValueField = "Name";
DdlEmployee.DataTextField = "Name";
DdlEmployee.DataBind();
Cache.Insert("EmployeeName", objfunction.ConnectionGenerate(strBrSelectQuery.ToString()),
null, DateTime.Now.AddSeconds(15),
System.Web.Caching.Cache.NoSlidingExpiration);
}
catch (Exception)
{
objconst = new ConstantMessages();
Response.Redirect(objconst.strErrorPage, false);
}
finally
{
strBrSelectQuery = null;
objfunction = null;
}
}
/// <summary>
/// Method Name:BindData
/// Description:Fill the Data in Dropdownlist from Database table
/// Author:Bhumi
/// Created On:10/7/2015
/// </summary>
public void BindData()
{
try
{
if (Cache["EmployeeName"] == null)
{
LblCacheStatus.Visible = true;
}
else
{
DdlEmployee.DataSource = Cache["EmployeeName"];
DdlEmployee.DataValueField = "Name";
DdlEmployee.DataTextField = "Name";
DdlEmployee.DataBind();
}
}
catch (Exception)
{
objconst = new ConstantMessages();
Response.Redirect(objconst.strErrorPage, false);
}
finally
{
strBrSelectQuery = null;
objfunction = null;
}
}
/// <summary>
/// Method Name:BtnDetails_Click
/// Description:Show the Data in Grid control while clicking Details Button
/// Author:Bhumi
/// Created On:10/7/2015
/// </summary>
protected void BtnDetails_Click(object sender, EventArgs e)
{
try
{
objconst = new ConstantMessages();
Response.Redirect(objconst.strCache_Ex7Page, false);
}
catch (Exception)
{
objconst = new ConstantMessages();
Response.Redirect(objconst.strErrorPage, false);
}
finally
{
objconst = null;
}
}
/// <summary>
/// Method Name:BindData
/// Description:Fill the Data in Dropdownlist from Database table
/// Author:Bhumi
/// Created On:10/7/2015
/// </summary>
public void BindData()
{
try
{
strBrSelectQuery = new StringBuilder("SELECT Name ");
strBrSelectQuery.Append(" FROM EmployeeDetail");
objfunction = new CommonFunction();
DdlEmployee.DataSource = objfunction.ConnectionGenerate(strBrSelectQuery.ToString());
DdlEmployee.DataValueField = "Name";
DdlEmployee.DataTextField = "Name";
DdlEmployee.DataBind();
}
catch (Exception)
{
objconst = new ConstantMessages();
Response.Redirect(objconst.strErrorPage, false);
}
finally
{
strBrSelectQuery = null;
objfunction = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
objconst = new ConstantMessages();
Response.Write(objconst.strErrorMessage);
}