public List <lecturerList> getLecturer(int id)
{
bo = new ClassBo();
dt = new DataTable();
dt = da.getLecturer(id);
List <lecturerList> list = new List <lecturerList>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lecturerList itlist = new lecturerList();
itlist.id = dr[bo.id].ToString();
itlist.universityID = dr[bo.universityID].ToString();
itlist.personalID = dr[bo.personalID].ToString();
itlist.personalCode = dr[bo.code].ToString();
itlist.position = dr[bo.position].ToString();
itlist.department = dr[bo.department].ToString();
itlist.description = dr[bo.description].ToString();
itlist.maximumLecturePerDay = dr[bo.maximumLecturePerDay].ToString();
itlist.maxLectureHoursPerDay = dr[bo.maxLectureHoursPerDay].ToString();
itlist.maximumLecturePerCycle = dr[bo.maximumLecturePerCycle].ToString();
itlist.qualification = dr[bo.qualification].ToString();
itlist.status = dr[bo.status].ToString() == "I" ? "Inactive" : "Active";
list.Add(itlist);
}
}
return(list);
}
public int saveLecturer(lecturerList list)
{
int rowCount = 0;
try
{
bo = new ClassBo();
con.ConnectionString = connStr;
cmd = new SqlCommand(ClassBo.insLecturer, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(bo.P_id, Convert.ToInt32(list.id));
cmd.Parameters.AddWithValue(bo.P_universityID, list.universityID);
cmd.Parameters.AddWithValue(bo.P_personalID, list.personalID);
cmd.Parameters.AddWithValue(bo.P_position, list.position);
cmd.Parameters.AddWithValue(bo.P_department, Convert.ToInt32(list.department));
cmd.Parameters.AddWithValue(bo.P_description, list.description);
cmd.Parameters.AddWithValue(bo.P_maximumLecturePerDay, Convert.ToInt32(list.maximumLecturePerDay));
cmd.Parameters.AddWithValue(bo.P_maxLectureHoursPerDay, float.Parse(list.maxLectureHoursPerDay));
cmd.Parameters.AddWithValue(bo.P_maximumLecturePerCycle, Convert.ToInt32(list.maximumLecturePerCycle));
cmd.Parameters.AddWithValue(bo.P_qualification, list.qualification);
cmd.Parameters.AddWithValue(bo.P_status, list.status);
cmd.Parameters.AddWithValue(bo.P_By, 1);
con.Open();
rowCount = cmd.ExecuteNonQuery();
con.Close();
return(rowCount);
}
catch (Exception ex)
{
con.Close();
return(rowCount);
}
}
public List <lecturerList> selectLecturer()
{
bo = new ClassBo();
dt = new DataTable();
dt = da.selectLecturer();
List <lecturerList> list = new List <lecturerList>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lecturerList itlist = new lecturerList();
itlist.id = dr[bo.id].ToString();
itlist.universityID = dr[bo.universityID].ToString();
itlist.personalID = dr[bo.commonName].ToString();
list.Add(itlist);
}
}
return(list);
}
public static int websaveLecturer(lecturerList list)
{
Lecturer cl = new Lecturer();
return(cl.saveLecturer(list));
}
public int saveLecturer(lecturerList list)
{
bl = new ClassBl();
return(bl.saveLecturer(list));
}
public int saveLecturer(lecturerList list)
{
return(da.saveLecturer(list));
}
