public static List <ForumEntries> GetForumEntries(int forumid)
{
using (VitaminEntities context = new VitaminEntities())
{
return(context.ForumEntries.Include("User").Where(x => x.ForumId == forumid).ToList());
}
}
public static List <User> GetUsersInDomain(Guid userid)
{
using (VitaminEntities context = new VitaminEntities())
{
var user = context.User.SingleOrDefault(x => x.UserID == userid);
if (user.EmployeeID != null)
{
return(context.User.Include("Employee.Company").Where(x => x.EmployeeID != null).ToList());
}
else if (user.StudentID != null)
{
var list = context.User.Include("Student").Where(x => x.StudentID != null).ToList();
return(list);
}
else if (user.TeacherId != null)
{
var list = context.User.Include("Student").Where(x => x.StudentID != null).ToList();
return(list);
}
else
{
var emp = context.User.Include("Employee.Company").Where(x => x.EmployeeID != null).ToList();
return(emp);
}
}
}
public static List <Schedule> GetSchedule(Guid userid)
{
using (VitaminEntities context = new VitaminEntities())
{
return(context.Schedule.Where(x => x.UserId == userid).ToList());
}
}
public static List <Resource> GetResources(Guid userid)
{
using (VitaminEntities context = new VitaminEntities())
{
var user = context.User.SingleOrDefault(x => x.UserID == userid);
if (user.EmployeeID != null)
{
var cid = context.Employee.Include("Company").SingleOrDefault(x => x.EmployeeId == user.EmployeeID);
return(context.Resource.Where(x => x.CompanyId == cid.CompanyId).ToList());
}
else if (user.StudentID != null)
{
var courses = context.Transcript.Include("Course").Where(x => x.StudentID == user.StudentID).ToList();
List <Resource> resource = new List <Resource>();
foreach (var course in courses)
{
var item = context.Resource.Where(x => x.CourseId == course.cid).ToList();
foreach (var element in item)
{
resource.Add(element);
}
}
return(resource);
}
return(null);
}
}
public static List <Message> GetOutgoingMessages(Guid userid)
{
using (VitaminEntities context = new VitaminEntities())
{
return(context.Message.Where(x => x.senderid == userid).OrderBy(x => x.CreateDate).ToList());
}
}
public static List <Vacation> GetVacationDays(Guid uid)
{
using (VitaminEntities context = new VitaminEntities())
{
return(context.Vacation.Where(x => x.UserId == uid).ToList());
}
}
public static void AddForumTopic(Forum forum)
{
using (VitaminEntities context = new VitaminEntities())
{
context.Forum.Add(forum);
context.SaveChanges();
}
}
public static void AddForumEntry(ForumEntries forumentry)
{
using (VitaminEntities context = new VitaminEntities())
{
context.ForumEntries.Add(forumentry);
context.SaveChanges();
}
}
public static void AddCourse(Course course)
{
using (VitaminEntities context = new VitaminEntities())
{
context.Course.Add(course);
context.SaveChanges();
}
}
public static Student GetStudentSchedule(Guid?StudentId)
{
using (VitaminEntities context = new VitaminEntities())
{
var transcript = context.Student.Include("Schedule").SingleOrDefault(x => x.StudentId == StudentId);
return(transcript);
}
}
public static Student GetStudentInfo(Guid?StudentId)
{
using (VitaminEntities context = new VitaminEntities())
{
var stu = context.Student.Include("User").SingleOrDefault(x => x.StudentId == StudentId);
return(stu);
}
}
public static bool AddUser(User User)
{
using (VitaminEntities context = new VitaminEntities())
{
context.User.Add(User);
context.SaveChanges();
return(true);
}
}
public static User Login(string username, string password)
{
using (VitaminEntities context = new VitaminEntities())
{
var user = context.User.SingleOrDefault(x => x.Username == username & x.Password == password);
return(user);
}
}
public static bool AddSchedule(Schedule v)
{
using (VitaminEntities context = new VitaminEntities())
{
context.Schedule.Add(v);
context.SaveChanges();
return(true);
}
}
public static bool AddVacationDay(Vacation v)
{
using (VitaminEntities context = new VitaminEntities())
{
context.Vacation.Add(v);
context.SaveChanges();
return(true);
}
}
public static Employee GetEmployeeSchedule(Guid?EmployeeId)
{
using (VitaminEntities context = new VitaminEntities())
{
if (EmployeeId != null)
{
var emp = context.Employee.Include("Schedule").SingleOrDefault(x => x.EmployeeId == EmployeeId);
return(emp);
}
return(null);
}
}
public static Employee GetEmployeeInformation(Guid?EmployeeId)
{
using (VitaminEntities context = new VitaminEntities())
{
if (EmployeeId != null)
{
var emp = context.Employee.Include("User").Include("Insurence").SingleOrDefault(x => x.EmployeeId == EmployeeId);
return(emp);
}
return(null);
}
}
public static List <Employee> GetAllEmployees()
{
using (VitaminEntities context = new VitaminEntities())
{
var emp = context.Employee.Include("User").Include("Insurence").ToList();
if (emp != null)
{
return(emp);
}
return(null);
}
}
public static Student GetStudentCourses(Guid?StudentId)
{
using (VitaminEntities context = new VitaminEntities())
{
var transcript = context.Student.Include("Transcript.Course").SingleOrDefault(x => x.StudentId == StudentId);
if (transcript != null)
{
transcript.Transcript = transcript.Transcript.Where(x => x.Semester == "Fall").ToList();
}
return(transcript);
}
}
public static Teacher GetCourses(Guid?TeacherId)
{
using (VitaminEntities context = new VitaminEntities())
{
if (TeacherId != null)
{
var teacher = context.Teacher.Include("Course").SingleOrDefault(x => x.TeacherId == TeacherId);
return(teacher);
}
return(null);
}
}
public static Teacher GetStudents(Guid?TeacherId)
{
using (VitaminEntities context = new VitaminEntities())
{
if (TeacherId != null)
{
var stu = context.Teacher.Include("Course.Transcript.Student.User").SingleOrDefault(x => x.TeacherId == TeacherId);
//var stu = context.Student.Include("Teacher").Include("User").Include("Transcript.Course").(x => x.Transcript.SingleOrDefault(x=> x.Course.Teacher.TeacherId == TeacherId)).ToList();
return(stu);
}
return(null);
}
}
public static Manager GetCompany(Guid ManagerId)
{
using (VitaminEntities context = new VitaminEntities())
{
if (ManagerId != null)
{
var comp = context.Manager.Include("Company").SingleOrDefault(x => x.ManagerId == ManagerId);
if (comp != null)
{
return(comp);
}
}
return(null);
}
}
public static bool SendMessage(Message msj)
{
using (VitaminEntities context = new VitaminEntities())
{
try
{
context.Message.Add(msj);
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public static User GetUserInfo(Guid usrid)
{
using (VitaminEntities context = new VitaminEntities())
{
var user = context.User.SingleOrDefault(x => x.UserID == usrid);
if (user.EmployeeID != null)
{
var emp = context.Employee.Include("Insurence").SingleOrDefault(x => x.EmployeeId == user.EmployeeID);
user.Employee = emp;
}
else if (user.StudentID != null)
{
var student = context.Student.SingleOrDefault(x => x.StudentId == user.StudentID);
user.Student = student;
}
return(user);
}
}
public static List <Forum> GetForums(Guid userid)
{
using (VitaminEntities context = new VitaminEntities())
{
var user = context.User.SingleOrDefault(x => x.UserID == userid);
if (user.EmployeeID != null)
{
var cid = context.Employee.Include("Company").SingleOrDefault(x => x.EmployeeId == user.EmployeeID);
return(context.Forum.Where(x => x.CompanyId == cid.CompanyId).ToList());
}
else if (user.StudentID != null)
{
var courses = context.Transcript.Include("Course").Where(x => x.StudentID == user.StudentID).ToList();
List <Forum> forum = new List <Forum>();
foreach (var course in courses)
{
forum.Add(context.Forum.SingleOrDefault(x => x.CourseId == course.Course.cid));
}
return(forum);
}
return(null);
}
}
