public void DownloadAttachment(HttpContext context, int id)
{
FuelOrderInvoices invoice = new FuelOrderInvoices();
invoice.Id = id;
invoice.GetAttachmentFile();
DownloadFileFromBinary(context, invoice.ContentType, invoice.InvoiceName, invoice.InvoiceData);
}
public FuelOrderInvoices GetAttachmentFile()
{
FuelOrderInvoices fileInfo = new FuelOrderInvoices();
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Id", Id));
using (SqlDataReader reader = ExecutionHelper.ExecuteReader("up_Select_FuelOrderInvoice", parameters))
{
if (ConnectionHelper.IsReadingOneRowSuccessful(reader))
{
fileInfo.ContentType = reader["ContentType"].ToString();
fileInfo.InvoiceData = (byte[])reader["InvoiceData"];
SetProperties(reader);
}
}
return(fileInfo);
}