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();*/
}
