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(); }