private void BindGVEmployee(string QueryText)
{
DataSet DSRecord = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.Text, QueryText);
if (DSRecord.Tables[0].Rows.Count > 0)
{
GVEmployee.DataSource = DSRecord.Tables[0];
GVEmployee.DataBind();
}
else
{
GVEmployee.EmptyDataText = "No Record Found !";
GVEmployee.DataBind();
}
foreach (GridViewRow Row in GVEmployee.Rows)
{
Label lblStatus = (Label)Row.FindControl("lblStatus");
LinkButton LBEdit = (LinkButton)Row.FindControl("LBEdit");
LinkButton LBDelete = (LinkButton)Row.FindControl("LBDelete");
if (lblStatus.Text == "Active")
{
lblStatus.CssClass = "label label-success";
LBEdit.Enabled = true;
LBDelete.Enabled = true;
}
else
{
lblStatus.CssClass = "label label-danger";
LBEdit.Enabled = false;
LBDelete.Enabled = false;
}
}
}
protected void SearchEvent(object sender, EventArgs e)
{
string SearchQuery = "SELECT * FROM View_EmployeeDetails WHERE View_EmployeeDetails.EmployeeName LIKE '" + TBSearch.Text.Trim() + "%'";
DataSet DSRecord = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.Text, SearchQuery);
if (DSRecord.Tables[0].Rows.Count > 0)
{
GVEmployee.DataSource = DSRecord.Tables[0];
GVEmployee.DataBind();
}
else
{
GVEmployee.EmptyDataText = "No Record Found !";
GVEmployee.DataBind();
}
foreach (GridViewRow Row in GVEmployee.Rows)
{
Label lblStatus = (Label)Row.FindControl("lblStatus");
LinkButton LBEdit = (LinkButton)Row.FindControl("LBEdit");
LinkButton LBDelete = (LinkButton)Row.FindControl("LBDelete");
if (lblStatus.Text == "Active")
{
lblStatus.CssClass = "label label-success";
LBEdit.Enabled = true;
LBDelete.Enabled = true;
}
else
{
lblStatus.CssClass = "label label-danger";
LBEdit.Enabled = false;
LBDelete.Enabled = false;
}
}
}
// this method requests all employees from the getEmployees() method in the HWW.cs and displays them in a grdiview
protected void fillEmployees()
{ // populates a gridview with all orders numbers
Employees allEmployees = new Employees();
GVEmployee.DataSource = allEmployees.getEmployees();
GVEmployee.DataBind();
}// closes the fillorders
public void bindEmpData()
{
List <ParaList> para = new List <ParaList>()
{
new ParaList {
Key = "@i_CompanyID", Value = CurrentUser.CompId
}
};
dsitem = crmclient.list(para, "Employee");
GVEmployee.DataSource = dsitem.Tables[0];
GVEmployee.DataBind();
}
void FillGridViewWithNativeSql()
{
List <Employee> lst_emp = new List <Employee>();
DataTable dtbl = new DataTable();
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
SqlCommand sqlcmd = new SqlCommand("Select * from Employees", sqlCon);
using (SqlDataReader reader = sqlcmd.ExecuteReader())
{
while (reader.Read())
{
lst_emp.Add(new Employee
{
id_emp = Convert.ToInt32(reader["id_emp"].ToString()),
nom_emp = reader["nom_emp"].ToString(),
prenom_emp = reader["prenom_emp"].ToString(),
date_recrute_emp = Convert.ToDateTime(reader["date_recrute_emp"].ToString()),
id_dep = Convert.ToInt32(reader["id_dep"].ToString()),
Salaire_emp = Convert.ToDouble(reader["Salaire_emp "].ToString())
});
}
}
SqlDataAdapter sqlDa = new SqlDataAdapter("Select * from Employees", sqlCon);
sqlDa.Fill(dtbl);
}
if (dtbl.Rows.Count > 0)
{
DropDownList dd = (DropDownList)GVEmployee.FooterRow.FindControl("dddeprt_footer");
BindDeprt(dd, PopulateDeprt());
GVEmployee.DataSource = dtbl;
GVEmployee.DataBind();
}
else
{
dtbl.Rows.Add(dtbl.NewRow());
GVEmployee.DataSource = dtbl;
GVEmployee.DataBind();
GVEmployee.Rows[0].Cells.Clear();
GVEmployee.Rows[0].Cells.Add(new TableCell());
GVEmployee.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count;
GVEmployee.Rows[0].Cells[0].Text = "No data Found...!";
GVEmployee.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
void BindGrid()
{
using (MMR_CP22Entities1 context = new MMR_CP22Entities1())
{
if (context.Users.Count() > 0)
{
GVEmployee.DataSource = (from em in context.Users.OrderBy(u => u.uID)
select new { em.uID, em.uName, em.uPassword, em.uStatus, em.rID, em.CMP_CODE, em.uFULL_NAME, em.GRID_CODE }
).ToList();
GVEmployee.DataBind();
}
else
{
GVEmployee.DataSource = null;
GVEmployee.DataBind();
}
}
}
void FillGridViewWithEntityFramework()
{
var listDtoEmp = new List <DtoEmployee>();
var list_emp = contxt.Employees.OrderBy(x => x.id_emp).ToList();
foreach (var emp in list_emp)
{
listDtoEmp.Add(new DtoEmployee
{
id_emp = emp.id_emp,
nom_emp = emp.nom_emp,
prenom_emp = emp.prenom_emp,
Salaire_emp = emp.Salaire_emp,
id_dep = emp.id_dep,
nom_dep = emp.Departement.nom_dep,
date_recrute_emp = emp.date_recrute_emp,
tele_emp = emp.tele_emp
});
}
DataTable dtbl = ToDataTable(listDtoEmp);
if (dtbl.Rows.Count > 0)
{
GVEmployee.DataSource = dtbl;
GVEmployee.DataBind();
DropDownList dd = GVEmployee.FooterRow.FindControl("dddeprt_footer") as DropDownList;
BindDeprt(dd, PopulateDeprt());
}
else
{
dtbl.Rows.Add(dtbl.NewRow());
GVEmployee.DataSource = dtbl;
GVEmployee.DataBind();
GVEmployee.Rows[0].Cells.Clear();
GVEmployee.Rows[0].Cells.Add(new TableCell());
GVEmployee.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count;
GVEmployee.Rows[0].Cells[0].Text = "No data Found...!";
GVEmployee.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
protected void GVEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GVEmployee.PageIndex = e.NewPageIndex;
BindGVEmployees();
GVEmployee.DataBind();
}
