private void ViewCourse_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Escape) { ViewCourse.CancelUpdateCurrentRow(); } }
public List <ViewCourse> GetStudentAllCourseDetailsWithRegistrationNo(StudentMustafa student) { Query = "SELECT * FROM StudentCourseResult WHERE StudentRegNo=@regNo "; Command = new SqlCommand(Query, Connection); Connection.Open(); Command.Parameters.Clear(); Command.Parameters.Add("regNo", SqlDbType.VarChar); Command.Parameters["regNo"].Value = student.RegNo; Reader = Command.ExecuteReader(); List <ViewCourse> studentCoursesInfo = new List <ViewCourse>(); while (Reader.Read()) { ViewCourse studentCourseInfo = new ViewCourse(); studentCourseInfo.Code = Reader["Code"].ToString(); studentCourseInfo.CourseName = Reader["Name"].ToString(); studentCourseInfo.Grade = Reader["Grade"].ToString(); studentCoursesInfo.Add(studentCourseInfo); } Reader.Close(); Connection.Close(); return(studentCoursesInfo); }
// GET: Courses/Details/5 public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var course = await _context.Courses .Include(c => c.Teacher) .FirstOrDefaultAsync(m => m.Id == id); if (course == null) { return(NotFound()); } ViewCourse viewCourse = new ViewCourse { Id = course.Id, Name = course.Name, TeacherId = course.TeacherId, Teacher = course.Teacher }; viewCourse.Enrollments = _context.Enrollments.Where(e => e.CourseId == course.Id).Include(e => e.Student).ToList(); viewCourse.Exams = _context.Exams.Where(e => e.CourseId == course.Id).ToList(); return(View(viewCourse)); }
public List <ViewCourse> GetAllViewCourse() { Query = "SELECT * From AssigendCourseview"; Command = new SqlCommand(Query, Connection); List <ViewCourse> aViewCourses = new List <ViewCourse>(); Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { ViewCourse aViewCourse = new ViewCourse() { Department_Id = (int)Reader["deptId"], Course_Id = (int)Reader["CourseId"], CourseCode = Reader["CourseCode"].ToString(), CourseName = Reader["CourseName"].ToString(), CourseSemester = Reader["Semester"].ToString(), TeacherName = Reader["TeacherName"].ToString() }; aViewCourses.Add(aViewCourse); } Reader.Close(); Connection.Close(); return(aViewCourses); }
public ViewResult ViewThisCourse(long courseId) { ViewCourse model = new ViewCourse(); model.Course = courseRepo.Courses.FirstOrDefault(c => c.CourseId == courseId); model.StudentList = studentRepo.GetAllStudentsFromCourses(model.Course); return(View("ViewThisCourse", model)); }
private void ViewCourse_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!e.Column.FieldName.ToString().Equals("IsEdited")) { if (ViewCourse.GetRowCellValue(e.RowHandle, "CourseID").ToString().Equals("")) { ViewCourse.SetRowCellValue(e.RowHandle, "IsEdited", "2"); } else { ViewCourse.SetRowCellValue(e.RowHandle, "IsEdited", "1"); } } }
private void SaveAllUpdatedList() { ViewCourse.CloseEditForm(); ViewCourse.UpdateCurrentRow(); List <string> updateQueries = new List <string>(); for (int i = 0; i < ViewCourse.RowCount; i++) { if (ViewCourse.GetRowCellValue(i, "IsEdited").ToString().Equals("1")) { long corID = Convert.ToInt64(ViewCourse.GetRowCellValue(i, "CourseID")); string courseName = ViewCourse.GetRowCellValue(i, "CourseName").ToString(); string abbrv = ViewCourse.GetRowCellValue(i, "Abbrv").ToString(); string query = "UPDATE attendance_db.tblcourse SET CourseName = '" + courseName + "' , Abbrv ='" + abbrv.ToUpper() + "' WHERE CourseID = " + corID + ""; updateQueries.Add(query); } else if (ViewCourse.GetRowCellValue(i, "IsEdited").ToString().Equals("2")) { if (InputValidation("")) { string courseName = ViewCourse.GetRowCellValue(i, "CourseName").ToString(); string abbrv = ViewCourse.GetRowCellValue(i, "Abbrv").ToString(); string query = "INSERT INTO attendance_db.tblcourse(CourseName , Abbrv , IsActive , UserID) VALUES('" + db.CorrectCasing(courseName) + "' , '" + abbrv.ToUpper() + "' , 'Active' , " + userid + ")"; updateQueries.Add(query); } } } if (updateQueries.Count > 0) { if (DialogResult.Yes == MessageBox.Show("Are you sure you want to save the following items. ", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { if (db.RunTransaction(updateQueries)) { MessageBox.Show("Selected records updated successfully. ", "Update Record", MessageBoxButtons.OK, MessageBoxIcon.Information); gridCourse.DataSource = null; PopulateCourse(); } } else { PopulateCourse(); } } DateTime dateValue = DateTime.Now; }
private void btnDelete_Click(object sender, EventArgs e) { //if (selectedindex == 0)return; string id = ViewCourse.GetRowCellValue(selectedindex, "CourseID").ToString(); if (DialogResult.Yes == MessageBox.Show("Are you sure, you want to delete the selected item ? ", "Deleted", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { string delete = "UPDATE tblcourse SET IsActive = 'In-Active' WHERE CourseID = " + id; int result = db.RunUpdateQuery(delete); if (result > 0) { MessageBox.Show("Course was deleted."); PopulateCourse(); } } }
public bool InputValidation(string cons) { for (int i = 0; i < ViewCourse.RowCount; i++) { if (ViewCourse.GetRowCellValue(i, "IsEdited").ToString().Equals("2")) { string coursename = ViewCourse.GetRowCellValue(i, "CourseName").ToString(); string abbrv = ViewCourse.GetRowCellValue(i, "Abbrv").ToString(); string query = "SELECT * FROM tblcourse WHERE CourseName = '" + coursename + "' AND Abbrv = '" + abbrv + "' AND UserID = " + userid + "" + cons; DataTable dt = db.SelectQuery(query); if (dt.Rows.Count != 0) { MessageBox.Show("Duplicate Course Name!!", "Duplicate", MessageBoxButtons.OK, MessageBoxIcon.Warning); PopulateCourse(); return(false); } } } return(true); }
private void ViewCourse_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e) { try { if (ViewCourse.GetRowCellValue(e.RowHandle, "IsEdited") == null) { return; } else if (ViewCourse.GetRowCellValue(e.RowHandle, "IsEdited").ToString().Equals("1")) { e.Appearance.BackColor = Color.Aqua; } else if (ViewCourse.GetRowCellValue(e.RowHandle, "IsEdited").ToString().Equals("2")) { e.Appearance.BackColor = Color.Beige; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public List <ViewCourse> GetAllViewCourse(int deptId) { Query = "SELECT Course.Code, Course.Name,Semester.Name as SemName,Teacher.Name as TeacherName FROM AssignedCourse Right JOIN Course ON Course.id=AssignedCourse.Course_Id LEFT JOIN Teacher ON Teacher.Id=AssignedCourse.Teacher_Id Inner JOIN Semester ON Course.Semester_Id=Semester.Id where Course.Department_ID='" + deptId + "' order by Code"; Command = new SqlCommand(Query, Connection); List <ViewCourse> aViewCourses = new List <ViewCourse>(); Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { ViewCourse aViewCourse = new ViewCourse { CourseCode = Reader["Code"].ToString(), CourseName = Reader["Name"].ToString(), CourseSemester = Reader["SemName"].ToString(), TeacherName = Reader["TeacherName"].ToString() }; aViewCourses.Add(aViewCourse); } Reader.Close(); Connection.Close(); return(aViewCourses); }