public void SetUp()
{
document = new MigraDocCore.DocumentObjectModel.Document();
// Workaround for a quirk in the migradoc API.
_ = document.AddSection().Elements;
pdfBuilder = new PdfBuilder(document, PdfOptions.Default);
pdfBuilder.UseTagRenderer(new MockTagRenderer());
renderer = new ParagraphTagRenderer();
}
public IActionResult OnGet(string PDF)
{
ActiveRecord = new SessionActive();
// get the session data
ActiveRecord.Active_SessionID = HttpContext.Session.GetString(Session_SessionID);
ActiveRecord.Active_EmailAddress = HttpContext.Session.GetString(Session_EmailAddress);
ActiveRecord.Active_FirstName = HttpContext.Session.GetString(Session_FirstName);
ActiveRecord.Active_ModLevel = HttpContext.Session.GetInt32(Session_ModLevel);
// check if a session exists
if (string.IsNullOrEmpty(ActiveRecord.Active_EmailAddress) && string.IsNullOrEmpty(ActiveRecord.Active_FirstName) && string.IsNullOrEmpty(ActiveRecord.Active_SessionID))
{
ActiveRecord.Active_Sesson = false;
// redirect to login if no session exists
return(RedirectToPage("/Login/Login"));
}
else
{
ActiveRecord.Active_Sesson = true;
if (ActiveRecord.Active_ModLevel != 1)
{
//if not a an admin redirect to user account page
return(RedirectToPage("/Users/Index"));
}
}
//connect to database
DBConnect G24database_connection = new DBConnect();
string DBconnection = G24database_connection.DatabaseString();
SqlConnection connect = new SqlConnection(DBconnection);
connect.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = connect;
// selects all users from the User database
command.CommandText = @"SELECT * FROM Users";
// filters users from the database if filter exists
if (!(string.IsNullOrEmpty(Type) || Type == "ALL"))
{
command.CommandText += " WHERE ModLevel = @accType";
command.Parameters.AddWithValue("@accType", Convert.ToInt32(Type));
}
// execte the database command
SqlDataReader reader = command.ExecuteReader();
UserRecords = new List <User>();
// loop though returned data
while (reader.Read())
{
User record = new User();
record.UserID = reader.GetInt32(0);
record.FirstName = reader.GetString(1);
record.LastName = reader.GetString(2);
record.EmailAddress = reader.GetString(3);
record.Password = reader.GetString(4);
record.ModLevel = reader.GetInt32(5);
UserRecords.Add(record);
}
reader.Close();
// if PDF is set in the url
if (PDF == "1")
{
//Create an object for the PDF document
Document doc = new Document();
Section sec = doc.AddSection();
Paragraph para = sec.AddParagraph();
//Add a picture to the pdf
ImageSource.ImageSourceImpl = new ImageSharpImageSource <Rgba32>();
Paragraph para2 = sec.AddParagraph();
var picpath = Path.Combine(_env.WebRootPath, "Files", "UserPhoto.png");
var image = para2.AddImage(ImageSource.FromFile(picpath));
image.Width = Unit.FromCentimeter(17); // define picture width
para2.Format.SpaceAfter = Unit.FromCentimeter(2); // define the space after the image
// define the font type size and colour
para.Format.Font.Name = "Arial";
para.Format.Font.Size = 14;
para.Format.Font.Color = Color.FromCmyk(0, 0, 0, 100); //black colour
// add title
para.AddFormattedText("User Report : ", TextFormat.Bold);
// add space after the title
para.Format.SpaceAfter = "1.0cm";
// set-up table define padding, and borders
Table tab = new Table();
tab.Borders.Width = 0.75;
tab.TopPadding = 5;
tab.BottomPadding = 5;
// sets up the columns within the ta table
Column col = tab.AddColumn(Unit.FromCentimeter(1.5));
col.Format.Alignment = ParagraphAlignment.Justify;
tab.AddColumn(Unit.FromCentimeter(4));
tab.AddColumn(Unit.FromCentimeter(4));
tab.AddColumn(Unit.FromCentimeter(6));
tab.AddColumn(Unit.FromCentimeter(1.5));
// creates a row for the table header and sets a background colour
Row row = tab.AddRow();
row.Shading.Color = Colors.Green;
//sets up the table headers
Cell cell = new Cell();
cell = row.Cells[0];
cell.AddParagraph("User ID");
cell = row.Cells[1];
cell.AddParagraph("First Name");
cell = row.Cells[2];
cell.AddParagraph("Last Name");
cell = row.Cells[3];
cell.AddParagraph("Email");
cell = row.Cells[4];
cell.AddParagraph("Mod Level");
//Add data to table loops through the user record array
for (int i = 0; i < UserRecords.Count; i++)
{
row = tab.AddRow();
cell = row.Cells[0];
cell.AddParagraph(Convert.ToString(UserRecords[i].UserID));
cell = row.Cells[1];
cell.AddParagraph(UserRecords[i].FirstName);
cell = row.Cells[2];
cell.AddParagraph(UserRecords[i].LastName);
cell = row.Cells[3];
cell.AddParagraph(UserRecords[i].EmailAddress);
cell = row.Cells[4];
cell.AddParagraph(Convert.ToString(UserRecords[i].ModLevel));
}
// sets the border of the page
tab.SetEdge(0, 0, 4, (UserRecords.Count + 1), Edge.Box, BorderStyle.Single, 1, Colors.Gray);
sec.Add(tab);
//renders the PDF
PdfDocumentRenderer pdfRen = new PdfDocumentRenderer();
pdfRen.Document = doc;
pdfRen.RenderDocument();
//creates a memory stream
MemoryStream stream = new MemoryStream();
pdfRen.PdfDocument.Save(stream); //saving the file into the stream
Response.Headers.Add("content-disposition", new[] { "inline; filename = UserRecord.pdf" });
return(File(stream, "application/pdf")); //directs to the PDF
}
}
return(Page());
}
public void SetUp()
{
document = new Document();
document.AddSection();
}