private void Report_Click(object sender, EventArgs e) { ReportManager RM = new ReportManager(); Hide(); RM.Show(); }
public static void ReportTestOutcome(string screenshotPath) { var status = MyTestContext.CurrentTestOutcome; switch (status) { case UnitTestOutcome.Failed: TheLogger.Error($"Test Failed=>{MyTestContext.FullyQualifiedTestClassName}"); CurrentTestCase.AddScreenCaptureFromPath(screenshotPath); CurrentTestCase.Fail("Fail"); break; case UnitTestOutcome.Inconclusive: CurrentTestCase.AddScreenCaptureFromPath(screenshotPath); CurrentTestCase.Warning("Inconclusive"); break; case UnitTestOutcome.Unknown: CurrentTestCase.Skip("Test skipped"); break; default: CurrentTestCase.Pass("Pass"); break; } ReportManager.Flush(); }
public IActionResult ReportOrderByLoadId(string status) { // throw new NotImplementedException(); var value = ReportManager.OrderByLoadId(); return(View(value)); }
public Family RandomFamily(ReportManager manager) { Member member = RandomMemberFromData(manager); MembershipManager membership = new MembershipManager(manager.ConnectionString); return(membership.GetFamily(member)); }
void Start() { currentWave = startingWave; dayNightCycle = GetComponent <DayNightCycle> (); reportManager = GetComponent <ReportManager> (); reportNew = viewReportButton.transform.Find("Image").gameObject; }
/* MyFuncs */ void MakeTableHeader() { TableRow view = (TableRow)inflater.Inflate(Resource.Layout.TableRowHeader, null); view.FindViewById <TextView> (Resource.Id.txtFIO).Text = "ФИО"; listOfWeekNum = new List <int> (); int delta = 0; var min = ReportManager.GetMinWeekNum(); for (int i = 0; i < 12; i++) { if ((min + i) % 53 == 0) { delta = 1; } listOfWeekNum.Add((min + i + delta) % 53); } foreach (int weekNum in listOfWeekNum) { TextView txtWeekNum = (TextView)inflater.Inflate(Resource.Layout.TableWeekNum, null); txtWeekNum.Text = weekNum.ToString(); view.AddView(txtWeekNum); } tlHeader.AddView(view); }
public IActionResult ReportOrderByCost() { // throw new NotImplementedException(); var value = ReportManager.OrderByCost(); return(View(value)); }
public static string RefreshGlobalReport6(string startDateStr, string endDateStr, string selectedProjectsStr) { DateTime startDate = Convert.ToDateTime(startDateStr); DateTime endDate = Convert.ToDateTime(endDateStr); return(ReportManager.GetReport5_HTML(startDate, endDate, selectedProjectsStr)); }
public ActionResult ContactReport(ContactReportViewModel model) { var mgr = new ReportManager(); var items = mgr.FetchContactReport(model).AsQueryable(); MemoryStream output = new MemoryStream(); StreamWriter writer = new StreamWriter(output, Encoding.UTF8); writer.Write("ContactId,Region,Fund,OrgCode,BA,Name,Phone,Fax,Email"); writer.WriteLine(); writer.WriteLine(); foreach (var item in items) { var format = "{0},\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\""; var formatted = string.Format(format, item.ContactId, item.Region, item.Fund, item.OrgCode, item.BA, item.Name, item.Phone, item.Fax, item.Email); writer.Write(formatted); writer.WriteLine(); } writer.Flush(); output.Position = 0; return(File(output, "text/comma-separated-values", "ContactReport.csv")); }
public void DeployWithEmbeddedDatasource() { var log = A.Fake <ILog>(); var fileSystemProxy = A.Fake <IFileSystemProxy>(); var settings = A.Fake <ISettings>(); var reportingServiceProxy = A.Fake <IReportingServiceProxy>(); A.CallTo(() => reportingServiceProxy.GetItemDataSourceReferences(A <string> ._)).Returns(new[] { "dataSourceName" }); A.CallTo(() => fileSystemProxy.ReadAllText(A <string> .That.Contains("Report"))).Returns("<DataSource Name=\"dataSourceName\"><DataSourceReference>sharedReference</DataSourceReference>"); var reportManager = new ReportManager(log, settings, fileSystemProxy, reportingServiceProxy); reportManager.Deploy("Report", "Report", "Datasets", "Data Sources", false); A.CallTo(() => reportingServiceProxy.CreateFolder("Report")).MustHaveHappened(); A.CallTo(() => reportingServiceProxy.CreateReport("Report", "/Report", false, A <byte[]> ._)).MustHaveHappened(); A.CallTo(() => reportingServiceProxy.CreateFolder("Datasets")).MustNotHaveHappened(); A.CallTo(() => reportingServiceProxy.CreateDataset("sharedReference", "/Datasets", false, A <byte[]> ._)).MustNotHaveHappened(); A.CallTo(() => reportingServiceProxy.CreateFolder("Data Sources")).MustHaveHappened(); A.CallTo(() => reportingServiceProxy.CreateDataSource("sharedReference", "/Data Sources", false, A <(string, string, string, string, string)> ._)).MustHaveHappened(); A.CallTo(() => reportingServiceProxy.SetItemReferences(A <string> .That.Contains("sharedReference"), A <(string, string)[]> ._)).MustNotHaveHappened(); A.CallTo(() => reportingServiceProxy.SetItemReferences(A <string> .That.Contains("Report"), A <(string, string)[]> ._)).MustHaveHappened(); }
protected void TextBox1_TextChanged(object sender, EventArgs e) { ReportManager rManager = new ReportManager(ctx); DropDownList1.DataBind(); if (DropDownList1.Items.Count > 0) { Report dalReport = rManager.GetByDateAndName(TestDate, DropDownList1.SelectedValue); if (dalReport != null) { TextBox1.Text = dalReport.TestDate.ToString("dd/MM/yyyy"); TextBox2.Text = dalReport.PrintDate.ToString("dd/MM/yyyy"); TextBox3.Text = dalReport.ReportNumber.ToString(); } else { TextBox3.Text = string.Empty; TextBox2.Text = DateTime.Now.ToString("dd/MM/yyyy"); } } if (TextBox2.Text.Trim() == "") { TextBox2.Text = DateTime.Now.ToString("dd/MM/yyyy"); } }
private static void AddDataSets(ReportManager reportManager, params DataSet[] dataSets) { foreach (var dataSet in dataSets) { reportManager.DataSources.Add(dataSet.DataSetName, dataSet); } }
private void btnEventsReport_Click(object sender, EventArgs e) { /* * // Create objects to give report, attach them to it, attach report to viewer and open it * FormFileAidRptViewer rptForm = new FormFileAidRptViewer(MainListView.Items); * rptForm.ShowDialog(); * //Messenger.Show("Placeholder for Tracked Files report", caption); * Report eventsRpt = ReportManager.GetReportByName("Tracked Files"); * if (eventsRpt == null) return; // Could not find report * bool wasLogged = LogReportRun(eventsRpt.ReportID, eventsRpt.Name); * */ FormFileAidRptEvents rptForm = new FormFileAidRptEvents(EventslistView.Items); rptForm.ShowDialog(); //Messenger.Show("Placeholder for Events report", caption); Report eventsRpt = ReportManager.GetReportByName("Events"); if (eventsRpt == null) { return; // Could not find report } bool wasLogged = LogReportRun(eventsRpt.ReportID, eventsRpt.Name); if (wasLogged) { FillListView(); // Refresh GUI } }
public void ReportStatusTestT() { int taskId = 67; // TODO: Initialize to an appropriate value string logClass = this.GetType().AssemblyQualifiedName; // TODO: Initialize to an appropriate value var details = new ReportManager { Caption = "A report", Versions = new List <FileVersion>() }; details.Versions.Add(new FileVersion { Name = "DFLink.exe", Version = "3.4.192" }); details.Versions.Add(new FileVersion { Name = "d3123api.dll", Version = "3.0.12" }); details.Versions.Add(new FileVersion { Name = "d3cotapi.dll", Version = "3.0.35" }); int status = 5; LogHelper.GetLoggerHandle() .ReportStatus(logClass, taskId, status, details, obj => { return(JsonConvert.SerializeObject(obj)); }); Thread.Sleep(100); Assert.AreEqual(logClass, LoggerName); Assert.AreEqual(Level.Info, LogLevel); Assert.AreEqual(taskId, TheReturnPact.TaskId); Assert.AreEqual(JsonConvert.SerializeObject(details), TheReturnPact.MessageDetails); Assert.AreEqual(MsgType.MtStatus, TheReturnPact.MessageType); Assert.AreEqual(status, TheReturnPact.Status); }
public RaceView() { InitializeComponent(); var mainWindow = (MainWindow)Application.Current.MainWindow; _rfidManager = mainWindow.RfidManager; _reportManager = mainWindow.ReportManager; _race = new Race(); rbRaceName.DataContext = _race; this.DataContext = _rfidManager; // btnSetTimer.IsEnabled = _rfidManager.Connected; btnStartTimer.IsEnabled = false; btnStopTimer.IsEnabled = false; // ttbTimer.IsStarted = false; _raceRepository = new RaceRepository(); this.Show.Text = _raceTime.ToString("HH:mm:ss:ff"); //this.ReportTags.Text = _rfidManager.ReportTags; dgSplits.ItemsSource = _rfidManager.AthleteSplits; // btnStartTimer.IsEnabled = RfidManager.Connected; }
/// <summary> /// Finalizes execution of every test. Use this method in TearDown section of /// every TestFixture /// </summary> protected async Task TestEnd() { var deleteAllTasksTask = BackgroundTaskApi.DeleteAllTasksAsync(CurrentUser); if (TestConfig.IsReportingEnabled) { ReportManager.GenerateTestResultRecord(); } CloseSecondaryBrowser(); if (IsEachTestInNewBrowser) { ClosePrimaryBrowser(); IsUserLoggedIn = false; await deleteAllTasksTask.ConfigureAwait(false); return; } var browserTabs = GetTabHandles(); if (browserTabs == null || browserTabs.Count <= 1) { await deleteAllTasksTask.ConfigureAwait(false); return; } foreach (var browserTab in browserTabs.Skip(1)) { CloseTab(browserTab); } await deleteAllTasksTask.ConfigureAwait(false); }
public StringGetter(ReportManager reportManager) { this.reportManager = reportManager; strs = new List <string>(); stList = new List <List <string> >(); instructionsToRemove = new List <List <Instruction> >(); }
public static void Postfix(ReportManager __instance, ref List <ReportManager.DailyReport> ___dailyReports) { try { var missingCycles = GameUtil.GetCurrentCycle() - ___dailyReports.Count(); if (missingCycles > 0) { var missingDailyReports = new ReportManager.DailyReport[missingCycles]; for (int i = 0; i < missingCycles; i++) { var newDailyReport = new ReportManager.DailyReport(__instance) { day = i }; newDailyReport.reportEntries.Clear(); missingDailyReports[i] = newDailyReport; } ___dailyReports.InsertRange(0, missingDailyReports); } } catch (Exception e) { Debug.Log("RDR: Error while trying to fix missing daily reports: " + e); } }
private void PrintReport() { if (dgvReport.CurrentRow == null) { return; } Report report = dgvReport.CurrentRow.DataBoundItem as Report; if (report == null) { MessageBox.Show("Не знайдений звіт для друку", "Помилка"); return; } ReportManager manager = new ReportManager(report.Report_File); manager.SetCheckedCard(id_card); IReport rep = manager.GetInstanceReport(); if (rep == null) { MessageBox.Show("Не написаний код для друку звіта. Див. файл ReportManager.cs", "Помилка"); return; } fmReportViewer rpr = new fmReportViewer(this, rep); rpr.StartReport(); this.Refresh(); }
public static void AddTestCaseMetaDataToHtmlReport(TestContext testContext) { MyTestContext = testContext; CurrentTestCase = ReportManager.CreateTest(MyTestContext.TestName); //CurrentTestCase = ReportManager.CreateTest<Feature>("Feature"); //CurrentTestCase.CreateNode<Scenario>(MyTestContext.) }
public static void ReportTestOutcome(string screenshotPath) { var status = TestContext.CurrentContext.Result.Outcome.Status; var errorMessage = TestContext.CurrentContext.Result.Message; switch (status) { case TestStatus.Failed: ExtentTest.Log(Status.Fail, "Test Failed <br/>" + errorMessage); ExtentTest.AddScreenCaptureFromPath(screenshotPath); break; case TestStatus.Inconclusive: ExtentTest.AddScreenCaptureFromPath(screenshotPath); ExtentTest.Warning("Inconclusive"); break; case TestStatus.Skipped: ExtentTest.Skip("Test Skipped"); break; case TestStatus.Passed: ExtentTest.Pass("Test Passed"); break; default: ExtentTest.Pass("Test Passed"); break; } ReportManager.Flush(); }
protected void Page_Load(object sender, EventArgs e) { // get id from query string int id = Convert.ToInt32(Request.QueryString["id"]); string type = Request.QueryString["type"]; if (type == "doc") { // get document for id FileManager fm = new FileManager(); Document d = fm.documentForID(id); Response.Write(Request.QueryString["id"]); Response.Clear(); Response.Buffer = true; Response.ContentType = d.MIMEType; Response.BinaryWrite(d.fileContent); } else { ReportManager rm = new ReportManager(); Report r = rm.ReportForID(id); Response.Write(Request.QueryString["id"]); Response.Clear(); Response.Buffer = true; Response.ContentType = r.MIMEType; Response.BinaryWrite(r.FileContent); } Response.Flush(); Response.End(); }
public DailyReport(ReportManager manager) { foreach (KeyValuePair <ReportType, ReportGroup> reportGroup in manager.ReportGroups) { reportEntries.Add(new ReportEntry(reportGroup.Key, noteStorage.GetNewNoteId(), null, false)); } }
//สรุปรายการซ่อมประจำวัน public ActionResult ReportDay() { ViewBag.ReportList = "first active"; ReportDayViewModel model = new ReportDayViewModel(); model.Report = new ReportDay(); DateTime start = DateTime.Today; model.DateStart = start.AddYears(543); DateTime end = DateTime.Today.AddDays(1); model.DateEnd = Convert.ToDateTime(end.AddYears(543).ToString("MM/dd/yyyy")); model.Report.Repairs = ReportManager.ReportRepairDay(start); model.Report.Claims = ReportManager.ReportClaimDay(start); var workingstatus = WorkingStatusManager.GetAll().Where(m => m.iDefault>=5 && m.iDefault<=7); model.Report.WorkingStatuies = workingstatus.OrderBy(m => m.iDefault).ToList(); model.Report.Insurances = InsuranceManager.GetAll().OrderBy(m => m.sInsuranceName).ToList(); model.Report.TCStaffs = StaffManager.GetAll().Where(m => m.StaffPosition.sDescription == "ช่าง").OrderBy(m => m.sStaffName).ToList(); model.Report.STCStaffs = StaffManager.GetAll().Where(m => m.StaffPosition.sDescription == "หัวหน้าช่าง").OrderBy(m => m.sStaffName).ToList(); model.Report.QCStaffs = StaffManager.GetAll().Where(m => m.StaffPosition.sDescription == "ฝ่ายตรวจสอบคุณภาพ").OrderBy(m => m.sStaffName).ToList(); ViewBag.ReportHeader = String.Format("รายงานบริการประจำวันที่ {0}", DateExtension.DateThaiFormat(start)); return View(model); }
public static void Test4_ReportManagerCreateSimpleReport() { MockRepository rhinoEngine = new MockRepository(); var mockWriter = rhinoEngine.DynamicMock <TextWriter>(); TextWriterFactory.SetTextWriter(mockWriter); using (rhinoEngine.Record()) { mockWriter.Write("Nothing"); LastCall.Constraints(new Rhino.Mocks.Constraints.Contains("TestCustomer") & new Rhino.Mocks.Constraints.Contains("TestMovie") & new Rhino.Mocks.Constraints.Contains("6 days") & new Rhino.Mocks.Constraints.Contains(12.ToString("C")) & new Rhino.Mocks.Constraints.Contains("(Regular)")); mockWriter.Flush(); } Customer customer = new Customer("TestCustomer"); customer.Rentals.Add(new Renatal(Movie.RegularMovie("TestMovie"), 6)); ReportManager.CreateSimpleReport("SomePath", customer); rhinoEngine.VerifyAll(); }
private void Init() { reportManager = new ReportManager(reportWindow); obfuscatorManager = new ObfuscatorManager(); obfuscatorCore = new ObfuscatorCore(reportManager); savePath.Text = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); }
public FileResult Download(string taskId, string reportId, string projectId, string docId) { var reportManager = new ReportManager(taskId, reportId, projectId); var doc = reportManager.GetReportAdditionalInfo(docId) as DocumentAdditionalInfo; return(doc != null?File(doc.FilePath, "application/doc", doc.InfoName) : null); }
public async Task <IActionResult> PregledUplata(DateTime datumOd, DateTime datumDo) { List <NpgsqlParameter> parameters = new List <NpgsqlParameter>(); List <string> sume = new List <string>(); string rpt = ""; string title = ""; string report = "Pregled uplata u periodu"; rpt = "rptPregledUplata"; parameters.Add(new NpgsqlParameter() { ParameterName = "datefrom", NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Date, Value = datumOd.Date }); parameters.Add(new NpgsqlParameter() { ParameterName = "dateto", NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Date, Value = datumDo.Date }); //} title = report + " " + datumOd.ToString("dd.MM.yyyy") + "-" + datumDo.ToString("dd.MM.yyyy"); sume.Add("uplaćeno"); var ds = await ReportManager.ExecuteProcedureReport(rpt, parameters, _con.GetConnectionString("Delos")); var reportFile = ReportBuilder.BuildReport(report, title, ds, sume); if (reportFile != null) { var fileStream = new FileStream(reportFile, FileMode.Open, FileAccess.Read); return(new FileStreamResult(fileStream, "application/vnd.ms-excel")); } else { return(BadRequest()); } }
/// <summary> /// Create a problem /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button5_Click(object sender, EventArgs e) // create a problem { int travelers; if (!int.TryParse(txtTravelersAmount.Text, out travelers)) { MessageBox.Show("Please write a number"); return; } DistanceOperator dOp; if (ControlProgram.tsp != null) // Load From TSPLib95 { TransferTspLibItemToPoints(); dOp = new DistanceOperator(ControlProgram.tsp.Problem.NodeProvider.CountNodes()); dOp.CalculateDistance(ControlProgram.tsp.Problem); } else { dOp = new DistanceOperator(this.Points.Count, Points); } TspManager = new TSPManager(dOp, travelers, int.Parse(cmbDepoId.Text), NextGeneration); ReportManager pManager = new ReportManager(1, 2, ControlProgram.tsp.Problem.Name); TspManager.NextGenerationEvent += pManager.NextGeneration; ControlProgram.Start(TspManager.Population, TspManager.dOp, TspManager.Environment); btnRun.Enabled = true; btnChooseOperator.Enabled = true; }
public IActionResult ReportByPath(string path) { // throw new NotImplementedException(); var value = ReportManager.SortByGivenPath(path); return(View(value)); }
public IActionResult ReportByStatus(string status) { // throw new NotImplementedException(); var value = ReportManager.SortByStatus(status); return(View(value)); }
protected void Page_Load(object sender, EventArgs e) { ReportManager rm = new ReportManager(); dbData = rm.getData(); if (!IsPostBack) { categoriesDDL.DataSource = rm.getCategories(); categoriesDDL.DataBind(); categoriesDDL.Items.Insert(0, "All Reports"); } }
public static dynamic GetReport(long reportNumber) { ReportManager rManager = new ReportManager(StaticDataHelper.FCCLDbContext); Report report = rManager.GetByNumber(reportNumber); report = report ?? new Report(); return new { rType = report.ReportType, objId = report.ObjectId, objName = report.ObjectName, testDate = report.TestDate.ToString("dd/MM/yyyy"), displayTxt = report.Id > 0 ? string.Format("A fost gasit raportul {0} pentru ferma {1} din data {2}.", (FCCLReportType)report.ReportType, report.ObjectName, report.TestDate.ToString("dd/MM/yyyy")) : string.Format("Nu a fost gasit raport pentru numarul {0}.", reportNumber) }; }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { ReportManager rManager = new ReportManager(ctx); Report dalReport = rManager.GetByDateAndId(TestDate, ObjectId); if (dalReport != null) { TextBox1.Text = dalReport.TestDate.ToString("dd/MM/yyyy"); TextBox2.Text = dalReport.PrintDate.ToString("dd/MM/yyyy"); TextBox3.Text = dalReport.ReportNumber.ToString(); } else { TextBox3.Text = string.Empty; TextBox2.Text = DateTime.Now.ToString("dd/MM/yyyy"); } }
/// <summary> /// Initializes a new instance of the <see cref="ReportManagerTests"/> class. /// </summary> public ReportManagerTests() { this.reportRepository = new Mock<IReportRepository>(); this.reportManager = new ReportManager(this.reportRepository.Object); }
public void CreateReport() { ReportManager rManager = new ReportManager(ctx); DateTime testDate; int farmId; DateTime.TryParse(TextBox1.Text, out testDate); Int32.TryParse(DropDownList1.SelectedValue, out farmId); Report b = rManager.GetByDateAndId(testDate, farmId); string nrb = b.ReportNumber.ToString(); string datab = b.TestDate.ToShortDateString(); int pos = 0; LocalReport report = new LocalReport(); byte[] file; string mimeType, encoding, fileExtension; string[] streams; Warning[] warnings; string fabricaid = DropDownList1.SelectedValue; string fabricaname = DropDownList1.Items[DropDownList1.SelectedIndex].ToString(); // read fabrica SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "SELECT Fabrici.Strada,Fabrici.Numar,Fabrici.Oras,Judete.Denloc " + "FROM Fabrici,Judete WHERE Fabrici.ID=" + fabricaid + " AND Fabrici.Judet=Judete.ID"; cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); string fabricastrada = Convert.ToString(reader["Strada"]); string fabricanumar = Convert.ToString(reader["Numar"]); string fabricaoras = Convert.ToString(reader["Oras"]); string fabricajudet = Convert.ToString(reader["Denloc"]); reader.Close(); cnn.Close(); string datatestare = TextBox1.Text; // date fabrica //deviceinfo string deviceInfo = "<DeviceInfo>" + " <OutputFormat>PDF</OutputFormat>" + " <PageWidth>29.7cm</PageWidth>" + " <PageHeight>21cm</PageHeight>" + " <MarginTop>0.0cm</MarginTop>" + " <MarginLeft>0.5cm</MarginLeft>" + " <MarginRight>0.5cm</MarginRight>" + " <MarginBottom>0.5cm</MarginBottom>" + "</DeviceInfo>"; string httppath = StaticDataHelper.SettingsManager.CaleRapoarteHttp; string filepath = StaticDataHelper.SettingsManager.CaleRapoarte; cmd.CommandTimeout = 300; cmd.CommandText = "SELECT DISTINCT Ferme_CCL.Nume,Ferme_CCL.ID, MostreTancuri.FermaID, Ferme_CCL.Cod, " + "Ferme_CCL.Strada,Ferme_CCL.Numar, Ferme_CCL.Oras, Ferme_CCL.Judet,Ferme_CCL.PersonaDeContact,Ferme_CCL.TelPersoanaContact,Ferme_CCL.Ferme_CCL,Ferme_CCL.FermierID,Judete.Denloc " + " FROM MostreTancuri, Ferme_CCL INNER JOIN JUDETE ON Convert(int,Ferme_CCL.Judet,2)=Judete.ID WHERE" + " CONVERT(datetime, MostreTancuri.DataTestareFinala, 103) = CONVERT(datetime, '" + datatestare + "', 103) " + " AND MostreTancuri.CodFerma = Ferme_CCL.Cod " + " AND Ferme_CCL.FabricaID = " + fabricaid + " AND MostreTancuri.Validat = 1 ORDER BY Ferme_CCL.Nume"; cnn.Open(); SqlDataReader drferme = cmd.ExecuteReader(); //prepare report parameters string laborator = ddlLaborator.Items[ddlLaborator.SelectedIndex].ToString(); string responsabil = ddlResponsabil.Items[ddlResponsabil.SelectedIndex].ToString(); string semnlab = ddlLaborator.SelectedValue; string semnresp = ddlResponsabil.SelectedValue; semnresp = semnresp.Substring(0, semnresp.LastIndexOf(".")); semnlab = semnlab.Substring(0, semnlab.LastIndexOf(".")); semnresp = semnresp.ToLower(); semnlab = semnlab.ToLower(); ReportParameter pDatatestare = new ReportParameter("datatestare", datatestare); ReportParameter pDatab = new ReportParameter("datab", datab); ReportParameter pNrb = new ReportParameter("nrb", nrb); ReportParameter pFabricanume = new ReportParameter("fabricanume", fabricaname); ReportParameter pFabricastrada = new ReportParameter("fabricastrada", fabricastrada); ReportParameter pFabricanumar = new ReportParameter("fabricanumar", fabricanumar); ReportParameter pFabricaoras = new ReportParameter("fabricaoras", fabricaoras); ReportParameter pFabricajudet = new ReportParameter("fabricajudet", fabricajudet); ReportParameter pLaborator = new ReportParameter("laborator", laborator); ReportParameter pResponsabil = new ReportParameter("responsabil", responsabil); List<FileLinks> list = new List<FileLinks>(); while (drferme.Read()) { FileLinks filelink = new FileLinks(); string fermacod = Convert.ToString(drferme["Cod"]); string fermanume = Convert.ToString(drferme["Nume"]); string fermastrada = Convert.ToString(drferme["Strada"]); string fermanumar = Convert.ToString(drferme["Numar"]); string fermaoras = Convert.ToString(drferme["Oras"]); string judet = Convert.ToString(drferme["Denloc"]); string codferma = Convert.ToString(drferme["Cod"]); string fermaadresa = "Str. " + fermastrada + " nr. " + fermanumar + ", " + fermaoras; string fermatelcontact = Convert.ToString(drferme["TelPersoanaContact"]); string fermaperscontact = Convert.ToString(drferme["PersonaDeContact"]); ReportDataSource rds = new ReportDataSource(); rds.Name = "MostreFabrica"; List<MostreFabrica> mostre = MostreFabrica.GetMostreFerma(fabricaid, fermacod, datatestare); rds.Value = mostre; // build dates interval string datatmin = datatestare; string datatmax = datatestare; string datatesttitlu = datatestare; string dataprimirii = ""; string datapmin = dataprimirii; string datapmax = dataprimirii; string dataprimtitlu = dataprimirii; string combi = mostre[0].Combi; foreach (MostreFabrica mf in mostre) { string datamin = mf.DataTestare; string datamax = mf.DataTestareFinala; dataprimirii = mf.DataPrimirii; if (datapmin == "") datapmin = dataprimirii; if (datapmax == "") datapmax = dataprimirii; if (datamin != datatmin) { DateTime dt1 = new DateTime(Int32.Parse(datamin.Substring(6, 4)), Int32.Parse(datamin.Substring(3, 2)), Int32.Parse(datamin.Substring(0, 2))); DateTime dt2 = new DateTime(Int32.Parse(datatmin.Substring(6, 4)), Int32.Parse(datatmin.Substring(3, 2)), Int32.Parse(datatmin.Substring(0, 2))); if (DateTime.Compare(dt1, dt2) < 0) datatmin = datamin; } if (datamax != datatmax) { DateTime dt1 = new DateTime(Int32.Parse(datamax.Substring(6, 4)), Int32.Parse(datamax.Substring(3, 2)), Int32.Parse(datamax.Substring(0, 2))); DateTime dt2 = new DateTime(Int32.Parse(datatmax.Substring(6, 4)), Int32.Parse(datatmax.Substring(3, 2)), Int32.Parse(datatmax.Substring(0, 2))); if (DateTime.Compare(dt1, dt2) > 0) datatmax = datamax; } // data primirii if (dataprimirii != datapmin) { DateTime dt1 = new DateTime(Int32.Parse(dataprimirii.Substring(6, 4)), Int32.Parse(dataprimirii.Substring(3, 2)), Int32.Parse(dataprimirii.Substring(0, 2))); DateTime dt2 = new DateTime(Int32.Parse(datapmin.Substring(6, 4)), Int32.Parse(datapmin.Substring(3, 2)), Int32.Parse(datapmin.Substring(0, 2))); if (DateTime.Compare(dt1, dt2) < 0) datapmin = dataprimirii; } if (dataprimirii != datapmax) { DateTime dt1 = new DateTime(Int32.Parse(dataprimirii.Substring(6, 4)), Int32.Parse(dataprimirii.Substring(3, 2)), Int32.Parse(dataprimirii.Substring(0, 2))); DateTime dt2 = new DateTime(Int32.Parse(datapmax.Substring(6, 4)), Int32.Parse(datapmax.Substring(3, 2)), Int32.Parse(datapmax.Substring(0, 2))); if (DateTime.Compare(dt1, dt2) > 0) datapmax = dataprimirii; } } if (datatmin != datatmax) datatesttitlu = datatmin + " - " + datatmax; if (datapmin != datapmax) dataprimtitlu = datapmin + " si " + datapmax; else dataprimtitlu = datapmin; // end dates interval report.DataSources.Clear(); report.DataSources.Add(rds); pos++; report.ReportPath = "ReportFerme4.rdlc"; report.Refresh(); ReportParameter pDatatitlu = new ReportParameter("datatestare", datatesttitlu); ReportParameter pDataprimirii = new ReportParameter("dataprimirii", dataprimtitlu); ReportParameter pCombi = new ReportParameter("combi", combi); ReportParameter pPos = new ReportParameter("pos", pos.ToString()); ReportParameter pCodferma = new ReportParameter("codferma", codferma); ReportParameter pFermanume = new ReportParameter("fermanume", fermanume); ReportParameter pFermaadresa = new ReportParameter("fermaadresa", fermaadresa); ReportParameter pFermajudet = new ReportParameter("fermajudet", judet); ReportParameter pFermaperscontact = new ReportParameter("fermaperscontact", fermaperscontact); ReportParameter pFermatelcontact = new ReportParameter("fermatelcontact", fermatelcontact); ReportParameter versiuneRaport = new ReportParameter("Versiune", new SettingManager(StaticDataHelper.FCCLDbContext).GetValueByName("ReportFerme4")); ReportParameter[] p ={ pDatatitlu,pDataprimirii,pCombi,pDatab,pNrb,pFabricanume,pFabricastrada,pFabricanumar,pFabricaoras,pFabricajudet,pLaborator,pResponsabil, pPos,pFermanume,pFermaadresa,pFermajudet,pCodferma,pFermaperscontact,pFermatelcontact, versiuneRaport}; report.SetParameters(p); file = report.Render("PDF", deviceInfo, out mimeType, out encoding, out fileExtension, out streams, out warnings); // read from date fixe!!! fermanume = replace_special_car_null(fermanume); string raport_name = "RaportFerma" + datatestare.Replace("/", "_") + "_" + fermacod + "-" + fermanume + ".pdf"; string raport_excel = "RaportFerma" + datatestare.Replace("/", "_") + "_" + fermacod + "-" + fermanume + ".xls"; string path_raport_http = "http://" + Request.ServerVariables.Get("HTTP_HOST") + "/" + httppath; string pdf_link = path_raport_http + @"Ferme/" + raport_name; string pdf_file = filepath + @"Ferme/" + raport_name; File.WriteAllBytes(pdf_file, file); filelink.Url = pdf_link; filelink.Des = raport_name; list.Add(filelink); } drferme.Close(); cnn.Close(); //raport cumulat LocalReport report_cum = new LocalReport(); ReportDataSource rdsc = new ReportDataSource(); rdsc.Name = "MostreFabrica1"; rdsc.Value = MostreFabrica.GetMostreFabrica(fabricaid, datatestare); report_cum.DataSources.Clear(); report_cum.DataSources.Add(rdsc); report_cum.ReportPath = "ReportCumulat4.rdlc"; report_cum.Refresh(); ReportParameter pSemnlab = new ReportParameter("semnlab", semnlab); ReportParameter pSemnresp = new ReportParameter("semnresp", semnresp); ReportParameter pVersiuneRaport = new ReportParameter("Versiune", new SettingManager(StaticDataHelper.FCCLDbContext).GetValueByName("ReportCumulat4")); ReportParameter[] rp = { pDatatestare, pDatab, pNrb, pFabricanume, pFabricastrada, pFabricanumar, pFabricaoras, pFabricajudet, pLaborator, pResponsabil, pSemnlab, pSemnresp, pVersiuneRaport }; report_cum.SetParameters(rp); byte[] file_cum = report_cum.Render("PDF", deviceInfo, out mimeType, out encoding, out fileExtension, out streams, out warnings); string fabricanume = replace_special_car_null(fabricaname); string raport_name_cum = "RaportCumulat" + datatestare.Replace("/", "_") + "_" + fabricaid + "-" + fabricanume + ".pdf"; string path_raport_http_cum = "http://" + Request.ServerVariables.Get("HTTP_HOST") + "/" + httppath; string pdf_link_cum = path_raport_http_cum + @"Ferme/" + raport_name_cum; string pdf_file_cum = filepath + @"Ferme/" + raport_name_cum; // writefile File.WriteAllBytes(pdf_file_cum, file_cum); linkall.Visible = true; linkall.NavigateUrl = pdf_link_cum; linkall.Text = raport_name_cum; // Repeater1.DataSource = list; Repeater1.DataBind(); Repeater1.Visible = true; }
public void CreateReport() { ReportManager rManager = new ReportManager(ctx); LocalReport report = new LocalReport(); byte[] file; string mimeType, encoding, fileExtension; string[] streams; Warning[] warnings; long reportNumber; Report dalReport = rManager.GetOrCreateReport(FCCLReportType.FCB, -1 , DropDownList1.SelectedItem.Text, TestDate, PrintDate, long.TryParse(TextBox3.Text, out reportNumber) ? (long?)reportNumber : null); TextBox3.Text = dalReport.ReportNumber.ToString(); ReportDataSource rds = new ReportDataSource(); rds.Name = "MostreFabrica"; List<MostreFabrica> mostre = MostreFabrica.GetMostreFCB(DropDownList1.SelectedValue, TextBox1.Text); rds.Value = mostre; string datatestare = TextBox1.Text; string datatmin = datatestare; string datatmax = datatestare; string datatesttitlu = datatestare; string dataprimirii = ""; string datapmin = dataprimirii; string datapmax = dataprimirii; string dataprimtitlu = dataprimirii; string combi = mostre[0].Combi; foreach (MostreFabrica mf in mostre) { string datamin = mf.DataTestare; string datamax = mf.DataTestareFinala; dataprimirii = mf.DataPrimirii; if (datapmin == "") datapmin = dataprimirii; if (datapmax == "") datapmax = dataprimirii; if (datamin != datatmin) { DateTime dt1 = new DateTime(Int32.Parse(datamin.Substring(6, 4)), Int32.Parse(datamin.Substring(3, 2)), Int32.Parse(datamin.Substring(0, 2))); DateTime dt2 = new DateTime(Int32.Parse(datatmin.Substring(6, 4)), Int32.Parse(datatmin.Substring(3, 2)), Int32.Parse(datatmin.Substring(0, 2))); if (DateTime.Compare(dt1, dt2) < 0) datatmin = datamin; } if (datamax != datatmax) { DateTime dt1 = new DateTime(Int32.Parse(datamax.Substring(6, 4)), Int32.Parse(datamax.Substring(3, 2)), Int32.Parse(datamax.Substring(0, 2))); DateTime dt2 = new DateTime(Int32.Parse(datatmax.Substring(6, 4)), Int32.Parse(datatmax.Substring(3, 2)), Int32.Parse(datatmax.Substring(0, 2))); if (DateTime.Compare(dt1, dt2) > 0) datatmax = datamax; } // data primirii if (dataprimirii != datapmin) { DateTime dt1 = new DateTime(Int32.Parse(dataprimirii.Substring(6, 4)), Int32.Parse(dataprimirii.Substring(3, 2)), Int32.Parse(dataprimirii.Substring(0, 2))); DateTime dt2 = new DateTime(Int32.Parse(datapmin.Substring(6, 4)), Int32.Parse(datapmin.Substring(3, 2)), Int32.Parse(datapmin.Substring(0, 2))); if (DateTime.Compare(dt1, dt2) < 0) datapmin = dataprimirii; } if (dataprimirii != datapmax) { DateTime dt1 = new DateTime(Int32.Parse(dataprimirii.Substring(6, 4)), Int32.Parse(dataprimirii.Substring(3, 2)), Int32.Parse(dataprimirii.Substring(0, 2))); DateTime dt2 = new DateTime(Int32.Parse(datapmax.Substring(6, 4)), Int32.Parse(datapmax.Substring(3, 2)), Int32.Parse(datapmax.Substring(0, 2))); if (DateTime.Compare(dt1, dt2) > 0) datapmax = dataprimirii; } } if (datatmin != datatmax) datatesttitlu = datatmin + " - " + datatmax; if (datapmin != datapmax) dataprimtitlu = datapmin + " si " + datapmax; else dataprimtitlu = datapmin; rds.Value = mostre; report.DataSources.Clear(); report.DataSources.Add(rds); report.ReportPath = "ReportFCB4.rdlc"; report.Refresh(); string client = DropDownList1.SelectedValue; // read fabrica SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "SELECT MostreTancuri.AdresaClient,MostreTancuri.NumeClient,MostreTancuri.Localitate,MostreTancuri.Judet,MostreTancuri.NrComanda " + "FROM MostreTancuri WHERE MostreTancuri.NumeClient='" + client + "'"; cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); string fabricastrada = mostre[0].FabriciStrada; string fabricaoras = mostre[0].FabriciOras; string fabricajudet = mostre[0].FabriciJudet; string nrcomanda = mostre[0].NrComanda; reader.Close(); cnn.Close(); string nrb = dalReport.ReportNumber.ToString(); ; //set report parameters string laborator = ddlLaborator.Items[ddlLaborator.SelectedIndex].ToString(); string responsabil = ddlResponsabil.Items[ddlResponsabil.SelectedIndex].ToString(); ReportParameter pDatatestare = new ReportParameter("datatestare", datatesttitlu); ReportParameter pDataprimirii = new ReportParameter("dataprimirii", dataprimtitlu); ReportParameter pCombi = new ReportParameter("combi", combi); ReportParameter pDatab = new ReportParameter("datab", TextBox2.Text); ReportParameter pNrb = new ReportParameter("nrb", nrb); ReportParameter pFabricanume = new ReportParameter("fabricanume", client); ReportParameter pFabricastrada = new ReportParameter("fabricastrada", fabricastrada); ReportParameter pComanda = new ReportParameter("nrcomanda", nrcomanda); ReportParameter pFabricaoras = new ReportParameter("fabricaoras", fabricaoras); ReportParameter pFabricajudet = new ReportParameter("fabricajudet", fabricajudet); ReportParameter pLaborator = new ReportParameter("laborator", laborator); ReportParameter pResponsabil = new ReportParameter("responsabil", responsabil); ReportParameter pVersiune = new ReportParameter("Versiune", new SettingManager(StaticDataHelper.FCCLDbContext).GetValueByName("ReportFCB4")); ReportParameter[] p = { pDatatestare, pDataprimirii, pCombi, pDatab, pNrb, pFabricanume, pFabricastrada, pComanda, pFabricaoras, pFabricajudet, pLaborator, pResponsabil, pVersiune }; report.SetParameters(p); file = report.Render("PDF", StaticData.DEVICE_INFO_PDF, out mimeType, out encoding, out fileExtension, out streams, out warnings); string httppath = StaticDataHelper.SettingsManager.CaleRapoarteHttp; string filepath = StaticDataHelper.SettingsManager.CaleRapoarte; string parse_client = replace_special_car(client); string raport_name = "RaportFCB" + datatestare.Replace("/", "_") + "_" + nrb + "_" + parse_client + ".pdf"; string raport_excel = "RaportFCB" + datatestare.Replace("/", "_") + "_" + nrb + "_" + parse_client + ".xls"; string path_raport_http = "http://" + Request.ServerVariables.Get("HTTP_HOST") + "/" + httppath; string pdf_link = path_raport_http + @"FCB/" + raport_name; string pdf_file = filepath + @"FCB/" + raport_name; // writefile string excel_link = path_raport_http + @"FCB/" + raport_excel; string excel_file = filepath + @"FCB/" + raport_excel; report.SetParameters(new ReportParameter("BkImage", "")); File.WriteAllBytes(pdf_file, file); dalReport.SampleCount = mostre.Count; dalReport.PageCount = PDFHelper.GetNumberOfPdfPages(pdf_file); rManager.Save(dalReport); ctx.SaveChanges(); byte[] file_xls = report.Render("EXCEL", StaticData.DEVICE_INFO_XLS, out mimeType, out encoding, out fileExtension, out streams, out warnings); File.WriteAllBytes(excel_file, file_xls); pdflink.Visible = true; pdflink.NavigateUrl = pdf_link; pdflink.Text = raport_name; xlslink.Visible = true; xlslink.NavigateUrl = excel_link; xlslink.Text = raport_excel; }
public EastJutlandParserTests() { _db = new DatabaseDataContext(); _precinct = _db.Precincts.Single(x => x.UrlName == "Oestjylland"); _reportManager = new ReportManager(_precinct); }
private List<Report> GetData(bool paged, out int count) { List<Report> reports = null; ReportManager rManager = new ReportManager(StaticDataHelper.FCCLDbContext); #region filter DateTime date; long no; DateTime? testDateStart = null; DateTime? testDateEnd = null; long? reportNoStart = null; long? reportNoEnd = null; if (!string.IsNullOrWhiteSpace(txtTDStart.Text)) { if (DateTime.TryParseExact(txtTDStart.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out date)) { testDateStart = date; } else { testDateStart = null; } } if (!string.IsNullOrWhiteSpace(txtTDEnd.Text)) { if (DateTime.TryParseExact(txtTDEnd.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out date)) { testDateEnd = date; } else { testDateEnd = null; } } if (!string.IsNullOrWhiteSpace(txtRNStart.Text)) { if (long.TryParse(txtRNStart.Text, out no)) { reportNoStart = no; } else { reportNoStart = null; } } if (!string.IsNullOrWhiteSpace(txtRNEnd.Text)) { if (long.TryParse(txtRNEnd.Text, out no)) { reportNoEnd = no; } else { reportNoEnd = null; } } #endregion if (paged) { reports = rManager.GetReportsPaged(testDateStart, testDateEnd, reportNoStart, reportNoEnd, txtON.Text, grdReports.PageIndex, grdReports.PageSize); count = rManager.GetReportsCount(testDateStart, testDateEnd, reportNoStart, reportNoEnd, txtON.Text); } else { reports = rManager.GetReportsFiltered(testDateStart, testDateEnd, reportNoStart, reportNoEnd, txtON.Text); count = reports.Count; } return reports; }
public FunenParserTestsTests() { _db = new DatabaseDataContext(); _precinct = _db.Precincts.Single(x => x.UrlName == "Fyn"); _reportManager = new ReportManager(_precinct); }
public void CreateReport() { Thread.CurrentThread.CurrentCulture.NumberFormat.NumberDecimalSeparator = "."; logger.Info(string.Format("GetMostreFerma|CreateReport")); LocalReport report = new LocalReport(); byte[] file; string mimeType, encoding, fileExtension; string[] streams; Warning[] warnings; long reportNumber; ReportManager rManager = new ReportManager(ctx); Report dalReport = rManager.GetOrCreateReport(FCCLReportType.Crotalii, ObjectId , DropDownList1.SelectedItem.Text, TestDate, PrintDate, long.TryParse(TextBox3.Text, out reportNumber) ? (long?)reportNumber : null); TextBox3.Text = dalReport.ReportNumber.ToString(); ReportDataSource rds = new ReportDataSource(); rds.Name = "MostreFabrica"; List<MostreFabrica> mostre = MostreFabrica.GetMostreFerma(DropDownList1.SelectedValue, DateTime.Parse(TextBox1.Text)); logger.Info(string.Format("GetMostreFerma|mostre cnt:{0}", mostre.Count)); rds.Value = mostre; DateTime datatestare = DateTime.Parse(TextBox1.Text); DateTime datatmin = datatestare; DateTime datatmax = datatestare; string datatesttitlu = datatestare.ToShortDateString(); DateTime datapmin = DateTime.MaxValue; DateTime datapmax = DateTime.MinValue; string dataprimtitlu; string nrcomanda = ""; string combi = mostre[0].Combi; foreach (MostreFabrica mf in mostre) { DateTime datamin = mf.DataTestare; DateTime datamax = mf.DataTestareFinala; if (mf.NrComanda.Trim() != "") nrcomanda = mf.NrComanda.Trim(); if (DateTime.Compare(datamin, datatmin) < 0) datatmin = datamin; if (DateTime.Compare(datamax, datatmax) > 0) datatmax = datamax; if (DateTime.Compare(mf.DataPrimirii, datapmin) < 0) datapmin = mf.DataPrimirii; if (DateTime.Compare(mf.DataPrimirii, datapmax) > 0) datapmax = mf.DataPrimirii; } if (datatmin != datatmax) datatesttitlu = datatmin.ToShortDateString() + " - " + datatmax.ToShortDateString(); if (datapmin != datapmax) dataprimtitlu = datapmin.ToShortDateString() + " si " + datapmax.ToShortDateString(); else dataprimtitlu = datapmin.ToShortDateString(); rds.Value = mostre; report.DataSources.Clear(); report.DataSources.Add(rds); report.ReportPath = "ReportCrotalii.rdlc"; report.Refresh(); string fermaid = DropDownList1.SelectedValue; string fermaname = DropDownList1.Items[DropDownList1.SelectedIndex].ToString(); // read fabrica SqlConnection cnn = new SqlConnection( ConfigurationManager.ConnectionStrings ["fccl2ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "SELECT Ferme_CCL.Cod,Ferme_CCL.Strada,Ferme_CCL.Numar,Ferme_CCL.Oras,Judete.Denloc " + "FROM Ferme_CCL,Judete WHERE Ferme_CCL.ID=" + fermaid + " AND Ferme_CCL.Judet=Judete.ID"; cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); string fermastrada = Convert.ToString(reader["Strada"]); string fermanumar = Convert.ToString(reader["Numar"]); string fermaoras = Convert.ToString(reader["Oras"]); string fermajudet = Convert.ToString(reader["Denloc"]); string fermacod = Convert.ToString(reader["Cod"]); reader.Close(); cnn.Close(); cmd.CommandText = "SELECT Fabrici.Nume, Ferme_CCL.FabricaID from Ferme_CCL, Fabrici " + " WHERE Ferme_CCL.ID =" + fermaid + " AND Ferme_CCL.FabricaID = Fabrici.ID"; cnn.Open(); reader = cmd.ExecuteReader(); reader.Read(); string asocid = Convert.ToString(reader["FabricaID"]); string asocnume = Convert.ToString(reader["Nume"]); reader.Close(); cnn.Close(); FermaName.Text = fermaname; FermaCod.Text = fermacod; FermaId.Text = "" + fermaid; string datab = TextBox2.Text; string nrb = dalReport.ReportNumber.ToString(); //set report parameters string laborator = ddlLaborator.Items[ddlLaborator.SelectedIndex].ToString(); string responsabil = ddlResponsabil.Items[ddlResponsabil.SelectedIndex].ToString(); ReportParameter pAsocnume = new ReportParameter("asocnume", asocnume); ReportParameter pNrcomanda = new ReportParameter("nrcomanda", nrcomanda); ReportParameter pDatatestare = new ReportParameter("datatestare", datatesttitlu); ReportParameter pDataprimirii = new ReportParameter("dataprimirii", dataprimtitlu); ReportParameter pCombi = new ReportParameter("combi", combi); ReportParameter pDatab = new ReportParameter("datab", TextBox2.Text); ReportParameter pNrb = new ReportParameter("nrb", nrb); ReportParameter pFermanume = new ReportParameter("fabricanume", fermaname); ReportParameter pFermastrada = new ReportParameter("fabricastrada", fermastrada); ReportParameter pFermanumar = new ReportParameter("fabricanumar", fermanumar); ReportParameter pFermaoras = new ReportParameter("fabricaoras", fermaoras); ReportParameter pFermajudet = new ReportParameter("fabricajudet", fermajudet); ReportParameter pLaborator = new ReportParameter("laborator", laborator); ReportParameter pResponsabil = new ReportParameter("responsabil", responsabil); ReportParameter pVersiune = new ReportParameter("Versiune", new SettingManager(StaticDataHelper.FCCLDbContext).GetValueByName("ReportCrotalii")); ReportParameter[] p ={ pDatatestare, pDataprimirii,pCombi, pNrcomanda, pDatab, pNrb, pFermanume, pFermastrada, pFermanumar, pFermaoras, pFermajudet, pAsocnume, pLaborator , pResponsabil, pVersiune }; report.SetParameters(p); file = report.Render("PDF", StaticData.DEVICE_INFO_PDF, out mimeType, out encoding, out fileExtension, out streams, out warnings); string httppath = StaticDataHelper.SettingsManager.CaleRapoarteHttp; string filepath = StaticDataHelper.SettingsManager.CaleRapoarte; fermaname = replace_special_car_null(fermaname); string nrcom = nrcomanda.Replace("/", "_"); nrcom = nrcom.Replace(".", ""); string raport_name = "Raport" + nrcom + "-" + fermaname + "_" + fermacod + "-" + datatestare.ToShortDateString().Replace("/", "") + ".pdf"; string raport_excel = "Raport" + nrcom + "-" + fermaname + "_" + fermacod + "-" + datatestare.ToShortDateString().Replace("/", "") + ".xls"; string path_raport_http = "http://" + Request.ServerVariables.Get("HTTP_HOST") + "/" + httppath; string pdf_link = path_raport_http + @"Ferme/" + raport_name; string pdf_file = filepath + @"Ferme/" + raport_name; // writefile string excel_link = path_raport_http + @"Ferme/" + raport_excel; string excel_file = filepath + @"Ferme/" + raport_excel; // Trace.Write(pdf_file); File.WriteAllBytes(pdf_file, file); logger.Info(string.Format("GetMostreFerma|pdf done")); dalReport.SampleCount = mostre.Count; dalReport.PageCount = PDFHelper.GetNumberOfPdfPages(pdf_file); rManager.Save(dalReport); ctx.SaveChanges(); logger.Info(string.Format("GetMostreFerma|saved report")); // raport excel LocalReport rapexcel = new LocalReport(); ReportDataSource rdse = new ReportDataSource(); rdse.Name = "MostreFabrica"; rdse.Value = mostre; rapexcel.DataSources.Clear(); rapexcel.DataSources.Add(rdse); rapexcel.ReportPath = "ReportCrotalii.rdlc"; rapexcel.SetParameters(p); rapexcel.Refresh(); rapexcel.SetParameters(new ReportParameter("BkImage", "")); byte[] file_xls = rapexcel.Render("EXCEL", StaticData.DEVICE_INFO_XLS, out mimeType, out encoding, out fileExtension, out streams, out warnings); // end raport excel File.WriteAllBytes(excel_file, file_xls); logger.Info(string.Format("GetMostreFerma|excel done")); int firstyear; if (int.TryParse(ConfigurationManager.AppSettings["firstyear"], out firstyear)) { // test rep. portal SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString); SqlCommand cmda = new SqlCommand("Select aspnet_Users.UserName from aspnet_users join usersinformation on aspnet_Users.userid = usersinformation.userid where usersinformation.asocid=" + asocid, connection); connection.Open(); string username = ""; using (SqlDataReader rdr = cmda.ExecuteReader()) { if (rdr.Read()) { username = rdr["UserName"].ToString(); } rdr.Close(); } connection.Close(); if (username.Length > 0) { try { MembershipUser User = Membership.Providers["PortalProvider"].GetUser(username, false); Username.Text = User.UserName; //Start generating from test date for (int year = firstyear; year <= DateTime.Now.Year; year++) { logger.Info(string.Format("GetMostreFerma|ext call year:{0}", year)); CreateReportExt(year); } } catch { } } } string raport_csv = "CSV_Registru_" + datatestare.ToShortDateString().Replace("/", "") + "_" + fermaid + "_" + fermaname + ".csv"; string csv_link = path_raport_http + @"Registru/" + raport_csv; string csv_file = filepath + @"Registru/" + raport_csv; logger.Info(string.Format("CreateReportExt|write csv file {0}", csv_file)); CreateExcelFile(mostre, csv_file); logger.Info(string.Format("GetMostreFerma|processing done")); pdflink.Visible = true; pdflink.NavigateUrl = pdf_link; pdflink.Text = raport_name; xlslink.Visible = true; xlslink.NavigateUrl = excel_link; xlslink.Text = raport_excel; csvlink.Visible = true; csvlink.NavigateUrl = csv_link; csvlink.Text = raport_csv; }
protected void Page_Load(object sender, EventArgs e) { ReportManager rm = new ReportManager(); dbData = rm.getData("Executive"); }
public CopenhagenTests() { _db = new DatabaseDataContext(); _precinct = _db.Precincts.Single(x => x.UrlName == "Koebenhavn"); _reportManager = new ReportManager(_precinct); }
public WestendTests() { _db = new DatabaseDataContext(); _precinct = _db.Precincts.Single(x => x.UrlName == "Vestegnen"); _reportManager = new ReportManager(_precinct); }
public SouthSealandParserTests() { _db = new DatabaseDataContext(); _precinct = _db.Precincts.Single(x => x.UrlName == "Sydsjaelland"); _reportManager = new ReportManager(_precinct); }