public JsonResult SaveEvent(Event e)
{
e.UserId = User.Identity.GetUserId();
var status = false;
using (SEA_DatabaseEntities dc = new SEA_DatabaseEntities())
{
if (e.EventID > 0)
{
//Update the event
var v = dc.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
}
}
else
{
dc.Events.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
// public ActionResult Index()
// {
// var aspNetClasses = (from cls in db.AspNetClasses.Include(a => a.AspNetUser)
// join std_cls in db.AspNetStudent_Session_class on
//cls.Id equals std_cls.ClassID
// where std_cls.SessionID == 17
// select cls);
// return View(aspNetClasses.Distinct().ToList());
// }
public void ClassExcelRecord()
{
SEA_DatabaseEntities db = new SEA_DatabaseEntities();
List <AspNetClass> ClassList;
ClassList = db.AspNetClasses.Select(x => x).ToList();
ExcelPackage pck = new ExcelPackage();
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Report");
ws.Cells["A1"].Value = "Class Name";
ws.Cells["B1"].Value = "Teacher";
ws.Cells["C1"].Value = "Class";
ws.Cells["D1"].Value = "Section";
int rowStart = 2;
foreach (var item in ClassList)
{
ws.Cells[string.Format("A{0}", rowStart)].Value = item.ClassName;
ws.Cells[string.Format("B{0}", rowStart)].Value = item.AspNetUser.UserName;
ws.Cells[string.Format("C{0}", rowStart)].Value = item.Class;
ws.Cells[string.Format("D{0}", rowStart)].Value = item.Section;
rowStart++;
}
ws.Cells["A:AZ"].AutoFitColumns();
Response.Clear();
Response.ContentType = "application/vnd.openxmlformates-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment:filename=" + "ExcelReport.xlsx");
Response.BinaryWrite(pck.GetAsByteArray());
Response.End();
//return RedirectToAction("TeacherIndex");
}
public JsonResult GetEvents()
{
using (SEA_DatabaseEntities dc = new SEA_DatabaseEntities())
{
var id = User.Identity.GetUserId();
var events = dc.Events.Where(x => x.UserId == id || x.IsPublic == true).Select(x => new { x.Description, x.End, x.EventID, x.IsFullDay, x.Subject, x.ThemeColor, x.Start, x.IsPublic }).ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public void FeeChallan_ExcelReport(string month)
{
SEA_DatabaseEntities db = new SEA_DatabaseEntities();
var challanlist = (from feemonth in db.StudentFeeMonths
join std in db.AspNetStudents on feemonth.StudentId equals std.Id
join challan in db.StudentChallanForms on std.Id equals challan.StudentId
where feemonth.Status == "Pending" && feemonth.Months == month && feemonth.Id == challan.StudentFeeMonthId
select new { challan.ChallanNo, feemonth.Months, feemonth.FeePayable, feemonth.IssueDate, std.AspNetUser.Name, std.AspNetClass.ClassName, feemonth.DueDate, feemonth.ValildityDate, }).ToList();
ExcelPackage pck = new ExcelPackage();
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Report");
ws.Cells["A1"].Value = "Challan No";
ws.Cells["B1"].Value = "Payable before due date";
ws.Cells["C1"].Value = "Issue Date";
ws.Cells["D1"].Value = "Registration No";
ws.Cells["E1"].Value = "Student Name";
ws.Cells["F1"].Value = "Class";
ws.Cells["G1"].Value = "Due Date";
ws.Cells["H1"].Value = "For the month of";
ws.Cells["I1"].Value = "Payable after due date";
ws.Cells["J1"].Value = "Validity Date";
int rowStart = 2;
foreach (var item in challanlist)
{
ws.Cells[string.Format("A{0}", rowStart)].Value = item.ChallanNo;
ws.Cells[string.Format("B{0}", rowStart)].Value = item.FeePayable;
ws.Cells[string.Format("C{0}", rowStart)].Value = item.IssueDate;
ws.Cells[string.Format("D{0}", rowStart)].Value = "";
ws.Cells[string.Format("E{0}", rowStart)].Value = item.Name;
ws.Cells[string.Format("F{0}", rowStart)].Value = item.ClassName;
ws.Cells[string.Format("G{0}", rowStart)].Value = item.DueDate;
ws.Cells[string.Format("H{0}", rowStart)].Value = month;
ws.Cells[string.Format("I{0}", rowStart)].Value = item.FeePayable;
ws.Cells[string.Format("J{0}", rowStart)].Value = item.ValildityDate;
rowStart++;
}
ws.Cells["A:AZ"].AutoFitColumns();
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment:filename=ExcelReport.xls");
Response.BinaryWrite(pck.GetAsByteArray());
Response.End();
//return RedirectToAction("TeacherIndex");
}
public JsonResult DeleteEvent(int eventID)
{
var status = false;
using (SEA_DatabaseEntities dc = new SEA_DatabaseEntities())
{
var v = dc.Events.Where(a => a.EventID == eventID).FirstOrDefault();
if (v != null)
{
dc.Events.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult NewSubjectsForTeacher(string ClassID1, string teachers)
{
int?classId = Convert.ToInt32(ClassID1);
List <AspNetTeacherSubject> AllTeacherSubjectOfCurrentClass = db.AspNetTeacherSubjects.Where(x => x.AspNetSubject.ClassID == classId).ToList();
int?teacherId = Convert.ToInt32(teachers);
var SubjectsToRemoveOfCurrentTeacher = AllTeacherSubjectOfCurrentClass.Where(x => x.TeacherID == teacherId);
db.AspNetTeacherSubjects.RemoveRange(SubjectsToRemoveOfCurrentTeacher);
db.SaveChanges();
var TeacherGenericSubjectsToRemove = db.Teacher_GenericSubjects.Where(x => x.TeacherId == teacherId).ToList();;
db.Teacher_GenericSubjects.RemoveRange(TeacherGenericSubjectsToRemove);
db.SaveChanges();
List <string> selectedsubjects = new List <string>();
if (Request.Form["MandatorySubjects"] != null)
{
selectedsubjects.AddRange(Request.Form["MandatorySubjects"].Split(',').ToList());
}
if (Request.Form["OptionalSubjects"] != null)
{
selectedsubjects.AddRange(Request.Form["OptionalSubjects"].Split(',').ToList());
}
List <string> listofIDs = selectedsubjects.ToList();
List <int> myIntegersSubjectsList = listofIDs.Select(s => int.Parse(s)).ToList();
if (selectedsubjects != null)
{
foreach (var item in selectedsubjects)
{
AspNetTeacherSubject teacherSubject = new AspNetTeacherSubject();
teacherSubject.TeacherID = teacherId;
teacherSubject.SubjectID = Convert.ToInt32(item);
db.AspNetTeacherSubjects.Add(teacherSubject);
db.SaveChanges();
}
}
SEA_DatabaseEntities db1 = new SEA_DatabaseEntities();
if (selectedsubjects != null)
{
var AllSubjectsOfTeacher = from subject in db.AspNetSubjects
where myIntegersSubjectsList.Contains(subject.Id)
select subject;
foreach (var sub in AllSubjectsOfTeacher)
{
foreach (var sub1 in db.GenericSubjects.ToList())
{
if (sub.SubjectName == sub1.SubjectName && sub.CourseType == sub1.SubjectType)
{
Teacher_GenericSubjects genericSubject = new Teacher_GenericSubjects();
genericSubject.SubjectId = sub1.Id;
genericSubject.TeacherId = teacherId;
db1.Teacher_GenericSubjects.Add(genericSubject);
db1.SaveChanges();
}
}
}
}
int?SessionId = db.AspNetClasses.Where(x => x.Id == classId).FirstOrDefault().SessionID;
var EmployeeExist = db.Aspnet_Employee_Session.Where(x => x.Emp_Id == teacherId && x.Session_Id == SessionId).FirstOrDefault();
if (EmployeeExist == null)
{
Aspnet_Employee_Session ES = new Aspnet_Employee_Session();
ES.Emp_Id = teacherId;
ES.Session_Id = SessionId;
db.Aspnet_Employee_Session.Add(ES);
db.SaveChanges();
}
var UserId = db.AspNetEmployees.Where(x => x.Id == teacherId).FirstOrDefault().UserId;
var EmployeeExist1 = db.AspNetUsers_Session.Where(x => x.UserID == UserId && x.SessionID == SessionId).FirstOrDefault();
if (EmployeeExist1 == null)
{
AspNetUsers_Session US = new AspNetUsers_Session();
US.UserID = UserId;
US.SessionID = SessionId;
db.AspNetUsers_Session.Add(US);
db.SaveChanges();
}
return(RedirectToAction("ClassIndex"));
}
public ActionResult Edit(LessonViewModel LessonViewModel)
{
AspnetLesson Lesson = db.AspnetLessons.Where(x => x.Id == LessonViewModel.Id).FirstOrDefault();
Lesson.Name = LessonViewModel.LessonName;
Lesson.Video_Url = LessonViewModel.LessonVideoURL;
Lesson.TopicId = LessonViewModel.TopicId;
Lesson.DurationMinutes = LessonViewModel.LessonDuration;
Lesson.Description = LessonViewModel.LessonDescription;
db.SaveChanges();
HttpPostedFileBase Assignment = Request.Files["Assignment"];
HttpPostedFileBase Attachment1 = Request.Files["Attachment1"];
HttpPostedFileBase Attachment2 = Request.Files["Attachment2"];
HttpPostedFileBase Attachment3 = Request.Files["Attachment3"];
var fileName = "";
if (Assignment.ContentLength > 0)
{
fileName = Path.GetFileName(Assignment.FileName);
Assignment.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName);
}
AspnetStudentAssignment studentAssignment = db.AspnetStudentAssignments.Where(x => x.LessonId == Lesson.Id).FirstOrDefault();
if (studentAssignment != null)
{
if (fileName != "")
{
studentAssignment.FileName = fileName;
}
studentAssignment.Name = LessonViewModel.AssignmentName;
string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate);
if (DueDate == "1/1/0001 12:00:00 AM")
{
studentAssignment.DueDate = null;
}
else
{
studentAssignment.DueDate = LessonViewModel.AssignmentDueDate;
}
studentAssignment.Description = LessonViewModel.AssignmentDescription;
db.SaveChanges();
}
else
{
if (Assignment.ContentLength > 0)
{
AspnetStudentAssignment studentAssignment1 = new AspnetStudentAssignment();
studentAssignment1.FileName = fileName;
studentAssignment1.Name = LessonViewModel.AssignmentName;
string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate);
if (DueDate == "1/1/0001 12:00:00 AM")
{
studentAssignment1.DueDate = null;
}
else
{
studentAssignment1.DueDate = LessonViewModel.AssignmentDueDate;
}
studentAssignment1.Description = LessonViewModel.AssignmentDescription;
studentAssignment1.CreationDate = DateTime.Now;
studentAssignment1.LessonId = Lesson.Id;
db.AspnetStudentAssignments.Add(studentAssignment1);
db.SaveChanges();
}
}
List <AspnetStudentAttachment> studentAttachments = db.AspnetStudentAttachments.Where(x => x.LessonId == Lesson.Id).ToList();
List <AspnetStudentLink> studentLinks = db.AspnetStudentLinks.Where(x => x.LessonId == Lesson.Id).ToList();
//db.AspnetStudentAttachments.RemoveRange(studentAttachments);
//db.SaveChanges();
db.AspnetStudentLinks.RemoveRange(studentLinks);
db.SaveChanges();
SEA_DatabaseEntities db1 = new SEA_DatabaseEntities();
List <AspnetStudentAttachment> studentAttachments1 = db1.AspnetStudentAttachments.Where(x => x.LessonId == Lesson.Id).ToList();
int TotalAttachments = studentAttachments1.Count;
if (TotalAttachments == 0)
{
if (Attachment1.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment1.FileName);
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment1 = new AspnetStudentAttachment();
studentAttachment1.Name = LessonViewModel.AttachmentName1;
studentAttachment1.Path = fileName1;
studentAttachment1.CreationDate = DateTime.Now;
studentAttachment1.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment1);
db.SaveChanges();
}
if (Attachment2.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment2.FileName);
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment();
studentAttachment2.Name = LessonViewModel.AttachmentName2;
studentAttachment2.Path = fileName1;
studentAttachment2.CreationDate = DateTime.Now;
studentAttachment2.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment2);
db.SaveChanges();
}
if (Attachment3.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment3.FileName);
Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment();
studentAttachment3.Name = LessonViewModel.AttachmentName3;
studentAttachment3.Path = fileName1;
studentAttachment3.CreationDate = DateTime.Now;
studentAttachment3.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment3);
db.SaveChanges();
}
}
else
{
if (TotalAttachments == 1)
{
var FirstElement = studentAttachments1.ElementAt(0);
FirstElement.Name = LessonViewModel.AttachmentName1;
var FileName = FirstElement.Path;
if (Attachment1.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment1.FileName);
FileName = fileName1;
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
}
FirstElement.Path = FileName;
db1.SaveChanges();
if (Attachment2.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment2.FileName);
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment();
studentAttachment2.Name = LessonViewModel.AttachmentName2;
studentAttachment2.Path = fileName1;
studentAttachment2.CreationDate = DateTime.Now;
studentAttachment2.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment2);
db.SaveChanges();
}
if (Attachment3.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment3.FileName);
Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment();
studentAttachment3.Name = LessonViewModel.AttachmentName3;
studentAttachment3.Path = fileName1;
studentAttachment3.CreationDate = DateTime.Now;
studentAttachment3.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment3);
db.SaveChanges();
}
}
else if (TotalAttachments == 2)
{
var FirstElement = studentAttachments1.ElementAt(0);
FirstElement.Name = LessonViewModel.AttachmentName1;
var FileName0 = FirstElement.Path;
if (Attachment1.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment1.FileName);
FileName0 = fileName1;
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
}
FirstElement.Path = FileName0;
db1.SaveChanges();
var SecondElement = studentAttachments1.ElementAt(1);
SecondElement.Name = LessonViewModel.AttachmentName2;
var FileName1 = SecondElement.Path;
if (Attachment2.ContentLength > 0)
{
var fileName2 = Path.GetFileName(Attachment2.FileName);
FileName1 = fileName2;
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName2);
}
SecondElement.Path = FileName1;
db1.SaveChanges();
if (Attachment3.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment3.FileName);
Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment();
studentAttachment3.Name = LessonViewModel.AttachmentName3;
studentAttachment3.Path = fileName1;
studentAttachment3.CreationDate = DateTime.Now;
studentAttachment3.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment3);
db.SaveChanges();
}
}
else
{
var FirstElement = studentAttachments1.ElementAt(0);
FirstElement.Name = LessonViewModel.AttachmentName1;
var FileName0 = FirstElement.Path;
if (Attachment1.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment1.FileName);
FileName0 = fileName1;
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
}
FirstElement.Path = FileName0;
db1.SaveChanges();
var SecondElement = studentAttachments1.ElementAt(1);
SecondElement.Name = LessonViewModel.AttachmentName2;
var FileName1 = SecondElement.Path;
if (Attachment2.ContentLength > 0)
{
var fileName2 = Path.GetFileName(Attachment2.FileName);
FileName1 = fileName2;
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName2);
}
SecondElement.Path = FileName1;
db1.SaveChanges();
var ThirdElement = studentAttachments1.ElementAt(2);
ThirdElement.Name = LessonViewModel.AttachmentName3;
var FileName2 = ThirdElement.Path;
if (Attachment3.ContentLength > 0)
{
var fileName3 = Path.GetFileName(Attachment3.FileName);
FileName2 = fileName3;
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName3);
}
ThirdElement.Path = FileName2;
db1.SaveChanges();
}
}
if (LessonViewModel.LinkUrl1 != null)
{
AspnetStudentLink link1 = new AspnetStudentLink();
link1.URL = LessonViewModel.LinkUrl1;
link1.CreationDate = DateTime.Now;
link1.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link1);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl2 != null)
{
AspnetStudentLink link2 = new AspnetStudentLink();
link2.URL = LessonViewModel.LinkUrl2;
link2.CreationDate = DateTime.Now;
link2.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link2);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl3 != null)
{
AspnetStudentLink link3 = new AspnetStudentLink();
link3.URL = LessonViewModel.LinkUrl3;
link3.CreationDate = DateTime.Now;
link3.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link3);
db.SaveChanges();
}
return(RedirectToAction("ViewTopicsAndLessons", "AspnetSubjectTopics"));
}
}// Student Assignment Submission
public ActionResult SaveCommentHead(int LessonID, string Title, string Body)
{
var id = User.Identity.GetUserId();
AspnetComment_Head commentHead = new AspnetComment_Head();
string EncrID = LessonID + Title + Body + id;
commentHead.EncryptedID = Encrpt.Encrypt(EncrID, true);
var newString = Regex.Replace(commentHead.EncryptedID, @"[^0-9a-zA-Z]+", "s");
string str = newString.Substring(0, 32);
commentHead.EncryptedID = str;
//Comment_Head commentHead = new Comment_Head();
commentHead.Comment_Head = Title;
commentHead.CommentBody = Body;
commentHead.LessonId = LessonID;
commentHead.CreatedBy = id;
commentHead.CreationDate = GetLocalDateTime.GetLocalDateTimeFunction();
db.AspnetComment_Head.Add(commentHead);
db.SaveChanges();
var UserId = User.Identity.GetUserId();
var UserName = db.AspNetUsers.Where(x => x.Id == UserId).FirstOrDefault().Name;
var NotificationObj = new AspNetNotification();
NotificationObj.Description = UserName + " asked a Question";
NotificationObj.Subject = "Student Comment ";
NotificationObj.SenderID = UserId;
NotificationObj.Time = GetLocalDateTime.GetLocalDateTimeFunction();
NotificationObj.Url = "/TeacherCommentsOnCourses/CommentsPage1/" + commentHead.Id;
db.AspNetNotifications.Add(NotificationObj);
db.SaveChanges();
int?TopicId = db.AspnetLessons.Where(x => x.Id == LessonID).FirstOrDefault().TopicId;
int?SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId;
var AllTeachers = db.Teacher_GenericSubjects.Where(x => x.SubjectId == SubjectId).Select(x => x.TeacherId);
var UnionTeachers = AllTeachers.Distinct();
var AllEmployeesUserId = from employee in db.AspNetEmployees
where AllTeachers.Contains(employee.Id)
select new
{
employee.UserId,
};
SEA_DatabaseEntities db2 = new SEA_DatabaseEntities();
foreach (var receiver in AllEmployeesUserId)
{
var notificationRecieve = new AspNetNotification_User();
notificationRecieve.NotificationID = NotificationObj.Id;
notificationRecieve.UserID = Convert.ToString(receiver.UserId);
notificationRecieve.Seen = false;
db2.AspNetNotification_User.Add(notificationRecieve);
try
{
db2.SaveChanges();
}
catch (Exception ex)
{
var Msg = ex.Message;
}
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult CommentReply(int CommentHeadId, string UserComment)
{
var id = User.Identity.GetUserId();
int count = db.AspnetComments.Count();
AspnetComment commentobj = new AspnetComment();
if (count == 0)
{
commentobj.ParentCommentId = null;
commentobj.Comment = UserComment;
commentobj.CreationDate = GetLocalDateTime.GetLocalDateTimeFunction();
commentobj.HeadId = CommentHeadId;
commentobj.CreatedBy = id;
db.AspnetComments.Add(commentobj);
db.SaveChanges();
}
else
{
int LastId = db.AspnetComments.OrderByDescending(o => o.Id).FirstOrDefault().Id;
commentobj.ParentCommentId = LastId;
commentobj.Comment = UserComment;
commentobj.CreationDate = GetLocalDateTime.GetLocalDateTimeFunction();
commentobj.HeadId = CommentHeadId;
commentobj.CreatedBy = id;
db.AspnetComments.Add(commentobj);
db.SaveChanges();
}
var UserNameLog = User.Identity.Name;
AspNetUser currentUser = db.AspNetUsers.First(x => x.UserName == UserNameLog);
var UserId = User.Identity.GetUserId();
var UserName = db.AspNetUsers.Where(x => x.Id == UserId).FirstOrDefault().Name;
var NotificationObj = new AspNetNotification();
NotificationObj.Description = "Teacher " + UserName + " Replied";
NotificationObj.Subject = "Reply To Student Comment";
NotificationObj.SenderID = UserId;
NotificationObj.Time = GetLocalDateTime.GetLocalDateTimeFunction();
NotificationObj.Url = "/StudentCourses/CommentsPage1/" + CommentHeadId;
db.AspNetNotifications.Add(NotificationObj);
db.SaveChanges();
//int? LessonID = db.AspnetComment_Head.Where(x => x.Id == CommentHeadId).FirstOrDefault().LessonId;
//int? TopicId = db.AspnetLessons.Where(x => x.Id == LessonID).FirstOrDefault().TopicId;
//int? SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId;
//var AllStudents = db.Student_GenericSubjects.Where(x => x.GenericSubjectId == SubjectId).Select(x => x.StudentId);
//var DistinctStudents = AllStudents.Distinct();
//foreach (var receiver in DistinctStudents)
//{
var receiver = db.AspnetComment_Head.Where(x => x.Id == CommentHeadId).Select(x => x.CreatedBy).FirstOrDefault();
SEA_DatabaseEntities db2 = new SEA_DatabaseEntities();
var notificationRecieve = new AspNetNotification_User();
notificationRecieve.NotificationID = NotificationObj.Id;
notificationRecieve.UserID = Convert.ToString(receiver);
notificationRecieve.Seen = false;
db2.AspNetNotification_User.Add(notificationRecieve);
db2.SaveChanges();
// }
return(Json("", JsonRequestBehavior.AllowGet));
}
public async Task <String> Login(string UserName, string Password)
{
SEA_DatabaseEntities db = new SEA_DatabaseEntities();
LoginViewModel model = new LoginViewModel();
model.UserName = UserName;
model.Password = Password;
model.RememberMe = false;
var result = await SignInManager.PasswordSignInAsync(model.UserName, model.Password, model.RememberMe, shouldLockout : false);
LoginUser login = new LoginUser();
switch (result)
{
case SignInStatus.Success:
var userID = SignInManager.AuthenticationManager.AuthenticationResponseGrant.Identity.GetUserId();
var USER = db.AspNetUsers.Where(x => x.Id == userID).Select(x => x).FirstOrDefault();
login.Id = userID;
login.Name = USER.Name;
if (UserManager.IsInRole(userID, "Teacher"))
{
login.Role = "Teacher";
}
else if (UserManager.IsInRole(userID, "Student"))
{
login.Role = "Student";
}
else if (UserManager.IsInRole(userID, "Admin"))
{
login.Role = "Admin";
}
else if (UserManager.IsInRole(userID, "Principal"))
{
login.Role = "Principal";
}
else if (UserManager.IsInRole(userID, "Accountant"))
{
login.Role = "Accountant";
}
else if (UserManager.IsInRole(userID, "Parent"))
{
login.Role = "Parent";
}
if (USER.Status == "False")
{
login.Message = "Admin Has disabled your account";
}
else
{
login.Message = "Login Success";
}
var javaScriptSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string jsonString = javaScriptSerializer.Serialize(login);
return(jsonString);
case SignInStatus.Failure:
login.Message = "Invalid login attempt.";
var javaScriptSerializer1 = new System.Web.Script.Serialization.JavaScriptSerializer();
string jsonString1 = javaScriptSerializer1.Serialize(login);
return(jsonString1);
default:
login.Message = "Invalid login attempt.";
var javaScriptSerializer2 = new System.Web.Script.Serialization.JavaScriptSerializer();
string jsonString2 = javaScriptSerializer2.Serialize(login);
return(jsonString2);
}
}
