// // GET: /Subject/Create public ActionResult Create() { Subject objSubject = new Subject(); SelectList courseList = null; SelectList classList = null; SelectList organizationList = null; LoadSelectLists(out classList, out courseList, out organizationList, false); objSubject.CourseList = courseList; objSubject.ClassList = classList; objSubject.OrganizationList = organizationList; objSubject.OrganizationId = ViewBag.OrganizationId == null ? 0 : Convert.ToInt32(ViewBag.OrganizationId); return PartialView(objSubject); }
//public List<Subject> GetSubjects() //{ // string sql = "select SubjectId,SubjectName,SubjectDescription,Subjects.CourseId,Courses.CourseName, Subjects.InsertedOn,Subjects.CreatedBy,Subjects.ModifiedBy,Subjects.ModifiedOn,Subjects.ModifiedBy,Subjects.ClassId,Classes.ClassName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName "; // sql += "from Subjects join Courses on Subjects.CourseId=Courses.CourseId join Classes on Subjects.ClassId = Classes.ClassId join Users on Subjects.CreatedBy=Users.UserId left join Users as Users_1 on Subjects.ModifiedBy=Users_1.UserId"; // List<Subject> modelList = db.Query<Subject>(sql).ToList(); // return modelList; //} //public Subject GetSubjects(long id) //{ // string sql = "select SubjectId,SubjectName,SubjectDescription,Subjects.CourseId,Courses.CourseName, Subjects.InsertedOn,Subjects.CreatedBy,Subjects.ModifiedBy,Subjects.ModifiedOn,Subjects.ModifiedBy,Subjects.ClassId,Classes.ClassName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName "; // sql += "from Subjects join Courses on Subjects.CourseId=Courses.CourseId join Classes on Subjects.ClassId = Classes.ClassId join Users on Subjects.CreatedBy=Users.UserId left join Users as Users_1 on Subjects.ModifiedBy=Users_1.UserId "; // sql += "where SubjectId=@0"; // Subject objModel = db.Query<Subject>(sql, id).FirstOrDefault(); // return objModel; //} public bool Create(Subject objSubject) { int recAffected = 0; DBConnectionString.Subject Subject = new DBConnectionString.Subject(); Subject.SubjectName = objSubject.SubjectName; Subject.SubjectDescription = objSubject.SubjectDescription; Subject.CourseId = objSubject.CourseId; Subject.ClassId = objSubject.ClassId; Subject.CreatedBy = objSubject.CreatedBy; Subject.InsertedOn = DateTime.Now; recAffected = Convert.ToInt32(Subject.Insert()); if (recAffected > 0) { return true; } return false; }
public string Create(Subject subject, string token) { try { if (ModelState.IsValid) { subject.CreatedBy = _userStatistics.UserId; if (objRep.CreateSubject(subject)) { SaveFiles(token, this.GetType().Name, subject.SubjectId); return Convert.ToString(true); } return Convert.ToString(false); } return Convert.ToString(false); } catch (Exception ex) { return ex.Message.ToString(); } }
public bool CreateSubject(Subject objSubject) { var parameters = new { SubjectName = objSubject.SubjectName, SubjectDescription = objSubject.SubjectDescription, OrganizationId = objSubject.OrganizationId, CourseId = objSubject.CourseId, ClassId = objSubject.ClassId, CreatedBy = objSubject.CreatedBy, InsertedOn = DateTime.Now }; using (IDbConnection connection = OpenConnection()) { const string storedProcedure = "usp_addSubject"; int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure); SetIdentity<int>(connection, id => objSubject.SubjectId = id); if (rowsAffected > 0) { return true; } return false; } }
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; }
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; }