public async Task <ActionResult> EditOrAddInternshipTask(List <string> Classes, InternshipTask internshipTask, bool isNewInternshipTask, int internshipTaskId)
{
var thisTeacher = getThisTeacher();
var aCopyOfDatabase = new Internship_Management_SystemEntities();
try
{
if (isNewInternshipTask)
{
internshipTask.TeacherEmail = thisTeacher.TeacherEmail;
db.InternshipTasks.Add(internshipTask);
db.Class_.Where(c => Classes.Contains(c.ClassName)).ToList().ForEach(c => c.InternshipTask = internshipTask);
}
else
{
db.InternshipTasks.Where(c => c.InternshipTaskId == internshipTaskId).FirstOrDefault().InternshipTask1 = internshipTask.InternshipTask1;
}
await db.SaveChangesAsync();
}
catch (Exception e)
{
db = aCopyOfDatabase;
}
return(PartialView("_InternshipTasks", prepareViewModel()));
}
public async Task <ActionResult> MarkStudent(List <string> companyMark)
{
var aCopyOfDB = new Internship_Management_SystemEntities();
var thisCompany = db.Companies.Where(c => c.CompanyEmail == User.Identity.Name).FirstOrDefault();
try {
var companyMarkIterator = 0;
foreach (var c in thisCompany.Class_)
{
foreach (var s in c.Students)
{
int result;
if (Int32.TryParse(companyMark[companyMarkIterator], out result))
{
s.CompanyMark = result;
}
else
{
s.CompanyMark = null;
}
companyMarkIterator++;
}
}
await db.SaveChangesAsync();
}
catch (Exception e) {
thisCompany = aCopyOfDB.Companies.Where(c => c.CompanyEmail == User.Identity.Name).FirstOrDefault();
}
return(PartialView("_CompanyMarkedStudentInfo", thisCompany));
}
public async Task <ActionResult> RegisterCompany(RegisterCompanyViewModel model)
{
if (ModelState.IsValid)
{
Internship_Management_SystemEntities db = new Internship_Management_SystemEntities();
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await UserManager.AddToRoleAsync(user.Id, "company");
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UshnerManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
RegisterCompanyViewModel newRegisteredCompany = (RegisterCompanyViewModel)model;
Company newCompany = new Company();
newCompany.CompanyEmail = newRegisteredCompany.Email;
newCompany.CompanyName = newRegisteredCompany.Name;
newCompany.PersonInCharge = newRegisteredCompany.PersonInCharge;
newCompany.ContactNumber = newRegisteredCompany.ContactNumber;
newCompany.CompanyLocation = newRegisteredCompany.CompanyLocation;
if (db.Companies.Count() != 0)
{
var newCompanyOrder = db.Companies.Count() + 1;
newCompany.CompanyOrder = newCompanyOrder;
}
else
{
newCompany.CompanyOrder = 1;
}
db.Companies.Add(newCompany);
await db.SaveChangesAsync();
return(Json(new
{
redirectUrl = Url.Action("Index", "Home"),
isRedirect = true
}));
}
AddErrors(result);
}
return(PartialView("_CompanyRegister", model));
}
public async Task <ActionResult> DeleteInternshipTask(int internshipTaskId)
{
var thisTeacher = getThisTeacher();
var aCopyOfDatabase = new Internship_Management_SystemEntities();
try
{
db.Class_.Where(c => c.InternshipTaskId == internshipTaskId).ToList().ForEach(c => c.InternshipTaskId = null);
var internshipTasksToBeRemoved = db.InternshipTasks.Where(i => i.InternshipTaskId == internshipTaskId).FirstOrDefault();
db.InternshipTasks.Remove(internshipTasksToBeRemoved);
await db.SaveChangesAsync();
}
catch (Exception e)
{
db = aCopyOfDatabase;
}
return(View("ForTeacher", prepareViewModel()));
}
public async Task <ActionResult> RegisterTeacher(RegisterViewModel model)
{
if (ModelState.IsValid)
{
Internship_Management_SystemEntities db = new Internship_Management_SystemEntities();
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await UserManager.AddToRoleAsync(user.Id, "teacher");
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UshnerManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
Teacher newTeacher = new Teacher();
newTeacher.TeacherName = model.Name;
newTeacher.TeacherEmail = model.Email;
newTeacher.TeacherContactNumber = model.ContactNumber;
db.Teachers.Add(newTeacher);
await db.SaveChangesAsync();
return(Json(new
{
redirectUrl = Url.Action("Index", "Home"),
isRedirect = true
}));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(PartialView("_TeacherRegister", model));
}
public async Task <ActionResult> DeleteContract(List <string> Classes, string company)
{
var thisTeacher = getThisTeacher();
var aCopyOfDatabase = new Internship_Management_SystemEntities();
try
{
var contractToRemove = db.Contract_.Where(c => c.CompanyName == company && c.TeacherEmail == thisTeacher.TeacherEmail);
db.Contract_.RemoveRange(contractToRemove);
var relatedClasses = db.Class_.Where(c => Classes.Contains(c.ClassName)).ToList();
relatedClasses.ForEach(c => c.CompanyName = null);
relatedClasses.ForEach(c => c.Students.ToList().ForEach(s => { s.CompanyName = null; s.CompanyMark = null; }));
await db.SaveChangesAsync();
}
catch (Exception e)
{
db = aCopyOfDatabase;
}
return(View("ForTeacher", prepareViewModel()));
}
public async Task <ActionResult> EditOrAddContract(Contract_ contract, List <string> Classes, string company)
{
var thisTeacher = getThisTeacher();
var aCopyOfDatabase = new Internship_Management_SystemEntities();
try
{
// If there is already a contract between this teacher and this company, delete it and replace it with our new contract later.
var contractsBetweenThisTeacherAndThisCompany = db.Contract_.Where(c => c.CompanyName == company && c.TeacherEmail == thisTeacher.TeacherEmail);
// If there are any contract that related to the classes we get, we also need to delete them.
var contractsRelatiedToTheseClasses = db.Contract_.Where(c => (from classes in db.Class_.Where(cl => Classes.Contains(cl.ClassName)) select classes.CompanyName).Contains(c.CompanyName) && c.TeacherEmail == thisTeacher.TeacherEmail);
var contractToRemove = contractsRelatiedToTheseClasses.Union(contractsBetweenThisTeacherAndThisCompany);
db.Contract_.RemoveRange(contractToRemove);
contract.Teacher = thisTeacher;
contract.TeacherEmail = thisTeacher.TeacherEmail;
contract.Company = db.Companies.Where(c => c.CompanyName == company).FirstOrDefault();
contract.Teacher = db.Teachers.Where(t => t.TeacherEmail == contract.TeacherEmail).FirstOrDefault();
db.Contract_.Add(contract);
await db.SaveChangesAsync();
//First set all the related classes' company to null
var relatedClasses = db.Class_.Where(c => c.CompanyName == company && c.Teacher.TeacherEmail == thisTeacher.TeacherEmail).ToList();
relatedClasses.ForEach(c => c.Company = null);
relatedClasses.ForEach(c => c.Students.ToList().ForEach(s => { s.CompanyName = null; s.CompanyMark = null; }));
//Then set the company attribute of the classes that are in Classes
var contractedCompany = db.Companies.Where(c => c.CompanyName == contract.CompanyName).FirstOrDefault();
foreach (string class_ in Classes)
{
var relatedClass = db.Class_.Where(c => c.ClassName == class_).FirstOrDefault();
relatedClass.Company = contract.Company;
relatedClass.Students.ToList().ForEach(s => s.Company = contract.Company);
}
await db.SaveChangesAsync();
}
catch (Exception e)
{
db = aCopyOfDatabase;
}
return(View("ForTeacher", prepareViewModel()));
}
public async Task <ActionResult> EditOrAddHomePageContent(HomePageContent homePageContent)
{
var aCopyOfDatabase = new Internship_Management_SystemEntities();
if (db.HomePageContents.Any(h => h.HomePageContentId == homePageContent.HomePageContentId))
{
var thisHomePageContent = db.HomePageContents.Where(h => h.HomePageContentId == homePageContent.HomePageContentId).FirstOrDefault();
thisHomePageContent.Content = homePageContent.Content;
thisHomePageContent.Title = homePageContent.Title;
}
else
{
db.HomePageContents.Add(homePageContent);
}
try {
await db.SaveChangesAsync();
}catch (Exception e)
{
db = aCopyOfDatabase;
}
return(PartialView("_HomePageContents", new HomePageContentViewModel(db.HomePageContents.ToList())));
}
public async Task <ActionResult> UploadStudentInfo(FormCollection formCollection)
{
var thisTeacher = getThisTeacher();
if (Request != null)
{
//Create a copy of db so if user submit any files with problem that mess up db, it can be reverted back.
var aCopyOfDB = new Internship_Management_SystemEntities();
try
{
//If there are already records of classes and students that are related to this teacher, delete them and replace with our new file.
db.Students.RemoveRange(thisTeacher.Students);
db.Class_.RemoveRange(thisTeacher.Class_);
db.Contract_.RemoveRange(thisTeacher.Contract_);
db.InternshipTasks.RemoveRange(thisTeacher.InternshipTasks);
HttpPostedFileBase file = Request.Files["UploadedFile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
}
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
Class_ class_ = new Class_();
for (int rowIterator = 2; ; rowIterator++)
{
if (workSheet.Cells[rowIterator, 1].Value != null)
{
//Calculate the number of students in this specific class.
if (class_.Students.Count != 0)
{
class_.NumberOfStudents = class_.Students.Count;
db.Class_.Add(class_);
}
class_ = new Class_();
class_.Teacher = thisTeacher;
class_.TeacherEmail = thisTeacher.TeacherEmail;
class_.ClassName = workSheet.Cells[rowIterator, 1].Value.ToString();
}
try
{
Student student = new Student();
student.Class_ = class_;
student.ClassName = class_.ClassName;
student.StudentName = workSheet.Cells[rowIterator, 2].Value.ToString();
student.PhoneNumber = workSheet.Cells[rowIterator, 3].Value.ToString();
student.TeacherEmail = thisTeacher.TeacherEmail;
student.Teacher = thisTeacher;
db.Students.Add(student);
}
catch (NullReferenceException ex)
{
class_.NumberOfStudents = class_.Students.Count;
break;
}
}
}
await db.SaveChangesAsync();
}
catch (Exception e)
{
db = aCopyOfDB;
ViewData["isSuccessful"] = false;
return(View("ForTeacher", prepareViewModel()));
}
ViewData["isSuccessful"] = true;
}
return(View("ForTeacher", prepareViewModel()));
}
public ActionResult MarkStudent(List <string> teacherMark, List <string> classesNames, List <string> studentsNames, List <string> phoneNumbers, bool isAssessment)
{
var aCopyOfDB = new Internship_Management_SystemEntities();
var thisTeacher = getThisTeacher();
if (isAssessment)
{
var teacherMarkIterator = 0;
foreach (var c in thisTeacher.Class_)
{
foreach (var s in c.Students)
{
int result;
if (Int32.TryParse(teacherMark[teacherMarkIterator], out result))
{
s.TeacherMark = result;
}
else
{
s.TeacherMark = null;
}
teacherMarkIterator++;
}
}
db.SaveChanges();
}
else
{
try {
var editInforIterator = 0;
var classesIterator = 0;
var infoChangedStudents = new Dictionary <Student, string>();
var infoChangedClasses = new Dictionary <Class_, string>();
foreach (var c in thisTeacher.Class_)
{
if (c.ClassName != classesNames[classesIterator])
{
infoChangedClasses.Add(c, classesNames[classesIterator]);
}
foreach (var s in c.Students)
{
s.StudentName = studentsNames[editInforIterator];
if (s.PhoneNumber != phoneNumbers[editInforIterator])
{
infoChangedStudents.Add(s, phoneNumbers[editInforIterator]);
}
editInforIterator++;
}
classesIterator++;
}
foreach (var item in infoChangedStudents)
{
var replacedStudent = new Student
{
PhoneNumber = item.Value,
StudentName = item.Key.StudentName,
ClassName = item.Key.ClassName,
CompanyName = item.Key.CompanyName,
TeacherEmail = thisTeacher.TeacherEmail,
CompanyMark = item.Key.CompanyMark,
TeacherMark = item.Key.TeacherMark
};
db.Students.Remove(item.Key);
db.Students.Add(replacedStudent);
}
foreach (var item in infoChangedClasses)
{
var replacedClass = new Class_
{
ClassName = item.Value,
CompanyName = item.Key.CompanyName,
TeacherEmail = thisTeacher.TeacherEmail,
NumberOfStudents = item.Key.NumberOfStudents,
InternshipTaskId = item.Key.InternshipTaskId,
};
var involvedStudents = db.Students.Where(s => s.ClassName == item.Key.ClassName);
db.Class_.Remove(item.Key);
db.Class_.Add(replacedClass);
foreach (var s in involvedStudents)
{
s.Class_ = replacedClass;
}
}
db.SaveChanges();
ViewData["editStudentinfoSuccessful"] = true;
} catch (Exception e)
{
db = aCopyOfDB;
ViewData["editStudentinfoSuccessful"] = false;
}
}
return(View("forTeacher", prepareViewModel()));
}
