public string GetRegistrationNumber(Student student)
{
Department department = DepartmentGateway.GetDepartmentById(student.DepartmentId);
int year = DateTime.Now.Year;
int studentsNumber = StudentGateway.GetStudentNumberByDepartmentAndYear(department.Id, year);
//Assigning the next number
studentsNumber++;
string numberOfStudents;
if (studentsNumber < 10)
{
numberOfStudents = "00" + studentsNumber;
}
else if (studentsNumber < 100)
{
numberOfStudents = "0" + studentsNumber;
}
else
{
numberOfStudents = studentsNumber.ToString();
}
return(department.Code + "-" + year + "-" + numberOfStudents);
}
public ViewResult Register(Student student)
{
RegisterStudentViewModel viewModel = new RegisterStudentViewModel
{
Departments = DepartmentGateway.GetAllDepartments()
};
if (ModelState.IsValid)
{
StudentGateway sg = new StudentGateway();
string registrationNumber = GetRegistrationNumber(student);
int rowAffected = sg.Save(student, registrationNumber);
if (rowAffected > 0)
{
ViewBag.Message = "Saved";
}
else
{
ViewBag.Message = "Error";
}
return(View(viewModel));
}
// Model state is not valid
viewModel.Student = student;
return(View(viewModel));
}
public ViewResult Create(Course course)
{
CourseViewModel viewModel = new CourseViewModel
{
Departments = DepartmentGateway.GetAllDepartments(),
Semesters = SemesterGateway.GetAllSemseters()
};
if (!ModelState.IsValid)
{
viewModel.Course = course;
return(View(viewModel));
}
int rowAffected = CourseGateway.Save(course);
if (rowAffected > 0)
{
ViewBag.message = "Course Saved";
viewModel.Course = new Course();
return(View(viewModel));
}
return(View("~/Views/Shared/BadRequest.cshtml"));
}
public ViewResult Allocate(ClassroomAllocation classroomAllocation)
{
ClassroomAllocationViewModel viewModel = new ClassroomAllocationViewModel
{
Departments = DepartmentGateway.GetAllDepartments(),
Days = DayGateway.GetAllDays(),
Rooms = RoomGateway.GetAllRooms()
};
if (!ModelState.IsValid)
{
viewModel.ClassroomAllocation = classroomAllocation;
ViewBag.Message = "Unsuccessful";
return(View(viewModel));
}
int rowAffected = RoomGateway.AllocateRoom(classroomAllocation);
if (rowAffected > 0)
{
ViewBag.Message = "Successful";
}
else
{
ViewBag.Message = "Not Saved";
}
return(View(viewModel));
}
public List <string> GetAllDepartmentCodes()
{
DepartmentGateway aDepartmentGateway = new DepartmentGateway();
List <string> listOfDepartmentCode = new List <string>();
listOfDepartmentCode = aDepartmentGateway.GetDepartmentCodeList();
return(listOfDepartmentCode);
}
public List <DepartmentModel> GetAllDepartments()
{
DepartmentGateway aDepartmentGateway = new DepartmentGateway();
List <DepartmentModel> listOfDepartments = new List <DepartmentModel>();
listOfDepartments = aDepartmentGateway.GetAllDepartments();
return(listOfDepartments);
}
public Student GetStudentByRegNo(int regNo)
{
Student student = StudentGateway.GetStudentByRegNo(regNo);
DepartmentGateway departmentGateway = new DepartmentGateway();
student.Department = departmentGateway.GetDepartmentCodeById(student.DepartmentId);
return(student);
}
// GET: Student
public ViewResult Register()
{
RegisterStudentViewModel viewModel = new RegisterStudentViewModel
{
Departments = DepartmentGateway.GetAllDepartments()
};
return(View(viewModel));
}
public ViewResult Assign()
{
CourseAssignmentViewModel viewModel = new CourseAssignmentViewModel
{
Departments = DepartmentGateway.GetAllDepartments()
};
return(View(viewModel));
}
// GET: Course/Create
public ViewResult Create()
{
CourseViewModel viewModel = new CourseViewModel
{
Departments = DepartmentGateway.GetAllDepartments(),
Semesters = SemesterGateway.GetAllSemseters()
};
return(View(viewModel));
}
// GET: Room/Allocate
public ViewResult Allocate()
{
ClassroomAllocationViewModel viewModel = new ClassroomAllocationViewModel
{
Departments = DepartmentGateway.GetAllDepartments(),
Days = DayGateway.GetAllDays(),
Rooms = RoomGateway.GetAllRooms()
};
return(View(viewModel));
}
// GET: Teacher/Save
public ViewResult Save()
{
TeacherViewModel viewModel = new TeacherViewModel
{
Designations = DesignationGateway.GetAllDesignations(),
Departments = DepartmentGateway.GetAllDepartments()
};
ViewBag.msg = "";
return(View(viewModel));
}
public int InsertDepartmentInfo(Departments department)
{
try
{
using (DepartmentGateway departmentGateway = new DepartmentGateway())
{
actionResult = departmentGateway.InsertDepartment(department);
}
}
catch (Exception ex)
{
}
return(actionResult);
}
public ActionResult Save(Department department)
{
if (!ModelState.IsValid)
{
return(View(department));
}
int rowAffected = DepartmentGateway.Save(department);
if (rowAffected > 0)
{
return(RedirectToAction("Save"));
}
return(HttpNotFound());
}
public Department GetDepartment(Int16 departmentId)
{
aDepartmentGateway = new DepartmentGateway();
List <Department> departments = new List <Department>();
departments = GetAllDepartments();
Department aDepartment = new Department();
foreach (var department in departments)
{
if (department.DepartmentId == departmentId)
{
aDepartment.DepartmentId = department.DepartmentId;
aDepartment.DepartmentCode = department.DepartmentCode;
aDepartment.DepartmentName = department.DepartmentName;
return(aDepartment);
}
}
return(aDepartment);
}
public string SaveDepartment(Department aDepartment)
{
aDepartmentGateway = new DepartmentGateway();
if (!HasThisDepartmentIdExist(aDepartment))
{
if (!HasThisDepartmentNameExist(aDepartment))
{
return(aDepartmentGateway.SaveDepartment(aDepartment));
}
else
{
return("This Department Name exist.");
}
}
else
{
return("This Department Code exist.");
}
}
public string LoadDepartmentInfo()
{
StringBuilder tableRow = new StringBuilder();
try
{
using (DepartmentGateway departmentGateway = new DepartmentGateway())
{
int count = 0;
DataTable dt = departmentGateway.LoadDepartmentInfo();
if (dt.Rows.Count > 0)
{
tableRow.Append("<table class='table table-bordered'><thead><tr>" +
"<th>Sl</th>" +
"<th>department Id</th>" +
"<th>department Name</th>" +
"</tr></thead >");
for (int i = 0; i < dt.Rows.Count; i++)
{
count++;
tableRow.Append("<tbody><tr>");
tableRow.Append("<td>" + count + "</td>");
tableRow.Append("<td>" + dt.Rows[i]["departmentId"] + "</td>");
tableRow.Append("<td>" + dt.Rows[i]["departmentName"] + "</td>");
tableRow.Append("</tr></tbody>");
}
tableRow.Append("</table>");
}
else
{
tableRow.Append("No Data Found");
}
}
}
catch (Exception ex)
{
}
return(tableRow.ToString());
}
public ViewResult Assign(CourseAssignment courseAssignment)
{
CourseAssignmentViewModel viewModel = new CourseAssignmentViewModel
{
Departments = DepartmentGateway.GetAllDepartments()
};
if (!ModelState.IsValid)
{
return(View(viewModel));
}
int rowAffected = CourseGateway.Assign(courseAssignment);
if (rowAffected > 0)
{
return(View(viewModel));
}
return(View("~/Views/Shared/BadRequest.cshtml"));
}
public string GetRegNoByStudent(Student student)
{
string date = student.Date.ToString();
string sub = null;
int temp = 0;
if (date[1] == '/')
{
if (date[3] == '/')
{
temp = 4;
}
else
{
temp = 5;
}
}
else
{
if (date[4] == '/')
{
temp = 5;
}
else
{
temp = 6;
}
}
sub = date.Substring(temp, 4);
DepartmentGateway departmentGateway = new DepartmentGateway();
string department = departmentGateway.GetDepartmentCodeById(student.DepartmentId);
// string sub2 = department.Substring(0, 3);
string substring = department + "-" + sub + "-";
return(GetRegNo(substring));
}
public ActionResult Save(Teacher teacher)
{
TeacherViewModel viewModel = new TeacherViewModel
{
Designations = DesignationGateway.GetAllDesignations(),
Departments = DepartmentGateway.GetAllDepartments()
};
if (!ModelState.IsValid)
{
viewModel.Teacher = teacher;
return(View(viewModel));
}
int rowAffected = TeacherGateway.Save(teacher);
if (rowAffected > 0)
{
return(Redirect("Save"));
}
return(View("~/Views/Shared/_BadRequest"));
}
public DepartmentManager()
{
departmentGateway = new DepartmentGateway();
}
public StudentManager()
{
studentGateway = new StudentGateway();
departmentGateway = new DepartmentGateway();
}
public TeacherManager()
{
teacherGateway = new TeacherGateway();
departmentGateway = new DepartmentGateway();
}
public bool IsNameExist(string name)
{
DepartmentGateway departmentGateway = new DepartmentGateway();
return(departmentGateway.IsNameExist(name));
}
public List <Department> GetAll()
{
DepartmentGateway departmentGateway = new DepartmentGateway();
return(departmentGateway.GetAll());
}
public bool IsCodeExist(string codeName)
{
DepartmentGateway departmentGateway = new DepartmentGateway();
return(departmentGateway.IsCodeExist(codeName));
}
public int Save(Department department)
{
DepartmentGateway departmentGateway = new DepartmentGateway();
return(departmentGateway.Save(department));
}
public DepartmentManagerBLL()
{
aDepartmentGateway = new DepartmentGateway();
}
public List <Department> GetDepartments()
{
return(DepartmentGateway.GetDepartments());
}
public ViewResult AllocationInformation()
{
ViewBag.Departments = DepartmentGateway.GetAllDepartments();
return(View());
}
