private void GetAllWages()
{
try
{
Attendance.BAL.Report obj = new Report();
DataTable dt = obj.GetAllWages();
ddlWagetype.DataSource = dt;
ddlWagetype.DataTextField = "WageType";
ddlWagetype.DataValueField = "WageID";
ddlWagetype.DataBind();
}
catch (Exception ex)
{
}
}
private void GetNamesList(string Fieldname, DataTable dt)
{
try
{
if (Fieldname == "Department")
{
Attendance.BAL.Report obj = new Report();
DataTable ds = obj.GetAllDepartments();
ddlNewValue.DataSource = ds;
ddlNewValue.DataTextField = "DeptName";
ddlNewValue.DataValueField = "DeptID";
ddlNewValue.DataBind();
ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString()));
txtEditNewValue.Visible = false;
ddlNewValue.Visible = true;
}
else if (Fieldname == "Location")
{
Attendance.BAL.Report obj = new Report();
DataTable ds = obj.GetLocations();
ddlNewValue.DataSource = ds;
ddlNewValue.DataTextField = "LocationName";
ddlNewValue.DataValueField = "LocationId";
ddlNewValue.DataBind();
ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString()));
txtEditNewValue.Visible = false;
ddlNewValue.Visible = true;
}
else if (Fieldname == "Schedule")
{
Attendance.BAL.Report obj = new Attendance.BAL.Report();
DataTable ds = obj.GetAllScheduleTypes();
ddlNewValue.DataSource = ds;
ddlNewValue.DataValueField = "ScheduleID";
ddlNewValue.DataTextField = "ScheduleType";
ddlNewValue.DataBind();
ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString()));
txtEditNewValue.Visible = false;
ddlNewValue.Visible = true;
}
else if (Fieldname == "State")
{
Attendance.BAL.Business obj = new Attendance.BAL.Business();
DataTable ds = obj.GetState();
ddlNewValue.DataSource = ds;
ddlNewValue.DataValueField = "StateID";
ddlNewValue.DataTextField = "StateName";
ddlNewValue.DataBind();
ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString()));
txtEditNewValue.Visible = false;
ddlNewValue.Visible = true;
}
else if (Fieldname == "Wage")
{
Attendance.BAL.Report obj = new Attendance.BAL.Report();
DataTable ds = obj.GetAllWages();
ddlNewValue.DataSource = ds;
ddlNewValue.DataValueField = "WageID";
ddlNewValue.DataTextField = "WageType";
ddlNewValue.DataBind();
txtEditNewValue.Visible = false;
ddlNewValue.Visible = true;
ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString()));
}
else if (Fieldname == "Employee type")
{
Attendance.BAL.Report obj = new Attendance.BAL.Report();
DataTable ds = obj.GetAllEmployeetypes();
ddlNewValue.DataSource = ds;
ddlNewValue.DataValueField = "EmpType";
ddlNewValue.DataTextField = "EmpTypeID";
ddlNewValue.DataBind();
ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString()));
txtEditNewValue.Visible = false;
ddlNewValue.Visible = true;
}
else if (Fieldname == "Shift")
{
Attendance.BAL.EmployeeBL obj = new Attendance.BAL.EmployeeBL();
DataTable ds = obj.GetShifts();
DataView dv = ds.DefaultView;
dv.RowFilter = "locationID=" + Convert.ToInt32(dt.Rows[0]["locationID"].ToString());
DataTable dt1 = dv.ToTable();
ddlNewValue.DataSource = dt1;
ddlNewValue.DataTextField = "ShiftName";
ddlNewValue.DataValueField = "ShiftID";
ddlNewValue.DataBind();
ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString()));
txtEditNewValue.Visible = false;
ddlNewValue.Visible = true;
}
else if (Fieldname == "Filling status")
{
ddlNewValue.DataSource = null;
ddlNewValue.DataBind();
ddlNewValue.Items.Insert(0, new ListItem("Single", "1"));
ddlNewValue.Items.Insert(1, new ListItem("Married", "2"));
txtEditNewValue.Visible = false;
ddlNewValue.Visible = true;
ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString()));
}
else
{
txtEditNewValue.Text = dt.Rows[0]["NewValue"].ToString();
txtEditNewValue.Visible = true;
ddlNewValue.Visible = false;
}
}
catch (Exception ex)
{
}
}