public static int GetWeekNumber(DateTime ReportDate, int WeekStartDay)
{
using (var db = new ccEntities())
{
var queryText = "SELECT ccModel.Store.GetWeekNumber(@ReportDate, @WeekStartDay) FROM {1}";
var result = db.CreateQuery <int>(queryText
, new ObjectParameter("ReportDate", ReportDate)
, new ObjectParameter("WeekStartDay", WeekStartDay));
return(result.First());
}
}
public static decimal?GovHcCapLeaveDate(int clientId, DateTime?checkPeriodStart, DateTime?checkPeriodEnd)
{
using (var db = new ccEntities())
{
var queryText = "SELECT ccModel.Store.GovHcCapLeaveDate(@clientId, @checkPeriodStart, @checkPeriodEnd) FROM {1}";
var result = db.CreateQuery <decimal?>(queryText
, new ObjectParameter("clientId", clientId)
, new ObjectParameter("checkPeriodStart", checkPeriodStart)
, new ObjectParameter("checkPeriodEnd", checkPeriodEnd));
return(result.First());
}
}
public static int CfsLevelForGivenDate(int clientId, DateTime?givenDate)
{
using (var db = new ccEntities())
{
var queryText = "SELECT ccModel.Store.CfsLevelForGivenDate(@clientId, @givenDate) FROM {1}";
var result = db.CreateQuery <int>(queryText
, new ObjectParameter("clientId", clientId)
, new ObjectParameter("givenDate", givenDate));
return(result.First());
}
}