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);
}
