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("Печать завершена");
}
}
private void PechatZaprosa(object sender, RoutedEventArgs e)
{
if (proguctsGrid3.IsVisible == true)
{
if (proguctsGrid3.SelectedItem != null)
{
var b = (ClassHelperRequest)proguctsGrid3.SelectedItem;
using (db = new Program_V1Context())
{
var RequestsQuery = from s in db.Requests
join g in db.RequestsProducts on s.IdRequest equals g.IdRequest
join o in db.Products on g.IdProduct equals o.IdProduct
join r in db.Stores on s.SroreАppointment equals r.IdStore
join y in db.Departments on r.IdDepartment equals y.IdDepartment
where s.SroreАppointment == 4 && s.StoreSource == 2 && g.IdRequest == b.IdRequest
select new ClassHelperRequest()
{
IdRequest = s.IdRequest,
SroreАppointment = y.TypeDepartment,
Date = s.Date.ToString(),
Name = o.Name,
Quantity = (int)g.Quantity
};
var a = RequestsQuery.ToList();
var document = new WordDocument("ShablonDlyaZakazaDep2.docx", FormatType.Docx);
string[] kol = { "kol1", "kol2", "kol3", "kol4" };
string[] date = { "date1", "date2", "date3", "date4" };
string[] prod = { "prod1", "prod2", "prod3", "prod4" };
var bookmarkHelper = new BookmarkHelper(document);
bookmarkHelper.MyMethod("zakaz", b.IdRequest.ToString());
bookmarkHelper.MyMethod("date", DateTime.Today.ToString("dd.MM.yyyy"));
bookmarkHelper.MyMethod("name", "Denis Agafonov");
for (int i = 0; i < a.Count; i++)
{
bookmarkHelper.MyMethod($"{date[i]}", $"{a[i].Date}");
bookmarkHelper.MyMethod($"{prod[i]}", $"{a[i].Name}");
bookmarkHelper.MyMethod($"{kol[i]}", $"{a[i].Quantity}");
}
document.Save($"Zapros_{b.IdRequest}.docx", FormatType.Docx);
document.Close();
MessageBox.Show("Печать завершена");
}
}
else
{
MessageBox.Show("Выбирите таблицу \"Добавленные\" и запись в ней");
}
}
else
{
MessageBox.Show("Выбирите таблицу \"Добавленные\" и запись в ней");
}
}
