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