public IActionResult Post([FromBody] UserRegistrationViewModel users) { //users.InstituteId = 1; // DBMContext db = new DBMContext(); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); if (users.EmailAlreadyExists(users.Email, users.Designation)) { ModelState.AddModelError("EmailAddress", "This email already exists for this designation."); return(BadRequest(ModelState)); } Users u = new Users(); u.FirstName = users.FirstName; u.LastName = users.LastName; u.RegNo = users.RegistrationNumber; u.Cnic = users.Cnic; u.Email = users.Email; u.Password = users.Password; u.DateOfBirth = users.DateOfBirth; u.Designation = users.Designation; u.LoginStatus = 0; u.ActiveStatue = 1; u.InstituteId = db.Institute.Where(p => p.Name.Equals(users.InstituteName)).FirstOrDefault().Id; db.Users.Add(u); //db.Users.Add(users); db.SaveChanges(); return(Ok()); }
public IEnumerable <AssignmentsViewModel> Get(int CourseId) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); List <AssignmentsViewModel> lst = new List <AssignmentsViewModel>(); foreach (Assignments s in db.Assignments) { if (s.CourseId == CourseId) { AssignmentsViewModel a = new AssignmentsViewModel(); a.Id = s.Id; a.Title = s.Title; a.CreatedBy = db.Users.Where(b => b.Id == s.CreatedBy).FirstOrDefault().FirstName + " " + db.Users.Where(b => b.Id == s.CreatedBy).FirstOrDefault().LastName; a.UpdatedBy = db.Users.Where(b => b.Id == s.UpdatedBy).FirstOrDefault().FirstName + " " + db.Users.Where(b => b.Id == s.UpdatedBy).FirstOrDefault().LastName; var d = s.SubmissionDateTime.ToString("yyyy-M-dd hh:mm"); //DateTime d1 = new DateTime(d); a.SubmissionDate = s.SubmissionDateTime; a.FilePath = s.FilePath; a.StartDateTime = s.StartDateTime; a.PostSubmissionDateTime = s.PostSubmissionDateTime; a.Status = s.Status; lst.Add(a); } } return(lst.ToList()); //return new string[] { "value1", "value2" }; }
public IActionResult AssignedCoursesToTeacher([FromBody] CourseViewModel course) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); TeachersAssignedCourses t = new TeachersAssignedCourses(); bool k = false; t.CourseId = db.Courses.Where(b => b.Name == course.name).FirstOrDefault().Id; t.UserId = db.Users.Where(b => b.Email == course.email).FirstOrDefault().Id; foreach (TeachersAssignedCourses t1 in db.TeachersAssignedCourses) { if (t1.CourseId == t.CourseId && t1.UserId == t.UserId) { k = true; break; } } //Nullable<int> k = db.TeachersAssignedCourses.Where(p => p.UserId == t.UserId).FirstOrDefault().CourseId; if (k == false) { db.Add(t); db.SaveChanges(); return(Ok()); } else { ModelState.AddModelError("", "Course already assigned to this teacher"); return(BadRequest(ModelState)); } }
public IActionResult Post([FromBody] AssignmentsViewModel val, int CourseId) { string tempFilePath = val.FilePath; val.FilePath = "Resources/Images/"; val.FilePath = val.FilePath + tempFilePath; DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); Assignments ass = new Assignments(); ass.Title = val.Title; ass.FilePath = val.FilePath; ass.SubmissionDateTime = val.SubmissionDate; ass.StartDateTime = val.StartDateTime; ass.Status = "Available"; ass.PostSubmissionDateTime = val.SubmissionDate; ass.CreatedBy = db.Users.Where(u => u.Email.Equals(val.Email)).FirstOrDefault().Id; ass.UpdatedBy = db.Users.Where(u => u.Email.Equals(val.Email)).FirstOrDefault().Id;; ass.CreatedOn = DateTime.Now; ass.UpdatedOn = DateTime.Now; ass.CourseId = db.Courses.Where(c => c.Id == CourseId).FirstOrDefault().Id; db.Assignments.Add(ass); db.SaveChanges(); return(Ok()); }
public string Get(string CourseName) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); string name = db.Courses.Where(b => b.Name == CourseName).FirstOrDefault().CourseCode; return("(" + name + ")" + CourseName); }
public IEnumerable <CourseViewModel> Get(int id) { //DBMContext db = new DBMContext(); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); List <CourseViewModel> courseLst = new List <CourseViewModel>(); if (db.Users.Where(b => b.Id == id).FirstOrDefault().Designation == "Admin") { foreach (Courses c in db.Courses) { foreach (CourseInfo i in db.CourseInfo) { if (i.Courseid == c.Id && c.ParentCourseid == null && c.InstituteId == db.Users.Where(b => b.Id == id).FirstOrDefault().InstituteId) { CourseViewModel v = new CourseViewModel(); v.id = c.Id; v.courseSemester = i.CourseSemester; v.courseSession = i.CourseYear.ToString(); string frstName = db.Users.Where(b => b.Id == i.CreatedBy).FirstOrDefault().FirstName; string lastName = db.Users.Where(b => b.Id == i.CreatedBy).FirstOrDefault().LastName; v.CreatedBy = frstName + " " + lastName; string UpdatedFirst = db.Users.Where(b => b.Id == i.UpdatedBy).FirstOrDefault().FirstName; string UpdatedLast = db.Users.Where(b => b.Id == i.UpdatedBy).FirstOrDefault().LastName; v.UpdatedBy = UpdatedFirst + " " + UpdatedLast; v.name = c.Name; v.courseCode = c.CourseCode; courseLst.Add(v); break; } } } } return(courseLst.ToList()); }
public IEnumerable <UserGroups> GetGroups(string email) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); int id = db.Users.Where(b => b.Email == email).SingleOrDefault().InstituteId; return(db.UserGroups.Where(b => b.InstituteId == id).ToList()); }
public IActionResult Put(int id, [FromBody] CourseViewModel course) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); //DBMContext db = new DBMContext(); int?courseId = db.CourseInfo.Where(b => b.Courseid == id).FirstOrDefault().Courseid; if (db.Courses.Any(b => b.Name == course.name && b.CourseCode == course.courseCode)) { int year = db.CourseInfo.Where(b => b.Courseid == db.Courses.Where(r => r.Name == course.name).FirstOrDefault().Id).FirstOrDefault().CourseYear; if (year == Int32.Parse(course.courseSession)) { ModelState.AddModelError("", "Course already exists"); return(BadRequest(ModelState)); } } db.Courses.Where(b => b.Id == courseId).SingleOrDefault().CourseCode = course.courseCode; db.Courses.Where(b => b.Id == courseId).SingleOrDefault().Name = course.name; db.CourseInfo.Where(b => b.Courseid == courseId).SingleOrDefault().UpdatedOn = DateTime.Now; // db.CourseInfo.Where(b => b.Id == id).SingleOrDefault().UpdatedBy = db.Users.Where(b => b.Email == GetCurrentUserAsync().ToString()).FirstOrDefault().Id db.CourseInfo.Where(b => b.Courseid == courseId).SingleOrDefault().UpdatedBy = db.Users.Where(a => a.Email == course.email).FirstOrDefault().Id; db.CourseInfo.Where(b => b.Courseid == courseId).SingleOrDefault().CourseSemester = course.courseSemester; db.CourseInfo.Where(b => b.Courseid == courseId).SingleOrDefault().CourseYear = Int32.Parse(course.courseSession); db.SaveChanges(); return(Ok()); }
public IEnumerable <AnnouncementViewModel> Get(int CourseId) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); List <AnnouncementViewModel> lst = new List <AnnouncementViewModel>(); if (db.Announcement.Any(a => a.CourseId == CourseId)) { foreach (Announcement a in db.Announcement) { AnnouncementViewModel obj = new AnnouncementViewModel(); if (a.CourseId == CourseId) { obj.Title = a.Title; string day = a.CreatedOn.DayOfWeek.ToString(); string date = a.CreatedOn.Day.ToString(); string year = a.CreatedOn.Year.ToString(); obj.postedDate = day + ' ' + date + ',' + year; obj.Description = a.Description; lst.Add(obj); } } } return(lst); }
public IActionResult Put(int id, [FromBody] AssignmentsViewModel val) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); if (db.Assignments.Any(b => b.Title == val.Title && b.FilePath == val.FilePath)) { ModelState.AddModelError("UniqueAssignment", "This assignment already exists"); return(BadRequest(ModelState)); } //else if (val.SubmissionDateTime < DateTime.Now) //{ // ModelState.AddModelError("", "Enter valid Submission Date"); // return BadRequest(ModelState); //} else if (val.StartDateTime < DateTime.Now) { ModelState.AddModelError("", "Enter valid Submission Date"); return(BadRequest(ModelState)); } db.Assignments.Where(b => b.Id == id).FirstOrDefault().Title = val.Title; db.Assignments.Where(b => b.Id == id).FirstOrDefault().FilePath = val.FilePath; db.Assignments.Where(b => b.Id == id).FirstOrDefault().PostSubmissionDateTime = val.PostSubmissionDateTime; //db.Assignments.Where(b => b.Id == id).FirstOrDefault().SubmissionDateTime = val.SubmissionDateTime; db.Assignments.Where(b => b.Id == id).FirstOrDefault().UpdatedOn = DateTime.Now; db.Assignments.Where(b => b.Id == id).FirstOrDefault().UpdatedBy = 1; // cd.UpdatedBy = db.Users.Where(b => b.Email == GetCurrentUserAsync().ToString()).FirstOrDefault().Id; db.SaveChanges(); return(Ok()); }
public Object GetNotesFileName(int Id) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); string filePath = db.Notes.Where(a1 => a1.Id == Id).FirstOrDefault().FilePath; string[] temp = filePath.Split('/'); int temp1 = temp.Count(); string fileName = temp[temp.Count() - 1]; return(new { fileName }); }
public IActionResult Post([FromBody] CourseViewModel course) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); CourseEnrollment c = new CourseEnrollment(); c.CourseId = db.Courses.Where(b => b.CourseCode == course.courseCode).FirstOrDefault().Id; c.UserId = course.UserId; c.EnrollmentStatus = "Pending"; db.Add(c); db.SaveChanges(); return(Ok()); }
public IEnumerable <Institute> get() { List <Institute> institutes = new List <Institute>(); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); //DBMContext db = new DBMContext(); foreach (Institute i in db.Institute) { institutes.Add(i); } return(institutes); }
public IActionResult ApproveTeacher(string id) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); var user = db.Users.Where(b => b.Id == Convert.ToInt32(id)).SingleOrDefault(); string Name = user.FirstName + " " + user.LastName; string Email = user.Email; string Body = "Your request has been approved"; if (SendEmail(Name, Email, Body)) { user.LoginStatus = 1; } db.SaveChanges(); return(Ok()); }
public IActionResult DeleteTeacher(int id) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); var user = db.Users.Where(b => b.Id == id).SingleOrDefault(); string Name = user.FirstName + " " + user.LastName; string Email = user.Email; string message = "Your request has been disapproved"; db.Users.Remove(user); if (SendEmail(Name, Email, message)) { db.SaveChanges(); } return(Ok()); }
public IActionResult ApproveRequest(string id) { //string email = " "; DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); var user = db.Users.Where(a => a.Id == Convert.ToInt32(id)).FirstOrDefault(); var crs = db.CourseEnrollment.Where(b => b.UserId == (user.Id)).SingleOrDefault(); string Message = "Your request for course enrollment is approved"; if (SendEmail(user.FirstName + " " + user.LastName, user.Email, Message)) { crs.EnrollmentStatus = "Approved"; db.SaveChanges(); } return(Ok()); }
public bool EmailAlreadyExists(string email, string designation) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); //DBMContext db = new DBMContext(); Users u = db.Users.Where(u1 => (u1.Email == email && u1.Designation == designation)).FirstOrDefault(); if (u != null) { return(true); } else { return(false); } }
public IActionResult Post([FromBody] AnnouncementViewModel obj) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); Announcement a = new Announcement(); a.CreatedBy = db.Users.Where(b => b.Email == obj.Email).FirstOrDefault().Id; a.UpdatedBy = db.Users.Where(b => b.Email == obj.Email).FirstOrDefault().Id; a.CreatedOn = DateTime.Now; a.UpdatedOn = DateTime.Now; a.Title = obj.Title; a.Description = obj.Description; a.CourseId = db.Courses.Where(b => b.Name == obj.CourseName).FirstOrDefault().Id; db.Announcement.Add(a); db.SaveChanges(); return(Ok()); }
public List <UserRegistrationViewModel> GetUserRoleDetails(int?id) { List <UserRegistrationViewModel> lst = new List <UserRegistrationViewModel>(); if (id != 0) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); string designantion = db.Users.Where(u => u.Id == id).FirstOrDefault().Designation; //user.Id = Convert.ToString(tempId); UserRegistrationViewModel u1 = new UserRegistrationViewModel(); u1.Designation = designantion; lst.Add(u1); } return(lst); }
public IActionResult Delete(int id) { //DBMContext db = new DBMContext(); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); if (!db.Institute.Any(b => b.Id == id)) { ModelState.AddModelError("", "Institute at this id doesn't exist"); return(BadRequest(ModelState)); } Institute i = db.Institute.Single(b => b.Id == id); db.Institute.Remove(i); db.SaveChanges(); return(Ok()); }
public IActionResult Post([FromBody] InstitutesViewModel institute) { //DBMContext db = new DBMContext(); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); Institute i = new Institute(); if (db.Institute.Any(b => b.Name == institute.InstituteName)) { ModelState.AddModelError("UniqueInstituteName", "This Institute already exists"); return(BadRequest(ModelState)); } i.Name = institute.InstituteName; db.Institute.Add(i); db.SaveChanges(); return(Ok()); }
public List <CourseViewModel> getAllTeachers() { List <CourseViewModel> t = new List <CourseViewModel>(); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); foreach (Users u in db.Users) { if (u.Designation == "Teacher") { CourseViewModel c = new CourseViewModel(); c.email = u.Email; t.Add(c); } } return(t); }
public IActionResult UploadLectureVideo([FromBody] LectureViewModel obj) { string tempFilePath = obj.FilePath; obj.FilePath = "Resources/Videos/"; obj.FilePath = obj.FilePath + tempFilePath; DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); Video v = new Video(); v.CourseId = obj.courseId; v.Titel = obj.Name; v.Lectureid = obj.LectureId; v.VideoFilePath = obj.FilePath; db.Add(v); db.SaveChanges(); return(Ok()); }
public IEnumerable <PermissionLookup> Get() { try { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); List <PermissionLookup> lst = new List <PermissionLookup>(); foreach (PermissionLookup p in db.PermissionLookup) { lst.Add(p); } return(lst); } catch (Exception e) { throw (e); } }
public async Task <Object> GetUSerProfile() { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); string userId = User.Claims.First(c => c.Type == "UserID").Value; var user = await _userManager.FindByIdAsync(userId); int tempId = db.Users.Where(u => u.Email == user.Email).FirstOrDefault().Id; //user.Id = Convert.ToString(tempId); return(new { tempId, user.FullName, user.Email, user.UserName }); }
public IActionResult Put(int id, [FromBody] InstitutesViewModel institutes) { //DBMContext db = new DBMContext(); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); foreach (Institute i in db.Institute) { if (i.Name == institutes.InstituteName && i.Id != id) { ModelState.AddModelError("UniqueInstituteName", "This Institute already exists"); return(BadRequest(ModelState)); } } db.Institute.Where(b => b.Id == id).FirstOrDefault().Name = institutes.InstituteName; db.SaveChanges(); return(Ok()); }
public IActionResult Post([FromBody] LectureViewModel obj) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); Lectures l = new Lectures(); if (!db.Courses.Any(b => b.Id == obj.courseId)) { ModelState.AddModelError("", "Course with course id doesn't exist"); return(BadRequest(ModelState)); } l.CourseId = obj.courseId; l.Name = obj.Name; db.Add(l); db.SaveChanges(); return(Ok()); }
public IEnumerable <LectureViewModel> getLectureNotes(int lectureId) { DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); List <LectureViewModel> list = new List <LectureViewModel>(); foreach (Notes v in db.Notes) { if (v.Lectureid == lectureId) { LectureViewModel lc = new LectureViewModel(); lc.Name = v.Title; lc.Id = v.Id; lc.FilePath = v.FilePath; list.Add(lc); } } return(list); }
public async Task <Object> Post(UserModel model) { model.UserName = model.Email; model.FullName = model.FirstName + model.LastName; var applicationUser = new ApplicationUser() { UserName = model.UserName, Email = model.Email, FullName = model.FullName, }; var result = await _userManager.CreateAsync(applicationUser, model.Password); await _userManager.AddToRoleAsync(applicationUser, model.Designation); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); // DBMContext db = new DBMContext(); UserRegistrationViewModel users = new UserRegistrationViewModel(); if (users.EmailAlreadyExists(model.Email, model.Designation)) { ModelState.AddModelError("EmailAddress", "This email already exists for this designation."); return(BadRequest(ModelState)); } Users u = new Users(); u.FirstName = model.FirstName; u.LastName = model.LastName; u.RegNo = model.RegistrationNumber; u.Cnic = model.Cnic; u.Email = model.Email; u.Password = model.Password; u.DateOfBirth = model.DateOfBirth; u.Designation = model.Designation; u.LoginStatus = 0; u.ActiveStatue = 1; u.InstituteId = db.Institute.Where(p => p.Name.Equals(model.InstituteName)).FirstOrDefault().Id; db.Users.Add(u); //db.Users.Add(users); db.SaveChanges(); return(Ok(result)); }
public List <InstitutesViewModel> Get() { //List<Institute> institutes = new List<Institute>(); //DBMContext db = new DBMContext(); //institutes = db.Institute.ToList(); //return institutes; //DBMContext db = new DBMContext(); DigitalBoardMarkerContext db = new DigitalBoardMarkerContext(); List <InstitutesViewModel> lstInstitutes = new List <InstitutesViewModel>(); foreach (Institute i in db.Institute) { InstitutesViewModel ins = new InstitutesViewModel(); ins.Id = i.Id; ins.InstituteName = i.Name; lstInstitutes.Add(ins); } return(lstInstitutes); }