public BaseResponse <AppointStatistics> GetAppPeopleBySevAndTime(string sevItem, DateTime dt, string period)
{
var q = from c in unitOfWork.GetRepository <DC_ServiceAppointment>()
.dbSet.Where(a => a.ServiceDate == dt)
join b in unitOfWork.GetRepository <DC_SerAppSerIt>().dbSet.Where(a => a.SIName == sevItem) on c.ServiceAppID equals b.ServiceAppID
select new ServiceAppointment
{
ServiceItemType = b.SIName,
AppBy = c.AppBy,
AppTime = c.AppTime,
AppPhone = c.AppPhone
};
if (period == "Morn")
{
string tmp = dt.ToShortDateString() + " 12:00:00";
DateTime cmp = DateTime.Parse(tmp);
q = q.Where(a => a.AppTime <= cmp);
}
if (period == "Noon")
{
string tmp = dt.ToShortDateString() + " 12:00:00";
DateTime cmp = DateTime.Parse(tmp);
q = q.Where(a => a.AppTime > cmp);
}
var collection = new AppointStatistics();
collection.ServicePeople = q.ToList();
return(new BaseResponse <AppointStatistics>()
{
Data = collection
});
}
public BaseResponse <AppointStatistics> GetAppPeopleByDateTime(DateTime dt)
{
var q = from c in unitOfWork.GetRepository <DC_ServiceAppointment>()
.dbSet.Where(a => a.ServiceDate == dt)
join b in unitOfWork.GetRepository <DC_SerAppSerIt>().dbSet on c.ServiceAppID equals b.ServiceAppID
select new ServiceAppointment
{
ServiceItemType = b.SIName,
AppBy = c.AppBy,
AppTime = c.AppTime
};
var collection = new AppointStatistics();
collection.ServicePeople = q.ToList();
return(new BaseResponse <AppointStatistics>()
{
Data = collection
});
}
