private void SendMailQ(HeaderQ Header, List <PlantMail> Mails, MemoryStream ExcelFile)
{
var to = Header.Email;
var subject = this.AppSet("Mail-Subject");
var bcc = this.GetMails(Mails, "BCC");
var cc = this.GetMails(Mails, "CC");
var body = this.GetMailTemplate("Mail-Template");
SendMail(to, subject, body, bcc, cc, ExcelFile, "Cotización.xlsx", "application/vnd.ms-excel");
}
private MemoryStream GetExcel(int Id, HeaderQ Header, List <Product> Body)
{
var path = System.Web.HttpContext.Current.Server.MapPath("~/Content/template/" + this.AppSet("Excel-Template"));
var fileinfo = new FileInfo(path);
var newFile = new FileInfo(System.Web.HttpContext.Current.Server.MapPath("~/Content/template/otro.xlsx"));
ExcelPackage package = new ExcelPackage(fileinfo, true);
ExcelWorksheet ws = package.Workbook.Worksheets[1];
ws.Cells[2, 1].Value = "Cotización: " + Id.ToString().PadLeft(10, '0');
ws.Cells[2, 3].Style.WrapText = true;
ws.Cells[2, 3].Value = Header.AddressPlant + Environment.NewLine +
"Teléfono: " + Header.PhonePlant +
(string.IsNullOrEmpty(Header.CellPhonePlant) ? string.Empty : " Celular: " + Header.CellPhonePlant);
ws.Cells[3, 1].Value = Header.Name;
for (int i = 0; i < Body.Count; i++)
{
var record = Body[i];
var row = i + 5;
ws.Cells[row, 1].Value = record.IdProduct;
ws.Cells[row, 2].Value = record.Name;
ws.Cells[row, 3].Value = record.Kg;
ws.Cells[row, 4].Value = record.Min;
ws.Cells[row, 5].Value = record.Price;
ws.Cells[row, 6].Value = record.Quantity;
ws.Cells[row, 7].Value = record.TotalKg;
ws.Cells[row, 8].Value = record.Total;
}
return(new MemoryStream(package.GetAsByteArray()));
}
