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()); }