public Dictionary <string, string> Get(TypeReport type, int idTransaction) { Dictionary <string, string> result = new Dictionary <string, string>(); switch (type) { case TypeReport.Akt: { //result = new AktTransactionPrintedDocumentTemplate(idTransaction, null).LabelValues(); } break; case TypeReport.Cash: //result = new CashReport(idTransaction).GetKeyValue(); break; case TypeReport.Commission: //result = new CommissionReport(idTransaction).GetKeyValue(); break; case TypeReport.Credit: //result = new CreditReport(idTransaction).GetKeyValue(); break; case TypeReport.DKP: //result = new DkpReport(idTransaction).GetKeyValue(); break; } return(result); }
public List <TypeReport> TypeWiseReport(DateTime firstDate, DateTime secondDate) { SqlConnection connection = new SqlConnection(connectionString); string query = "spTypeWiseReport '" + firstDate + "','" + secondDate + "'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <TypeReport> testReport = new List <TypeReport>(); while (reader.Read()) { TypeReport report = new TypeReport(); report.TestType = reader["Name"].ToString(); report.TotalNoTest = int.Parse(reader["TotalCount"].ToString()); report.TotalAmount = double.Parse(reader["Amount"].ToString()); testReport.Add(report); } reader.Close(); connection.Close(); return(testReport); }
public ConfiguringReportWindow(TypeReport typeReport = TypeReport.Simple) { InitializeComponent(); try { var assembly = Assembly.GetExecutingAssembly(); var resourceName = assembly.GetManifestResourceNames().Single(s => s.EndsWith("icon.ico")); using (Stream stream = assembly.GetManifestResourceStream(resourceName)) { if (stream != null) { Icon = BitmapFrame.Create(stream); } } } catch (Exception ex) { Clipboard.SetText(ex.ToString()); } typeReportBox.ItemsSource = ReportNameCollection.Collection; typeReportBox.DisplayMemberPath = "Name"; CurrentReport = new Report(); CurrentReport.Options.CreateOptionsChangedEvent += Options_CreateOptionsChangedEvent; CurrentReport.Options.TypeReportChangedEvent += TypeReportChangedEventHandler; CurrentReport.Options.TypeReport = typeReport; sortingParamsList.ItemContainerGenerator.StatusChanged += ItemContainerGenerator_StatusChanged; typeReportBox.SelectedItem = CurrentReport.Options.ReportName; configureGrid.DataContext = CurrentReport; }
public static ReportName GetReportName(TypeReport typeReport) { for (var i = 0; i < Collection.Count; i++) { if (Collection[i].Type == typeReport) { return(Collection[i]); } } return(null); }
public void Save(TypeReport type, DateTime startDate, DateTime endDate) { switch (type) { case TypeReport.Report: CreateReport1(startDate, endDate); break; default: break; } }
public decimal CreateBody(Document doc, TypeReport typeReport, IEnumerable <EventEmployeeEntity> model) { var table = new PdfPTable(5); //--------------------------------------------------------------- AddEmptyParagraph(doc, 3); table.WidthPercentage = 100; //--------------------------------------------------------------- AddCell(table, FontBold, 1, $"Назва {GetEventName(typeReport)}"); AddCell(table, FontBold, 1, "Розмір дотації"); AddCell(table, FontBold, 1, "Розмір знижки"); AddCell(table, FontBold, 1, "Дата початку"); AddCell(table, FontBold, 1, "Дата закінчення"); foreach (var ev in model) { AddCell(table, Font, 1, $"{ev.Name}"); AddCell(table, Font, 1, $"{ev.Amount} {Сurrency}"); AddCell(table, Font, 1, $"{ev.Discount} {Сurrency}"); AddCell(table, Font, 1, $"{ev.StartDate:dd/MM/yyyy}"); AddCell(table, Font, 1, $"{ev.EndDate:dd/MM/yyyy}"); } doc.Add(table); //--------------------------------------------------------------- var sumAmount = model.Sum(x => x.Amount); var sumDiscount = model.Sum(x => x.Discount); var generalSum = sumAmount + sumDiscount; doc.Add(new Paragraph($"Сумма дотацій - {sumAmount} {Сurrency}", Font) { Alignment = Element.ALIGN_RIGHT }); doc.Add(new Paragraph($"Сумма знижок - {sumDiscount} {Сurrency}", Font) { Alignment = Element.ALIGN_RIGHT }); doc.Add(new Paragraph($"Загальна сумма - {generalSum} {Сurrency}", Font) { Alignment = Element.ALIGN_RIGHT }); return(generalSum); }
private void AddAllGeneralSum(TypeReport predicate, IElementListener doc) { if (predicate == TypeReport.All) { var sum = _materialAidEmployeesGeneralSum + _awardEmployeesGeneralSum + _culturalEmployeesGeneralSum + _travelEventEmployeesGeneralSum + _wellnessEventEmployeesGeneralSum + _tourEventEmployeesGeneralSum + _giftEmployeesGeneralSum; doc.Add(new Paragraph($"Cумма - {sum} {Сurrency}", Font) { Alignment = Element.ALIGN_RIGHT }); AddEmptyParagraph(doc, 2); } }
public Dictionary <string, string> Get(TypeReport type, int idTransaction) { Dictionary <string, string> result = new Dictionary <string, string>(); string queryTemplateCommand = $"SELECT запрос FROM ТИПЫ_ШАБЛОНОВ WHERE код = {(int) type}"; string queryTemplate = database.Query(queryTemplateCommand).Rows[0][0].ToString(); var table = database.Query($"{queryTemplate} {idTransaction}"); for (int iColumn = 0; iColumn < table.Columns.Count; iColumn++) { result.Add(table.Columns[iColumn].ColumnName, table.Rows[0][iColumn].ToString()); } return(result); }
private string GetEventName(TypeReport typeEvent) { switch (typeEvent) { case TypeReport.Travel: return("Поїздки"); case TypeReport.Wellness: return("Оздоровлення"); case TypeReport.Tour: return("Путівки"); default: throw new ArgumentOutOfRangeException(nameof(typeEvent), typeEvent, null); } }
/// <summary> /// Construtores para criar um novo relatório /// </summary> /// <param name="typeReport"></param>Tipo de relatório a ser gerado public XFrmAddReport(TypeReport typeReport) : this() { btnRefreshGroup_Click(null, null); this._typeReport = typeReport; }
protected List <WPPlanDAO> SortResourcesByWC(List <WPPlanDAO> entriesPL, List <ACType> sortWC, TypeReport typeReport) { var tmpWpPlan = new List <WPPlanDAO>(); //по каждому критерию сортировки foreach (var sort in sortWC) { if (typeReport == TypeReport.Plan) { tmpWpPlan.AddRange(entriesPL.Where(x => x.AC_TYP == sort).OrderByDescending(x => x.StartDate)); } else { tmpWpPlan.AddRange(entriesPL.Where(x => x.AC_TYP == sort).OrderByDescending(x => x.FactStartDate)); } } return(tmpWpPlan); }
protected (DataRow dr, int counter) CreateRowByPL(DataTable dt, DataRow dr, DateTime start, DateTime dateTimeStartTO, DateTime dateTimeEndTO, int counter, string resource, string resourceName, ACType acType, TypeReport typeReports, List <WPPlanDAO> entriesPL) { if (typeReports == TypeReport.Plan) { foreach (var entryPL in entriesPL) { dr = dt.NewRow(); dr["id"] = counter; var differenceBetweenTwoStartDates = dateTimeStartTO.DifferenceBetweenTwoDates(entryPL.StartDate); var differenceBetweenTwoStartDatesInHours = entryPL.StartDate.Date.DifferenceBetweenTwoDatesInHours(entryPL.StartDate); if (differenceBetweenTwoStartDates >= 0 && differenceBetweenTwoStartDatesInHours >= 0) { dr["start"] = start.AddDays(differenceBetweenTwoStartDates).AddHours(differenceBetweenTwoStartDatesInHours); dr["arrival"] = entryPL.Arrival; } else { dr["start"] = entryPL.StartDate; dr["arrival"] = entryPL.Arrival; } var differenceBetweenTwoEndDates = dateTimeStartTO.DifferenceBetweenTwoDates(entryPL.EndDate); var differenceBetweenTwoEndDatesInHours = entryPL.EndDate.Date.DifferenceBetweenTwoDatesInHours(entryPL.EndDate); if (differenceBetweenTwoEndDates >= 0 && differenceBetweenTwoEndDatesInHours >= 0) { dr["end"] = start.AddDays(differenceBetweenTwoEndDates).AddHours(differenceBetweenTwoEndDatesInHours); dr["departure"] = entryPL.Departure; } else { dr["end"] = entryPL.EndDate; dr["departure"] = entryPL.Departure; } dr["name"] = entryPL.Description; dr["resource"] = resource; dr["color"] = entryPL.HEXColorACType; dr["wpnoi"] = entryPL.WPNO_I; dr["wpno"] = entryPL.WPNO; dr["mhr"] = entryPL.MHR; dr["bookedMHR"] = entryPL.BOOKED_MHR; dr["resourceName"] = resourceName; dr["acType"] = entryPL.AC_TYP; dr["stationName"] = entryPL.STATION_NAME; dt.Rows.Add(dr); counter++; } } else { foreach (var entryPL in entriesPL) { dr = dt.NewRow(); dr["id"] = counter; var startDate = entryPL.FactStartDate; var endDate = entryPL.FactEndDate; if (entryPL.FactStartDate == DateTime.MinValue) { startDate = entryPL.StartDate; } if (entryPL.FactEndDate == DateTime.MinValue) { endDate = entryPL.EndDate; } var differenceBetweenTwoStartDates = dateTimeStartTO.DifferenceBetweenTwoDates(startDate); var differenceBetweenTwoStartDatesInHours = startDate.Date.DifferenceBetweenTwoDatesInHours(startDate); if (differenceBetweenTwoStartDates >= 0 && differenceBetweenTwoStartDatesInHours >= 0) { dr["start"] = start.AddDays(differenceBetweenTwoStartDates).AddHours(differenceBetweenTwoStartDatesInHours); dr["arrival"] = entryPL.Arrival; } else { dr["start"] = startDate; dr["arrival"] = entryPL.Arrival; } var differenceBetweenTwoEndDates = dateTimeStartTO.DifferenceBetweenTwoDates(endDate); var differenceBetweenTwoEndDatesInHours = endDate.Date.DifferenceBetweenTwoDatesInHours(endDate); if (differenceBetweenTwoEndDates >= 0 && differenceBetweenTwoEndDatesInHours >= 0) { dr["end"] = start.AddDays(differenceBetweenTwoEndDates).AddHours(differenceBetweenTwoEndDatesInHours); dr["departure"] = entryPL.Departure; } else { dr["end"] = endDate; dr["departure"] = entryPL.Departure; } var mhrFact = entryPL.BOOKED_MHR != 0 ? $" - {entryPL.BOOKED_MHR} MH" : ""; var readiness = entryPL.CONTAINS_C_CHECK ? $"<br/>(готовность {endDate.ToShortDateString()})" : ""; var remarks = !string.IsNullOrEmpty(entryPL.INTERNAL_REMARKS) ? entryPL.INTERNAL_REMARKS + "<br/>" : "<br/>"; var name = $"{remarks}{entryPL.AC_MODEL} {entryPL.AC_REGISTR} {entryPL.Description}{mhrFact} {readiness}"; dr["name"] = name; dr["resource"] = resource; dr["color"] = entryPL.HEXColorACType; dr["wpnoi"] = entryPL.WPNO_I; dr["wpno"] = entryPL.WPNO; dr["mhr"] = entryPL.BOOKED_MHR; dr["bookedMHR"] = entryPL.BOOKED_MHR; dr["resourceName"] = resourceName; dr["acType"] = entryPL.AC_TYP; dr["stationName"] = entryPL.STATION_NAME; dt.Rows.Add(dr); counter++; } } return(dr, counter); }