public ActionResult EditingUsers(int id)
{
SISEntities db = new SISEntities();
var model = db.Users.Find(id);
return(View(model));
}
public ActionResult LoginMethod(string userLoginNumber, string userPassword)
{
SISEntities entity = new SISEntities();
entity.Configuration.ProxyCreationEnabled = true;
using (SISEntities db = entity)
{
foreach (var user in db.Users)
{
if (user.u_Login_Number == userLoginNumber)
{
if (user.u_Password == userPassword)
{
Session["LoggedUser"] = user;
return(Redirect("/Home/Index"));
}
TempData["alertMessage"] = 0;
return(View("Index"));
}
}
}
TempData["alertMessage"] = 1;
return(View("Index"));
}
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////\\
// List of Users
public ActionResult ListingUsers()
{
SISEntities db = new SISEntities();
var model = db.Users.ToList();
return(View(model));
}
public ActionResult AddNewFaculty()
{
SISEntities db = new SISEntities();
var model = db.Faculties.Create();
return(View(model));
}
public ActionResult OpenNewCourse()
{
SISEntities db = new SISEntities();
var model = db.Courses.Create();
return(View(model));
}
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////\\
// List of Departments
public ActionResult ListingDepartments()
{
SISEntities db = new SISEntities();
var model = db.Deparments.ToList();
return(View(model));
}
public JsonResult GetCoursesWithSelectedUser(int ID)
{
SISEntities db = new SISEntities();
List <Json_Courses> course_list = new List <Json_Courses>();
var dept_id = db.Users.Where(row => row.TableID == ID).FirstOrDefault().u_Departments_TableID;
foreach (var course in db.Courses.Where(row => row.c_Departments_TableID == dept_id).ToList())
{
if (db.Lecturers_Courses.Where(r => r.lc_Users_TableID == ID).Where(r => r.lc_Courses_TableID == course.TableID).Any())
{
continue;
}
else
{
Json_Courses new_course = new Json_Courses
{
CourseID = course.TableID,
CourseName = course.c_Name,
};
course_list.Add(new_course);
}
}
return(Json(course_list, JsonRequestBehavior.AllowGet));
}
public ActionResult EditingDepartments(int id)
{
SISEntities db = new SISEntities();
var model = db.Deparments.Find(id);
return(View(model));
}
public ActionResult GradeEntry1(int courseID)
{
SISEntities db = new SISEntities();
var model = db.Students_Courses.Where(r => r.sc_Courses_TableID == courseID).ToList();
return(View(model));
}
public ActionResult AddNewDepartment()
{
SISEntities db = new SISEntities();
var model = db.Deparments.Create();
return(View(model));
}
public ActionResult AddNewUser()
{
SISEntities db = new SISEntities();
var model = db.Users.Create();
return(View(model));
}
public ActionResult CourseGrades()
{
//To list Selected Courses
var userID = ((Users)Session["LoggedUser"]).TableID;
SISEntities db = new SISEntities();
var model = db.Students_Courses.Where(r => r.sc_Users_TableID == userID).ToList();
return(View(model));
}
public ActionResult EditingFaculties(int id, string facultyName)
{
SISEntities db = new SISEntities();
var model = db.Faculties.Where(r => r.TableID == id).FirstOrDefault();
model.f_Name = facultyName;
db.SaveChanges();
return(RedirectToAction("ListingFaculties", "Faculty"));
}
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////\\
public ActionResult DeletingDepartments(int ID)
{
SISEntities db = new SISEntities();
if (db.Deparments.Where(r => r.TableID == ID).Any())
{
db.Deparments.Remove(db.Deparments.Where(r => r.TableID == ID).FirstOrDefault());
db.SaveChanges();
}
return(RedirectToAction("ListingDepartments", "Department"));
}
public ActionResult EditingDepartments(int id, string deptName, int facultyID)
{
SISEntities db = new SISEntities();
var model = db.Deparments.Where(r => r.TableID == id).FirstOrDefault();
model.d_Name = deptName;
model.d_Faculties_TableID = facultyID;
db.SaveChanges();
return(RedirectToAction("ListingDepartments", "Department"));
}
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////\\
//Deleting Users
public ActionResult DeletingUsers(int ID)
{
SISEntities db = new SISEntities();
if (db.Users.Where(r => r.TableID == ID).Any()) //LINQ usage
{
db.Users.Remove(db.Users.Where(r => r.TableID == ID).FirstOrDefault());
db.SaveChanges();
}
return(RedirectToAction("ListingUsers", "User"));
}
public ActionResult AddNewFaculty(string facultyName)
{
SISEntities db = new SISEntities();
Faculties faculty = new Faculties
{
f_Name = facultyName,
};
db.Faculties.Add(faculty);
db.SaveChanges();
return(View());
}
public ActionResult EditingCourses(int id, string courseName, int courseEcts, string courseTerm, int deptID)
{
SISEntities db = new SISEntities();
var model = db.Courses.Where(r => r.TableID == id).FirstOrDefault();
model.c_Name = courseName;
model.c_ECTS = courseEcts;
model.c_Term = courseTerm;
model.c_Departments_TableID = deptID;
db.SaveChanges();
return(RedirectToAction("ListingCourses", "Course"));
}
public ActionResult AssigningCourse(int id, int CourseID)
{
SISEntities db = new SISEntities();
Lecturers_Courses lecturer = new Lecturers_Courses
{
lc_Users_TableID = id,
lc_Courses_TableID = CourseID
};
db.Lecturers_Courses.Add(lecturer);
db.SaveChanges();
return(View());
}
public ActionResult AddNewDepartment(string deptName, int facultyID)
{
SISEntities db = new SISEntities();
Deparments deparment = new Deparments
{
d_Name = deptName,
d_Faculties_TableID = facultyID,
};
db.Deparments.Add(deparment);
db.SaveChanges();
return(View());
}
public ActionResult OpenNewCourse(string courseName, int courseEcts, string courseTerm, int deptID)
{
SISEntities db = new SISEntities();
Courses course = new Courses();
course.c_Name = courseName;
course.c_ECTS = courseEcts;
course.c_Term = courseTerm;
course.c_Departments_TableID = deptID;
db.Courses.Add(course);
db.SaveChanges();
return(View());
}
public ActionResult CourseSelection(int courseID)
{
var userID = ((Users)Session["LoggedUser"]).TableID;
SISEntities db = new SISEntities();
Students_Courses choosenCourse = new Students_Courses
{
sc_Users_TableID = userID,
sc_Courses_TableID = courseID
};
db.Students_Courses.Add(choosenCourse);
db.SaveChanges();
return(View());
}
public ActionResult AddNewUser(string citNum, string logNum, string fulName, string password, string email, string phnNum, string address,
string title, int groupID, string pic, int depID, HttpPostedFileBase uploadImages)
{
SISEntities db = new SISEntities();
Users user = new Users();
user.u_Citizen_Number = citNum;
user.u_Login_Number = logNum;
user.u_Name = fulName;
user.u_Password = password;
user.u_eMail = email;
user.u_Phone_Number = phnNum;
user.u_Address = address;
user.u_Registration_Date = DateTime.Now;
user.u_Title = title;
user.u_Groups_TableID = groupID;
//Picture section
if (uploadImages != null || uploadImages.ContentLength > 0)
{
var name = Path.GetExtension(uploadImages.FileName);
var fullname = logNum + name;
var path = Path.Combine(Server.MapPath("~/images/pp"), fullname);
uploadImages.SaveAs(path);
user.u_Picture = fullname;
}
else if (uploadImages == null)
{
user.u_Picture = fulName;
}
else
{
user.u_Picture = "user.png";
}
//Department Selection
if (groupID == 1)
{
//admin
}
else if (groupID == 2 || groupID == 3)
{
user.u_Departments_TableID = depID;
}
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("AddNewUser", "User"));
}
/// <summary>Database Context for the SIS tables</summary>
/// <remarks>
/// The SIS tables are not prefixed with the application name.
/// </remarks>
public static SISEntities getSisDbContext()
{
bool ventureMode = GetVentureMode();
// string currentPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
// if (currentPath.ToLower().Contains("venture"))
if (ventureMode)
{
Debug.WriteLine("GetDbContext Venture mode - using SISEntitiesVenture");
SISEntities se = new SISEntities("SISEntitiesVenture");
se.Database.Connection.ConnectionString = ventureConnectionString;
return(se);
}
return(new SISEntities());
}
public JsonResult GetDepartments(int ID)
{
SISEntities db = new SISEntities();
List <Json_Department> dep_list = new List <Json_Department>();
foreach (var dep in db.Deparments.Where(row => row.d_Faculties_TableID == ID).ToList())
{
Json_Department new_dep = new Json_Department
{
DepID = dep.TableID,
DepName = dep.d_Name
};
dep_list.Add(new_dep);
}
return(Json(dep_list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetLecturersFromUsers(int ID)
{
SISEntities db = new SISEntities();
List <Json_Users> lecturer_list = new List <Json_Users>();
foreach (var user in db.Users.Where(row => row.u_Groups_TableID == 2).Where(r => r.u_Departments_TableID == ID).ToList())
{
Json_Users new_user = new Json_Users
{
LecturerName = user.u_Name,
LecturerTitle = user.u_Title,
LecturerID = user.TableID
};
lecturer_list.Add(new_user);
}
return(Json(lecturer_list, JsonRequestBehavior.AllowGet));
}
public ActionResult EditingUsers(int id, string citNum, string logNum, string fulName, string password, string email, string phnNum, string address,
string title, int groupID, int depID)
{
SISEntities db = new SISEntities();
var model = db.Users.Where(r => r.TableID == id).FirstOrDefault();
model.u_Citizen_Number = citNum;
model.u_Login_Number = logNum;
model.u_Name = fulName;
model.u_Password = password;
model.u_eMail = email;
model.u_Phone_Number = phnNum;
model.u_Address = address;
model.u_Title = title;
model.u_Groups_TableID = groupID;
model.u_Departments_TableID = depID;
db.SaveChanges();
return(RedirectToAction("ListingUsers", "User"));
}
public ActionResult SetNotes(int id, int midterm, int final, int?resit, double?courseGPA = 0.0)
{
SISEntities db = new SISEntities();
var std_course = db.Students_Courses.Where(r => r.TableID == id).FirstOrDefault();
std_course.sc_Midterm_Grade = midterm;
std_course.sc_Final_Grade = final;
std_course.sc_Resit_Grade = resit;
if (resit == null || resit == 0)
{
courseGPA = midterm * 0.4 + final * 0.6;
std_course.sc_Grade = courseGPA;
}
else
{
courseGPA = midterm * 0.5 + resit * 0.5;
std_course.sc_Grade = courseGPA;
}
db.SaveChanges();
return(RedirectToAction("GradeEntry1", "Course", new { courseID = std_course.sc_Courses_TableID }));
}
public JsonResult GetCourses(int ID)
{
SISEntities db = new SISEntities();
List <Json_Courses> course_list = new List <Json_Courses>();
foreach (var dep_ID in db.Deparments.Where(row => row.d_Faculties_TableID == ID).ToList())
{
foreach (var course in db.Courses.Where(row => row.c_Departments_TableID == dep_ID.TableID).ToList())
{
var dep_name = db.Deparments.Where(row => row.TableID == course.c_Departments_TableID).FirstOrDefault().d_Name;
Json_Courses new_course = new Json_Courses
{
CourseID = course.TableID,
CourseName = course.c_Name,
CourseTerm = course.c_Term,
CourseECTS = course.c_ECTS,
DepName = dep_name
};
course_list.Add(new_course);
}
}
return(Json(course_list, JsonRequestBehavior.AllowGet));
}
