public ActionResult Create([Bind(Include = "Tutor,Student")] AssociateTutor associateTutor) { if (ModelState.IsValid) { ApplicationUser user = _db.Users.Find(associateTutor.Tutor.Id); Student student = _db.Students.Find(associateTutor.Student.Id); AssociateTutor newAssociateTutor = new AssociateTutor { Tutor = user, Student = student }; _db.AssociateTutors.Add(newAssociateTutor); try { _db.SaveChanges(); } catch (Exception ex) { Exception x = ex; } return(RedirectToAction("Index")); } else { return(RedirectToAction("Create", "AssociateTutors")); } }
public ActionResult Create([Bind(Include = "Id,name")] Location location) { if (ModelState.IsValid) { db.Locations.Add(location); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(location)); }
public ActionResult Create([Bind(Include = "Id,UserName,FirstName,LastName,DateTime,Status")] Login login) { if (ModelState.IsValid) { _db.Login.Add(login); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(login)); }
public ActionResult Create([Bind(Include = "Id,Name,Address,MainPhone,Fax,Email,ContactName,ContactEmail,ContactPhone,BoxWeight,ProviderNote")] HfedProvider hfedProvider) { if (ModelState.IsValid) { db.HfedProviders.Add(hfedProvider); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hfedProvider)); }
public ActionResult Create([Bind(Include = "Id,Name")] TipsCategory tipsCategory) { if (ModelState.IsValid) { _db.TipsCategories.Add(tipsCategory); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tipsCategory)); }
public ActionResult Create([Bind(Include = "Id,Name")] DocumentType documentType) { if (ModelState.IsValid) { _db.DocumentTypes.Add(documentType); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(documentType)); }
public ActionResult Create([Bind(Include = "Id,Name,Address,Location,MainPhone,LocationNote")] HfedLocation hfedLocation) { if (ModelState.IsValid) { db.HfedLocations.Add(hfedLocation); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hfedLocation)); }
public ActionResult Create([Bind(Include = "Id,firstName,lastName,title,workPhone,cellPhone,eMail")] Staff staff) { if (ModelState.IsValid) { _db.StaffMembers.Add(staff); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(staff)); }
public ActionResult Create([Bind(Include = "Id,firstName,lastName,address1,cityStateZip,homePhone,cellPhone,eMail")] Volunteer volunteer) { if (ModelState.IsValid) { db.Volunteers.Add(volunteer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(volunteer)); }
public ActionResult Create([Bind(Include = "Id,name")] School school) { if (ModelState.IsValid) { _db.Schools.Add(school); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(school)); }
public void TestSaveStudentTutorNote() { using (SenecaContext db = new SenecaContext()) { Debug.WriteLine(db.Database.Connection.ConnectionString); db.Database.Log = Console.Write; Student student = (from s in db.Students where s.FirstName == "Jayden" select s).Single(); ApplicationUser user = (from u in db.Users where u.UserName == "p" select u).Single(); TutorNote note = db.TutorNotes.Create(); note.Date = DateTime.Now; note.SessionNote = "xxx"; note.Student = student; note.ApplicationUser = user; db.TutorNotes.Add(note); db.SaveChanges(); TutorNote foundNote = (from n in db.TutorNotes where n.SessionNote == "xxx" select n).SingleOrDefault(); Assert.IsNotNull(foundNote); Assert.AreEqual(student, foundNote.Student); Assert.AreEqual(user, foundNote.ApplicationUser); Assert.IsTrue(student.TutorNotes.Contains(foundNote)); } }
public ActionResult Edit([Bind(Include = "Id,UserName,Active,FirstName,LastName,Title,PhoneNumber,Email")] ApplicationUser user) { if (ModelState.IsValid) { ApplicationUser saveUser = (from u in _db.Users.Where(u => u.Id == user.Id) select u).Single(); saveUser.UserName = user.UserName; saveUser.FirstName = user.FirstName; saveUser.LastName = user.LastName; saveUser.Title = user.Title; saveUser.PhoneNumber = user.PhoneNumber; saveUser.Email = user.Email; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public void TestNullPrimaryTutor() { using (SenecaContext db = new SenecaContext()) { var student = db.Students.Find(6); student.PrimaryTutor = null; db.SaveChanges(); } }
public ActionResult Edit([Bind(Include = "Id,User,Student,Date,SessionNote")] AddEditTutorNoteViewModel viewModel) { if (ModelState.IsValid) { var tutorNote = _db.TutorNotes.Find(viewModel.Id); if (tutorNote != null) { tutorNote.Date = viewModel.Date; tutorNote.SessionNote = viewModel.SessionNote; tutorNote.Student = (from s in _db.Students where s.Id == viewModel.Student.Id select s).Single(); tutorNote.ApplicationUser = (from u in _db.Users where u.Id == viewModel.User.Id select u).Single(); } _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(viewModel)); }
public ActionResult Create([Bind(Include = "DocumentDate,Comments,Student,DocumentType,DocumentLink,PostedFile")] AddEditStudentReportViewModel model) { if (ModelState.IsValid) { StudentReport studentReport = new StudentReport { DocumentDate = model.DocumentDate, Comments = model.Comments, DocumentLink = Settings.Default.DocumentStoragePath + model.DocumentLink, DocumentType = (from d in _db.DocumentTypes where d.Id == model.DocumentType.Id select d).Single(), Student = (from s in _db.Students where s.Id == model.Student.Id select s).Single() }; _db.StudentReports.Add(studentReport); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(model)); }
public ActionResult Create([Bind(Include = "Id,LastName,School,FirstName,WorkPhone,CellPhone,Email")] AddEditTeacherViewModel viewModel) { if (ModelState.IsValid) { Teacher teacher = new Teacher { FirstName = viewModel.FirstName, LastName = viewModel.LastName, CellPhone = viewModel.CellPhone, WorkPhone = viewModel.WorkPhone, Email = viewModel.Email }; _db.Teachers.Add(teacher); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(viewModel)); }
public ActionResult DeleteConfirmed(int id) { HfedSchedule hfedSchedule = db.HfedSchedules.Find(id); if (hfedSchedule != null) { db.HfedSchedules.Remove(hfedSchedule); } db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { var hfedClient = db.HfedClients.Find(id); if (hfedClient != null) { db.HfedClients.Remove(hfedClient); } db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "MotherFather,FirstName,Address,HomePhone,CellPhone,Email,SelectedMotherFather,CaseManagerUser")] AddEditParentViewModel model) { if (ModelState.IsValid) { var parent = _db.Parents.Create(); parent.MotherFather = model.SelectedMotherFather; parent.FirstName = model.FirstName; parent.Email = model.Email; parent.Address = model.Address; parent.HomePhone = model.HomePhone; parent.CellPhone = model.CellPhone; if (model.CaseManagerUser != null) { parent.CaseManagerUser = _db.Users.Find(model.CaseManagerUser.Id); } _db.Parents.Add(parent); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(model)); }
public ActionResult Edit([Bind(Include = "Id,Tutor,Student,DayName,TimeOfDay")] TutorScheduleViewModel tutorSchedule) { if (ModelState.IsValid) { var modifiedSchedule = _db.TutorSchedules.Find(tutorSchedule.Id); if (modifiedSchedule != null) { using (var context = new SenecaContext()) { var sqlString = "SELECT Tutor_Id FROM TutorSchedule WHERE Id = " + tutorSchedule.Id; var tutorId = context.Database.SqlQuery <string>(sqlString).FirstOrDefault(); ApplicationUser tutor = _db.Users.Find(tutorId); modifiedSchedule.Tutor = tutor; tutorSchedule.Tutor = tutor; sqlString = "SELECT Student_Id FROM TutorSchedule WHERE Id = " + tutorSchedule.Id; var studentId = context.Database.SqlQuery <int>(sqlString).FirstOrDefault(); Student student = _db.Students.Find(studentId); modifiedSchedule.Student = student; } modifiedSchedule.DayOfWeekIndex = GetDayOfWeekIndex(tutorSchedule.DayName); modifiedSchedule.MinutesPastMidnight = ConvertToMinutesPastMidnight(tutorSchedule.TimeOfDay); _db.Entry(modifiedSchedule).State = EntityState.Modified; _db.SaveChanges(); if (modifiedSchedule.Student != null) { string msgText = "On " + DateTime.Now.ToShortDateString() + " " + modifiedSchedule.Tutor.FullName + " changed " + modifiedSchedule.Student.FirstName + " to " + tutorSchedule.DayName + " " + tutorSchedule.TimeOfDay; Task <ActionResult> unused = new AccountController().EmailSheduleChange(modifiedSchedule.Tutor, msgText); } return(RedirectToAction("Index")); } } return(View(tutorSchedule)); }
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,PhoneNumber,Email")] UpdateMyProfileViewModel viewModel) { if (ModelState.IsValid) { var user = _db.Users.Find(viewModel.Id); if (user != null) { user.FirstName = viewModel.FirstName; user.LastName = viewModel.LastName; user.PhoneNumber = viewModel.PhoneNumber; user.Email = viewModel.Email; _db.SaveChanges(); return(RedirectToAction("Index", "HfedHome")); } } return(View(viewModel)); }
// POST: Upload public ActionResult Upload(HttpPostedFileBase file, int?studentId, int?documentTypeId) { if (studentId == null) { TempData["ErrorMessage"] = "Student ID AND Document Type required. Re-enter all."; return(RedirectToAction("Index")); } if (documentTypeId == null) { TempData["ErrorMessage"] = "Student ID AND Document Type required. Re-enter all."; return(RedirectToAction("Index")); } try { if (file != null) { var fileName = Path.GetFileName(file.FileName); string path = Server.MapPath(" ") + "\\" + fileName; path = path.Replace("\\Upload", "\\UploadFiles"); path = path.Replace("\\", "/"); file.SaveAs(path); CloudStorageAccount storageAccount = CloudStorageAccount.Parse(Properties.Settings.Default.StorageConnectionString); CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); CloudBlobContainer container = blobClient.GetContainerReference("studentreports"); CloudBlockBlob blob = container.GetBlockBlobReference(fileName); if (blob.Exists()) { TempData["ErrorMessage"] = "There is already a file with this name. Re-enter all."; return(RedirectToAction("Index")); } if (fileName != null && fileName.ToUpper().Substring(fileName.Length - 3, 3) == "MP4") { blob.Properties.ContentType = "video/mp4"; } else { blob.Properties.ContentType = "application/pdf"; } using (var fileStream = System.IO.File.OpenRead(path)) { blob.UploadFromStream(fileStream); } System.IO.File.Delete(path); int i = path.IndexOf("UploadFiles", StringComparison.Ordinal); path = path.Remove(0, i + 12); var studentReport = new StudentReport { DocumentLink = path.Replace(@"\", "/"), Student = _db.Students.Find(studentId), DocumentType = _db.DocumentTypes.Find(documentTypeId), DocumentDate = DateTime.Now }; _db.StudentReports.Add(studentReport); _db.SaveChanges(); return(RedirectToAction("Edit", "StudentReports", new { id = studentReport.Id })); } // If(File != null) if (User.IsInRole("Administrator")) { return(RedirectToAction("Index")); } else { return(RedirectToAction("Index", "Home")); // Dashboard } } catch (Exception) { return(null); } }
public ActionResult Create([Bind(Include = "Tutor,Student,DayName,TimeOfDay")] TutorScheduleViewModel tutorSchedule) { tutorSchedule.ErrorMessage = null; if (tutorSchedule.Tutor.Id == null) { tutorSchedule.ErrorMessage = "Tutor Required!"; } if (tutorSchedule.Student.Id == 0) { tutorSchedule.ErrorMessage = "Student Required!"; } if (tutorSchedule.ErrorMessage != null || ModelState.IsValid != true) // rebuild drop-down lists: { var tutorRoleId = (from r in _db.Roles where (r.Name == "Tutor") select r.Id).Single(); var listTutors = new List <ApplicationUser>(); var users = _db.Users.ToList(); foreach (var user in users) { foreach (var role in user.Roles) { if (role.RoleId == tutorRoleId) { listTutors.Add(user); } } } tutorSchedule.Tutors = listTutors; tutorSchedule.Students = _db.Students.OrderBy(s => s.FirstName).ToList(); List <string> daysList = new List <string> { "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday" }; tutorSchedule.DaysList = daysList; List <string> timesList = new List <string> { "10:00", "10:15", "10:30", "10:45", "11:00", "11:15", "11:30", "11:45", "1:00", "1:15", "1:30", "1:45", "2:00", "2:15", "2:30", "2:45", "3:00", "3:15", "3:30", "3:45", "4:00", "4:15", "4:30", "4:45", "5:00", "5:15", "5:30", "TBD" }; tutorSchedule.TimesList = timesList; return(View(tutorSchedule)); } // if ErrorMessage = null AND ModelState.IsValid: ApplicationUser tutor = _db.Users.Find(tutorSchedule.Tutor.Id); Student student = _db.Students.Find(tutorSchedule.Student.Id); TutorSchedule newTutorSchedule = new TutorSchedule() { Tutor = tutor, Student = student, DayOfWeekIndex = GetDayOfWeekIndex(tutorSchedule.DayName), MinutesPastMidnight = ConvertToMinutesPastMidnight(tutorSchedule.TimeOfDay) }; _db.TutorSchedules.Add(newTutorSchedule); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,FirstName,Gender,BirthDate,GradeLevel,SpecialClass,School,Parent,PrimaryTutor,Teacher,Active")] AddEditStudentViewModel viewModel) { viewModel.ErrorMessage = null; if (viewModel.School.Id == 0) { viewModel.ErrorMessage = "School Required!"; } if (viewModel.Parent.Id == 0) { viewModel.ErrorMessage = "Parent Required!"; } if (viewModel.FirstName == null) { viewModel.ErrorMessage = "First Name Required!"; } if (viewModel.ErrorMessage != null) // rebuild drop-down lists: { List <SelectListItem> schoolList = new List <SelectListItem>(); foreach (School school in _db.Schools) { schoolList.Add(new SelectListItem { Text = school.Name, Value = school.Id.ToString() }); } viewModel.Schools = schoolList; List <SelectListItem> parentList = new List <SelectListItem>(); var sortedParents = _db.Parents.OrderBy(p => p.FirstName).ToList(); foreach (Parent parent in sortedParents) { parentList.Add(new SelectListItem { Text = parent.FirstName, Value = parent.Id.ToString() }); } viewModel.Parents = parentList; List <SelectListItem> userList = new List <SelectListItem>(); var sortedUsers = _db.Users.OrderBy(u => u.LastName).ThenBy(u => u.FirstName).ToList(); foreach (ApplicationUser user in sortedUsers) { if (user.Id != null) { userList.Add(new SelectListItem { Text = user.LastName + @", " + user.FirstName, Value = user.Id }); } } viewModel.Users = userList; List <SelectListItem> teacherList = new List <SelectListItem>(); var sortedTeachers = _db.Teachers.OrderBy(p => p.LastName).ToList(); foreach (Teacher teacher in sortedTeachers) { teacherList.Add(new SelectListItem { Text = teacher.LastName + @", " + teacher.FirstName, Value = teacher.Id.ToString() }); } viewModel.Teachers = teacherList; return(View(viewModel)); } if (ModelState.IsValid) { Student student = new Student { FirstName = viewModel.FirstName, Gender = viewModel.Gender, BirthDate = viewModel.BirthDate, GradeLevel = viewModel.GradeLevel, SpecialClass = viewModel.SpecialClass, Parent = (from p in _db.Parents where p.Id == viewModel.Parent.Id select p).Single(), School = (from s in _db.Schools where s.Id == viewModel.School.Id select s).Single() }; if (viewModel.PrimaryTutor.Id != null) { student.PrimaryTutor = (from t in _db.Users where t.Id == viewModel.PrimaryTutor.Id select t).Single(); } if (viewModel.Teacher.Id != 0) { student.Teacher = (from t in _db.Teachers where t.Id == viewModel.Teacher.Id select t).Single(); } student.Active = viewModel.Active; _db.Students.Add(student); _db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Create")); }
// POST: Upload public ActionResult Upload(HttpPostedFileBase file, int?studentId, int?documentTypeId) { if (studentId == null) { TempData["ErrorMessage"] = "Student ID AND Document Type required. Re-enter all."; return(RedirectToAction("Index")); } if (documentTypeId == null) { TempData["ErrorMessage"] = "Student ID AND Document Type required. Re-enter all."; return(RedirectToAction("Index")); } var fileName = Path.GetFileName(file.FileName); string path = Server.MapPath(" ") + "\\" + fileName; path = path.Replace("\\Upload", "\\StudentReportFiles"); path = path.Replace("\\", "/"); file.SaveAs(path); //{ // FileName = System.IO.Path.GetFileName(upload.FileName), // FileType = FileType.Avatar, // ContentType = upload.ContentType //}; //using (var reader = new System.IO.BinaryReader(upload.InputStream)) //{ // avatar.Content = reader.ReadBytes(upload.ContentLength); //} //student.Files = new List<File> { avatar }; //CloudStorageAccount storageAccount = CloudStorageAccount.Parse(Settings.Default.StorageConnectionString); //CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); //CloudBlobContainer container = blobClient.GetContainerReference("studentreports"); //CloudBlockBlob blob = container.GetBlockBlobReference(fileName); //if (blob.Exists()) //{ // TempData["ErrorMessage"] = "There is already a file with this name. Re-enter all."; // return RedirectToAction("Index"); //} //if (fileName != null && fileName.ToUpper().Substring(fileName.Length - 3, 3) == "MP4") //{ // blob.Properties.ContentType = "video/mp4"; //} //else //{ // blob.Properties.ContentType = "application/pdf"; //} //using (var fileStream = System.IO.File.OpenRead(path)) //{ // //blob.UploadFromStream(fileStream); //} //System.IO.File.Delete(path); //int i = path.IndexOf("UploadFiles", StringComparison.Ordinal); //path = path.Remove(0, i + 12); var studentReport = new StudentReport { DocumentLink = fileName, Student = _db.Students.Find(studentId), DocumentType = _db.DocumentTypes.Find(documentTypeId), DocumentDate = DateTime.Now }; _db.StudentReports.Add(studentReport); _db.SaveChanges(); return(RedirectToAction("Edit", "StudentReports", new { id = studentReport.Id })); //if (User.IsInRole("Administrator")) //{ // return RedirectToAction("Index"); //} //else //{ // return RedirectToAction("Index", "Home"); // Dashboard //} }
public ActionResult Create(HttpPostedFileBase file, int?categoryId, string name) { if (categoryId == null) { TempData["ErrorMessage"] = "Category required. Re-enter all."; return(RedirectToAction("Create")); } try { if (file != null) { var fileName = Path.GetFileName(file.FileName); string path = Server.MapPath(" ") + "\\" + fileName; path = path.Replace("\\TipDocuments", "\\UploadFiles"); path = path.Replace("\\", "/"); file.SaveAs(path); CloudStorageAccount storageAccount = CloudStorageAccount.Parse(Settings.Default.StorageConnectionString); CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); CloudBlobContainer container = blobClient.GetContainerReference("teachingtips"); CloudBlockBlob blob = container.GetBlockBlobReference(fileName); if (blob.Exists()) { TempData["ErrorMessage"] = "There is already a file with this name. Re-enter all."; return(RedirectToAction("Create")); } if (fileName != null && fileName.ToUpper().Substring(fileName.Length - 3, 3) == "MP4") { blob.Properties.ContentType = "video/mp4"; } else { blob.Properties.ContentType = "application/pdf"; } using (var fileStream = System.IO.File.OpenRead(path)) { blob.UploadFromStream(fileStream); } System.IO.File.Delete(path); int i = path.IndexOf("UploadFiles", StringComparison.Ordinal); path = path.Remove(0, i + 12); string currentUserId = User.Identity.GetUserId(); var tipDocument = new TipDocument { DocumentLink = path.Replace(@"\", "/"), User = _db.Users.Find(currentUserId), Category = _db.TipsCategories.Find(categoryId), Name = name }; _db.TipDocuments.Add(tipDocument); _db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception) { return(null); } TempData["ErrorMessage"] = "File not found error."; return(RedirectToAction("Create")); }