private void ExportMethod()
{
var cardReport = new CardReport();
cardReport.Export(Card, false);
MessageBox.Show("Карточка успешно экспортирована");
}
public string GetCardReport(HttpRequestMessage request)
{
try
{
var content = request.Content;
string j = content.ReadAsStringAsync().Result;
TimeWindows timeWindow = new TimeWindows();
timeWindow = JsonConvert.DeserializeObject <TimeWindows>(j);
if (timeWindow.admin.check())
{
CardReport cardReport = new CardReport();
cardReport.GetCardReport(timeWindow.fromDate, timeWindow.toDate);
if (cardReport != null)
{
return(JsonConvert.SerializeObject(cardReport));
}
}
return(null);
}
catch (Exception exc)
{
Console.WriteLine(exc.ToString());
logger.Error(exc.ToString());
return(null);
}
}
public void CardReportExportTest()
{
var cardRepository = new CardRepository();
var card = cardRepository.GetById(23, true);
var templateFileName = "C:\\Work\\Stock\\Stock.Report\\bin\\Debug\\Templates\\passportTemplate.docx";
var outFileName = "C:\\Work\\Stock\\Stock.Report\\bin\\Debug\\Export\\passportTemplate.docx";
var cardReport = new CardReport();
cardReport.Export(templateFileName, outFileName, card, false);
}
public void CalculateCardSet()
{
Dictionary <Card, int> cardCounter = new Dictionary <Card, int>();
foreach (Deck d in AllDecks)
{
foreach (Card c in d.ClassCards)
{
var foundCard = AllCards.Where(card => card.HearthstoneCard.Name == c.Name).FirstOrDefault();
if (foundCard == null)
{
foundCard = new CardReport()
{
HearthstoneCard = c
};
AllCards.Add(foundCard);
}
foreach (var cardReport in AllCards.Where(w => w.HearthstoneCard.Name == c.Name))
{
cardReport.CardCount++;
cardReport.DecksWithCard.Add(d);
}
}
foreach (Card c in d.NeutralCards)
{
var foundCard = AllCards.Where(card => card.HearthstoneCard.Name == c.Name).FirstOrDefault();
if (foundCard == null)
{
foundCard = new CardReport()
{
HearthstoneCard = c
};
AllCards.Add(foundCard);
}
foreach (var cardReport in AllCards.Where(w => w.HearthstoneCard.Name == c.Name))
{
cardReport.CardCount++;
cardReport.DecksWithCard.Add(d);
}
}
}
}
public CardReport GetCardReport(RequestCardReport requestCard)
{
try
{
CardReport cardReport = new CardReport();
string sql2 = string.Format("SELECT * from TicketMonth s left JOIN (select ID, MAX(RowID) as 'RowID' from TicketMonth GROUP BY ID) t on s.ID = t.ID where t.RowID = s.RowID and s.ProcessDate between '{0}' and '{1}'", requestCard.fromDate.ToString("yyyy-MM-dd"), requestCard.toDate.ToString("yyyy-MM-dd"));
List <string> report = new List <string>();
List <SmartCard> M1 = new List <SmartCard>();
List <SmartCard> M2 = new List <SmartCard>();
List <TicketMonthResult> ticketMonthResults1 = new List <TicketMonthResult>();
List <TicketMonthResult> ticketMonthResults2 = new List <TicketMonthResult>();
using (DB db = new DB("M1"))
{
M1 = db.SmartCards.Where(x => x.DayUnlimit <= requestCard.toDate).ToList();
ticketMonthResults1 = db.Database.SqlQuery <TicketMonthResult>(sql2).ToList();
}
using (DB db = new DB("M2"))
{
M2 = db.SmartCards.Where(x => x.DayUnlimit <= requestCard.toDate).ToList();
ticketMonthResults2 = db.Database.SqlQuery <TicketMonthResult>(sql2).ToList();
}
cardReport.Total = M1.Count() + M2.Count();
cardReport.TotalUsing = M1.Count(x => x.Using == true) + M2.Count(x => x.Using == true);;
cardReport.TotalBlock = cardReport.Total - cardReport.TotalUsing;
cardReport.TotalTicketMonth = ticketMonthResults1.Count() + ticketMonthResults2.Count();
cardReport.TotalGuest = cardReport.Total - cardReport.TotalTicketMonth;
cardReport.TotalStopUsingTicketMonth = ticketMonthResults1.Count(x => x.Status == 3) + ticketMonthResults2.Count(x => x.Status == 3);
cardReport.TotalBlackTicketMonth = ticketMonthResults1.Count(x => x.Status == 4) + ticketMonthResults2.Count(x => x.Status == 4);
cardReport.TotalTicketMonthUsing = cardReport.TotalTicketMonth - (cardReport.TotalStopUsingTicketMonth + cardReport.TotalBlackTicketMonth);
return(cardReport);
}
catch
{
throw new NullReferenceException();
}
}
// GET: Report/PrintCards
public async Task <ActionResult> GetAllCards(int competitionId)
{
var userId = Convert.ToInt32(User.Identity.Name);
var canReport = await _competitionService.CanReportCards(competitionId, userId);
if (!canReport)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var competitors = await _competitorService.GetCompetitorsCard(competitionId, userId);
if (competitors.Count < 1)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var competitionLogo = await _competitionService.GetLogoImage(competitionId);
var pdfListStream = new List <Stream>();
foreach (var xx in competitors.Select(competitor => CardReport.Generate(competitor, competitionLogo.Logo, competitionLogo.CompetitionName)))
{
xx.Flush();
xx.Position = 0;
pdfListStream.Add(xx);
}
var technicalStaffs = await _techTechnicalStaffService.GetTechnicalStaffsCards(competitionId, userId);
foreach (var xx in technicalStaffs.Select(technicalStaff => TechnicalStaffCardReport.Generate(technicalStaff, competitionLogo.Logo, competitionLogo.CompetitionName)))
{
xx.Flush();
xx.Position = 0;
pdfListStream.Add(xx);
}
var commonTechnicalStaffs = await _techTechnicalStaffService.GetCommonTechnicalStaffsCards(competitionId, userId);
foreach (var xx in commonTechnicalStaffs.Select(technicalStaff => TechnicalStaffCardReport.Generate(technicalStaff, competitionLogo.Logo, competitionLogo.CompetitionName)))
{
xx.Flush();
xx.Position = 0;
pdfListStream.Add(xx);
}
var stream = new MemoryStream();
new MergePdfDocuments
{
DocumentMetadata = new DocumentMetadata {
Author = "دانشگاه آزاد اسلامی واحد نجف آباد", Application = "IAUN Sports System", Keywords = "کارتهای شرکت کنندگان مسابقه", Subject = "کارتهای شرکت کنندگان مسابقه", Title = "کارتهای شرکت کنندگان مسابقه"
},
WriterCustomizer = info =>
{
info.ImportedPage.PdfWriter.CloseStream = false;
},
InputFileStreams = pdfListStream,
OutputFileStream = stream,
AttachmentsBookmarkLabel = "Attachment(s) ",
}
.PerformMerge();
stream.Flush(); //Always catches me out
stream.Position = 0; //Not sure if this is required
return(File(stream, "application/pdf", "Cards.pdf"));
}
