示例#1
0
 private bool IsCorseCodeValid(Course aCourse)
 {
     if (aCourse.Code.Length > 5)
     {
         return true;
     }
     return false;
 }
示例#2
0
        public ActionResult Save(Course aCourse)
        {
            try
            {

                    string message = courseManager.Save(aCourse);
                    ViewBag.Mgs = message;
                    List<Department> departments = departmentManager.GetAll().ToList();
                    List<Semester> semesters = semesterManager.GetAll.ToList();
                    ViewBag.Departments = departments;
                    ViewBag.Semesters = semesters;
                    return View();

                //return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }
示例#3
0
 public string Save(Course aCourse)
 {
     if (!(IsCorseCodeValid(aCourse)))
     {
         return "Course must be at least 5 character of length";
     }
     if (IsCourseCodeExits(aCourse.Code))
     {
         return "Course code must be unique";
     }
     if (IsCourseNameExits(aCourse.Name))
     {
         return "Course Name must be unique";
     }
     if (courseGateway.Insert(aCourse) > 0)
     {
         return "Saved Sucessfully";
     }
         return "Failed to save";
 }
示例#4
0
 public int Insert(Course aCourse)
 {
     try
     {
         CommandObj.CommandText = "spAddCourse";
         CommandObj.CommandType = CommandType.StoredProcedure;
         CommandObj.Parameters.Clear();
         CommandObj.Parameters.AddWithValue("@Code", aCourse.Code.ToUpper());
         CommandObj.Parameters.AddWithValue("@Name", aCourse.Name);
         CommandObj.Parameters.AddWithValue("@Credit", aCourse.Credit);
         CommandObj.Parameters.AddWithValue("@Description", aCourse.Description);
         CommandObj.Parameters.AddWithValue("@DepartmentId", aCourse.DepartmentId);
         CommandObj.Parameters.AddWithValue("@SemesterId", aCourse.SemesterId);
         ConnectionObj.Open();
         return CommandObj.ExecuteNonQuery();
     }
     catch (Exception exception)
     {
         throw new Exception("Unable to Seve course", exception);
     }
     finally
     {
         ConnectionObj.Close();
         CommandObj.Dispose();
     }
 }
示例#5
0
 public IEnumerable<Course> GetCoursesTakeByaStudentByStudentId(int id)
 {
     try
     {
         List<Course> courses = new List<Course>();
         CommandObj.CommandText = "spGetCoursesTakenByaStudent";
         CommandObj.CommandType = CommandType.StoredProcedure;
         CommandObj.Parameters.Clear();
         CommandObj.Parameters.AddWithValue("@StudentId", id);
         ConnectionObj.Open();
         SqlDataReader reader = CommandObj.ExecuteReader();
         while (reader.Read())
         {
             Course aCourse = new Course
             {
                 Id = Convert.ToInt32(reader["Id"].ToString()),
                 Name = reader["Name"].ToString(),
                 Code = reader["Code"].ToString(),
                 Credit = Convert.ToDouble(reader["Credit"].ToString()),
                 DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()),
                 Description = reader["Descirption"].ToString(),
                 SemesterId = Convert.ToInt32(reader["SemesterId"].ToString())
             };
             courses.Add(aCourse);
         }
         reader.Close();
         return courses;
     }
     catch (Exception exception)
     {
         throw new Exception("Unable to collect Courses",exception);
     }
     finally
     {
         ConnectionObj.Close();
         CommandObj.Dispose();
     }
 }
示例#6
0
        public Course GetCourseByName(string name)
        {
            try
            {
                string query = "SELECT * FROM t_Course WHERE Name=@name";
                CommandObj.CommandText = query;
                CommandObj.Parameters.Clear();
                CommandObj.Parameters.AddWithValue("@name", name);
                ConnectionObj.Open();
                Course course = null;
                SqlDataReader reader = CommandObj.ExecuteReader();
                if(reader.Read())
                {
                  course = new Course
                    {
                        Id = Convert.ToInt32(reader["Id"].ToString()),
                        Name = reader["Name"].ToString(),
                        Code = reader["Code"].ToString(),
                        Credit = Convert.ToDouble(reader["Credit"].ToString()),
                        Description = reader["Descirption"].ToString(),
                        DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()),
                        SemesterId = Convert.ToInt32(reader["SemesterId"].ToString())

                    };

                }
                reader.Close();
                return course;
            }
            catch (Exception exception)
            {
                throw new Exception("Unable to collect course", exception);
            }
            finally
            {
                ConnectionObj.Close();
                CommandObj.Dispose();
            }
        }
示例#7
0
        public IEnumerable<Course> GetCourseByDepartmentId(int departmentId)
        {
            try
                {
                    string query = "SELECT * FROM t_Course WHERE DepartmentId='"+departmentId+"'";
                    CommandObj.CommandText = query;
                    List<Course> courses = new List<Course>();
                    ConnectionObj.Open();
                    SqlDataReader reader = CommandObj.ExecuteReader();

                    while (reader.Read())
                    {
                        Course course = new Course
                        {
                            Id = Convert.ToInt32(reader["Id"].ToString()),
                            Name = reader["Name"].ToString(),
                            Code = reader["Code"].ToString(),
                            Credit = Convert.ToDouble(reader["Credit"].ToString()),
                            Description = reader["Descirption"].ToString(),
                            DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()),
                            SemesterId = Convert.ToInt32(reader["SemesterId"].ToString())

                        };
                        courses.Add(course);
                    }
                    reader.Close();
                    return courses;
                }
                catch (Exception exception)
                {
                    throw new Exception("Unable to collect courses", exception);
                }
                finally
                {
                    ConnectionObj.Close();
                    CommandObj.Dispose();
                }
        }