private async void PechatKol(object sender, RoutedEventArgs e)
{
using (db = new Program_V1Context())
{
var databaseProcedures = new Program_V1ContextProcedures(db);
var result = await databaseProcedures.QuantityProdDepartment2Async();
var a = result.ToList();
var document = new WordDocument("ShablonKolDep2.docx", FormatType.Docx);
string[] kol = { "kol1", "kol2", "kol3", "kol4" };
string[] prod = { "prod1", "prod2", "prod3", "prod4" };
var bookmarkHelper = new BookmarkHelper(document);
bookmarkHelper.MyMethod("date", DateTime.Today.ToString("dd.MM.yyyy"));
bookmarkHelper.MyMethod("name", "Denis Agafonov");
for (int i = 0; i < a.Count; i++)
{
bookmarkHelper.MyMethod($"{prod[i]}", $"{a[i].ProductName}");
bookmarkHelper.MyMethod($"{kol[i]}", $"{a[i].Quantity}");
}
document.Save($"kolDep2.docx", FormatType.Docx);
document.Close();
MessageBox.Show("Печать завершена");
}
}
public async void LoadRequestsStore()
{
using (db = new Program_V1Context())
{
var databaseProcedures = new Program_V1ContextProcedures(db);
var result = await databaseProcedures.QuantityProdGlavMedAsync();
proguctsGrid1.ItemsSource = result.ToList();
}
}
