コード例 #1
0
ファイル: CourseController.cs プロジェクト: punj-aab/School
 //
 // GET: /Cource/Create
 public ActionResult Create()
 {
     Course objCourse = new Course();
     objCourse.OrganizationList = LoadSelectLists();
     objCourse.OrganisationId = ViewBag.OrganizationId == null ? 0 : Convert.ToInt32(ViewBag.OrganizationId);
     return PartialView(objCourse);
 }
コード例 #2
0
ファイル: CourseRepository.cs プロジェクト: punj-aab/School
 //public List<Course> GetCourses()
 //{
 //    string sql = "select CourseId,CourseName,CourseDescription,Courses.CreatedBy,Courses.InsertedOn,Courses.ModifiedBy,ModifiedOn,Courses.OrganisationId,Organizations.OrganizationName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName ";
 //    sql += "from Courses join Organizations on Courses.OrganisationId=Organizations.OrganizationId join Users on Courses.CreatedBy=Users.UserId left join Users as Users_1 on  Courses.ModifiedBy=Users_1.UserId";
 //    List<Course> modelList = db.Query<Course>(sql).ToList();
 //    return modelList;
 //}
 //public Course GetCourses(long id)
 //{
 //    string sql = "select CourseId,CourseName,CourseDescription,Courses.CreatedBy,Courses.InsertedOn,Courses.ModifiedBy,ModifiedOn,Courses.OrganisationId,Organizations.OrganizationName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName ";
 //    sql += "from Courses join Organizations on Courses.OrganisationId=Organizations.OrganizationId join Users on Courses.CreatedBy=Users.UserId left join Users as Users_1 on  Courses.ModifiedBy=Users_1.UserId ";
 //    sql += "where CourseId=@0";
 //    Course objModel = db.Query<Course>(sql, id).FirstOrDefault();
 //    return objModel;
 //}
 public bool Create(Course objCourse)
 {
     int recAffected = 0;
     DBConnectionString.Course Course = new DBConnectionString.Course();
     Course.CourseName = objCourse.CourseName;
     Course.CourseDescription = objCourse.CourseDescription;
     Course.OrganisationId = objCourse.OrganisationId;
     Course.CreatedBy = objCourse.CreatedBy;
     Course.InsertedOn = DateTime.Now;
     recAffected = Convert.ToInt32(Course.Insert());
     if (recAffected > 0)
     {
         return true;
     }
     return false;
 }
コード例 #3
0
ファイル: CourseController.cs プロジェクト: punj-aab/School
        public string Create(Course course, string token)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    course.CreatedBy = _userStatistics.UserId;
                    if (objRep.CreateCourse(course))
                    {
                        SaveFiles(token, this.GetType().Name, course.CourseId);
                        return Convert.ToString(true);
                    }
                    return Convert.ToString(false);
                }

                return Convert.ToString(false);
            }
            catch (Exception ex)
            {
                return ex.Message.ToString();
            }
        }
コード例 #4
0
ファイル: CommonRepository.cs プロジェクト: punj-aab/School
        public bool CreateCourse(Course objCourse)
        {
            var parameters = new
            {
                CourseName = objCourse.CourseName,
                CourseDescription = objCourse.CourseDescription,
                OrganisationId = objCourse.OrganisationId,
                CreatedBy = objCourse.CreatedBy,
                InsertedOn = DateTime.Now,
            };

            using (IDbConnection connection = OpenConnection())
            {
                const string storedProcedure = "usp_addCourse";
                int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure);
                SetIdentity<int>(connection, id => objCourse.CourseId = id);
                if (rowsAffected > 0)
                {
                    return true;
                }
                return false;
            }
        }
コード例 #5
0
ファイル: CourseController.cs プロジェクト: punj-aab/School
        public string Edit(Course course, string token)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    course.ModifiedBy = _userStatistics.UserId;
                    course.ModifiedOn = DateTime.UtcNow;
                    if (objRep.Update(course))
                    {
                        SaveFiles(token, this.GetType().Name, course.CourseId);
                        return Convert.ToString(true);
                    }
                    return Convert.ToString(false);
                }

                return Convert.ToString(false);
            }
            catch (Exception ex)
            {
                return ex.Message.ToString();
            }
        }
