public static void FillProductsComboBox(InvoiceForm f)
{
DataTable medecines;
try
{
if (f.comboBox1.SelectedValue == null)
{
MessageBox.Show("please select a Supplier");
}
else
{
object[,] Params = new object[2, 1];
Params[0, 0] = "@S_ID";
Params[1, 0] = f.comboBox1.SelectedValue;
medecines = dt.GetData_StoredProcedure("GetMedecinesINDVBySupplier", Params, "medecines");
medecines.Columns.Add("Info");
foreach (DataRow item in medecines.Rows)
{
item["Info"] = item["Name"].ToString() + " - " + item["Dosage"].ToString() + " - " + item["Volume"].ToString();
}
Filling.FillComboBox(f.myComboBox11, medecines, "ID", "Info");
}
}
catch { MessageBox.Show("ERROR!!"); }
}
public static void FillSupplierComboBox(InvoiceForm f)
{
DataTable suppliers;
suppliers = dt.GetData_StoredProcedure("GetSuppliersNames", "suppliers");
Filling.FillComboBox(f.comboBox1, suppliers, "ID", "Supplier");
}
public IActionResult CreateInvoice([FromBody] InvoiceForm form)
{
Error error = new Error();
var invoiceId = _invoiceManager.CreateInvoice(form.MapToCore(), ref error);
if (error.ErrorCode != ErrorCode.OKAY)
{
return(BadRequest(error.Message));
}
return(Ok(new { InvoiceId = invoiceId }));
}
private void Invoice_Click(object sender, EventArgs e)
{
if (invoiceForm == null || invoiceForm.IsDisposed)
{
invoiceForm = new InvoiceForm();
invoiceForm.Show();
invoiceForm.MdiParent = this;
}
else
{
invoiceForm.Activate();
}
}
public bool WritePDFReport(string FilePath)
{
//try
//{
// Create a invoice form with the sample invoice data
InvoiceForm invoice = new InvoiceForm(FilePath + "\\Invoice.xml");
// Create a MigraDoc document
Document document = invoice.CreateDocument();
document.UseCmykColor = true;
// #if DEBUG
// // for debugging only...
// MigraDoc.DocumentObjectModel.IO.DdlWriter.WriteToFile(document, "MigraDoc.mdddl");
// document = MigraDoc.DocumentObjectModel.IO.DdlReader.DocumentFromFile("MigraDoc.mdddl");
// #endif
// Create a renderer for PDF that uses Unicode font encoding
PdfDocumentRenderer pdfRenderer = new PdfDocumentRenderer(true);
// Set the MigraDoc document
pdfRenderer.Document = document;
// Create the PDF document
pdfRenderer.RenderDocument();
// Save the PDF document...
string filename = FilePath + "\\Invoice.pdf";
//#if DEBUG
// // I don't want to close the document constantly...
// filename = "Invoice-" + Guid.NewGuid().ToString("N").ToUpper() + ".pdf";
//#endif
pdfRenderer.Save(filename);
// ...and start a viewer.
// Process.Start(filename);
//}
//catch (Exception ex)
//{
// ex.
// //Console.WriteLine(ex.Message);
// //Console.ReadLine();
//}
return true;
}
public IActionResult EditInvoice([FromBody] InvoiceForm form)
{
Error error = new Error();
_invoiceManager.RemoveCityExpensesFromInvoice(form.CityExpensesToRemove);
_invoiceManager.RemoveInvoiceAccounts(form.InvoiceAccountsToRemove);
var invoice = _invoiceManager.EditInvoice(form.MapToCore(), ref error);
if (error.ErrorCode != ErrorCode.OKAY)
{
return(BadRequest(error.Message));
}
var response = InvoiceDetails.MapFromObject(invoice);
return(Ok(response));
}
public static void AddRow_InvoiceDataGridView(InvoiceForm f)
{
DataTable medecinesData;
object[,] Params = new object[2, 1];
Params[0, 0] = "@M_ID";
Params[1, 0] = f.myComboBox11.ComboBoxSelectedValue;
medecinesData = dt.GetData_StoredProcedure("GetMedecineByID_Invoice", Params, "medecines");
string id = medecinesData.Rows[0]["ID"].ToString();
string name = (string)medecinesData.Rows[0]["Name"];
string Price = medecinesData.Rows[0]["Price"].ToString();
string Discount = medecinesData.Rows[0]["Discount"].ToString() + "%";
string quantity = "1";
string VAT = "0";
string TotalPrice = ((float.Parse(Price)) * ((100 - float.Parse(Discount.Replace("%", ""))) / 100) * (int.Parse(quantity))).ToString();
f.dataGridView11.Rows.Add(id, name, "", VAT, quantity, Price, Discount, TotalPrice);
}
private static void Main()
{
try
{
// Create a invoice form with the sample invoice data
InvoiceForm invoice = new InvoiceForm("../../invoice.xml");
// Create a MigraDoc document
Document document = invoice.CreateDocument();
document.UseCmykColor = true;
#if DEBUG
// for debugging only...
MigraDoc.DocumentObjectModel.IO.DdlWriter.WriteToFile(document, "MigraDoc.mdddl");
document = MigraDoc.DocumentObjectModel.IO.DdlReader.DocumentFromFile("MigraDoc.mdddl");
#endif
// Create a renderer for PDF that uses Unicode font encoding
PdfDocumentRenderer pdfRenderer = new PdfDocumentRenderer(true);
// Set the MigraDoc document
pdfRenderer.Document = document;
// Create the PDF document
pdfRenderer.RenderDocument();
// Save the PDF document...
string filename = "Invoice.pdf";
#if DEBUG
// I don't want to close the document constantly...
filename = "Invoice-" + Guid.NewGuid().ToString("N").ToUpper() + ".pdf";
#endif
pdfRenderer.Save(filename);
// ...and start a viewer.
//Process.Start(filename)
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.ReadLine();
}
}
public static void Save_Invoice(InvoiceForm f)
{
//save Invoice
try
{
if (f.bunifuDatepicker1.Value != null && (f.Textbox1ID.Text != "" || f.Textbox1ID.Text != null))
{
//save Invoiec
int InvID = int.Parse(f.Textbox1ID.Text);
DateTime InvDate = f.bunifuDatepicker1.Value;
int InvSupplier = int.Parse(f.comboBox1.SelectedValue.ToString());
Invoice inv = new Invoice(InvID, InvDate, InvSupplier);
inv.AddInvoice(dt);
//save InvoiceDetails
InvoiceDetails invDetails;
foreach (DataGridViewRow r in f.dataGridView11.Rows)
{
string MedecineID = r.Cells["ProductID"].Value.ToString();
string VAT = r.Cells["VAT"].Value.ToString();
string Price = r.Cells["Price"].Value.ToString();
string Discount = r.Cells["Discount"].Value.ToString();
string quantity = r.Cells["Quantity"].Value.ToString();
string expiryDate = r.Cells["Date"].Value.ToString();
invDetails = new InvoiceDetails(MedecineID, InvID, quantity, Price, VAT.Replace("%", ""), expiryDate, Discount.Replace("%", ""));
invDetails.AddInvoiceDetails(dt);
Stocks.UpdateStocks(dt, int.Parse(MedecineID), int.Parse(quantity));
}
}
else
{
MessageBox.Show("Please Fill ID and Date ");
}
}
catch
{
//ADD DELETE FUNCTION
MessageBox.Show("ERROR!!");
}
}
public override void Run()
{
InvoiceForm invoiceForm = new InvoiceForm();
InvoiceItemForm itemForm = new InvoiceItemForm();
IInvoiceRepository invoiceDao = new NHibernateInvoiceRepository();
IVehicleTripRepository tripDao = new NHibernateVehicleTripRepository();
ICustomerRepository customerDao = new NHibernateCustomerRepository();
IItemRepository itemDao = new NHibernateItemRepository();
IAccountRepository accountDao = new NHibernateAccountRepository();
invoiceForm.VehicleTripsList += delegate { invoiceForm.VehicleTrips = tripDao.FindAll(); };
invoiceForm.AccountsList += delegate { invoiceForm.Accounts = accountDao.FindAccountsReceivables(); };
invoiceForm.CustomersList += delegate { invoiceForm.Customers = customerDao.FindActive(); };
itemForm.ItemFind += delegate(object sender, ItemEventArgs e) {
IList <Item> items = itemDao.FindByName(e.Item.Name);
if (items.Count == 1)
{
itemForm.InvoiceItem.Item = items[0];
}
else
{
// TODO: Add item list of value!
}
};
invoiceForm.ItemAdding += delegate(object sender, InvoiceItemEventArgs e) {
itemForm.InvoiceItem = e.InvoiceItem;
if (WorkbenchSingleton.AddDialog(itemForm) == DialogResult.OK)
{
invoiceForm.Invoice.AddItem(itemForm.InvoiceItem);
}
};
invoiceForm.InvoiceSaveAndClose += delegate(object sender, InvoiceEventArgs e) {
invoiceDao.SaveOrUpdate(e.Invoice);
invoiceForm.Close();
};
WorkbenchSingleton.AddChild(invoiceForm);
}
// Make a new invoice with the products in the room.
private void nieuweOfferteToolStripMenuItem_Click(object sender, EventArgs e)
{
bool inactiveProducts = false;
for (int i = 0; i < DesignPanel1.rDesign.productList.Count; i++)
{
if (!DesignPanel1.rDesign.productList[i].active)
{
inactiveProducts = true;
}
}
if (!inactiveProducts)
{
InvoiceForm ivf = new InvoiceForm(DesignPanel1.rDesign, this);
ivf.InstantiateAutocompleteLists();
ivf.FillExistingCustomerList();
ivf.ShowDialog();
}
else
{
MessageBox.Show("Er staan inactieve producten in uw ontwerp. Wilt u deze verwijderen?", "Foutmelding", MessageBoxButtons.OK);
}
}
internal static string CreateInvoice(long userId, string status, string transid, string paymentmethod, ProductInfo productInfo, ProductPriceInfo ppi)
{
string companyName = string.Empty;
string userPath = String.Empty;
string password = HttpContext.Current.Session["access"] as string;
UserInfo userInfo = null;
ClientInfo clientInfo = null;
using (Database db = new MySqlDatabase())
{
userPath = db.GetUserDocumentPath(userId, password);
userPath = userPath.Replace("\\", "/");
if (!Directory.Exists(userPath))
Directory.CreateDirectory(userPath);
userInfo = db.GetUser(userId, password);
clientInfo = db.GetClientInfo(userId);
companyName = clientInfo.CompanyName;
}
// complete userPath with document name
string filename = String.Format("INV{0}.pdf", transid);
userPath = Path.Combine(userPath, filename);
// Get the invoice template from the proper location
string templatePath = Resource.InvoiceTemplate;
string invoiceTemplate = HttpContext.Current.Server.MapPath(templatePath);
try
{
InvoiceForm form = new InvoiceForm(invoiceTemplate);
string culture = "nl-NL";
if (HttpContext.Current.Session["culture"] != null)
culture = HttpContext.Current.Session["culture"] as string;
CultureInfo cultureInfo = new CultureInfo(culture);
List<string> fields = new List<string>();
fields.Add(clientInfo.GetFullName());
fields.Add(clientInfo.AddressLine1);
if (!string.IsNullOrEmpty(clientInfo.AddressLine2))
fields.Add(clientInfo.AddressLine2);
string tmpResidence = clientInfo.ZipCode + " " + clientInfo.City.ToUpper();
if (!string.IsNullOrEmpty(tmpResidence))
fields.Add(tmpResidence);
if (!string.IsNullOrEmpty(clientInfo.Country))
fields.Add(clientInfo.Country);
while (fields.Count < 5)
fields.Add(" ");
form.ClientAddress = fields.ToArray();
form.InvoiceDate = DateTime.Now.ToString("d", cultureInfo);
form.InvoiceNumber = transid;
using (Database db = new MySqlDatabase())
{
Transaction transaction = db.GetTransaction(Util.UserId, transid);
foreach (TransactionLine tl in transaction.TransactionLines)
{
form.InvoiceLines.Add(new PdfInvoiceLine()
{
Description = tl.Description,
Quantity = tl.Quantity,
UnitPrice = tl.Price,
VatRate = tl.VatPercentage
});
}
}
form.GenerateInvoice(userPath, companyName);
}
catch (Exception ex)
{
Logger.Instance.Write(LogLevel.Error, ex, "[CreateInvoice]");
}
SendInvoice(userId, userPath);
return userPath;
}
public override void Run()
{
var form = new InvoiceForm(invoice);
WorkbenchSingleton.AddChild(form);
}
