public static List <TTKunde> GetKunden()
{
using (var context = new MSUtilityDBEntities())
{
return((from c in context.TTKunde select c).Distinct().ToList());
}
}
public static List <DateTime> GetCalenderEntries()
{
using (var context = new MSUtilityDBEntities())
{
return((from c in context.TTDates where c.Day.Month == StateManager.CurrentInstance.CurrentSelectedDate.Month && c.Day.Year == StateManager.CurrentInstance.CurrentSelectedDate.Year select c).Include("TTKundeEntry").ToList().Where(x => x.TTKundeEntry.Count != 0).Select(x => x.Day).ToList());
}
}
public static List <TTProject> GetProjects(TTKundeEntry currentInstanceSelectedKundeEntry)
{
if (currentInstanceSelectedKundeEntry == null)
{
return(new List <TTProject>());
}
using (var context = new MSUtilityDBEntities())
{
return((from c in context.TTProject where c.KundeId == currentInstanceSelectedKundeEntry.KundeID select c).Distinct().ToList());
}
}
public static TTDates GetDateDataFromDate(DateTime date)
{
using (var context = new MSUtilityDBEntities())
{
var result = context.TTDates
.Include("TTKundeEntry")
.Include("TTKundeEntry.TTKunde")
.Include("TTKundeEntry.TTProjectEntry")
.Include("TTKundeEntry.TTProjectEntry.TTProject")
.Include("TTKundeEntry.TTProjectEntry.TTEntryData").FirstOrDefault(x => x.Day == date.Date);
return(result);
}
}
public static List <TTDates> GetDateDataFromDateRange(DateTime from, DateTime to)
{
using (var context = new MSUtilityDBEntities())
{
var result = context.TTDates
.Include("TTKundeEntry")
.Include("TTKundeEntry.TTKunde")
.Include("TTKundeEntry.TTProjectEntry")
.Include("TTKundeEntry.TTProjectEntry.TTProject")
.Include("TTKundeEntry.TTProjectEntry.TTEntryData").Where(x => x.Day >= from && x.Day <= to)
.ToList();
return(result);
}
}