public void Init()
{
this._mockRepository = new Mock <IRepository>();
this._mockDialogService = new Mock <IDialogService>();
this._mockWordService = new Mock <IWordService>();
this._billItemEditViewModel = new BillItemEditViewModel(this._mockRepository.Object, this._mockDialogService.Object, this._mockWordService.Object);
}
public void Cleanup()
{
this._mockRepository = null;
this._mockDialogService = null;
this._mockWordService = null;
this._billItemEditViewModel = null;
GC.Collect();
}
public void CreateWordBill(BillItemEditViewModel billItemEditViewModel, bool visible)
{
if (File.Exists(Settings.Default.WordTemplateFilePath) == false)
{
throw new Exception(Resources.Exception_Message_NoPathToBillTemplate);
}
if (Directory.Exists(Settings.Default.BillFolderPath) == false)
{
throw new Exception(Resources.Exception_Message_NoPathToBillFolder);
}
this._wordApp = new Application {
DisplayAlerts = WdAlertLevel.wdAlertsNone
};
// Represents the path to the word template.
object pathWordTemplate = Settings.Default.WordTemplateFilePath;
// These objects represent word settings.
object readOnly;
object isVisible;
// Set Word to be (not) visble.
if (visible)
{
readOnly = false;
isVisible = true;
// Set Word to be visble.
this._wordApp.Visible = true;
}
else
{
readOnly = false;
isVisible = false;
// Set Word to be not visble.
this._wordApp.Visible = false;
}
// Open the word document.
this._wordDoc = this._wordApp.Documents.Open(ref pathWordTemplate, ref this._oMissing, ref readOnly, ref this._oMissing, ref this._oMissing,
ref this._oMissing, ref this._oMissing, ref this._oMissing, ref this._oMissing, ref this._oMissing, ref this._oMissing, ref isVisible, ref this._oMissing, ref this._oMissing, ref this._oMissing, ref this._oMissing);
// Activate the document.
this._wordDoc.Activate();
// check if saveable, before filling in datas
this._wordDoc.SaveAs(Path.Combine(Settings.Default.BillFolderPath, Resources.BillFileName));
// Find Place Holders and Replace them with values.
this.FindAndReplace(this._wordApp, "<Anrede>", billItemEditViewModel.CurrentBillDetailViewModel.Title.ToString());
if (string.IsNullOrEmpty(billItemEditViewModel.CurrentBillDetailViewModel.CompanyName))
{
var range = this._wordDoc.Content;
if (range.Find.Execute("<Firmenname>"))
{
range.Expand(WdUnits.wdSentence); // or change to .wdSentence or .wdParagraph
range.Delete();
}
}
else
{
this.FindAndReplace(this._wordApp, "<Firmenname>", billItemEditViewModel.CurrentBillDetailViewModel.CompanyName);
}
this.FindAndReplace(this._wordApp, "<Vorname>", billItemEditViewModel.CurrentBillDetailViewModel.FirstName);
this.FindAndReplace(this._wordApp, "<Nachname>", billItemEditViewModel.CurrentBillDetailViewModel.LastName);
this.FindAndReplace(this._wordApp, "<Strasse>", billItemEditViewModel.CurrentBillDetailViewModel.Street);
this.FindAndReplace(this._wordApp, "<Hausnummer>", billItemEditViewModel.CurrentBillDetailViewModel.HouseNumber);
this.FindAndReplace(this._wordApp, "<PLZ>", billItemEditViewModel.CurrentBillDetailViewModel.PostalCode);
this.FindAndReplace(this._wordApp, "<Ort>", billItemEditViewModel.CurrentBillDetailViewModel.City);
this.FindAndReplace(this._wordApp, "<Rechnungsart>", billItemEditViewModel.CurrentBillDetailViewModel.KindOfBill.ToString());
this.FindAndReplace(this._wordApp, "<Datum>", billItemEditViewModel.CurrentBillDetailViewModel.Date);
this.FindAndReplace(this._wordApp, "<Rechnungsnummer>", billItemEditViewModel.CurrentBillDetailViewModel.Id);
this.FindAndReplace(this._wordApp, "<Kundennummer>", billItemEditViewModel.CurrentBillDetailViewModel.ClientId);
this.FindAndReplace(this._wordApp, "<Netto>", $"{billItemEditViewModel.NettoSum:N2} €");
this.FindAndReplace(this._wordApp, "<MwSt%> ", billItemEditViewModel.CurrentBillDetailViewModel.VatPercentage);
this.FindAndReplace(this._wordApp, "<MwSt>", $"{billItemEditViewModel.VatSum:N2} €");
this.FindAndReplace(this._wordApp, "<Brutto>", $"{billItemEditViewModel.BruttoSum:N2} €");
this.FindAndReplace(this._wordApp, "<Angebot>", Settings.Default.Offer);
// The bookmark where the table will be inserted.
object bookmarkTableStart = "tableStart";
// Creates a new instance of a table.
var wrdRng = this._wordDoc.Bookmarks.get_Item(ref bookmarkTableStart).Range;
// Adds the table to the word document.
var objTable = this._wordDoc.Tables.Add(wrdRng, billItemEditViewModel.BillItemDetailViewModels.Count + 1, 7, ref this._oMissing, ref this._oMissing);
// Sets the preferred width for the columns
objTable.Columns.PreferredWidthType = WdPreferredWidthType.wdPreferredWidthPercent;
// Pos
objTable.Columns[1].PreferredWidth = 6;
// Article number
objTable.Columns[2].PreferredWidth = 10;
// Description
objTable.Columns[3].PreferredWidth = 45;
// Amount
objTable.Columns[4].PreferredWidth = 6;
// Price
objTable.Columns[5].PreferredWidth = 11;
// Discount
objTable.Columns[6].PreferredWidth = 8;
// Sum
objTable.Columns[7].PreferredWidth = 14;
// Sets the preferred width of the whole table and centers the table
objTable.PreferredWidthType = WdPreferredWidthType.wdPreferredWidthPercent;
objTable.PreferredWidth = 100;
objTable.Rows.Alignment = WdRowAlignment.wdAlignRowCenter;
// Sets up the header for the cell
objTable.Rows[1].Range.Font.Bold = 1;
objTable.Rows[1].Range.Font.Size = 11;
objTable.Rows[1].Range.Font.Name = "Calibri";
objTable.Rows[1].AllowBreakAcrossPages = 0;
objTable.Cell(1, 1).Range.Text = "Pos.";
objTable.Cell(1, 2).Range.Text = "Artikelnr.";
objTable.Cell(1, 3).Range.Text = "Bezeichnung";
objTable.Cell(1, 4).Range.Text = "Anz.";
objTable.Cell(1, 5).Range.Text = "Preis";
objTable.Cell(1, 6).Range.Text = "Rabatt";
objTable.Cell(1, 7).Range.Text = "Gesamtpreis";
// Changes the background color of the header and centers the text
for (var i = 1; i <= 7; i++)
{
objTable.Cell(1, i).Range.Shading.BackgroundPatternColor = (WdColor)ColorTranslator.ToOle(Color.LightGray);
objTable.Cell(1, i).Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphCenter;
}
// Fills in all the billDetails and sets the row height.
for (var i = 2; i <= billItemEditViewModel.BillItemDetailViewModels.Count + 1; i++)
{
objTable.Cell(i, 1).Range.Text = billItemEditViewModel.BillItemDetailViewModels[i - 2].Position.ToString();
objTable.Cell(i, 1).Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphCenter;
objTable.Cell(i, 2).Range.Text = billItemEditViewModel.BillItemDetailViewModels[i - 2].ArticleNumber.ToString();
objTable.Cell(i, 2).Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphCenter;
objTable.Cell(i, 3).Range.Text = billItemEditViewModel.BillItemDetailViewModels[i - 2].Description;
objTable.Cell(i, 4).Range.Text = $"{billItemEditViewModel.BillItemDetailViewModels[i - 2].Amount:####.##}";
objTable.Cell(i, 4).Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphCenter;
objTable.Cell(i, 5).Range.Text = $"{billItemEditViewModel.BillItemDetailViewModels[i - 2].Price:N2} €";
objTable.Cell(i, 5).Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphRight;
objTable.Cell(i, 6).Range.Text = $"{billItemEditViewModel.BillItemDetailViewModels[i - 2].Discount:#0} %";
objTable.Cell(i, 6).Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphCenter;
objTable.Cell(i, 7).Range.Text = $"{billItemEditViewModel.BillItemDetailViewModels[i - 2].Sum:N2} €";
objTable.Cell(i, 7).Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphRight;
objTable.Rows[i].AllowBreakAcrossPages = 0;
}
// Sets the border
objTable.Rows[1].Borders[WdBorderType.wdBorderTop].LineStyle = WdLineStyle.wdLineStyleSingle;
objTable.Rows[1].Borders[WdBorderType.wdBorderBottom].LineStyle = WdLineStyle.wdLineStyleSingle;
objTable.Rows[billItemEditViewModel.BillItemDetailViewModels.Count + 1].Borders[WdBorderType.wdBorderBottom].LineStyle = WdLineStyle.wdLineStyleSingle;
for (var i = 1; i <= 7; i++)
{
objTable.Columns[i].Borders[WdBorderType.wdBorderLeft].LineStyle = WdLineStyle.wdLineStyleSingle;
objTable.Columns[i].Borders[WdBorderType.wdBorderRight].LineStyle = WdLineStyle.wdLineStyleSingle;
}
// save again when all datas were filled in
this._wordDoc.SaveAs(Path.Combine(Settings.Default.BillFolderPath, Resources.BillFileName));
}
