public int saveCourses(coursesList list)
{
int rowCount = 0;
try
{
bo = new ClassBo();
con.ConnectionString = connStr;
cmd = new SqlCommand(ClassBo.insCourses, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(bo.P_id, Convert.ToInt32(list.id));
cmd.Parameters.AddWithValue(bo.P_courseCode, list.courseCode);
cmd.Parameters.AddWithValue(bo.P_name, list.name);
cmd.Parameters.AddWithValue(bo.P_types, list.types);
cmd.Parameters.AddWithValue(bo.P_ects, float.Parse(list.ects));
cmd.Parameters.AddWithValue(bo.P_description, list.description);
cmd.Parameters.AddWithValue(bo.P_labFlag, list.labFlag);
cmd.Parameters.AddWithValue(bo.P_maximumHoursPerCycle, float.Parse(list.maximumHoursPerCycle));
cmd.Parameters.AddWithValue(bo.P_maximumDaysPerCycle, Convert.ToInt32(list.maximumDaysPerCycle));
cmd.Parameters.AddWithValue(bo.P_maximumEnrollment, Convert.ToInt32(list.maximumEnrollment));
cmd.Parameters.AddWithValue(bo.P_maximumHoursPerDay, float.Parse(list.maximumHoursPerDay));
if (list.startingDate == null)
{
cmd.Parameters.AddWithValue(bo.P_startingDate, DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue(bo.P_startingDate, list.startingDate);
}
if (list.endingDate == null)
{
cmd.Parameters.AddWithValue(bo.P_endingDate, DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue(bo.P_endingDate, list.endingDate);
}
cmd.Parameters.AddWithValue(bo.P_By, 1);
cmd.Parameters.AddWithValue(bo.P_lcid, Convert.ToInt32(list.lcid));
cmd.Parameters.AddWithValue(bo.P_coursesID, list.coursesID);
cmd.Parameters.AddWithValue(bo.P_lectureID, list.lectureID);
cmd.Parameters.AddWithValue(bo.P_colorCode, list.colorCode);
cmd.Parameters.AddWithValue(bo.P_lcstatus, list.lcstatus);
cmd.Parameters.AddWithValue("@department", Convert.ToInt32(list.department));
cmd.Parameters.AddWithValue(bo.status, list.status);
con.Open();
rowCount = cmd.ExecuteNonQuery();
con.Close();
return(rowCount);
}
catch (Exception ex)
{
con.Close();
return(rowCount);
}
}
public List <coursesList> selectCourse()
{
bo = new ClassBo();
dt = new DataTable();
dt = da.selectCourse();
List <coursesList> list = new List <coursesList>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
coursesList itlist = new coursesList();
itlist.id = dr[bo.id].ToString();
itlist.courseCode = dr[bo.courseCode].ToString();
list.Add(itlist);
}
}
return(list);
}
public List <coursesList> getCourse(int id, string code)
{
bo = new ClassBo();
dt = new DataTable();
dt = da.getCourse(id, code);
List <coursesList> list = new List <coursesList>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
coursesList itlist = new coursesList();
itlist.id = dr[bo.id].ToString();
itlist.courseCode = dr[bo.courseCode].ToString();
itlist.name = dr[bo.name].ToString();
itlist.types = dr[bo.types].ToString();
itlist.ects = dr[bo.ects].ToString();
itlist.department = dr[bo.department].ToString();
itlist.labFlag = dr[bo.labFlag].ToString();
itlist.maximumHoursPerCycle = dr[bo.maximumHoursPerCycle].ToString();
itlist.maximumDaysPerCycle = dr[bo.maximumDaysPerCycle].ToString();
itlist.maximumEnrollment = dr[bo.maximumEnrollment].ToString();
itlist.maximumHoursPerDay = dr[bo.maximumHoursPerDay].ToString();
itlist.description = dr[bo.description].ToString();
itlist.startingDate = dr[bo.startingDate].ToString().Length > 0 ? DateTime.Parse(dr[bo.startingDate].ToString()).ToString("MM/dd/yyyy") : null;
itlist.endingDate = dr[bo.endingDate].ToString().Length > 0 ? DateTime.Parse(dr[bo.endingDate].ToString()).ToString("MM/dd/yyyy") : null;
itlist.status = dr[bo.status].ToString() == "I" ? "Inactive" : "Active";
itlist.lcid = dr[bo.lcid].ToString();
itlist.coursesID = dr[bo.coursesID].ToString();
itlist.lectureID = dr[bo.lectureID].ToString();
itlist.colorCode = dr[bo.colorCode].ToString();
itlist.lcstatus = dr[bo.lcstatus].ToString() == "I" ? "Inactive" : "Active";
list.Add(itlist);
}
}
return(list);
}
public List <coursesList> selectedCourse(int id)
{
bo = new ClassBo();
dt = new DataTable();
dt = da.selectedCourse(id);
List <coursesList> list = new List <coursesList>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
coursesList itlist = new coursesList();
itlist.id = dr[bo.id].ToString();
itlist.courseCode = dr[bo.courseCode].ToString();
itlist.maximumDaysPerCycle = dr[bo.maximumDaysPerCycle].ToString();
itlist.maximumHoursPerCycle = dr[bo.maximumHoursPerCycle].ToString();
itlist.maximumHoursPerDay = dr[bo.maximumHoursPerDay].ToString();
itlist.lcid = dr[bo.lcid].ToString();
itlist.name = dr[bo.commonName].ToString();
list.Add(itlist);
}
}
return(list);
}
public static int websaveCourses(coursesList list)
{
index cl = new index();
return(cl.saveCourses(list));
}
public int saveCourses(coursesList list)
{
bl = new ClassBl();
return(bl.saveCourses(list));
}
public int saveCourses(coursesList list)
{
return(da.saveCourses(list));
}
