protected void EmpGroupSal_CheckedChanged(object sender, EventArgs e)
{
ViewState["SalaryReportSelected"] = 0;
if (rbtnGroupSal.Checked)
{
pnlEmp.Visible = false;
pnlGroupSal.Visible = true;
DataTable dtGroup = objEmpGroup.GetEmployeeGroup_Master(Session["CompId"].ToString());
dtGroup = new DataView(dtGroup, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dtGroup.Rows.Count > 0)
{
lbxGroupSal.DataSource = dtGroup;
lbxGroupSal.DataTextField = "Group_Name";
lbxGroupSal.DataValueField = "Group_Id";
lbxGroupSal.DataBind();
}
gvEmployeeSal.DataSource = null;
gvEmployeeSal.DataBind();
lbxGroupSal_SelectedIndexChanged(null, null);
}
else if (rbtnEmpSal.Checked)
{
pnlEmp.Visible = true;
pnlGroupSal.Visible = false;
lblEmp.Text = "";
lblSelectRecord.Text = "";
string GroupIds = string.Empty;
string EmpIds = string.Empty;
DataTable dtEmp = objEmp.GetEmployeeMaster(Session["CompId"].ToString());
dtEmp = new DataView(dtEmp, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (Session["SessionDepId"] != null)
{
dtEmp = new DataView(dtEmp, "Department_Id in(" + Session["SessionDepId"].ToString().Substring(0, Session["SessionDepId"].ToString().Length - 1) + ")", "", DataViewRowState.CurrentRows).ToTable();
}
if (dtEmp.Rows.Count > 0)
{
Session["dtEmp4"] = dtEmp;
gvEmployee.DataSource = dtEmp;
gvEmployee.DataBind();
}
else
{
gvEmployee.DataSource = null;
gvEmployee.DataBind();
}
}
}
private void FillGrid()
{
DataTable dtBrand = objEmpGroup.GetEmployeeGroup_Master(Session["CompId"].ToString().ToString());
dtBrand = new DataView(dtBrand, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
lblTotalRecords.Text = Resources.Attendance.Total_Records + ": " + dtBrand.Rows.Count + "";
Session["dtGroup"] = dtBrand;
Session["dtFilter"] = dtBrand;
if (dtBrand != null && dtBrand.Rows.Count > 0)
{
GvGroup.DataSource = dtBrand;
GvGroup.DataBind();
AllPageCode();
}
else
{
GvGroup.DataSource = null;
GvGroup.DataBind();
}
}
public static string[] GetCompletionListGroupG(string prefixText, int count, string contextKey)
{
Set_EmployeeGroup_Master objGroup = new Set_EmployeeGroup_Master();
DataTable dt = new DataView(objGroup.GetEmployeeGroup_Master(HttpContext.Current.Session["CompId"].ToString()), "Group_Name like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable();
string[] txt = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
txt[i] = dt.Rows[i]["Group_Name"].ToString();
}
return(txt);
}
protected void EmpGroup_CheckedChanged(object sender, EventArgs e)
{
if (rbtnGroup.Checked)
{
Panel4.Visible = false;
pnlGroup.Visible = true;
DataTable dtGroup = objEmpGroup.GetEmployeeGroup_Master(Session["CompId"].ToString());
dtGroup = new DataView(dtGroup, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dtGroup.Rows.Count > 0)
{
lbxGroup.DataSource = dtGroup;
lbxGroup.DataTextField = "Group_Name";
lbxGroup.DataValueField = "Group_Id";
lbxGroup.DataBind();
}
lbxGroup_SelectedIndexChanged(null, null);
}
else if (rbtnEmp.Checked)
{
Panel4.Visible = true;
pnlGroup.Visible = false;
lblEmp.Text = "";
string GroupIds = string.Empty;
string EmpIds = string.Empty;
DataTable dtEmp = objEmp.GetEmployeeMaster(Session["CompId"].ToString());
dtEmp = new DataView(dtEmp, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dtEmp.Rows.Count > 0)
{
Session["dtEmp"] = dtEmp;
gvEmployee.DataSource = dtEmp;
gvEmployee.DataBind();
}
}
}
protected void EmpGroup_CheckedChanged(object sender, EventArgs e)
{
if (rbtnGroup.Checked)
{
pnlEmp.Visible = false;
pnlGroup.Visible = true;
btnDelete.Visible = true;
DataTable dtGroup = objEmpGroup.GetEmployeeGroup_Master(Session["CompId"].ToString());
dtGroup = new DataView(dtGroup, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dtGroup.Rows.Count > 0)
{
lbxGroup.DataSource = dtGroup;
lbxGroup.DataTextField = "Group_Name";
lbxGroup.DataValueField = "Group_Id";
lbxGroup.DataBind();
}
DataTable dtHolidayGroup = objHolidayGroup.GetHolidayGroupByHolidayId(Session["CompId"].ToString(), editid.Value);
if (dtHolidayGroup.Rows.Count > 0)
{
for (int i = 0; i < lbxGroup.Items.Count; i++)
{
DataTable dt = new DataView(dtHolidayGroup, "Group_Id='" + lbxGroup.Items[i].Value + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dt.Rows.Count > 0)
{
lbxGroup.Items[i].Selected = true;
}
}
}
lbxGroup_SelectedIndexChanged(null, null);
}
else if (rbtnEmp.Checked)
{
pnlEmp.Visible = true;
pnlGroup.Visible = false;
btnDelete.Visible = false;
lblEmp.Text = "";
string GroupIds = string.Empty;
string EmpIds = string.Empty;
DataTable dtEmp = objEmp.GetEmployeeMaster(Session["CompId"].ToString());
dtEmp = new DataView(dtEmp, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
// dtEmpInGroup = new DataView(dtEmpInGroup, "Group_Id in(" + GroupIds.Substring(0, GroupIds.Length - 1) + ")", "", DataViewRowState.CurrentRows).ToTable();
//for (int i = 0; i < dtEmpInGroup.Rows.Count; i++)
//{
// if (!EmpIds.Split(',').Contains(dtEmpInGroup.Rows[i]["Emp_Id"].ToString()))
// {
// EmpIds += dtEmpInGroup.Rows[i]["Emp_Id"].ToString() + ",";
// }
//}
//dtEmp = new DataView(dtEmp, "Emp_Id in(" + EmpIds.Substring(0, EmpIds.Length - 1) + ")", "", DataViewRowState.CurrentRows).ToTable();
if (dtEmp.Rows.Count > 0)
{
Session["dtEmp"] = dtEmp;
gvEmployee.DataSource = dtEmp;
gvEmployee.DataBind();
lblTotalRecordEmp.Text = Resources.Attendance.Total_Records + " : " + dtEmp.Rows.Count.ToString() + "";
DataTable dtEmpInGrp = objEmpHoliday.GetEmployeeHolidayMasterById(Session["CompId"].ToString(), editid.Value);
if (dtEmpInGrp.Rows.Count > 0)
{
for (int i = 0; i < dtEmpInGrp.Rows.Count; i++)
{
lblEmp.Text += dtEmpInGrp.Rows[i]["Emp_Id"].ToString() + ",";
}
}
foreach (GridViewRow gvr in gvEmployee.Rows)
{
Label lb = (Label)gvr.FindControl("lblEmpId");
if (lblEmp.Text.Split(',').Contains(lb.Text))
{
if (!lblEmp.Text.Split(',').Contains(lb.Text))
{
lblEmp.Text += lb.Text + ",";
}
CheckBox chk = (CheckBox)gvr.FindControl("chkgvSelect");
chk.Checked = true;
}
}
}
}
}