public Data.IndicateReport GetIndicateReportById(string reportId)
{
using (var context=new IndicateReportEntities())
{
return context.IndicateReports.FirstOrDefault(item => item.ReportID == reportId);
}
}
public Actual_model GetActualModelById(int id)
{
using (var context=new IndicateReportEntities())
{
return context.Actual_model.FirstOrDefault(a => a.Id_model == id);
}
}
public ID_process GetProcessById(int id)
{
using (var context=new IndicateReportEntities())
{
return context.ID_process.FirstOrDefault(p => p.ID_process1 == id);
}
}
public IndicateReportService()
{
_context=new IndicateReportEntities();
}
public int ActualByTime(string reportId, int startHour, int startSecond, int startMinute, int endHour, int endMinute, int endSecond)
{
var start = new TimeSpan(startHour, startMinute, startSecond);
var end = new TimeSpan(endHour, endMinute, endSecond);
using (var context=new IndicateReportEntities())
{
var report = context.IndicateReports
.Where(c => c.ReportID == reportId)
.Where(c => c.DateRerport.ToShortDateString() == DateTime.Now.ToShortDateString()).FirstOrDefault(c => c.DateRerport.TimeOfDay >= start && c.DateRerport.TimeOfDay <= end);
if (report != null)
{
int pass = report.Pass;
return pass;
}
return 0;
}
}
public List<Report_detail> GetReportDetails()
{
using (var context = new IndicateReportEntities())
{
return context.Report_detail.ToList();
}
}
public DateTime GetReport_detailById(string reportId)
{
using (var context = new IndicateReportEntities())
{
var detail = context.Report_detail.FirstOrDefault(c => c.ReportID == reportId);
if (detail != null)
return detail.Date_check;
return DateTime.Now;
}
}
public ActualModelService()
{
_context=new IndicateReportEntities();
}
public ProcessService()
{
_context = new IndicateReportEntities();
}