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 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"));
}
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////\\
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"));
}
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////\\
//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 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 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 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"));
}
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 }));
}
