public List <string> GetProjectNames(string name)
{
using (var ctx = new TimeTrackerDataModelContainer())
{
if (name == "")
{
var allNames = (from c in ctx.Projects
orderby c.Name
select c.Name);
return(allNames.ToList());
}
else
{
var names = (from c in ctx.Projects
orderby c.Name
where c.Name.Contains(name)
select c.Name).ToList();
var notNames = (from c in ctx.Projects
orderby c.Name
where !c.Name.Contains(name)
select c.Name).ToList();
List <string> returnNames = names.Concat(notNames).ToList();
return(returnNames);
}
}
}
public List <string> GetProjectNumbers()
{
using (var ctx = new TimeTrackerDataModelContainer())
{
var projectNumbers = (from c in ctx.Projects
orderby c.Number
select c.Number).ToList();
return(projectNumbers);
}
}
public List <Project> GetProjects(DateTime?day)
{
if (day.HasValue)
{
using (var ctx = new TimeTrackerDataModelContainer())
{
var projects = ctx.Projects.Where(s => s.Calendar.Date.Day == day.Value.Day).ToList();
return(projects);
}
}
else
{
using (var ctx = new TimeTrackerDataModelContainer())
{
var projects = ctx.Projects.Where(s => s.Calendar.Date == DateTime.Today).ToList();
return(projects);
}
}
}
private void SeedDb(TimeTrackerDataModelContainer ctx)
{
var employee = new Employee()
{
Id = 1,
FirstName = "Wieslaw",
Surname = "Urban",
Role = Roles.Engineer,
Calendar = new List <Calendar>()
{
new Calendar()
{
EmployeeId = 1, Id = 1, Date = DateTime.Today
}
}
};
var employee2 = new Employee()
{
Id = 2,
FirstName = "Ewelina",
Surname = "Urban",
Role = Roles.Manager,
Calendar = new List <Calendar>()
{
new Calendar()
{
EmployeeId = 2, Id = 2, Date = DateTime.Today
}
}
};
var project = new Project()
{
Id = 1,
Name = "Dupa",
Number = "PD892",
Description = "Projekt z dupki",
CalendarId = 1
};
var project2 = new Project()
{
Id = 2,
Name = "Cipa",
Number = "PD894",
Description = "Projekt z pipki",
CalendarId = 2
};
var project3 = new Project()
{
Id = 3,
Name = "Cipka",
Number = "PD895",
Description = "Projekt z pipki2",
CalendarId = 1
};
ctx.Employees.Add(employee);
ctx.Employees.Add(employee2);
ctx.Projects.Add(project);
ctx.Projects.Add(project2);
ctx.Projects.Add(project3);
ctx.SaveChanges();
}
