//Function to create Lease and save to database
private void CreateLease_Click(object sender, EventArgs e)
{
if (CheckOrderIsGood() == false)
{
return;
}
DelpinCore.Lease lease = GetLeaseFromForm();
string leaseSuccess = controller.CreateLease(lease);
if (leaseSuccess.Contains("Success"))
{
string leaseNumber = Regex.Match(leaseSuccess, @"^[^;]+").ToString();
this.leaseNumber.Text = leaseNumber;
AddOpenStatusesToComboBox();
createLease.Enabled = false;
updateLease.Enabled = true;
deleteLease.Enabled = true;
updateStatus.Enabled = true;
writeInvoice.Enabled = true;
MessageBox.Show($"Ordren blev oprettet med ordrenummer {leaseNumber}");
}
else
{
string errorMessage = Regex.Match(leaseSuccess, @"[^;]+$").ToString();
MessageBox.Show($"Der opstod en fejl ved oprettelsen af ordren:\n" + errorMessage);
}
}
private void buttonUpdateOrder_Click(object sender, EventArgs e)
{
DelpinCore.Lease lease = GetLeaseFromForm();
lease.SetLeaseID(Convert.ToInt32(leaseNumber.Text));
string isUpdateSuccess = controller.UpdateLease(lease);
MessageBox.Show(isUpdateSuccess);
}
private void FillFormWithLease(DelpinCore.Lease lease)
{
string debtorID = lease.debtorID;
if (debtorID.Length == 10)
{
personalRadioButton.Checked = true;
}
else
{
businessRadioButton.Checked = true;
}
debtorIDTextBox.Text = debtorID;
GetDebtoryByID(debtorID);
contactFirstName.Text = lease.contactFirstName;
contactLastName.Text = lease.contactLastName;
contactPhone.Text = lease.contactPhone;
leaseNumber.Text = lease.leaseID.ToString();
if (lease.active == true)
{
AddOpenStatusesToComboBox();
FillStatus(lease.status);
}
else
{
AddClosedStatusesToComboBox();
}
foreach (LeaseOrder leaseOrder in lease.GetLeaseOrders())
{
leaseOrders.Rows.Add();
int lastRow = leaseOrders.Rows.GetLastRow(DataGridViewElementStates.Visible);
leaseOrders.Rows[lastRow].Cells["ResurseID"].Value = leaseOrder.resourceID;
leaseOrders.Rows[lastRow].Cells["Resurse"].Value = leaseOrder.modelName;
leaseOrders.Rows[lastRow].Cells["Leveringsdato"].Value = leaseOrder.startDate.ToString("yyyy/MM/dd");
leaseOrders.Rows[lastRow].Cells["Slutdato"].Value = leaseOrder.endDate.ToString("yyyy/MM/dd");
leaseOrders.Rows[lastRow].Cells["Dagspris"].Value = leaseOrder.leasePrice.ToString("N2");
leaseOrders.Rows[lastRow].Cells["Levering"].Value = leaseOrder.deliveryPrice.ToString("N2");
leaseOrders.Rows[lastRow].Cells["Gade"].Value = leaseOrder.deliveryStreet;
leaseOrders.Rows[lastRow].Cells["Postkode"].Value = leaseOrder.deliveryPostalCode.ToString();
leaseOrders.Rows[lastRow].Cells["By"].Value = leaseOrder.deliveryCity;
}
}
private DelpinCore.Lease GetLeaseFromForm()
{
bool active = false;
if (leaseStatus.SelectedText != "Slettet")
{
active = true;
}
DelpinCore.Lease lease = new DelpinCore.Lease(debtorIDTextBox.Text, Utility.BranchID, active);
lease.SetContactDetails(contactFirstName.Text, contactLastName.Text, contactPhone.Text);
foreach (DataGridViewRow row in leaseOrders.Rows)
{
if (row.Cells["ResurseID"].Value == null)
{
continue;
}
int resouceID = Convert.ToInt32(row.Cells["ResurseID"].Value.ToString());
DateTime deliveryDate = Convert.ToDateTime(row.Cells["Leveringsdato"].Value.ToString());
DateTime returnDate = Convert.ToDateTime(row.Cells["Slutdato"].Value.ToString());
decimal price = Convert.ToDecimal(row.Cells["Dagspris"].Value.ToString());
decimal deliveryPrice = Convert.ToDecimal(row.Cells["Levering"].Value.ToString());
string deliveryAddrress = row.Cells["Gade"].Value.ToString();
int deliveryPostCode = 0;
try
{
deliveryPostCode = Convert.ToInt32(row.Cells["Postkode"].Value.ToString());
}
catch { }
string deliveryCity = row.Cells["By"].Value.ToString();
LeaseOrder leaseOrder = new LeaseOrder(deliveryDate, returnDate, price, resouceID);
leaseOrder.SetDeliveryAddress(deliveryAddrress, deliveryPostCode, deliveryCity, deliveryPrice);
lease.SetStatus("Åben");
lease.AddLeaseOrder(leaseOrder);
}
return(lease);
}
private void GetLeaseByLeaseID(int leaseID)
{
DelpinCore.Lease lease = controller.ReadLeaseByLeaseID(leaseID);
if (lease.debtorID == "-1")
{
MessageBox.Show("Ordren blev ikke fundet, prøv at indtaste ordrenummeret igen.");
return;
}
ClearAllTextBoxes();
FillFormWithLease(lease);
createLease.Enabled = false;
updateLease.Enabled = true;
deleteLease.Enabled = true;
updateStatus.Enabled = true;
writeInvoice.Enabled = true;
}
private string UpdateLeaseOrdersOnLease(Lease lease)
{
string deleteLeaseOrders = $"delete from LeaseOrder where LeaseID = {lease.leaseID}";
string isDeleteSuccess = DatabaseManager.CreateUpdateDeleteInDatabase(deleteLeaseOrders);
if (isDeleteSuccess != "Success")
{
return(isDeleteSuccess);
}
if (lease.GetLeaseOrders().Count == 0)
{
return("Success");
}
string insertLeaseOrder = GetLeaseOrderInsertString(lease);
string isInsertSuccess = DatabaseManager.CreateUpdateDeleteInDatabase(insertLeaseOrder);
return(isInsertSuccess);
}
public string UpdateLease(Lease lease)
{
string isUpdateSuccess = leaseManager.UpdateLease(lease);
return(isUpdateSuccess);
}
public string CreateLease(Lease lease)
{
string leaseSuccess = leaseManager.CreateLease(lease);
return(leaseSuccess);
}
//------------------------------------------------------------------------------------------------------------------------------------------------------------------
//Lease
public Lease ReadLeaseByLeaseID(int leaseID)
{
Lease lease = leaseManager.ReadLeaseByLeaseID(leaseID);
return(lease);
}
public string MakePDF(Lease lease, Business business)
{
// Her bruges classen pdfDocument.
PdfDocument document = new PdfDocument();
// Her laver jeg et pdf dokument og kalder det Faktura
document.Info.Title = "Faktura";
// Her laves en side
PdfPage page = document.AddPage();
// Get an XGraphics object for drawing
XGraphics gfx = XGraphics.FromPdfPage(page);
// Opret skrift størelse og sill
XFont companyAndDebtor = new XFont("Calibri", 10, XFontStyle.Regular);
XFont fakture = new XFont("Calibri", 20, XFontStyle.Bold);
XFont smallHeadLine = new XFont("Calibri", 10, XFontStyle.Bold);
XFont priceFat = new XFont("Calibri", 10, XFontStyle.Bold);
// Draw the text. Dette er hvad der skal være på teksten, og hvor det skal være. Der kan laves lige så mange som man vil
//Kunde Oplysninger------------------------------------------------------------------------------------------------------------------------------
gfx.DrawString($"{business.companyName}", companyAndDebtor, XBrushes.Black,
new XRect(80, -270, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString($"{business.street}", companyAndDebtor, XBrushes.Black,
new XRect(80, -260, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString($"{business.postalCode} {business.city}", companyAndDebtor, XBrushes.Black,
new XRect(80, -250, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString($"Kunde Nr: {lease.debtorID}", companyAndDebtor, XBrushes.Black,
new XRect(80, -230, page.Width, page.Height),
XStringFormats.CenterLeft);
//FAKTURA---------------------------------------------------------------------------------------------------------------------------------------
gfx.DrawString("FAKTURA", fakture, XBrushes.Black,
new XRect(80, -170, page.Width, page.Height),
XStringFormats.CenterLeft);
//Billede af Delpin----------------------------------------------------------------------------------------------------------------------------
var image = DelpinCore.Properties.Resources.Delpinlogo;
System.IO.MemoryStream stream = new System.IO.MemoryStream();
image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
XImage xImage = XImage.FromStream(stream);
gfx.DrawImage(xImage, 405, 35);
//Firma informationer----------------------------------------------------------------------------------------------------------------------------
gfx.DrawString("Nordvesthavnsvej 60 ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -300, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString("6400 Sønderborg ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -290, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString("Tlf 74 48 88 88 ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -280, page.Width, page.Height),
XStringFormats.CenterRight);
//BankOplysninger------------------------------------------------------------------------------------------------------------------------------
gfx.DrawString("Bank ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -250, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString("Reg. Nr:9735 ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -240, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString("Konto Nr:4571973602842330 ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -230, page.Width, page.Height),
XStringFormats.CenterRight);
//Fakture Nr dato og betalings dato------------------------------------------------------------------------------------------------------------
gfx.DrawString($"Faktura Nr.{lease.leaseID} ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -180, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString($"{lease.dateCreated.ToShortDateString()} ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -170, page.Width, page.Height),
XStringFormats.CenterRight);
//Headlines Resurce Antal Pris Beløb-----------------------------------------------------------------------------------------------------------
gfx.DrawString("Vare ", smallHeadLine, XBrushes.Black,
new XRect(80, -130, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString("Antal Dage ", smallHeadLine, XBrushes.Black,
new XRect(0, -130, page.Width, page.Height),
XStringFormats.Center);
gfx.DrawString("Daglig Lejepris ", smallHeadLine, XBrushes.Black,
new XRect(80, -130, page.Width, page.Height),
XStringFormats.Center);
gfx.DrawString("Levering ", smallHeadLine, XBrushes.Black,
new XRect(150, -130, page.Width, page.Height),
XStringFormats.Center);
gfx.DrawString("Beløb ", smallHeadLine, XBrushes.Black,
new XRect(-60, -130, page.Width, page.Height),
XStringFormats.CenterRight);
//Navn på vare antal pris beløb-------------------------------------------------------------------------------------------------------------
gfx.DrawString("___________________________________________________________________________________________ ", smallHeadLine, XBrushes.Black,
new XRect(80, -125, page.Width, page.Height),
XStringFormats.CenterLeft);
//Her oprettes en variabel som sættes til 0
int lineSpace = 0;
for (int i = 0; i < lease.GetLeaseOrders().Count; i++)
{
//Her bliver Variablen sat til 15. så hver gange der bliver kørt GetLeaseOrders(tilføjet en ny vare linje bliver der pludset 15 til y aksens position)
lineSpace = 15 * i;
gfx.DrawString($"{lease.GetLeaseOrders()[i].modelName}", companyAndDebtor, XBrushes.Black,
new XRect(80, -110 + lineSpace, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString($"{lease.GetLeaseOrders()[i].GetDaysRented()}", companyAndDebtor, XBrushes.Black,
new XRect(0, -110 + lineSpace, page.Width, page.Height),
XStringFormats.Center);
gfx.DrawString($"Kr. {lease.GetLeaseOrders()[i].leasePrice} ", companyAndDebtor, XBrushes.Black,
new XRect(80, -110 + lineSpace, page.Width, page.Height),
XStringFormats.Center);
gfx.DrawString($"Kr. {lease.GetLeaseOrders()[i].deliveryPrice}", companyAndDebtor, XBrushes.Black,
new XRect(150, -110 + lineSpace, page.Width, page.Height),
XStringFormats.Center);
gfx.DrawString($"Kr. {lease.GetLeaseOrders()[i].GetTotalPrice()}", companyAndDebtor, XBrushes.Black,
new XRect(-60, -110 + lineSpace, page.Width, page.Height),
XStringFormats.CenterRight);
}
gfx.DrawString("___________________________________________________________________________________________ ", smallHeadLine, XBrushes.Black,
new XRect(80, -100 + lineSpace, page.Width, page.Height),
XStringFormats.CenterLeft);
//Hvis det er erhvers person
if (business.CVR.Length == 8)
{
gfx.DrawString("Total: ", priceFat, XBrushes.Black,
new XRect(400, -20 + lineSpace, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString($"Kr. {lease.GetTotalPrice()} ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -20 + lineSpace, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString("___________________________ ", smallHeadLine, XBrushes.Black,
new XRect(400, -15 + lineSpace, page.Width, page.Height),
XStringFormats.CenterLeft);
}
//Hvis det er Privat person
else
{
gfx.DrawString("Netto: ", companyAndDebtor, XBrushes.Black,
new XRect(400, -20 + lineSpace, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString("Moms (25%): ", companyAndDebtor, XBrushes.Black,
new XRect(400, -5 + lineSpace, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString("Total: ", priceFat, XBrushes.Black,
new XRect(400, 10 + lineSpace, page.Width, page.Height),
XStringFormats.CenterLeft);
gfx.DrawString($"Kr. {lease.GetTotalPrice()} ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -20 + lineSpace, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString($"Kr. {Moms(lease.GetTotalPrice())} ", companyAndDebtor, XBrushes.Black,
new XRect(-60, -5 + lineSpace, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString($"Kr. {endPrice(Moms(lease.GetTotalPrice()), lease.GetTotalPrice())} ", priceFat, XBrushes.Black,
new XRect(-60, 10 + lineSpace, page.Width, page.Height),
XStringFormats.CenterRight);
gfx.DrawString("___________________________ ", smallHeadLine, XBrushes.Black,
new XRect(400, 15 + lineSpace, page.Width, page.Height),
XStringFormats.CenterLeft);
}
//Her Laves navnet på filen
string filename = $"Faktura{lease.leaseID}.pdf";
try
{
//Dette er til at gemme pdf
document.Save(filename);
}
catch (Exception)
{
return("Filen kan ikke gemmes");
}
//Dette er til at vise PDF
Process.Start(filename);
return("Success");
}