コード例 #6
0
ファイル: ScheduleRepository.cs プロジェクト: punj-aab/School
        public Schedule LoadScheduleLists(string userRole, long organizationId = -1, long scheduleId = -1)
        {
            Schedule schedule = null;
            if (scheduleId != -1)
            {
                schedule = this.GetSchedule(scheduleId);
            }
            if (schedule == null)
            {
                schedule = new Schedule();
            }
            //list class objects
            List<Organization> listOrganizations = new List<Organization>();
            List<Course> courseList = new List<Course>();
            List<Class> classList = new List<Class>();
            List<Subject> subjectList = new List<Subject>();
            List<Department> departmentList = new List<Department>();
            List<ClassRoom> classRoomList = new List<ClassRoom>();

            //class objects
            Organization objOrganization = null;
            Course objCourse = null;
            Class objClass = null;
            Subject objSubject = null;
            Department objDep = null;
            ClassRoom objRoom = null;

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["StudentContext"].ConnectionString);
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            using (SqlCommand cmd = new SqlCommand("usp_getSchedules", con))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@userRole", SqlDbType.VarChar, 50).Value = userRole;
                cmd.Parameters.Add("@organizationId", SqlDbType.BigInt).Value = schedule.OrganizationId;
                cmd.Parameters.Add("@courseId", SqlDbType.BigInt).Value = schedule.CourseId;
                cmd.Parameters.Add("@departmentId", SqlDbType.BigInt).Value = schedule.DepartmentId;
                cmd.Parameters.Add("@classId", SqlDbType.BigInt).Value = schedule.ClassId;
                cmd.Parameters.Add("@createdByOrganization", SqlDbType.BigInt, 50).Value = organizationId;

                SqlDataAdapter adp = new SqlDataAdapter();
                adp.SelectCommand = cmd;
                DataSet dataSet = new DataSet();
                adp.Fill(dataSet);

                foreach (DataRow row in dataSet.Tables[0].Rows)
                {
                    objOrganization = new Organization();
                    objOrganization.OrganizationId = Convert.ToInt64(row["OrganizationId"]);
                    objOrganization.OrganizationName = Convert.ToString(row["OrganizationName"]);
                    listOrganizations.Add(objOrganization);
                    if (userRole != "SiteAdmin")
                    {
                        schedule.OrganizationName = objOrganization.OrganizationName;
                    }
                }

                foreach (DataRow row in dataSet.Tables[1].Rows)
                {
                    objCourse = new Course();
                    objCourse.CourseId = Convert.ToInt64(row["CourseId"]);
                    objCourse.CourseName = Convert.ToString(row["CourseName"]);
                    courseList.Add(objCourse);
                }

                foreach (DataRow row in dataSet.Tables[2].Rows)
                {
                    objClass = new Class();
                    objClass.ClassId = Convert.ToInt64(row["ClassId"]);
                    objClass.ClassName = Convert.ToString(row["ClassName"]);
                    classList.Add(objClass);
                }

                foreach (DataRow row in dataSet.Tables[3].Rows)
                {
                    objSubject = new Subject();
                    objSubject.SubjectId = Convert.ToInt64(row["SubjectId"]);
                    objSubject.SubjectName = Convert.ToString(row["SubjectName"]);
                    subjectList.Add(objSubject);
                }

                foreach (DataRow row in dataSet.Tables[4].Rows)
                {
                    objDep = new Department();
                    objDep.DepartmentId = Convert.ToInt64(row["DepartmentId"]);
                    objDep.DepartmentName = Convert.ToString(row["DepartmentName"]);
                    departmentList.Add(objDep);
                }

                foreach (DataRow row in dataSet.Tables[5].Rows)
                {
                    objRoom = new ClassRoom();
                    objRoom.ClassRoomId = Convert.ToInt64(row["ClassRoomId"]);
                    objRoom.Name = Convert.ToString(row["Name"]);
                    classRoomList.Add(objRoom);
                }

            }
            schedule.OrganizationList = new SelectList(listOrganizations, "OrganizationId", "OrganizationName", schedule.OrganizationId);
            schedule.CourseList = new SelectList(courseList, "CourseId", "CourseName", schedule.CourseId);
            schedule.ClassList = new SelectList(classList, "ClassId", "ClassName", schedule.ClassId);
            schedule.SubjectList = new SelectList(subjectList, "SubjectId", "SubjectName", schedule.SubjectId);
            schedule.DepartmentList = new SelectList(departmentList, "DepartmentId", "DepartmentName", schedule.DepartmentId);
            schedule.ClassRoomList = new SelectList(classRoomList, "ClassRoomId", "Name", schedule.ClassRoomId);
            List<SelectListItem> daysList = Enum.GetValues(typeof(StudentTracker.Core.Utilities.Days)).Cast<StudentTracker.Core.Utilities.Days>().Select(v => new SelectListItem
            {
                Text = v.ToString(),
                Value = ((int)v).ToString()
            }).ToList();
            schedule.DayList = new SelectList(daysList, "Value", "Text");

            return schedule;
        }
