private void Getdepartments() { try { Attendance.BAL.Report obj = new Report(); DataTable dt = obj.GetAllDepartments(); ddlDeptment.DataSource = dt; ddlDeptment.DataTextField = "Deptname"; ddlDeptment.DataValueField = "DeptID"; ddlDeptment.DataBind(); ddlEditDepart.DataSource = dt; ddlEditDepart.DataTextField = "Deptname"; ddlEditDepart.DataValueField = "DeptID"; ddlEditDepart.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) { } }