protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
DataSet ds = obj.DisplyEmployee("select * from tblEmployeeInfo order by " + e.SortExpression);
GridEmployee.DataSource = ds.Tables[0];
GridEmployee.DataBind();
}
public void GetData()
{
DataSet ds = obj.DisplyEmployee("select * from tblEmployeeInfo");
GridEmployee.DataSource = ds.Tables[0];
GridEmployee.DataBind();
}
public void loadgird1()
{
string query = @"SELECT [Employee_ID]
,[Employee_Name]
FROM [dbo].[Employee]";
GridEmployee.DataSource = db.getData(query);
GridEmployee.DataBind();
}
public void GetEmployeeList()
{
DataTable dt = new DataTable();
dt = objCommon.GetAllEmployeeList();
GridEmployee.DataSource = dt;
GridEmployee.DataBind();
count.Text = "Number of Employees =" + dt.Rows.Count;
ViewState["dirState"] = dt;
ViewState["sortdr"] = "Asc";
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataTable dtSearch1;
string sqr = "Select * from Login L inner Join Department D on D.DepartmentID=L.DepartmentID inner join Role R on L.RoleID=R.RoleID where L.IsActive=1";
if (txtName.Text != "")
{
sqr += "and L.EmployeeName like '%' +'" + txtName.Text + "'+ '%'";
}
if (txtMobile.Text != "")
{
sqr += "and L.Mobile like '%' + '" + txtMobile.Text + "'+ '%'";
}
if (ddlDepartment.SelectedIndex != 0)
{
sqr += "and L.DepartmentID =" + ddlDepartment.SelectedValue;
}
if (ddlDesignation.SelectedIndex != 0)
{
sqr += "and L.RoleID =" + ddlDesignation.SelectedValue;
}
dtSearch1 = objGeneral.GetDatasetByCommand(sqr);
GridFillSearch();
void GridFillSearch()
{
if (dtSearch1 != null)
{
//DataTable dtSearch = dtSearch1.CopyToDataTable();
GridEmployee.DataSource = dtSearch1;
GridEmployee.DataBind();
count.Text = "Number of Employee= " + (dtSearch1.Rows.Count).ToString();
}
else
{
DataTable dt = new DataTable();
GridEmployee.DataSource = dt;
GridEmployee.DataBind();
count.Text = "Number of Employee= 0";
}
ViewState["dirState"] = dtSearch1;
ViewState["sortdr"] = "Asc";
}
}
protected void GridEmployee_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable dtrslt = (DataTable)ViewState["dirState"];
if (dtrslt.Rows.Count > 0)
{
if (Convert.ToString(ViewState["sortdr"]) == "Asc")
{
dtrslt.DefaultView.Sort = e.SortExpression + " Desc";
ViewState["sortdr"] = "Desc";
}
else
{
dtrslt.DefaultView.Sort = e.SortExpression + " Asc";
ViewState["sortdr"] = "Asc";
}
GridEmployee.DataSource = dtrslt;
GridEmployee.DataBind();
}
}
private void BindData()
{
GridEmployee.DataSource = emphandler.GetEmployeeList();
GridEmployee.DataBind();
}
public ActionResult Index()
{
return(View(GridEmployee.GetAll()));
}
