protected void Load_Events()
{
EventsDataContext edc = new EventsDataContext();
var events = (from e in edc.tblEvents_Cafes
where e.EventDateTime >= DateTime.Now && e.VenueCity.Trim() == city.Trim() && (e.VenueName.Contains("Café") || e.VenueName.Contains("Cafe"))
orderby e.EventDateTime
select new {
EventName = e.EventName,
EventDate = e.EventDate,
EventTime = e.EventTime,
Description = edc.tblEvents_Cafe_Descriptions.OrderBy(d => d.Priority).Where(d => d.Keywords.ToLower() == e.EventName.ToLower()).Select(d => d.Description).First(), // edc.tblEvents_Cafe_Descriptions.OrderBy(d => d.Priority).Where(d => d.Keywords.ToLower() == e.EventName.ToLower() || d.Keywords.ToLower().CompareTo(e.EventName.ToLower()) >= 0).Select(d => d.Description).First()
}).Take(showcount);
lstvwEvents.DataSource = events;
lstvwEvents.DataBind();
}
public EventsController(EventsDataContext context, ILookupEmployees employeeService)
{
_context = context;
_employeeService = employeeService;
}
public RepositoryBase()
{
_context = new EventsDataContext();
_dbSet = _context.Set <T>();
}
public EventRegistrationsController(EventsDataContext context)
{
_context = context;
}
public EventRegistrationController(EventsDataContext context, EventRegistrationChannel channel)
{
_context = context;
_channel = channel;
}
//Begin gridview for pdf
protected void btnExportPDF_Click(object sender, EventArgs e)
{
gvEventCaf.AllowPaging = Convert.ToBoolean(rbPaging.SelectedItem.Value);
EventsDataContext edc = new EventsDataContext();
var events = (from f in edc.tblEvents_Cafes
where f.EventDateTime >= DateTime.Now && f.VenueCity.Trim() == city.Trim() && (f.VenueName.Contains("Café") || f.VenueName.Contains("Cafe"))
orderby f.EventDateTime
select new
{
EventName = f.EventName,
EventDate = f.EventDate,
EventTime = f.EventTime,
VenueName = f.VenueName,
Description = edc.tblEvents_Cafe_Descriptions.OrderBy(d => d.Priority).Where(d => d.Keywords.ToLower() == f.EventName.ToLower()).Select(d => d.Description).First(), // edc.tblEvents_Cafe_Descriptions.OrderBy(d => d.Priority).Where(d => d.Keywords.ToLower() == e.EventName.ToLower() || d.Keywords.ToLower().CompareTo(e.EventName.ToLower()) >= 0).Select(d => d.Description).First()
}).Take(showcount);
gvEventCaf.DataSource = events;
gvEventCaf.DataBind();
//Create a table
iTextSharp.text.Table table = new iTextSharp.text.Table(gvEventCaf.Columns.Count);
table.Cellpadding = 5;
//Set the column widths
int[] widths = new int[gvEventCaf.Columns.Count];
for (int x = 0; x < gvEventCaf.Columns.Count; x++)
{
widths[x] = (int)gvEventCaf.Columns[x].ItemStyle.Width.Value;
string cellText = Server.HtmlDecode(gvEventCaf.HeaderRow.Cells[x].Text);
iTextSharp.text.Cell cell = new iTextSharp.text.Cell(cellText);
cell.BackgroundColor = new Color(System.Drawing.ColorTranslator.FromHtml("#25925c"));
table.AddCell(cell);
}
table.SetWidths(widths);
//Transfer rows from GridView to table
for (int i = 0; i < gvEventCaf.Rows.Count; i++)
{
if (gvEventCaf.Rows[i].RowType == DataControlRowType.DataRow)
{
for (int j = 0; j < gvEventCaf.Columns.Count; j++)
{
string cellText = Server.HtmlDecode(gvEventCaf.Rows[i].Cells[j].Text);
iTextSharp.text.Cell cell = new iTextSharp.text.Cell(cellText);
//Set Color of Alternating row
if (i % 2 != 0)
{
cell.BackgroundColor = new Color(System.Drawing.ColorTranslator.FromHtml("#C2D69B"));
}
table.AddCell(cell);
}
}
}
//Create the PDF Document
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
Paragraph chunk = new Paragraph("Calendar of Events for " + city + "Cafe");
pdfDoc.Add(chunk);
pdfDoc.Add(table);
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=CafeCalendar.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
Response.End();
}
public BaseBOLEvents()
{
dataContext = new EventsDataContext();
}
