public List <CourseStatics> GetCourseStatics(string departmentCode)
{
List <CourseStatics> courseStaticsList = new List <CourseStatics>();
GenarateConnection();
using (Connection)
{
string query = "select * from CourseStatics where Department = @Department and Visible = @Visible;";
Command = new SqlCommand(query, Connection);
Command.Parameters.Clear();
Connection.Open();
Command.Parameters.Add("@Department", SqlDbType.VarChar);
Command.Parameters["@Department"].Value = departmentCode;
Command.Parameters.Add("@Visible", SqlDbType.Int);
Command.Parameters["@Visible"].Value = 1;
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
while (Reader.Read())
{
CourseStatics courseStatics = new CourseStatics();
courseStatics.Code = Reader["Code"].ToString();
courseStatics.Name = Reader["Name"].ToString();
courseStatics.Semester = Reader["Semester"].ToString();
courseStatics.Teacher = Reader["Teacher"].ToString();
courseStaticsList.Add(courseStatics);
}
}
Connection.Close();
}
return(courseStaticsList);
}
public List <CourseStatics> GetCourseStaticsesByDepartment(int departmentId)
{
connection.ConnectionString = connectionString;
string sqlQuery = "SELECT * FROM CourseStatics WHERE department_id='" + departmentId + "'";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <CourseStatics> courseStaticsList = new List <CourseStatics>();
while (reader.Read())
{
CourseStatics courseList = new CourseStatics
{
Code = reader["code"].ToString(),
Name = reader["courseName"].ToString(),
SemesterId = reader["semester_id"].ToString(),
AssignedTo = reader["teachersName"].ToString()
};
courseStaticsList.Add(courseList);
}
reader.Close();
connection.Close();
return(courseStaticsList);
}
public List <CourseStatics> GetAllCourseStatics()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "select distinct CourseCode,CourseName,Semester,TeacherName,CourseStatus from CourseStatics ";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <CourseStatics> courseStaticList = new List <CourseStatics>();
while (reader.Read())
{
CourseStatics courseStatics = new CourseStatics();
courseStatics.CourseName = reader["CourseName"].ToString();
courseStatics.Semester = reader["Semester"].ToString();
courseStatics.CourseStatus = reader["CourseStatus"] == DBNull.Value
? (int?)null
: (int)reader["CourseStatus"];
courseStatics.CourseCode = reader["CourseCode"].ToString();
courseStatics.TeacherName = reader["TeacherName"].ToString();
courseStaticList.Add(courseStatics);
}
reader.Close();
connection.Close();
return(courseStaticList);
}
public List <CourseStatics> GetAllCourseStatics()
{
Query = "SELECT * FROM CourseStatics";
Command = new SqlCommand(Query, Connection);
List <CourseStatics> aList = new List <CourseStatics>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
CourseStatics aCourseStatics = new CourseStatics();
aCourseStatics.Code = Reader["Code"].ToString();
aCourseStatics.Name = Reader["Name"].ToString();
aCourseStatics.DepartmentId = (int)Reader["DepartmentId"];
aCourseStatics.Semester = Reader["Semester"].ToString();
aList.RemoveAll(m => m.Code == aCourseStatics.Code);
if (Reader["Valid"].ToString() == "True")
{
aCourseStatics.AssignedTo = Reader["AssignedTo"].ToString();
}
else
{
aCourseStatics.AssignedTo = "Not Assigned Yet";
}
aList.Add(aCourseStatics);
}
Reader.Close();
Connection.Close();
return(aList);
}
public List <CourseStatics> GetAllCouseStatics()
{
Query = "SELECT * FROM CourseStatics_vtb";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <CourseStatics> coursesStatics = new List <CourseStatics>();
while (Reader.Read())
{
CourseStatics courseStatics = new CourseStatics
{
DepartmentId = (int)Reader["DepartmentId"],
Code = Reader["CourseCode"].ToString(),
Name = Reader["CourseName"].ToString(),
Semester = Reader["SemesterName"].ToString(),
AssignedTo = Reader["TeacherName"].ToString()
};
if (courseStatics.AssignedTo == "")
{
courseStatics.AssignedTo = "Not Assigned Yet";
}
if (courseStatics.Code != "")
{
coursesStatics.Add(courseStatics);
}
}
Reader.Close();
Connection.Close();
return(coursesStatics);
}
public List <CourseStatics> GetCourseStatics(int departmentId)
{
//int status = 1;
SqlConnection connection = new SqlConnection(connectionString);
string query = "select CourseCode,CourseName,Semester,TeacherName,CourseStatus from CourseStatics where DeptId='" + departmentId + "' and CourseStatus='" + 1 + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <CourseStatics> courseStaticList = new List <CourseStatics>();
while (reader.Read())
{
CourseStatics courseStatics = new CourseStatics();
courseStatics.CourseName = reader["CourseName"].ToString();
courseStatics.Semester = reader["Semester"].ToString();
courseStatics.CourseStatus = (int)reader["CourseStatus"];
courseStatics.CourseCode = reader["CourseCode"].ToString();
courseStatics.TeacherName = reader["TeacherName"].ToString();
courseStaticList.Add(courseStatics);
}
reader.Close();
connection.Close();
return(courseStaticList);
}
public List <CourseStatics> GetCourseStaticsByDepartmentId(int departmentId)
{
try
{
List <CourseStatics> courseStaticses = null;
const string storeProcedure = "GetCourseStaticsByDepartmentId";
Connection.Open();
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = storeProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@DepartmentId", departmentId);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
courseStaticses = new List <CourseStatics>();
while (Reader.Read())
{
var courseStatics = new CourseStatics
{
Code = Reader["Code"].ToString(),
Title = Reader["Title"].ToString(),
Semester = Reader["Semester"].ToString(),
AssignedTo = Reader["AssignedTo"].ToString()
};
courseStaticses.Add(courseStatics);
}
Reader.Close();
}
return(courseStaticses);
}
finally
{
Connection.Close();
}
}
public List <CourseStatics> GetAllCourseStaticsesbyDepartmentId(int a)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM v_dogcat WHERE DepartmentId='" + a + "'";
SqlCommand command = new SqlCommand(query, connection);
List <CourseStatics> aList = new List <CourseStatics>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
CourseStatics aCourseStatics = new CourseStatics();
aCourseStatics.CourseCode = reader["CourseCode"].ToString();
aCourseStatics.CourseName = reader["CourseName"].ToString();
aCourseStatics.SemesterName = reader["Semester"].ToString();
aCourseStatics.DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString());
aCourseStatics.TeacherName = reader["TeacherName"].ToString();
aCourseStatics.Status = reader["Status"].ToString();
aList.Add(aCourseStatics);
}
reader.Close();
}
connection.Close();
return(aList);
}
public ActionResult ViewCourseStatics(CourseStatics aCourseStatics)
{
DepartmentManager aDepartmentManager = new DepartmentManager();
CourseStaticManager aCourseStaticManager = new CourseStaticManager();
ViewBag.departments = aDepartmentManager.GetAllDepartmentInfo();
ViewBag.coursestatics = aCourseStaticManager.GetAllCourseStaticses();
var courselist = aCourseStaticManager.GetAllCourseStaticsesbyDepartmentId(aCourseStatics.DepartmentId);
ViewBag.clist = courselist;
return(View());
}
public List <CourseStatics> GetCourseInformation()
{
string query = "SELECT * FROM ViewCourseStatics WHERE Assigned='true'";
Command = new SqlCommand(query, Connection);
List <CourseStatics> courseStaticList = new List <CourseStatics>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
CourseStatics courseStatics = new CourseStatics();
courseStatics.Code = Reader["Code"].ToString();
courseStatics.Name = Reader["Name"].ToString();
courseStatics.DepartmentId = Convert.ToInt32(Reader["DepartmentId"]);
courseStatics.Semester = Convert.ToInt32(Reader["Semester"]);
courseStatics.Assigned = Reader["Assigned"].ToString();
courseStatics.TeacherId = HandleNullValue(Reader);
courseStaticList.Add(courseStatics);
}
Reader.Close();
Connection.Close();
return(courseStaticList);
}
public List<CourseStatics> GetCourseStatics(int departmentId)
{
List<CourseStatics> courseStaticsList;
List<Course> courses;
List<CourseStatics> newCourseStatics;
string assigned = "";
if(departmentId!=0)
{
courseStaticsList = _courseGateway.GetCourseStatics(departmentId);
courses = GetAllCourses();
var courseList = courses.Where(a => a.DepartmentId == departmentId);
newCourseStatics = new List<CourseStatics>();
CourseStatics aCourseStatics = null;
foreach (Course course in courseList)
{
bool flag = false;
foreach (CourseStatics courseStatics in courseStaticsList)
{
if (courseStatics.CourseCode==course.CourseCode)
{
if (courseStatics.CourseStatus==1)
{
newCourseStatics.Add(courseStatics);
flag = true;
break;
}
}
}
if (!flag)
{
string semester = _semesterGateway.GetSemesterNameById(course.SemesterId);
assigned= "Not Assigned Yet";
aCourseStatics=new CourseStatics(course.CourseCode,course.CourseName,semester,assigned);
newCourseStatics.Add(aCourseStatics);
}
}
return newCourseStatics;
}
courseStaticsList = _courseGateway.GetAllCourseStatics();
//courses = GetAllCourses();
newCourseStatics = new List<CourseStatics>();
CourseStatics bCourseStatics = null;
foreach (CourseStatics courseStatic in courseStaticsList)
{
if (courseStatic.CourseCode!="")
{
if (courseStatic.TeacherName!="")
{
if (courseStatic.CourseStatus==1)
{
newCourseStatics.Add(courseStatic);
}
else
{
assigned = "Not Assigned Yet";
bCourseStatics = new CourseStatics(courseStatic.CourseCode, courseStatic.CourseName, courseStatic.Semester, assigned);
newCourseStatics.Add(bCourseStatics);
}
}
else
{
assigned = "Not Assigned Yet";
bCourseStatics=new CourseStatics(courseStatic.CourseCode,courseStatic.CourseName,courseStatic.Semester,assigned);
newCourseStatics.Add(bCourseStatics);
}
}
}
return newCourseStatics;
}
