public UpdateEmp(vari vi)
{
v = vi;
InitializeComponent();
List <ViewEmpVar> emplist = new List <ViewEmpVar>();
//List<Department> departments = new List<Department>();
SqlDataReader reader = bl.DShowemplist(vi);
ViewEmpVar ser = new ViewEmpVar();
while (reader.Read())
{
// ser.Id = reader.GetInt32(0);
vi.name = reader.GetString(1);
vi.Department = reader.GetString(2);
vi.salary = reader.GetString(3);
//vi.address= reader.GetString(4);
vi.available = reader.GetString(4);
vi.address = reader.GetString(5);
//emplist.Add(ser);
}
// EmpView.DataSource = emplist;
Ename.Text = vi.name;
Department.Text = vi.Department;
Salary.Text = vi.salary;
Address.Text = vi.address;
if (vi.available == "Yes")
{
Yes.Checked = true;
}
else
{
No.Checked = true;
}
}
public DeleteEmp(vari d_id)
{
InitializeComponent();
vemp = d_id;
List <ViewEmpVar> emplist = new List <ViewEmpVar>();
//List<Department> departments = new List<Department>();
SqlDataReader reader = bl.DShowemplist(vemp);
while (reader.Read())
{
ViewEmpVar ser = new ViewEmpVar();
ser.Id = reader.GetInt32(0);
ser.Name = reader.GetString(1);
ser.Department = reader.GetString(2);
ser.Salary = reader.GetString(3);
ser.Available = reader.GetString(4);
emplist.Add(ser);
}
dempview.DataSource = emplist;
}
public Employee()
{
InitializeComponent();
List <ViewEmpVar> emplist = new List <ViewEmpVar>();
//List<Department> departments = new List<Department>();
SqlDataReader reader = bl.Showemplist();
while (reader.Read())
{
ViewEmpVar ser = new ViewEmpVar();
ser.Id = reader.GetInt32(0);
ser.Name = reader.GetString(1);
ser.Department = reader.GetString(2);
ser.Salary = reader.GetString(3);
ser.Available = reader.GetString(4);
ser.Address = reader.GetString(5);
emplist.Add(ser);
}
EmpView.DataSource = emplist;
}