public string ToHtml()
{
var report = EmbadedResources.GetEmbeddedResource("Mashkanta.Reports.Report.html");
var table1 = EmbadedResources.GetEmbeddedResource("Mashkanta.Reports.Table1.html");
var courses = Courses.ToHtml();
var summery = Summery.ToHtml();
table1 = table1.Replace("@@TITLE@@", Course.GetCourseTitle(Course.CourseType.None));
table1 = table1.Replace("@@RATIO@@", Ratio.ToString("N2"));
table1 = table1.Replace("@@MIN_PAYMENT@@", MinMonthReturn.ToString("N2"));
table1 = table1.Replace("@@MAX_PAYMENT@@", MaxMonthReturn.ToString("N2"));
table1 = table1.Replace("@@TOTAL_PAYMENT@@", TotalReturn.ToString("N2"));
table1 = table1.Replace("@@INTEREST@@", TotalInterestAndPriceIndex.ToString("N2"));
var tableAll = table1 + TotalPayments.ToHtml(Course.CourseType.None);
report = report.Replace("@@COURSES@@", courses);
report = report.Replace("@@SUMMERY@@", summery);
report = report.Replace("@@TABLE_ALL@@", tableAll);
report = report.Replace("@@PaymentDoughnutChart@@", new PaymentDoughnut(this, "PaymentDoughnutChart").ToHtml());
var tableCources = string.Empty;
foreach (var c in Courses)
{
tableCources += c.Result.ToHtml(c.Type);
}
report = report.Replace("@@TABLE_COURSE@@", tableCources);
return(report);
}
public string ToHtml(CourseType courseType)
{
var table1 = EmbadedResources.GetEmbeddedResource("Mashkanta.Reports.Table1.html");
table1 = table1.Replace("@@TITLE@@", Course.GetCourseTitle(courseType));
table1 = table1.Replace("@@RATIO@@", Ratio.ToString("N2"));
table1 = table1.Replace("@@MIN_PAYMENT@@", MinMonthReturn.ToString("N2"));
table1 = table1.Replace("@@MAX_PAYMENT@@", MaxMonthReturn.ToString("N2"));
table1 = table1.Replace("@@TOTAL_PAYMENT@@", TotalReturn.ToString("N2"));
table1 = table1.Replace("@@INTEREST@@", TotalInterestAndPriceIndex.ToString("N2"));
var result = $"{table1}\r\n{Payments.ToHtml(courseType)}\r\n<hr />";
return(result);
}
public void GetAttendanceStatisticsReport(DateTime fromDate, DateTime toDate)
{
SqlConn conn = new SqlConn();
List <TransactionCashRegister> transactionsCashRegister = conn.selectTransactionCashRegister("transactions_cashiermashine",
" date BETWEEN '" + fromDate.ToString("dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture) + " 0:00:00' AND '"
+ toDate.ToString("dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture) + " 23:59:59'");
List <TransactionAttractions> trasactionsAttractions = conn.selectTransactionAttractions("transactions_attractions",
" date BETWEEN '" + fromDate.ToString("dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture) + " 0:00:00' AND '"
+ toDate.ToString("dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture) + " 23:59:59'");
List <Card> cards = conn.selectCards("cards");
List <Card> oldCards = new List <Card>();
List <Card> newCards = new List <Card>();
List <Card> returnedOldCards = new List <Card>();
List <Card> returnedNewCards = new List <Card>();
foreach (Card card in cards)
{
if (transactionsCashRegister.FindAll(x => x.cardId == card.cardId).Count > 0 ||
trasactionsAttractions.FindAll(x => x.cardId == card.cardId).Count > 0)
{
if ((DateTime)card.cardRegDate <= fromDate.Date)
{
oldCards.Add(card);
}
else if ((DateTime)card.cardRegDate >= fromDate.Date && (DateTime)card.cardRegDate <= ((toDate).Date.AddDays(1)))
{
newCards.Add(card);
}
}
}
decimal addedPointsNewCards = 0, spendedPointsNewCards = 0, returnedPointsNewCards = 0, addedMoneyForNewCard = 0, returnedMoneyForNewCards = 0;
foreach (Card newCard in newCards)
{
foreach (TransactionCashRegister transactionCashRegister in transactionsCashRegister)
{
if ((int)transactionCashRegister.cardId == (int)newCard.cardId)
{
if ((int)transactionCashRegister.operation == 5 || (int)transactionCashRegister.operation == 18 || (int)transactionCashRegister.operation == 19)
{
addedPointsNewCards += (decimal)transactionCashRegister.summ;
}
if ((int)transactionCashRegister.operation == 22)
{
addedMoneyForNewCard += (decimal)transactionCashRegister.summ;
}
if ((int)transactionCashRegister.operation == 2)
{
returnedNewCards.Add(newCard);
returnedPointsNewCards += (decimal)transactionCashRegister.summ;
}
if ((int)transactionCashRegister.operation == 20)
{
returnedNewCards.Add(newCard);
returnedMoneyForNewCards += (decimal)transactionCashRegister.summ;
}
}
}
foreach (TransactionAttractions trasactionAttractions in trasactionsAttractions)
{
if ((int)trasactionAttractions.cardId == (int)newCard.cardId)
{
spendedPointsNewCards += (decimal)trasactionAttractions.summ;
}
}
}
this.registretedCards = new RegistretedCards(
newCards.Count,
addedPointsNewCards + addedMoneyForNewCard,
addedPointsNewCards,
addedMoneyForNewCard,
spendedPointsNewCards);
decimal addedPointsOldCards = 0, spendedPointsOldCards = 0, returnedPointsOldCards = 0, addedMoneyForOldCard = 0, returnedMoneyForOldCards = 0;
foreach (Card oldCard in oldCards)
{
foreach (TransactionCashRegister transactionCashRegister in transactionsCashRegister)
{
if ((int)transactionCashRegister.cardId == (int)oldCard.cardId)
{
if ((int)transactionCashRegister.operation == 5)
{
addedPointsOldCards += (decimal)transactionCashRegister.summ;
}
if ((int)transactionCashRegister.operation == 22)
{
addedMoneyForOldCard += (decimal)transactionCashRegister.summ;
}
if ((int)transactionCashRegister.operation == 2)
{
returnedOldCards.Add(oldCard);
returnedPointsOldCards += (decimal)transactionCashRegister.summ;
}
if ((int)transactionCashRegister.operation == 20)
{
returnedOldCards.Add(oldCard);
returnedMoneyForOldCards += (decimal)transactionCashRegister.summ;
}
}
}
foreach (TransactionAttractions trasactionAttractions in trasactionsAttractions)
{
if ((int)trasactionAttractions.cardId == (int)oldCard.cardId)
{
spendedPointsOldCards += (decimal)trasactionAttractions.summ;
}
}
}
this.usedCards = new UsedCards(
oldCards.Count,
addedPointsOldCards + addedMoneyForOldCard,
addedPointsOldCards,
addedMoneyForOldCard,
spendedPointsOldCards);
this.totalIncome = new TotalIncome(
oldCards.Count + newCards.Count,
addedPointsOldCards + addedMoneyForOldCard + addedPointsNewCards + addedMoneyForNewCard,
addedPointsOldCards + addedPointsNewCards,
addedMoneyForOldCard + addedMoneyForNewCard,
spendedPointsOldCards + spendedPointsNewCards);
addedPointsNewCards = 0; spendedPointsNewCards = 0;
if (returnedNewCards.Count != 0)
{
foreach (Card returnedNewCard in returnedNewCards)
{
foreach (TransactionCashRegister transactionCashRegister in transactionsCashRegister)
{
if ((int)transactionCashRegister.cardId == (int)returnedNewCard.cardId)
{
if ((int)transactionCashRegister.operation == 5)
{
addedPointsNewCards += (decimal)transactionCashRegister.summ;
}
}
}
foreach (TransactionAttractions trasactionAttractions in trasactionsAttractions)
{
if ((int)trasactionAttractions.cardId == (int)returnedNewCard.cardId)
{
spendedPointsNewCards += (decimal)trasactionAttractions.summ;
}
}
}
}
this.returnedNewCards = new ReturnedNewCards(
returnedNewCards.Count,
returnedPointsNewCards + returnedMoneyForNewCards,
returnedPointsNewCards,
returnedMoneyForNewCards,
spendedPointsNewCards);
addedPointsOldCards = 0; spendedPointsOldCards = 0;
if (returnedOldCards.Count != 0)
{
foreach (Card returnedOldCard in returnedOldCards)
{
foreach (TransactionCashRegister transactionCashRegister in transactionsCashRegister)
{
if ((int)transactionCashRegister.cardId == (int)returnedOldCard.cardId)
{
if ((int)transactionCashRegister.operation == 5)
{
addedPointsOldCards += (decimal)transactionCashRegister.summ;
}
}
}
foreach (TransactionAttractions trasactionAttractions in trasactionsAttractions)
{
if ((int)trasactionAttractions.cardId == (int)returnedOldCard.cardId)
{
spendedPointsOldCards += (decimal)trasactionAttractions.summ;
}
}
}
}
this.returnedOldCards = new ReturnedOldCards(
returnedOldCards.Count,
returnedPointsOldCards + returnedMoneyForOldCards,
returnedPointsOldCards,
returnedMoneyForOldCards,
spendedPointsOldCards);
this.totalReturn = new TotalReturn(
returnedOldCards.Count + returnedNewCards.Count,
returnedPointsOldCards + returnedMoneyForOldCards + returnedPointsNewCards + returnedMoneyForNewCards,
returnedPointsOldCards + returnedPointsNewCards,
returnedMoneyForOldCards + returnedMoneyForNewCards,
spendedPointsOldCards + spendedPointsNewCards);
}
