private int insertToDB()
{
DTO.Invoice invoice = new DTO.Invoice();
System.Collections.ArrayList details = new System.Collections.ArrayList();
for (int i = 0; i < grdItems.Rows.Count; i++)
{
DTO.InvoiceDetail d = new DTO.InvoiceDetail();
DTO.Product p = new DTO.Product();
p.Productid = int.Parse(grdItems.Rows[i].Cells[7].Value.ToString());
d.Quantity = int.Parse(grdItems.Rows[i].Cells[2].Value.ToString());
d.Priceout = decimal.Parse(grdItems.Rows[i].Cells[3].Value.ToString());
d.Dicount = decimal.Parse(grdItems.Rows[i].Cells[4].Value.ToString());
d.Pricein = decimal.Parse(grdItems.Rows[i].Cells[8].Value.ToString());
d.Product = p;
details.Add(d);
}
DTO.Member member = new DTO.Member();
member.Memberid = (int)cboMember.SelectedValue; ///
invoice.Staff = UserSession.Session.Staff;
invoice.Member = member;
invoice.Remark = "";
invoice.Discount = decimal.Parse(txtDiscount.Text.Replace("%", "").Replace(" ",""));
invoice.InvoiceDetail = details;
return new DAO.InvoiceDAO().addInvoice(invoice);
}
public byte[] WriteInvoiceToPdf(DTO.Invoice invoice, string language)
{
var currentCulture = System.Threading.Thread.CurrentThread.CurrentCulture;
try
{
if (language == "fr")
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("fr-FR");
}
var templatePath = $@"{Gitos.DTO.FileSettings.Default.GitosTemplates}{invoice.Client.Language}\InvoiceTemplate.html";
var htmlTemplate = File.ReadAllText(templatePath);
var css = File.ReadAllText($@"{Gitos.DTO.FileSettings.Default.GitosTemplates}\Invoice.css");
htmlTemplate = htmlTemplate.Replace("{logoPath}", $@"{Gitos.DTO.FileSettings.Default.GitosTemplates}\Images\Gitos_Logo.png");
var pdfBytes = Gitos.Pdf.PdfTools.WriteHtmlToPdf(htmlTemplate, css);
return(pdfBytes);
}
catch (Exception ex)
{
throw ex;
}
finally
{
System.Threading.Thread.CurrentThread.CurrentCulture = currentCulture;
}
}
public Invoice(DTO.Invoice invoice, Company company)
{
Name = invoice.Name;
Amount = invoice.Amount;
Type = invoice.Type;
Company = company;
CreatedDate = DateTime.Now.ToString();
}
private string GetInvoicesTable(DTO.Invoice invoice)
{
var sb = new StringBuilder();
foreach (var item in invoice.InvoiceLines)
{
sb.AppendLine($@"<tr>");
sb.AppendLine($@"<td>{item.Description}</td>");
sb.AppendLine($@"<td>{item.Units}</td>");
sb.AppendLine($@"<td>{item.Price.ToEuroString()}</td>");
sb.AppendLine($@"<td style=""text-align:right"">{item.Total.ToEuroString()}</td>");
sb.AppendLine($@"</tr>");
}
return(sb.ToString());
}
