public List <Staff> GetEachStaffType(int choice)
{
Staff staffObj = null;
List <Staff> staffList = new List <Staff>();
List <Staff> staffTypeList = new List <Staff>();
try
{
using SqlConnection connection = new SqlConnection(this.connectionString);
SqlCommand cmd = new SqlCommand("spViewEachStaff", connection);
cmd.Parameters.AddWithValue("@staffChoice", choice);
connection.Open();
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
int staffType = (int)(sdr["StaffType"]);
if (staffType == 1)
{
staffObj = new Teaching((int)sdr["StaffID"], (int)sdr["EmployeeID"], (int)sdr["Salary"], (StaffType)sdr["StaffType"], (string)sdr["InstituteName"], (string)sdr["Subject"]);
}
else if (staffType == 2)
{
staffObj = new Administration((int)sdr["StaffID"], (int)sdr["EmployeeID"], (int)sdr["Salary"], (StaffType)sdr["StaffType"], (string)sdr["InstituteName"], (string)sdr["AdministrationArea"]);
}
else
{
staffObj = new Supporting((int)sdr["StaffID"], (int)sdr["EmployeeID"], (int)sdr["Salary"], (StaffType)sdr["StaffType"], (string)sdr["InstituteName"], (string)sdr["SupportingArea"]);
}
staffList.Add(staffObj);
}
if (choice == 1)
{
staffTypeList = staffList.Where(item => item.Designation == StaffType.Teaching).ToList();
}
else if (choice == 2)
{
staffTypeList = staffList.Where(item => item.Designation == StaffType.Administration).ToList();
}
else
{
staffTypeList = staffList.Where(item => item.Designation == StaffType.Supporting).ToList();
}
}
catch (Exception e)
{
Console.WriteLine("OOPs, something went wrong.\n" + e);
}
return(staffTypeList);
}
public Staff GetStaffByID(int iD)
{
Staff staffObj = null;
try
{
using SqlConnection connection = new SqlConnection(this.connectionString);
SqlCommand cmd = new SqlCommand("spSearchStaff", connection);
connection.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@staffID", iD);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
int staffType = (int)(sdr["StaffType"]);
if (staffType == 1)
{
staffObj = new Teaching((int)sdr["StaffID"], (int)sdr["EmployeeID"], (int)sdr["Salary"], (StaffType)sdr["StaffType"], (string)sdr["InstituteName"], (string)sdr["Subject"]);
}
else if (staffType == 2)
{
staffObj = new Administration((int)sdr["StaffID"], (int)sdr["EmployeeID"], (int)sdr["Salary"], (StaffType)sdr["StaffType"], (string)sdr["InstituteName"], (string)sdr["AdministrationArea"]);
}
else
{
staffObj = new Supporting((int)sdr["StaffID"], (int)sdr["EmployeeID"], (int)sdr["Salary"], (StaffType)sdr["StaffType"], (string)sdr["InstituteName"], (string)sdr["SupportingArea"]);
}
}
}
catch (Exception e)
{
Console.WriteLine("OOPs, something went wrong.\n" + e);
}
return(staffObj);
}