public ActionResult Create([Bind(Include = "Id,TeacherID,JoiningDate")] AspNetTeacher aspNetTeacher) { var TransactionObj = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetTeachers.Add(aspNetTeacher); db.SaveChanges(); } TransactionObj.Commit(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; var logMessage = "New Teacher Added, TeacherID: " + aspNetTeacher.TeacherID + ", JoiningDate: " + aspNetTeacher.JoiningDate; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// return(RedirectToAction("Index")); } catch { TransactionObj.Dispose(); } ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetTeacher.TeacherID); return(View(aspNetTeacher)); }
public ActionResult Create([Bind(Include = "Id,SubjectName,ClassID,TeacherID")] AspNetSubject aspNetSubject) { var TransactionObj = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetSubjects.Add(aspNetSubject); db.SaveChanges(); } TransactionObj.Commit(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; string user = db.AspNetUsers.Where(x => x.Id == aspNetSubject.TeacherID).Select(x => x.Name).FirstOrDefault(); var logMessage = "New Subject Added, SubjectName: " + aspNetSubject.SubjectName + ", ClassID: " + aspNetSubject.ClassID + ", TeacherName: " + user; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// return(RedirectToAction("ClassIndexs")); } catch { TransactionObj.Dispose(); ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetSubject.ClassID); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(x => x.AspNetRoles.Select(y => y.Name).Contains("Teacher")), "Id", "Name"); return(View("Create", aspNetSubject)); } }
public ActionResult Create([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status")] AspNetSession aspNetSession) { var TransactionObj = db.Database.BeginTransaction(); if (db.AspNetSessions.Where(x => x.Status == "Active").Count() == 0 || aspNetSession.Status == "InActive") { if (ModelState.IsValid) { aspNetSession.SessionEndDate = Convert.ToDateTime(Request.Form["SessionEndDate"]); aspNetSession.SessionStartDate = Convert.ToDateTime(Request.Form["SessionStartDate"]); db.AspNetSessions.Add(aspNetSession); db.SaveChanges(); } TransactionObj.Commit(); ////////////////////////////////////////////////////////Term Add///////////////////////////////////////////////////////////////// int length = 3; for (int i = 0; i < length; i++) { AspNetTerm aspnetTerm = new AspNetTerm(); aspnetTerm.SessionID = aspNetSession.Id; aspnetTerm.TermName = "Term " + (i + 1); aspnetTerm.TermStartDate = DateTime.Now; aspnetTerm.TermEndDate = DateTime.Now; aspnetTerm.Status = "InActive"; db.AspNetTerms.Add(aspnetTerm); db.SaveChanges(); } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; var logMessage = "New Session Added, SessionName: " + aspNetSession.SessionName + ", SessionStartDate: " + aspNetSession.SessionStartDate + ", SessionEndDate: " + aspNetSession.SessionEndDate + ", Status: " + aspNetSession.Status; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// return(RedirectToAction("Indexs")); } else { return(RedirectToAction("Index")); } }
public ActionResult Create([Bind(Include = "Id,ClassName,Class,Section,TeacherID")] AspNetClass aspNetClass) { aspNetClass.SessionID = SessionID; var transactionObj = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetClasses.Add(aspNetClass); db.SaveChanges(); } transactionObj.Commit(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser userObjLog = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = userObjLog.Id; AspNetUser ClassTeacherLog = db.AspNetUsers.First(x => x.Id == aspNetClass.TeacherID); string ClassTeacherNameLog = ClassTeacherLog.Name; string user = db.AspNetUsers.Where(x => x.Id == aspNetClass.TeacherID).Select(x => x.Name).FirstOrDefault(); var logMessage = "A new Class Added, Name: " + aspNetClass.ClassName + ", Class Teacher: " + ClassTeacherNameLog + ", Teacher Name: " + user; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// return(RedirectToAction("Index")); } catch (Exception) { transactionObj.Dispose(); } ViewBag.Class = new SelectList(Classes, "option", "value"); ViewBag.Section = new SelectList(Sections, "option", "value"); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(x => x.AspNetRoles.Select(y => y.Name).Contains("Teacher")), "Id", "UserName", aspNetClass.TeacherID); return(View(aspNetClass)); }
public ActionResult Create([Bind(Include = "Id,TermName,SessionID,TermStartDate,TermEndDate,Status")] AspNetTerm aspNetTerm) { var TransactionObj = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { var terms = db.AspNetTerms.Where(p => p.SessionID == aspNetTerm.SessionID).Count(); aspNetTerm.TermNo = terms + 1; db.AspNetTerms.Add(aspNetTerm); db.SaveChanges(); } TransactionObj.Commit(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; var logMessage = "New Term Added, TermName: " + aspNetTerm.TermName + ", TermStartDate: " + aspNetTerm.TermStartDate + ", TermEndDate: " + aspNetTerm.TermEndDate + ", Status: " + aspNetTerm.Status; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// return(RedirectToAction("Indexs")); } catch { TransactionObj.Dispose(); } ViewBag.SessionID = new SelectList(db.AspNetSessions, "Id", "SessionName", aspNetTerm.SessionID); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,TopicNo,TopicName,StartDate,EndDate,ChapterID,Status")] AspNetTopic aspNetTopic) { var dbTransaction = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetTopics.Add(aspNetTopic); db.SaveChanges(); } dbTransaction.Commit(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; var logMessage = "New Topic Added, SubjectID: " + aspNetTopic.ChapterID + ", Topic: " + aspNetTopic.TopicName; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ViewBag.CreateTopic = "Topic created and updated successfully"; ViewBag.ClassID = new SelectList(db.AspNetSubjects.Where(x => x.TeacherID == TeacherID).Select(x => x.AspNetClass).Distinct(), "Id", "ClassName"); return(View("../Teacher_Dashboard/_Topics")); } catch (Exception) { dbTransaction.Dispose(); ViewBag.ChapterID = new SelectList(db.AspNetChapters.Where(x => x.AspNetSubject.AspNetClass.SessionID == SessionID), "Id", "ChapterName", aspNetTopic.ChapterID); return(View(aspNetTopic)); } ViewBag.ChapterID = new SelectList(db.AspNetChapters.Where(x => x.AspNetSubject.AspNetClass.SessionID == SessionID), "Id", "ChapterName", aspNetTopic.ChapterID); return(View(aspNetTopic)); }
public ActionResult Create([Bind(Include = "Id,SubjectName,ClassID,TeacherID")] AspNetSubject aspNetSubject) { var CourseType = Convert.ToString(Request.Form["CourseType"]); var class_id = db.AspNetClasses.Where(x => x.SessionID == SessionID).FirstOrDefault().Id; aspNetSubject.ClassID = class_id; aspNetSubject.CourseType = Request.Form["CourseType"]; string IsMandatory = Request.Form["IsMandatory"]; aspNetSubject.Points = Int32.Parse(Request.Form["Points"]); if (IsMandatory == "on") { aspNetSubject.IsManadatory = true; } else { aspNetSubject.IsManadatory = false; if (CourseType == "CSS") { aspNetSubject.SubjectGroup = Convert.ToString(Request.Form["CSSGroup"]); } else { aspNetSubject.SubjectGroup = Convert.ToString(Request.Form["PMSGroup"]); } } var TransactionObj = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetSubjects.Add(aspNetSubject); db.SaveChanges(); } TransactionObj.Commit(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; string user = db.AspNetUsers.Where(x => x.Id == aspNetSubject.TeacherID).Select(x => x.Name).FirstOrDefault(); var logMessage = "New Subject Added, SubjectName: " + aspNetSubject.SubjectName + ", ClassID: " + aspNetSubject.ClassID + ", TeacherName: " + user; //string[] SelectedTeachers = Request.Form["TotalTeachers"].Split(','); // var class_id = db.AspNetClasses.Where(x => x.SessionID == SessionID).FirstOrDefault().Id; // var sub_id = db.AspNetSubjects.Where(x => x.SubjectName == aspNetSubject.SubjectName && x.ClassID == class_id).FirstOrDefault().Id; var teacherid = db.AspNetEmployees.Where(x => x.UserId == aspNetSubject.TeacherID).FirstOrDefault().Id; //var SelectedTeahcersFromDB = db.AspNetEmployees.Where(x=> SelectedTeachers.Contains(x.UserId)).ToList(); //foreach(var Emplyee in SelectedTeahcersFromDB) //{ // assign subject to teacher start /* * AspNetTeacherSubject ts = new AspNetTeacherSubject(); * * * ts.TeacherID = teacherid; * ts.SubjectID = aspNetSubject.Id; * db.AspNetTeacherSubjects.Add(ts); * db.SaveChanges(); */ // assign subject to teachers end // //} var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// return(RedirectToAction("ClassIndexs")); } catch { TransactionObj.Dispose(); ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetSubject.ClassID); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(x => x.AspNetRoles.Select(y => y.Name).Contains("Teacher")), "Id", "Name"); return(View("Create", aspNetSubject)); } }
public ActionResult Create([Bind(Include = "Id,Title,Description")] AspNetAnnouncement aspNetAnnouncement) { string subjects = Request.Form["subjects"]; IEnumerable <string> selectedsubjects = subjects.Split(','); if (ModelState.IsValid) { var dbContextTransaction = db.Database.BeginTransaction(); try { aspNetAnnouncement.Date = DateTime.Now; db.AspNetAnnouncements.Add(aspNetAnnouncement); db.SaveChanges(); int announcementID = db.AspNetAnnouncements.Max(item => item.Id); List <int> SubjectIDs = new List <int>(); foreach (var item in selectedsubjects) { int subjectID = Convert.ToInt32(item); SubjectIDs.Add(subjectID); } foreach (var item in SubjectIDs) { AspNetAnnouncement_Subject ann_sub = new AspNetAnnouncement_Subject(); ann_sub.SubjectID = item; ann_sub.AnnouncementID = announcementID; db.AspNetAnnouncement_Subject.Add(ann_sub); db.SaveChanges(); } List <string> student = db.AspNetStudent_Subject.Where(x => SubjectIDs.Contains(x.SubjectID)).Select(s => s.StudentID).ToList(); foreach (var item in student) { AspNetStudent_Announcement stu_ann = new AspNetStudent_Announcement(); stu_ann.StudentID = item; stu_ann.AnnouncementID = announcementID; stu_ann.Seen = false; db.AspNetStudent_Announcement.Add(stu_ann); db.SaveChanges(); /////////////////////////////////////////////////////Push Notifications Module//////////////////////////////////////////////////////////// //var pushNotificationObj = new AspNetPushNotification(); //pushNotificationObj.Message = "New Announcement: " + aspNetAnnouncement.Title + ", Description: " + aspNetAnnouncement.Description; //pushNotificationObj.UserID = item; //pushNotificationObj.IsOpenParent = false; //pushNotificationObj.IsOpenStudent = false; //pushNotificationObj.Time = DateTime.Now; //db.AspNetPushNotifications.Add(pushNotificationObj); //db.SaveChanges(); } ////////////////////////////////////////////////NOTIFICATION/////////////////////////////////////////////////////////////////// var NotificationObj = new AspNetNotification(); NotificationObj.Description = aspNetAnnouncement.Description; NotificationObj.Subject = aspNetAnnouncement.Title; NotificationObj.SenderID = User.Identity.GetUserId(); NotificationObj.Time = DateTime.Now; NotificationObj.Url = "/AspNetAnnouncement/details/" + aspNetAnnouncement.Id; NotificationObj.SessionID = SessionID; db.AspNetNotifications.Add(NotificationObj); db.SaveChanges(); var NotificationID = db.AspNetNotifications.Max(x => x.Id); List <string> students = db.AspNetStudent_Subject.Where(x => SubjectIDs.Contains(x.SubjectID)).Select(s => s.StudentID).ToList(); var users = new List <String>(); foreach (var item in students) { var parentID = db.AspNetParent_Child.Where(x => x.ChildID == item).Select(x => x.ParentID).FirstOrDefault(); users.Add(parentID); } var allusers = users.Union(students); //Message start //var classe = db.AspNetClasses.Where(p => p.Id == aspNetHomework.ClassId).FirstOrDefault(); //Utility obj = new Utility(); //obj.SMSToOffitialsp("Dear Principal, Announcement has been made with Title: " + aspNetAnnouncement.Title + "- IPC NGS Preschool, Aziz Avenue, Lahore."); //obj.SMSToOffitialsa("Dear Admin, Announcement has been made with Title: " + aspNetAnnouncement.Title + "- IPC NGS Preschool, Aziz Avenue, Lahore."); //AspNetMessage oob = new AspNetMessage(); //oob.Message = "Dear Parents, Announcement has been made with Title: " + aspNetAnnouncement.Title + "For discription login to Portal please - IPC NGS Preschool, Aziz Avenue, Lahore."; //obj.SendSMS(oob, users); //Message end foreach (var receiver in allusers) { var notificationRecieve = new AspNetNotification_User(); notificationRecieve.NotificationID = NotificationID; notificationRecieve.UserID = Convert.ToString(receiver); notificationRecieve.Seen = false; db.AspNetNotification_User.Add(notificationRecieve); db.SaveChanges(); } dbContextTransaction.Commit(); /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; var classObjLog = Request.Form["ClassID"]; var logMessage = "A new Announcement Added, Topic: " + aspNetAnnouncement.Title + ", Description: " + aspNetAnnouncement.Description + ", ClassIDs: " + classObjLog; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// } catch (Exception) { dbContextTransaction.Dispose(); } return(RedirectToAction("Teacher_Announcement", "Teacher_Dashboard")); } return(View(aspNetAnnouncement)); }
public ActionResult Create([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status,Total_Fee")] AspNetSession aspNetSession) { var TransactionObj = db.Database.BeginTransaction(); if (ModelState.IsValid) { aspNetSession.SessionEndDate = Convert.ToDateTime(Request.Form["SessionEndDate"]); aspNetSession.SessionStartDate = Convert.ToDateTime(Request.Form["SessionStartDate"]); aspNetSession.Total_Fee = aspNetSession.Total_Fee; db.AspNetSessions.Add(aspNetSession); db.SaveChanges(); } TransactionObj.Commit(); ////////////////////////////////////////////////////////Term Add///////////////////////////////////////////////////////////////// //int length = 3; //for (int i = 0; i < length; i++) //{ // AspNetTerm aspnetTerm = new AspNetTerm(); // aspnetTerm.SessionID = aspNetSession.Id; // aspnetTerm.TermName = "Term " + (i + 1); // aspnetTerm.TermStartDate = DateTime.Now; // aspnetTerm.TermEndDate = DateTime.Now; // aspnetTerm.Status = "InActive"; // db.AspNetTerms.Add(aspnetTerm); // db.SaveChanges(); //} ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; var logMessage = "New Session Added, SessionName: " + aspNetSession.SessionName + ", SessionStartDate: " + aspNetSession.SessionStartDate + ", SessionEndDate: " + aspNetSession.SessionEndDate + ", Status: " + aspNetSession.Status; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// AspNetClass Class = new AspNetClass(); var CurrentSession = db.AspNetSessions.OrderByDescending(x => x.Id).FirstOrDefault(); Class.ClassName = CurrentSession.SessionName; Class.Class = CurrentSession.SessionName; Class.SessionID = CurrentSession.Id; db.AspNetClasses.Add(Class); db.SaveChanges(); //Create Subjects to New Session var AllSubjectsofTestSession = db.AspNetSubjects.Where(x => x.ClassID == 1).ToList(); List <subjects_mapping> list = new List <subjects_mapping>(); foreach (AspNetSubject Subject in AllSubjectsofTestSession) { subjects_mapping sub = new subjects_mapping(); sub.oldId = Subject.Id; sub.name = Subject.SubjectName; AspNetSubject NewSubjectForSession = new AspNetSubject(); NewSubjectForSession = Subject; NewSubjectForSession.ClassID = Class.Id; NewSubjectForSession.TeacherID = null; db.AspNetSubjects.Add(NewSubjectForSession); db.SaveChanges(); sub.newId = NewSubjectForSession.Id; list.Add(sub); } var AllTeacherSubjects = db.AspNetTeacherSubjects.Where(x => x.AspNetSubject.ClassID == 1).ToList(); foreach (var item in AllTeacherSubjects) { foreach (var item1 in list) { if (item1.oldId == item.SubjectID) { AspNetTeacherSubject TS = new AspNetTeacherSubject(); TS.SubjectID = item1.newId; TS.TeacherID = item.TeacherID; db.AspNetTeacherSubjects.Add(TS); break; } } } db.SaveChanges(); var UserIDs = (from teacher in db.AspNetUsers.Where(x => x.Status != "False") join t2 in db.AspNetUsers_Session on teacher.Id equals t2.UserID join t3 in db.AspNetEmployees on teacher.Id equals t3.UserId where teacher.AspNetRoles.Select(y => y.Name).Contains("Teacher") && t2.AspNetSession.AspNetClasses.Any(x => x.Id == 1) /*&& db.AspNetChapters.Any(x=>x.Id==id)*/ select new { TeacherId = teacher.Id, EmployeeId = t3.Id, }).ToList(); foreach (var Id in UserIDs) { string IdString = Id.TeacherId.ToString(); AspNetUsers_Session UserSession = new AspNetUsers_Session(); UserSession.SessionID = aspNetSession.Id; UserSession.UserID = IdString; db.AspNetUsers_Session.Add(UserSession); db.SaveChanges(); } foreach (var Id in UserIDs) { Aspnet_Employee_Session EmployeeSession = new Aspnet_Employee_Session(); EmployeeSession.Emp_Id = Id.EmployeeId; EmployeeSession.Session_Id = aspNetSession.Id; db.Aspnet_Employee_Session.Add(EmployeeSession); db.SaveChanges(); } return(RedirectToAction("Indexs")); }