public async Task <List <RepairReportViewModel> > GetReport(RepairReportDto dto) { //var parameters = new List<SqlParameter>() //{ // //new SqlParameter(){ParameterName="RETURN_VALUE", Value = dto.RETURN_VALUE, SqlDbType = System.Data.SqlDbType.Int}, // new SqlParameter(){ParameterName="Date1", Value = dto.Date1, SqlDbType = SqlDbType.Date}, // new SqlParameter(){ParameterName="Date2", Value = dto.Date2, SqlDbType = SqlDbType.Date}, // new SqlParameter(){ParameterName="Production", Value = dto.Production, SqlDbType = SqlDbType.VarChar,Size=10}, // new SqlParameter(){ParameterName="RepLocationList", Value = dto.RepLocationList, SqlDbType = SqlDbType.VarChar,Size=-1}, // new SqlParameter(){ParameterName="Location", Value = dto.Location, SqlDbType = SqlDbType.VarChar,Size=-1}, // new SqlParameter(){ParameterName="Currency", Value = dto.Currency, SqlDbType = SqlDbType.VarChar,Size=10}, // new SqlParameter(){ParameterName="UserId", Value = dto.UserId, SqlDbType = SqlDbType.VarChar,Size=10}, // new SqlParameter(){ParameterName="EquipList", Value = dto.EquipList, SqlDbType = SqlDbType.VarChar,Size=-1}, // new SqlParameter(){ParameterName="Language", Value = dto.Language, SqlDbType = SqlDbType.VarChar,Size=10}, // new SqlParameter(){ParameterName="OwnerList", Value = dto.OwnerList, SqlDbType = SqlDbType.VarChar,Size=-1}, // new SqlParameter(){ParameterName="IncludeBilled", Value = dto.IncludeBilled, SqlDbType = SqlDbType.Bit}, // new SqlParameter(){ParameterName="CurrentlyInRepair", Value = dto.CurrentlyInRepair, SqlDbType = SqlDbType.Bit}, //}; //return await _context.ExecuteStoreProcedureAsync<RepairReportViewModel>("rpRepair", parameters); return(new List <RepairReportViewModel>() { new RepairReportViewModel() { Barcode = new Random().Next().ToString(), Category = Guid.NewGuid().ToString(), Cost = 10, Customer = "aa", DateIn = DateTime.Now, DateOut = DateTime.Now, Department = "pol", Description = Guid.NewGuid().ToString(), Equipment = new Random().Next().ToString() }, new RepairReportViewModel() { Barcode = new Random().Next().ToString(), Category = Guid.NewGuid().ToString(), Cost = 10, Customer = "aa1", DateIn = DateTime.Now, DateOut = DateTime.Now, Department = "pol2", Description = Guid.NewGuid().ToString(), Equipment = new Random().Next().ToString() } }); }
public async Task <string> MakeReport([FromBody] RepairReportDto model) { _dataTools.SetNullStringsEmpty(model); var report = await _reportBuilder.GetReport(model); //report.CalculationMode = StiCalculationMode.Interpretation; report.Save("C:\\Csharp-Projects\\stimulTest\\stimulTest\\rep.mrt"); report.Render(false); report.ExportDocument(StiExportFormat.Pdf, "C:\\Csharp-Projects\\stimulTest\\stimulTest\\rep.pdf"); var result = report.SaveDocumentJsonToString(); //var viewmodel = await _repository.GetReport(model); //var result = new ReportStyle<List<RepairReportViewModel>> //{ // ReportTemplate = report.SaveToString(), // Data = new Pagination<List<RepairReportViewModel>>() // { // Count = 30, // Page = viewmodel.Count / 30, // Total = viewmodel.Count, // DataSets = new List<DataSet<List<RepairReportViewModel>>> // { // new DataSet<List<RepairReportViewModel>>() // { // DataSetName = "dataset", // Resource = viewmodel // } // } // } //}; return(result); }