public List <ContinuousBlowingMachineReportModel> GenerateContinuousBlowingMachineReport(DateTime selectedFromDate, DateTime selectedToDate) { var data = dbConnection.GetDataFromDB(GenerateContinuousBlowingMachineQuery(selectedFromDate, selectedToDate)); var model = GenerateModelLogic <ContinuousBlowingMachineReportModel> .GenerateReportModel(data, ModelDictionaries.ContinuousBlowingMachineDbColumnNameToModelPropertyNameDictionary); return(model); }
public List <FormDateReportDBModel> GenerateFormReportModel(DateTime selectedFromDate, DateTime selectedToDate) { var query = string.Format( "SELECT * FROM public.forma_blok2 where data_czas > '{0}' and data_czas < '{1}'", selectedFromDate, selectedToDate); var data = dbConnection.GetDataFromDB(query); var dateReportDbModelList = GenerateModelLogic <FormDateReportDBModel> .GenerateReportModel(data, ModelDictionaries.FormDetailedReportDbModelPropertyNameDictionary); return(dateReportDbModelList); }
public async Task <List <ContinuousBlowingMachineReportModel> > GetContinuousBlowingMachineData(DateTime endDate, int chamber, int pz) { var query = string.Format( "SELECT * FROM public.spieniarka_ciagla_probki where komora = '{0}' and numer_pz = '{1}' and data_czas < '{2}'" + "and data_czas > '{3}' order by data_czas limit 10", chamber, pz, new DateTime(endDate.Year, endDate.Month, endDate.Day, endDate.Hour, endDate.Minute, endDate.Second), new DateTime(endDate.Year, endDate.Month, endDate.Day, endDate.Hour, endDate.Minute, endDate.Second).AddMonths(-1)); var data = dbConnection.GetDataFromDB(query); return(GenerateModelLogic <ContinuousBlowingMachineReportModel> .GenerateReportModel(data, ModelDictionaries.ContinuousBlowingMachineDbColumnNameToModelPropertyNameDictionary)); }
public async Task <List <BlowingMachineReportModel> > GetBlowingMachineData(DateTime endDate, int chamber, int pz) { var query = string.Format( "SELECT * FROM public.spieniarka_probki_summary where silos_0 = '{0}' and nr_lot = '{1}' and data_koniec < '{2}' " + "and data_koniec > '{3}' order by data_koniec desc limit 1", chamber, pz, new DateTime(endDate.Year, endDate.Month, endDate.Day, endDate.Hour, endDate.Minute, endDate.Second), new DateTime(endDate.Year, endDate.Month, endDate.Day, endDate.Hour, endDate.Minute, endDate.Second).AddMonths(-1)); var data = dbConnection.GetDataFromDB(query); return(GenerateModelLogic <BlowingMachineReportModel> .GenerateReportModel(data, ModelDictionaries.BlowingMachineDbColumnNameToModelPropertyNameDictionary)); }