private async void btnSearch_Click(object sender, EventArgs e)
{
var request = new ListingSearchRequest
{
Approved = true,
City = txtCity.Text,
};
if (IsStartDateNull)
{
request.StartDate = null;
}
else
{
request.StartDate = dtpStart.Value;
}
if (IsEndDateNull)
{
request.EndDate = null;
}
else
{
request.EndDate = dtpEnd.Value;
}
var result = await _listingService.Get <List <Listing> >(request);
dgvListings.AutoGenerateColumns = false;
dgvListings.DataSource = result;
}
private async void ucListings_Load(object sender, EventArgs e)
{
var request = new ListingSearchRequest {
Approved = true
};
var result = await _listingService.Get <List <Listing> >(request);
dgvListings.AutoGenerateColumns = false;
dgvListings.DataSource = result;
}
private async void ucHighestRatedListings_Load(object sender, EventArgs e)
{
var request = new ListingSearchRequest {
Approved = true
};
var result = await _listingService.Get <List <Listing> >(request);
result = result.OrderByDescending(x => x.AverageRating).ToList();
dgvListings.AutoGenerateColumns = false;
dgvListings.DataSource = result;
}
private async void btnSearch_Click(object sender, EventArgs e)
{
var request = new ListingSearchRequest
{
Approved = true,
City = txtCity.Text,
};
var result = await _listingService.Get <List <Listing> >(request);
dgvListings.AutoGenerateColumns = false;
dgvListings.DataSource = result;
}
private async void ucApproveListings_Load(object sender, EventArgs e)
{
var request = new ListingSearchRequest {
Approved = false
};
var result = await _listingService.Get <List <Listing> >(request);
dgvListings.AutoGenerateColumns = false;
dgvListings.DataSource = result;
var count = result.Count;
txtCount.Text = count.ToString();
}
public List <Model.Listing> Get(ListingSearchRequest request)
{
var query = _context.Listing.Include(x => x.Territory).Include(x => x.User).AsQueryable();
if (request != null)
{
query = query.Where(x => x.Approved == request.Approved);
if (!string.IsNullOrWhiteSpace(request.City))
{
query = query.Where(x => x.City.StartsWith(request.City));
}
if (request.StartDate != null)
{
query = query.Where(x => x.DateApproved > request.StartDate);
}
if (request.EndDate != null)
{
query = query.Where(x => x.DateApproved < request.EndDate);
}
}
var list = query.Select(x => new Model.Listing
{
Address = x.Address,
AreaDescription = x.AreaDescription,
Bathrooms = x.Bathrooms,
Beds = x.Beds,
City = x.City,
DateCreated = x.DateCreated,
DateApproved = x.DateApproved,
ListingDescription = x.ListingDescription,
Name = x.Name,
Persons = x.Persons,
TerritoryName = x.Territory.Name,
UserName = x.User.FirstName + " " + x.User.LastName,
ListingId = x.ListingId,
AverageRating = _context.Rating.Where(y => y.ListingId == x.ListingId).Average(y => y.RatingValue)
}).ToList();
return(list);
}
private async void btnPDF_Click(object sender, EventArgs e)
{
var request = new ListingSearchRequest
{
Approved = true,
City = txtCity.Text,
};
if (IsStartDateNull)
{
request.StartDate = null;
}
else
{
request.StartDate = dtpStart.Value;
}
if (IsEndDateNull)
{
request.EndDate = null;
}
else
{
request.EndDate = dtpEnd.Value;
}
var tableData = await _listingService.Get <List <Listing> >(request);
var month = DateTime.Now.ToString("MM");
var year = DateTime.Now.ToString("yyyy");
var fileName = "detaljiOglasa_" + month + "_" + year + ".pdf";
var path = "..\\..\\Data\\Reports\\izvjestaj_" + fileName;
PdfWriter writer = new PdfWriter(path);
PdfDocument pdf = new PdfDocument(writer);
Document document = new Document(pdf);
Paragraph header = new Paragraph("Izvještaj za mjesec: " + month + ". " + year + ". godine")
.SetTextAlignment(TextAlignment.CENTER)
.SetFontSize(20);
document.Add(header);
document.Add(new Paragraph(new Text("\n")));
document.Add(new Paragraph("Broj aktivnih oglasa po gradovima"))
.SetTextAlignment(TextAlignment.CENTER)
.SetFontSize(15);
float[] columnWidths = { 1, 2, 2, 2, 2, 2 };
Table table = new Table(UnitValue.CreatePercentArray(columnWidths));
table.SetHorizontalAlignment(iText.Layout.Properties.HorizontalAlignment.CENTER);
Cell[] headerFooter = new Cell[] {
new Cell().SetTextAlignment(TextAlignment.CENTER).SetBackgroundColor(new DeviceGray(0.75f)).Add(new Paragraph("RB.")),
new Cell().SetTextAlignment(TextAlignment.CENTER).SetBackgroundColor(new DeviceGray(0.75f)).Add(new Paragraph("Naziv")),
new Cell().SetTextAlignment(TextAlignment.CENTER).SetBackgroundColor(new DeviceGray(0.75f)).Add(new Paragraph("Lokacija")),
new Cell().SetTextAlignment(TextAlignment.CENTER).SetBackgroundColor(new DeviceGray(0.75f)).Add(new Paragraph("Kanton")),
new Cell().SetTextAlignment(TextAlignment.CENTER).SetBackgroundColor(new DeviceGray(0.75f)).Add(new Paragraph("Korisnik")),
new Cell().SetTextAlignment(TextAlignment.CENTER).SetBackgroundColor(new DeviceGray(0.75f)).Add(new Paragraph("Datum objave"))
};
foreach (Cell hfCell in headerFooter)
{
table.AddHeaderCell(hfCell);
}
int counter = 1;
tableData = tableData.ToList();
if (tableData != null)
{
foreach (var row in tableData)
{
table.AddCell(new Cell().SetTextAlignment(TextAlignment.CENTER).Add(new Paragraph(counter++.ToString())));
table.AddCell(new Cell().SetTextAlignment(TextAlignment.CENTER).Add(new Paragraph(row.Name)));
table.AddCell(new Cell().SetTextAlignment(TextAlignment.CENTER).Add(new Paragraph(row.City)));
table.AddCell(new Cell().SetTextAlignment(TextAlignment.CENTER).Add(new Paragraph(row.TerritoryName)));
table.AddCell(new Cell().SetTextAlignment(TextAlignment.CENTER).Add(new Paragraph(row.UserName)));
table.AddCell(new Cell().SetTextAlignment(TextAlignment.CENTER).Add(new Paragraph(row.DateApproved.ToString("dd/MM/yyyy"))));
}
}
document.Add(table);
document.Close();
MessageBox.Show("Izvjestaj uspjesno kreiran!");
}
public ActionResult <List <Model.Listing> > Get([FromQuery] ListingSearchRequest request)
{
return(_service.Get(request));
}
