public static EmployeeSubjectDTO Convert(this EmployeeSubject employeesubject) { return(new EmployeeSubjectDTO { ItemId = employeesubject.ItemId, IsDeleted = employeesubject.IsDeleted, Updated = employeesubject.Updated, CorrectorId = employeesubject.CorrectorId, Name = employeesubject.ShortName, FullName = employeesubject.FullName, LicenceTypeId = employeesubject.LicenceTypeId }); }
private void UpdateEmployeeSubjects(AppDbContext context, UpdateEmployeeRequestModel request, Employee employee) { List <EmployeeSubject> employeeSubjectList = new List <EmployeeSubject>(); foreach (Subject subject in request.LearnedSubjects) { EmployeeSubject employeeSubject = new EmployeeSubject() { Employee = employee, EmployeeId = employee.Id, Subject = subject, SubjectId = subject.Id }; employeeSubjectList.Add(employeeSubject); } employee.LearnedSubjects = employeeSubjectList; }
public async Task AddSubjectToEmployee(Guid EmployeeId, Guid SubjectId) { var es = new EmployeeSubject { EmployeeId = EmployeeId, SubjectId = SubjectId }; await _context.EmployeeSubjects.AddAsync(es); var goalToDelete = await _context.Goals .FirstOrDefaultAsync(x => x.EmployeeId == EmployeeId && x.SubjectId == SubjectId); if (goalToDelete != null) { _context.Goals.Remove(goalToDelete); } await _context.SaveChangesAsync(); }
public static void Initialize(TekDeskContext context) { context.Database.EnsureCreated(); // Look for any employees if (context.Employees.Any()) { return; // DB has been seeded } var employees = new Employee[] { new Employee { ID = 1000, FName = "KING", LName = "FIRST" }, new Employee { ID = 1001, FName = "BLAKE", LName = "LAST" }, new Employee { ID = 1002, FName = "Carson", LName = "Alexander" }, new Employee { ID = 1003, FName = "Meredith", LName = "Alonso" }, new Employee { ID = 1004, FName = "Arturo", LName = "Anand" }, new Employee { ID = 1005, FName = "Gytis", LName = "Barzdukas" }, new Employee { ID = 1006, FName = "Yan", LName = "Li" }, new Employee { ID = 1007, FName = "Peggy", LName = "Justice" }, new Employee { ID = 1008, FName = "Laura", LName = "Norman" }, new Employee { ID = 1009, FName = "Nino", LName = "Olivetto" }, }; foreach (Employee e in employees) { context.Employees.Add(e); } context.SaveChanges(); var queries = new Query[] { new Query { Description = "Network Device not connecting", EmployeeID = 1003, QState = States.pending, Tag = Expertise.Network, Added = DateTime.Now }, new Query { Description = "OS showing not activated", EmployeeID = 1005, QState = States.pending, Tag = Expertise.Software, Added = DateTime.Now }, new Query { Description = "MS office Not Installing", EmployeeID = 1004, QState = States.pending, Tag = Expertise.Software, Added = DateTime.Now }, new Query { Description = "Server crashed", EmployeeID = 1002, QState = States.pending, Tag = Expertise.Network, Added = DateTime.Now }, new Query { Description = "Keyborad not functioning correctly", EmployeeID = 1002, QState = States.pending, Tag = Expertise.Hardware, Added = DateTime.Now }, }; foreach (Query q in queries) { context.Queries.Add(q); } context.SaveChanges(); var subjects = new Subject[] { new Subject { ID = 2, Name = Expertise.Network }, new Subject { ID = 1, Name = Expertise.Software }, new Subject { ID = 0, Name = Expertise.Hardware } }; foreach (Subject s in subjects) { context.Subjects.Add(s); } context.SaveChanges(); var solutions = new Solution[] { new Solution { Description = "Check the network cables", EmployeeID = 1000, QueryID = 1 }, new Solution { Description = "Renew the Activation", EmployeeID = 1002, QueryID = 2 }, new Solution { Description = "Check System Requirements", EmployeeID = 1003, QueryID = 3 }, new Solution { Description = "Contact data recovery", EmployeeID = 1001, QueryID = 4 }, new Solution { Description = "Buy a new one", EmployeeID = 1005, QueryID = 5 } }; foreach (Solution s in solutions) { context.Solutions.Add(s); } context.SaveChanges(); var employeeSubjects = new EmployeeSubject[] { new EmployeeSubject { EmployeeID = 1000, SubjectID = 0 }, new EmployeeSubject { EmployeeID = 1001, SubjectID = 0 }, new EmployeeSubject { EmployeeID = 1002, SubjectID = 1 }, new EmployeeSubject { EmployeeID = 1003, SubjectID = 1 }, new EmployeeSubject { EmployeeID = 1004, SubjectID = 2 }, new EmployeeSubject { EmployeeID = 1005, SubjectID = 2 }, new EmployeeSubject { EmployeeID = 1006, SubjectID = 0 }, new EmployeeSubject { EmployeeID = 1007, SubjectID = 0 }, new EmployeeSubject { EmployeeID = 1008, SubjectID = 1 }, new EmployeeSubject { EmployeeID = 1009, SubjectID = 2 }, }; foreach (EmployeeSubject es in employeeSubjects) { context.EmployeeSubjects.Add(es); } context.SaveChanges(); var employeeNotifications = new EmployeeNotification[] { new EmployeeNotification { EmployeeID = 1004, Notification = "Network Device not connecting", QueryID = 1 }, new EmployeeNotification { EmployeeID = 1005, Notification = "Network Device not connecting", QueryID = 1 }, new EmployeeNotification { EmployeeID = 1009, Notification = "Network Device not connecting", QueryID = 1 }, new EmployeeNotification { EmployeeID = 1002, Notification = "OS showing not activated", QueryID = 2 }, new EmployeeNotification { EmployeeID = 1003, Notification = "OS showing not activated", QueryID = 2 }, new EmployeeNotification { EmployeeID = 1008, Notification = "OS showing not activated", QueryID = 2 }, new EmployeeNotification { EmployeeID = 1002, Notification = "MS office Not Installing", QueryID = 3 }, new EmployeeNotification { EmployeeID = 1003, Notification = "MS office Not Installing", QueryID = 3 }, new EmployeeNotification { EmployeeID = 1008, Notification = "MS office Not Installing", QueryID = 3 }, new EmployeeNotification { EmployeeID = 1004, Notification = "Server crashed", QueryID = 4 }, new EmployeeNotification { EmployeeID = 1005, Notification = "Server crashed", QueryID = 4 }, new EmployeeNotification { EmployeeID = 1009, Notification = "Server crashed", QueryID = 4 }, new EmployeeNotification { EmployeeID = 1000, Notification = "Keyborad not functioning correctly", QueryID = 5 }, new EmployeeNotification { EmployeeID = 1001, Notification = "Keyborad not functioning correctly", QueryID = 5 }, new EmployeeNotification { EmployeeID = 1006, Notification = "Keyborad not functioning correctly", QueryID = 5 }, new EmployeeNotification { EmployeeID = 1007, Notification = "Keyborad not functioning correctly", QueryID = 5 }, }; foreach (EmployeeNotification ef in employeeNotifications) { context.EmployeeNotifications.Add(ef); } context.SaveChanges(); }
public static void Initialize(AppDbContext context) { context.Database.EnsureCreated(); if (context.Users.Any() && context.Subjects.Any()) { return; // DB has been seeded } var emp1 = new Employee { Id = Guid.Parse("b96f7695-c9d9-4b5c-849e-4219083d6220"), FirstName = "Mantas", LastName = "Bagdonas", Email = "*****@*****.**" }; var emp2 = new Employee { Id = Guid.Parse("1c8c9ce0-2251-4ef3-ab0b-cfc7dd7a2949"), FirstName = "Evaldas", LastName = "Jonaitis", Email = "*****@*****.**", BossId = emp1.Id }; var emp3 = new Employee { Id = Guid.Parse("5a677c6e-56e5-4cf1-9c64-157b483e8eff"), BossId = emp2.Id, FirstName = "Justinas", LastName = "Kondroska", Email = "*****@*****.**", }; var emp4 = new Employee { Id = Guid.Parse("61f06ab5-1d19-40b3-90fa-bcd6ba20304b"), BossId = emp2.Id, FirstName = "Kostas", LastName = "Tostas", Email = "*****@*****.**" }; var emp5 = new Employee { Id = Guid.Parse("cd915686-9476-4dc9-af2f-1f4e8d6f744b"), BossId = emp4.Id, FirstName = "Arturas", LastName = "Honduras", Email = "*****@*****.**" }; var employees = new Employee[] { emp1, emp2, emp3, emp4, emp5, new Employee { Id = Guid.Parse("63f4e537-cb7b-4fe0-beca-cc080e42552d"), FirstName = "Spotify", LastName = "Premium", Email = "*****@*****.**", BossId = emp3.Id }, new Employee { Id = Guid.Parse("69ca4eef-df2a-4d04-87eb-c0e2f31c0708"), FirstName = "Petras", LastName = "Gardziulas", Email = "*****@*****.**", BossId = emp3.Id }, new Employee { Id = Guid.Parse("ca595500-ac9b-4d55-a887-7ec28bad3983"), FirstName = "Algis", LastName = "Greitullas", Email = "*****@*****.**", BossId = emp3.Id }, new Employee { Id = Guid.Parse("4cce91af-6898-4b09-9d8d-043bbdc4e654"), FirstName = "Nartumanas", LastName = "Karbovskis", Email = "*****@*****.**", BossId = emp3.Id }, new Employee { Id = Guid.Parse("c85d09e8-8658-456c-8595-502076661f41"), FirstName = "Martensas", LastName = "Gilberto", Email = "*****@*****.**", BossId = emp3.Id }, new Employee { Id = Guid.Parse("e214ea22-5d39-4cea-bf71-3749806e7bdd"), FirstName = "Zemaiciu", LastName = "Blynai", Email = "*****@*****.**", BossId = emp3.Id } }; /*context.Users.AddRange(employees); * context.SaveChanges();*/ var parentSubject = new Subject("Programming", null, "description description text"); var childOne = new Subject("Object oriented programming", parentSubject.Id, "description description text"); var childTwo = new Subject("Functional programming", parentSubject.Id, "description description text"); var subjects = new Subject[] { parentSubject, childOne, childTwo, new Subject("Java language", childOne.Id, "description description text"), new Subject("C language", childTwo.Id, "description description text") }; context.Subjects.AddRange(subjects); context.SaveChanges(); var employeeSubjects = new EmployeeSubject[] { new EmployeeSubject { EmployeeId = emp1.Id, Employee = emp1, SubjectId = parentSubject.Id, Subject = parentSubject }, new EmployeeSubject { EmployeeId = emp1.Id, Employee = emp1, SubjectId = childOne.Id, Subject = childOne }, new EmployeeSubject { EmployeeId = emp1.Id, Employee = emp1, SubjectId = childTwo.Id, Subject = childTwo }, new EmployeeSubject { EmployeeId = emp2.Id, Employee = emp2, SubjectId = parentSubject.Id, Subject = parentSubject }, new EmployeeSubject { EmployeeId = emp2.Id, Employee = emp2, SubjectId = childOne.Id, Subject = childOne }, new EmployeeSubject { EmployeeId = emp3.Id, Employee = emp3, SubjectId = childTwo.Id, Subject = childTwo }, new EmployeeSubject { EmployeeId = Guid.Parse("63f4e537-cb7b-4fe0-beca-cc080e42552d"), SubjectId = childTwo.Id }, new EmployeeSubject { EmployeeId = emp4.Id, Employee = emp4, SubjectId = parentSubject.Id, Subject = parentSubject }, new EmployeeSubject { EmployeeId = emp4.Id, Employee = emp4, SubjectId = childTwo.Id, Subject = childTwo } }; /*context.EmployeeSubjects.AddRange(employeeSubjects); * context.SaveChanges();*/ var daysList = new List <Day>(); var day1 = new Day { Employee = emp1, Id = Guid.NewGuid(), Date = new DateTime(), }; var day2 = new Day { Employee = emp2, Id = Guid.NewGuid(), Date = new DateTime(), }; daysList.Add(day1); daysList.Add(day2); context.Days.AddRange(daysList); context.SaveChanges(); var daysSubjects = new DaySubject[] { new DaySubject { Day = day1, Subject = parentSubject }, new DaySubject { Day = day1, Subject = childOne }, new DaySubject { Day = day1, Subject = childTwo }, new DaySubject { Day = day2, Subject = parentSubject }, new DaySubject { Day = day2, Subject = childTwo }, }; /*context.DaySubjects.AddRange(daysSubjects); * context.SaveChanges();*/ }