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);
}