コード例 #7
0
ファイル: StudentRepository.cs プロジェクト: punj-aab/School
        public Staff LoadStaffLists(string userRole, long organizationId = -1, long scheduleId = -1)
        {
            Staff objStaff = null;
            if (scheduleId != -1)
            {
                //objStaff = this.GetSchedule(scheduleId);
            }
            if (objStaff == null)
            {
                objStaff = new Staff();
            }
            //list class objects
            List<Organization> listOrganizations = new List<Organization>();
            List<Course> courseList = new List<Course>();
            List<Class> classList = new List<Class>();
            List<Subject> subjectList = new List<Subject>();
            List<Department> departmentList = new List<Department>();
            List<Section> sectionList = new List<Section>();

            //class objects
            Organization objOrganization = null;
            Course objCourse = null;
            Class objClass = null;
            Subject objSubject = null;
            Department objDep = null;
            Section objSection = null;

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["StudentContext"].ConnectionString);
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            using (SqlCommand cmd = new SqlCommand("usp_getSchedules", con))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@userRole", SqlDbType.VarChar, 50).Value = userRole;
                cmd.Parameters.Add("@organizationId", SqlDbType.BigInt).Value = objStaff.OrganizationId;
                cmd.Parameters.Add("@courseId", SqlDbType.BigInt).Value = objStaff.CourseId;
                cmd.Parameters.Add("@departmentId", SqlDbType.BigInt).Value = objStaff.DepartmentId;
                cmd.Parameters.Add("@classId", SqlDbType.BigInt).Value = objStaff.ClassId;
                cmd.Parameters.Add("@createdByOrganization", SqlDbType.BigInt, 50).Value = organizationId;

                SqlDataAdapter adp = new SqlDataAdapter();
                adp.SelectCommand = cmd;
                DataSet dataSet = new DataSet();
                adp.Fill(dataSet);

                foreach (DataRow row in dataSet.Tables[0].Rows)
                {
                    objOrganization = new Organization();
                    objOrganization.OrganizationId = Convert.ToInt64(row["OrganizationId"]);
                    objOrganization.OrganizationName = Convert.ToString(row["OrganizationName"]);
                    listOrganizations.Add(objOrganization);
                    if (userRole != "SiteAdmin")
                    {
                        objStaff.OrganizationName = objOrganization.OrganizationName;
                    }
                }

                foreach (DataRow row in dataSet.Tables[1].Rows)
                {
                    objCourse = new Course();
                    objCourse.CourseId = Convert.ToInt64(row["CourseId"]);
                    objCourse.CourseName = Convert.ToString(row["CourseName"]);
                    courseList.Add(objCourse);
                }

                foreach (DataRow row in dataSet.Tables[2].Rows)
                {
                    objClass = new Class();
                    objClass.ClassId = Convert.ToInt64(row["ClassId"]);
                    objClass.ClassName = Convert.ToString(row["ClassName"]);
                    classList.Add(objClass);
                }

                foreach (DataRow row in dataSet.Tables[3].Rows)
                {
                    objSubject = new Subject();
                    objSubject.SubjectId = Convert.ToInt64(row["SubjectId"]);
                    objSubject.SubjectName = Convert.ToString(row["SubjectName"]);
                    subjectList.Add(objSubject);
                }

                foreach (DataRow row in dataSet.Tables[4].Rows)
                {
                    objDep = new Department();
                    objDep.DepartmentId = Convert.ToInt64(row["DepartmentId"]);
                    objDep.DepartmentName = Convert.ToString(row["DepartmentName"]);
                    departmentList.Add(objDep);
                }

                foreach (DataRow row in dataSet.Tables[6].Rows)
                {
                    objSection = new Section();
                    objSection.SectionId = Convert.ToInt32(row["SectionId"]);
                    objSection.SectionName = Convert.ToString(row["SectionName"]);
                    sectionList.Add(objSection);
                }

            }
            objStaff.OrganizationList = new SelectList(listOrganizations, "OrganizationId", "OrganizationName", objStaff.OrganizationId);
            objStaff.CourseList = new SelectList(courseList, "CourseId", "CourseName", objStaff.CourseId);
            objStaff.ClassList = new SelectList(classList, "ClassId", "ClassName", objStaff.ClassId);
            objStaff.SubjectList = new SelectList(subjectList, "SubjectId", "SubjectName", objStaff.SubjectId);
            objStaff.DepartmentList = new SelectList(departmentList, "DepartmentId", "DepartmentName", objStaff.DepartmentId);
            objStaff.SectionList = new SelectList(sectionList, "SectionId", "SectionName", objStaff.SectionId);
            return objStaff;
        }
コード例 #8
0
ファイル: ImportController.cs プロジェクト: punj-aab/School
 public long GetCourseId(StudentContext context, string courseName, int organizationId)
 {
     var course = context.Courses.Where(c => c.CourseName == courseName && c.OrganisationId == organizationId);
     if (course == null || course.ToList().Count() == 0)
     {
         Course newCourse = new Course();
         newCourse.CourseName = courseName;
         newCourse.OrganisationId = _userStatistics.OrganizationId == 0 ? 1 : Convert.ToInt32(_userStatistics.OrganizationId);
         newCourse.CourseDescription = "Created by Code";
         newCourse.CreatedBy = _userStatistics.UserId;
         newCourse.InsertedOn = DateTime.Now;
         context.Courses.Add(newCourse);
         context.SaveChanges();
         return newCourse.CourseId;
     }
     else
     {
         return course.FirstOrDefault().CourseId;
     }
 }