private void BtnSave_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (_CurrentInventory.id == 0)
{
AccountingEquipmentEntities.GetContext().Inventory.Add(_CurrentInventory);
}
try
{
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Информация сохранена");
FrameManager.MainFrame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public EditNewEquipmentPage()
{
InitializeComponent();
DataContext = _currentEquipment;
ComboManufacturer.ItemsSource = AccountingEquipmentEntities.GetContext().Manufacturer.ToList();
ComboNomenclature.ItemsSource = AccountingEquipmentEntities.GetContext().Nomenclature.ToList();
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
string Current = _currentEquipmentCard.Equipment.Model.Trim(new Char[] { ',', '*', '.', '/', '#', '@', '!', '"', '№', '$', ';'
, '%', '^', ':', '&', '?', '(', ')', '-', '+', '=', '_', '~', '`', '<', '>', '|', '{', '}', '[', ']' });
_currentEquipmentCard.Equipment.Model = Current;
Current = _currentEquipmentCard.Equipment.Manufacturer.ManufacturerName.Trim(new Char[] { ',', '*', '.', '/', '#', '@', '!', '"', '№', '$', ';'
, '%', '^', ':', '&', '?', '(', ')', '-', '+', '=', '_', '~', '`', '<', '>', '|', '{', '}', '[', ']' });
_currentEquipmentCard.Equipment.Manufacturer.ManufacturerName = Current;
Current = _currentEquipmentCard.InventNumber.Trim(new Char[] { ',', '*', '.', '/', '#', '@', '!', '"', '№', '$', ';'
, '%', '^', ':', '&', '?', '(', ')', '-', '+', '=', '_', '~', '`', '<', '>', '|', '{', '}', '[', ']' });
_currentEquipmentCard.InventNumber = Current;
Current = _currentEquipmentCard.InventNumber.Trim(new Char[] { ',', '*', '.', '/', '#', '@', '!', '"', '№', '$', ';'
, '%', '^', ':', '&', '?', '(', ')', '-', '+', '=', '_', '~', '`', '<', '>', '|', '{', '}', '[', ']' });
_currentEquipmentCard.InventNumber = Current;
if (string.IsNullOrWhiteSpace(_currentEquipmentCard.Equipment.Model))
{
errors.AppendLine("Укажите модель оборудования");
}
if (string.IsNullOrWhiteSpace(_currentEquipmentCard.InventNumber))
{
errors.AppendLine("Укажите инвентарный номер");
}
if (string.IsNullOrWhiteSpace(_currentEquipmentCard.Equipment.Manufacturer.ManufacturerName))
{
errors.AppendLine("Укажите название производителя");
}
if (_currentEquipmentCard.DateOfDelivery == null)
{
errors.AppendLine("Укажите дату получения оборудования ");
}
if (_currentEquipmentCard.Equipment.Nomenclature.NameOfNomenclature == null)
{
errors.AppendLine("Выберите номенклатуру ");
}
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (_currentEquipmentCard.id == 0)
{
AccountingEquipmentEntities.GetContext().EquipmentCard.Add(_currentEquipmentCard);
}
//try
//{
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Информация сохранена");
FrameManager.MainFrame.GoBack();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message.ToString());
//}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
if (string.IsNullOrWhiteSpace(_CurrentWorker.FirstName))
{
errors.AppendLine("Введите Фамилию");
}
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (_CurrentWorker.id == 0)
{
AccountingEquipmentEntities.GetContext().Worker.Add(_CurrentWorker);
}
//try
//{
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Информация сохранена");
FrameManager.MainFrame.GoBack();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message.ToString());
//}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
if (DPDeliver == null)
{
errors.AppendLine("Укажите дату выдачи в ремонт оборудования ");
}
if (DPBack == null)
{
errors.AppendLine("Укажите дату получения оборудования ");
}
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (_CurrentBreakdown.id == 0)
{
AccountingEquipmentEntities.GetContext().Repair.Add(_CurrentBreakdown);
}
try
{
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Информация сохранена");
FrameManager.MainFrame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
if (ComboTypeRoom.SelectedItem == null)
{
errors.AppendLine("Укажите тип помещения");
}
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (_CurrentRoom.id == 0)
{
AccountingEquipmentEntities.GetContext().Room.Add(_CurrentRoom);
}
try
{
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Информация сохранена");
FrameManager.MainFrame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
if (ComboTypeNomenclture.SelectedItem == null)
{
errors.AppendLine("Укажите вид номенклатуры");
}
if (string.IsNullOrWhiteSpace(_currentnomenclature.NameOfNomenclature))
{
errors.AppendLine("введите номенклатуру");
}
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (_currentnomenclature.id == 0)
{
AccountingEquipmentEntities.GetContext().Nomenclature.Add(_currentnomenclature);
}
try
{
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Информация сохранена");
FrameManager.MainFrame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void Page_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e)
{
if (Visibility == Visibility.Visible)
{
AccountingEquipmentEntities.GetContext().ChangeTracker.Entries().ToList().ForEach(p => p.Reload());
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Worker.ToList();
}
}
public RepairPage()
{
InitializeComponent();
Manufacturers = AccountingEquipmentEntities.GetContext().Manufacturer.ToList();
Manufacturers.Insert(0, new Manufacturer {
ManufacturerName = "All"
});
ManufacturerCmb.ItemsSource = Manufacturers;
}
public EditNomenclaturePage(Nomenclature SelectedNomeclature)
{
InitializeComponent();
if (SelectedNomeclature != null)
{
_currentnomenclature = SelectedNomeclature;
}
DataContext = _currentnomenclature;
ComboTypeNomenclture.ItemsSource = AccountingEquipmentEntities.GetContext().TypeOfNomenclature.ToList();
}
public WorkerPage()
{
InitializeComponent();
statusOfs = AccountingEquipmentEntities.GetContext().StatusOfWorker.ToList();
statusOfs.Insert(0, new StatusOfWorker {
NameOfStatus = "Все работники"
});
FilteCmb.ItemsSource = statusOfs;
DataContext = _CurrentWorker;
}
public EditRoomPage(Room SelectedRoom)
{
InitializeComponent(); if (SelectedRoom != null)
{
_CurrentRoom = SelectedRoom;
}
DataContext = _CurrentRoom;
ComboTypeRoom.ItemsSource = AccountingEquipmentEntities.GetContext().TypeOfRoom.ToList();
}
public EditWorkerPage(Worker SeletedWorker)
{
InitializeComponent(); if (SeletedWorker != null)
{
_CurrentWorker = SeletedWorker;
}
DataContext = _CurrentWorker;
ComboGender.ItemsSource = AccountingEquipmentEntities.GetContext().Gender.ToList();
ComboPosition.ItemsSource = AccountingEquipmentEntities.GetContext().Position.ToList();
ComboStatus.ItemsSource = AccountingEquipmentEntities.GetContext().StatusOfWorker.ToList();
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
try
{
AccountingEquipmentEntities.GetContext().Equipment.Add(_currentEquipment);
AccountingEquipmentEntities.GetContext().SaveChanges();
FrameManager.MainFrame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
}
public InventarizationPage()
{
InitializeComponent();
List <StatusOfInventory> statusOfs = new List <StatusOfInventory>();
statusOfs = AccountingEquipmentEntities.GetContext().StatusOfInventory.ToList();
statusOfs.Insert(0, new StatusOfInventory {
InventoryStatus = "Весь список"
});
FilteCmb.ItemsSource = statusOfs;
DataContext = _CurrentInventory;
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Inventory.ToList();
}
public EditEquipmentPage(EquipmentCard SelectedEQC)
{
InitializeComponent();
if (SelectedEQC != null)
{
_currentEquipmentCard = SelectedEQC;
}
DataContext = _currentEquipmentCard;
ComboNomenclature.ItemsSource = AccountingEquipmentEntities.GetContext().Nomenclature.ToList();
ComboManufacturer.ItemsSource = AccountingEquipmentEntities.GetContext().Manufacturer.ToList();
ComboModel.ItemsSource = AccountingEquipmentEntities.GetContext().Equipment.ToList();
}
public EditRepairPage(Repair SelectedBRKDWN)
{
InitializeComponent();
if (SelectedBRKDWN != null)
{
_CurrentBreakdown = SelectedBRKDWN;
}
DataContext = _CurrentBreakdown;
ComboBreakdown.ItemsSource = AccountingEquipmentEntities.GetContext().Breakdown.ToList();
InventNumber.ItemsSource = AccountingEquipmentEntities.GetContext().EquipmentCard.ToList();
ComboModel.ItemsSource = AccountingEquipmentEntities.GetContext().Equipment.ToList();
ComboServiceName.ItemsSource = AccountingEquipmentEntities.GetContext().ServiceOrganization.ToList();
ComboStatusRepair.ItemsSource = AccountingEquipmentEntities.GetContext().StatusEquipInRepair.ToList();
ComboFIO.ItemsSource = AccountingEquipmentEntities.GetContext().Worker.ToList();
}
private void FilteCmb_DropDownClosed(object sender, EventArgs e)
{
if (FilteCmb.SelectedIndex == 0)
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Worker.ToList();
}
else if (SearchTxt.Text == "")
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.StatusOfWorker.NameOfStatus == FilteCmb.Text).ToList();
}
else
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.Position.PostionName.StartsWith(SearchTxt.Text) && w.StatusOfWorker.NameOfStatus == FilteCmb.Text).ToList();
}
}
public EditInvantarizationPage(Inventory SelectedInventory)
{
InitializeComponent();
if (SelectedInventory != null)
{
_CurrentInventory = SelectedInventory;
}
DataContext = _CurrentInventory;
ComboInvent.ItemsSource = AccountingEquipmentEntities.GetContext().EquipmentCard.ToList();
ComboManufacturerName.ItemsSource = AccountingEquipmentEntities.GetContext().Manufacturer.ToList();
ComboModel.ItemsSource = AccountingEquipmentEntities.GetContext().Equipment.ToList();
ComboNameOfNomenclature.ItemsSource = AccountingEquipmentEntities.GetContext().Nomenclature.ToList();
ComboRoom.ItemsSource = AccountingEquipmentEntities.GetContext().Room.ToList();
ComboStatus.ItemsSource = AccountingEquipmentEntities.GetContext().StatusOfInventory.ToList();
ComboFname.ItemsSource = AccountingEquipmentEntities.GetContext().Worker.ToList();
}
private void SearchTxt_TextChanged(object sender, TextChangedEventArgs e)
{
if (SearchTxt.Text == "")
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Inventory.ToList();
}
else if (FilteCmb.SelectedIndex == 0)
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Inventory.Where(w => w.EquipmentCard.Equipment.Nomenclature.NameOfNomenclature.StartsWith(SearchTxt.Text)).ToList();
}
else
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().
Inventory.Where(w => w.EquipmentCard.Equipment.Nomenclature.NameOfNomenclature.StartsWith(SearchTxt.Text) && w.StatusOfInventory.InventoryStatus == FilteCmb.Text).ToList();
}
}
private void BtnReturn_Click(object sender, RoutedEventArgs e)
{
var TestCaseUse = DgridMyPage.SelectedItems.Cast <Repair>().FirstOrDefault() as Repair;
TestCaseUse.FK_StatusEquipInRepair_id = 8;
try
{
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Возврат офомлен");
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Repair.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void ManufacturerCmb_DropDownClosed(object sender, EventArgs e)
{
if (ManufacturerCmb.SelectedIndex == 0)
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Repair.ToList();
}
else if (SrchTxt.Text == "")
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Repair.Where(w => w.EquipmentCard.Equipment.Manufacturer.ManufacturerName == ManufacturerCmb.Text).ToList();
}
else
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Repair.
Where(w => w.EquipmentCard.Equipment.Manufacturer.ManufacturerName == ManufacturerCmb.Text && w.EquipmentCard.SerialNumber.StartsWith(SrchTxt.Text)).ToList();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var idCheck = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.Login.Equals(LoginTextBX.Text) && w.Password.Equals(PasswordTextBX.Text)).Select(s => s.id).FirstOrDefault();
var idChecklogin = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.Login.Equals(LoginTextBX.Text)).Select(s => s.id).FirstOrDefault();
if (LoginTextBX.Text == "" && PasswordTextBX.Text == "")
{
Fail1.Visibility = Visibility.Visible;
Fail1.Content = "Введите логин";
Fail2.Visibility = Visibility.Visible;
Fail2.Content = "Введите пароль";
}
else if (LoginTextBX.Text == "")
{
Fail1.Visibility = Visibility.Visible;
Fail1.Content = "Введите логин";
}
else if (PasswordTextBX.Text == "")
{
Fail2.Content = "Введите пароль";
Fail2.Visibility = Visibility.Visible;
}
else
{
if (idChecklogin == 0)
{
GlobarFail.Visibility = Visibility.Visible;
GlobarFail.HorizontalContentAlignment = HorizontalAlignment.Center;
GlobarFail.Content = "Пользователя с такими данными не существует!";
}
else
{
if (idCheck == 0)
{
GlobarFail.Visibility = Visibility.Visible;
}
else
{
string Code = Class.SenderCode();
Class.senderMAil(AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == idCheck).Select(s => s.EmailOfWorker).FirstOrDefault(), Code);
SenderMail.IntId = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == idCheck).Select(s => s.id).FirstOrDefault();
FrameManager.LogFrame.Navigate(new AutherizationPage(Code));
}
}
}
}
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
System.Windows.Controls.TextBox txt = sender as System.Windows.Controls.TextBox;
if (txt.Text == "")
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Repair.ToList();
}
else if (ManufacturerCmb.SelectedIndex == 0)
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Repair.Where(w => w.EquipmentCard.SerialNumber.StartsWith(txt.Text)).ToList();
}
else
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Repair.
Where(w => w.EquipmentCard.Equipment.Manufacturer.ManufacturerName == ManufacturerCmb.Text && w.EquipmentCard.SerialNumber.StartsWith(SrchTxt.Text)).ToList();
}
}
private void BtnDel_Click(object sender, RoutedEventArgs e)
{
var EquipmentForRemoving = DgridMyPage.SelectedItems.Cast <Worker>().ToList();
if (MessageBox.Show($"Вы точно хотите удалить следующие {EquipmentForRemoving.Count} элементов?", "Внимание",
MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
AccountingEquipmentEntities.GetContext().Worker.RemoveRange(EquipmentForRemoving);
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Данные удалены");
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Worker.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
private void BtnExcel_Copy_Click(object sender, RoutedEventArgs e)
{
if (Cmb.Text == "1")
{
switchNumber = 1;
}
if (Cmb.Text == "2")
{
switchNumber = 2;
}
if (Cmb.Text == "3")
{
switchNumber = 3;
}
if (Cmb.Text == "4")
{
switchNumber = 4;
}
if (Cmb.Text == "5")
{
switchNumber = 5;
}
switch (switchNumber)
{
case 1:
Word.Application word = new Microsoft.Office.Interop.Word.Application();
Word.Document doc = word.Documents.Open(Environment.CurrentDirectory + @"\Akt_utilizatsii_oborudovania.docx");
var TestCaseUse = DgridMyPage.SelectedItems.Cast <Repair>().FirstOrDefault() as Repair;
var XHuman1 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 1).Select(s => s.FirstName + " " + s.MiddleName.Substring(0, 1) + " " + s.LastName.Substring(0, 1)).FirstOrDefault();
var XHuman2 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 5).Select(s => s.FirstName + " " + s.MiddleName.Substring(0, 1) + " " + s.LastName.Substring(0, 1)).FirstOrDefault();
var XHuman3 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 9).Select(s => s.FirstName + " " + s.MiddleName.Substring(0, 1) + " " + s.LastName.Substring(0, 1)).FirstOrDefault();
var Nomencl = TestCaseUse.EquipmentCard.Equipment.Nomenclature.NameOfNomenclature;
var Mdl = TestCaseUse.EquipmentCard.Equipment.Model;
var SerNumb = TestCaseUse.EquipmentCard.SerialNumber;
var StatusEquip = TestCaseUse.EquipmentCard.StatusOfEquipment.NameOfStatus;
var Break = TestCaseUse.StatusEquipInRepair.StatusEquipInRepair1;
var GetDate = DateTime.Today.ToShortDateString();
try
{
ReplaceWordStub("{FirstComm}", XHuman1, doc);
ReplaceWordStub("{SecComm}", XHuman2, doc);
ReplaceWordStub("{ThreeComm}", XHuman3, doc);
ReplaceWordStub("{GetDate}", GetDate.ToString(), doc);
ReplaceWordStub("{Model}", Mdl, doc);
ReplaceWordStub("{Nomenclature}", Nomencl, doc);
ReplaceWordStub("{SerialNumber}", SerNumb, doc);
ReplaceWordStub("{StatusEq}", StatusEquip.ToString(), doc);
ReplaceWordStub("{Dead}", Break, doc);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
doc.SaveAs2(@"G:\1robit.docx");
doc.Close();
break;
case 2:
Word.Application word2 = new Microsoft.Office.Interop.Word.Application();
Word.Document doc2 = word2.Documents.Open(Environment.CurrentDirectory + @"\Akt_remonta_oborudovania.docx");
var TestCaseUse2 = DgridMyPage.SelectedItems.Cast <Repair>().FirstOrDefault() as Repair;
var HumanFIO = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 6).Select(s => s.FirstName + " " + s.MiddleName.Substring(0, 1) + " " + s.LastName.Substring(0, 1)).FirstOrDefault();
var DateDelBerk = TestCaseUse2.EquipmentCard.DateOfDelivery.ToShortDateString();
var Manufac = TestCaseUse2.EquipmentCard.Equipment.Manufacturer.ManufacturerName;;
var Nomencl2 = TestCaseUse2.EquipmentCard.Equipment.Nomenclature.NameOfNomenclature;
var Mdl2 = TestCaseUse2.EquipmentCard.Equipment.Model;
var SerNum2b = TestCaseUse2.EquipmentCard.SerialNumber;
var PhoneNumb = TestCaseUse2.Worker.PhoneNumber;
var Brk2 = TestCaseUse2.StatusEquipInRepair.StatusEquipInRepair1;
var DateCreateBrk = DateTime.Today.ToShortDateString();
try
{
ReplaceWordStub("{DateOfDelivery}", DateDelBerk, doc2);
ReplaceWordStub("{Nomenclature}", Nomencl2, doc2);
ReplaceWordStub("{Manufacturer}", Manufac, doc2);
ReplaceWordStub("{Model}", Mdl2, doc2);
ReplaceWordStub("{SerialNumber}", SerNum2b, doc2);
ReplaceWordStub("{BreakDown}", Brk2, doc2);
ReplaceWordStub("{FirstName}", HumanFIO, doc2);
ReplaceWordStub("{Number}", PhoneNumb, doc2);
ReplaceWordStub("{Email}", Brk2, doc2);
ReplaceWordStub("{DateRepair}", DateCreateBrk, doc2);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
doc2.SaveAs2(@"G:\G;chromesaves\2robit.docx");
doc2.Close();
break;
case 3:
Word.Application word3 = new Microsoft.Office.Interop.Word.Application();
Word.Document doc3 = word3.Documents.Open(Environment.CurrentDirectory + @"\Akt_priyoma_peredachi_oborudovania_v_remont.docx");
var TestCaseUse3 = DgridMyPage.SelectedItems.Cast <Repair>().FirstOrDefault() as Repair;
var HumanFIO2 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 6).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var DateDeliverReapir = TestCaseUse3.DateOfDeliveryForRepair.ToShortDateString();
var Manufac2 = TestCaseUse3.EquipmentCard.Equipment.Manufacturer.ManufacturerName;
var Nomencl3 = TestCaseUse3.EquipmentCard.Equipment.Nomenclature.NameOfNomenclature;
var Mdl4 = TestCaseUse3.EquipmentCard.Equipment.Model;
var SerNum3b = TestCaseUse3.EquipmentCard.SerialNumber;
var PhoneNumb2 = TestCaseUse3.Worker.PhoneNumber;
var Mail = TestCaseUse3.Worker.EmailOfWorker;
var Positions = TestCaseUse3.Worker.Position.PostionName;
var DateCreateBrk3 = TestCaseUse3.DateOfReceiving.ToShortDateString();
var Breakd = TestCaseUse3.Breakdown.NameOfBreakdown;
var ServiceOrg = TestCaseUse3.ServiceOrganization.NameOfServiceOrganization;
try
{
ReplaceWordStub("{DateOfDeliveryForRepair}", DateDeliverReapir, doc3);
ReplaceWordStub("{Nomenclature}", Nomencl3, doc3);
ReplaceWordStub("{Manufacturer}", Manufac2, doc3);
ReplaceWordStub("{Model}", Mdl4, doc3);
ReplaceWordStub("{BreakDown}", Breakd, doc3);
ReplaceWordStub("{F.M.LastName}", HumanFIO2, doc3);
ReplaceWordStub("{ContactPhone}", PhoneNumb2, doc3);
ReplaceWordStub("{Email}", Mail, doc3);
ReplaceWordStub("{DateOfDeliveryForRepair}", DateDeliverReapir, doc3);
ReplaceWordStub("{DateOfReceiving}", DateCreateBrk3, doc3);
ReplaceWordStub("{ServiceOrganization}", ServiceOrg, doc3);
ReplaceWordStub("{ServiceOrganization1}", ServiceOrg, doc3);
ReplaceWordStub("{Position}", Positions, doc3);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
doc3.SaveAs2(@"G:\G;chromesaves\3robit.docx");
doc3.Close();
break;
case 4:
Word.Application word4 = new Microsoft.Office.Interop.Word.Application();
Word.Document doc4 = word4.Documents.Open(Environment.CurrentDirectory + @"\Akt_vozvrata_oborudovania_iz_remonta.docx");
var TestCaseUse4 = DgridMyPage.SelectedItems.Cast <Repair>().FirstOrDefault() as Repair;
var HumanFIO23 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 6).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var DateDeliverReapir3 = TestCaseUse4.DateOfDeliveryForRepair.ToShortDateString();
var Manufac22 = TestCaseUse4.EquipmentCard.Equipment.Manufacturer.ManufacturerName;
var Nomencl33 = TestCaseUse4.EquipmentCard.Equipment.Nomenclature.NameOfNomenclature;
var Mdl5 = TestCaseUse4.EquipmentCard.Equipment.Model;
var Positions2 = TestCaseUse4.Worker.Position.PostionName;
var DateCreateBrk4 = TestCaseUse4.DateOfReceiving.ToShortDateString();
var ServiceOrg2 = TestCaseUse4.ServiceOrganization.NameOfServiceOrganization;
try
{
ReplaceWordStub("{Nomenclature}", Nomencl33, doc4);
ReplaceWordStub("{Manufacturer}", Manufac22, doc4);
ReplaceWordStub("{Model}", Mdl5, doc4);
ReplaceWordStub("{F.M.LastName}", HumanFIO23, doc4);
ReplaceWordStub("{DateOfDelivery}", DateDeliverReapir3, doc4);
ReplaceWordStub("{DateOfReceiving}", DateCreateBrk4, doc4);
ReplaceWordStub("{DateOfReceiving1}", DateDeliverReapir3, doc4);
ReplaceWordStub("{DateOfReceiving2}", DateCreateBrk4, doc4);
ReplaceWordStub("{ServiceOrganization}", ServiceOrg2, doc4);
ReplaceWordStub("{ServiceOrganization1}", ServiceOrg2, doc4);
ReplaceWordStub("{Position}", Positions2, doc4);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
doc4.SaveAs2(@"G:\G;chromesaves\4robit.docx");
doc4.Close();
break;
break;
case 5:
break;
}
}
public NomenclaturePage()
{
InitializeComponent();
DataContext = _curentnomenclature;
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Nomenclature.ToList();
}
private void InventarizationOfReport_DropDownClosed(object sender, EventArgs e)
{
if (InventarizationOfReport.Text == "Приказ")
{
Switchjopbl = 1;
}
if (InventarizationOfReport.Text == "Акт")
{
Switchjopbl = 2;
}
if (DgridMyPage.SelectedItem == null)
{
return;
}
else
{
switch (Switchjopbl)
{
case 1:
try
{
SaveFileDialog openDlg = new SaveFileDialog();
openDlg.FileName = "Отчет №";
openDlg.Filter = "Word (.doc)|.doc |Word (.docx)|.docx |All files (.)|.";
openDlg.FilterIndex = 2;
openDlg.RestoreDirectory = true;
if (openDlg.ShowDialog() == true)
{
Word.Application word = new Microsoft.Office.Interop.Word.Application();
Word.Document doc = word.Documents.Open(Environment.CurrentDirectory + @"\Prikaz_o_provedenii_inventarizatsii.docx");
var TestCaseUse = DgridMyPage.SelectedItems.Cast <Inventory>().FirstOrDefault() as Inventory;
var XHuman1 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 1).Select(s => s.FirstName + " " + s.MiddleName.Substring(0, 1) + " " + s.LastName.Substring(0, 1)).FirstOrDefault();
var XHuman2 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 5).Select(s => s.FirstName + " " + s.MiddleName.Substring(0, 1) + " " + s.LastName.Substring(0, 1)).FirstOrDefault();
var XHuman3 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 9).Select(s => s.FirstName + " " + s.MiddleName.Substring(0, 1) + " " + s.LastName.Substring(0, 1)).FirstOrDefault();
var XHuman4 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 41).Select(s => s.FirstName + " " + s.MiddleName.Substring(0, 1) + " " + s.LastName.Substring(0, 1)).FirstOrDefault();
var Position1 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 1).Select(s => s.Position.PostionName).FirstOrDefault();
var Position2 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 5).Select(s => s.Position.PostionName).FirstOrDefault();
var Position3 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 9).Select(s => s.Position.PostionName).FirstOrDefault();
var Position4 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 41).Select(s => s.Position.PostionName).FirstOrDefault();
var Nomencl = TestCaseUse.EquipmentCard.Equipment.Nomenclature.NameOfNomenclature;
var Mdl = TestCaseUse.EquipmentCard.Equipment.Model;
var SerNumb = TestCaseUse.EquipmentCard.SerialNumber;
var InvetNumber = TestCaseUse.EquipmentCard.InventNumber;
var StatusEquip = TestCaseUse.EquipmentCard.StatusOfEquipment.NameOfStatus;
var GetDate = DateTime.Today.ToShortDateString();
var datein = TestCaseUse.InventoryDate.ToShortDateString();
var iddoc = TestCaseUse.id;
var dateout = DateTime.Now.AddDays(3).ToShortDateString();
var dateoutBuh = DateTime.Now.AddDays(7).ToShortDateString();
var Manufac = TestCaseUse.EquipmentCard.Equipment.Manufacturer.ManufacturerName;
ReplaceWordStub("{FIO1}", XHuman1, doc);
ReplaceWordStub("{FIO2}", XHuman2, doc);
ReplaceWordStub("{FIO3}", XHuman3, doc);
ReplaceWordStub("{FIO4}", XHuman4, doc);
ReplaceWordStub("{Position1}", Position1, doc);
ReplaceWordStub("{Position2}", Position2, doc);
ReplaceWordStub("{Position3}", Position3, doc);
ReplaceWordStub("{Position4}", Position4, doc);
ReplaceWordStub("{InventNumber}", Mdl, doc);
ReplaceWordStub("{Model}", InvetNumber, doc);
ReplaceWordStub("{GetDate}", GetDate, doc);
ReplaceWordStub("{Nomenclature}", Nomencl, doc);
ReplaceWordStub("{SerialNumber}", SerNumb, doc);
ReplaceWordStub("{GetDate1}", datein, doc);
ReplaceWordStub("{GetDate2}", dateout, doc);
ReplaceWordStub("{GetDate3}", dateoutBuh, doc);
ReplaceWordStub("{id}", iddoc.ToString(), doc);
ReplaceWordStub("{Manufacturer}", Manufac.ToString(), doc);
doc.SaveAs2(openDlg.FileName);
doc.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
break;
case 2:
try
{
SaveFileDialog openDlg = new SaveFileDialog();
openDlg.FileName = "Отчет №";
openDlg.Filter = "Word (.doc)|.doc |Word (.docx)|.docx |All files (.)|.";
openDlg.FilterIndex = 2;
openDlg.RestoreDirectory = true;
if (openDlg.ShowDialog() == true)
{
Word.Application word2 = new Microsoft.Office.Interop.Word.Application();
Word.Document doc2 = word2.Documents.Open(Environment.CurrentDirectory + @"\Akt_o_rezultatakh_inventarizatsii.docx");
var TestCaseUse2 = DgridMyPage.SelectedItems.Cast <Inventory>().FirstOrDefault() as Inventory;
var XHuman11 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 1).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var XHuman21 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 5).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var XHuman31 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 9).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var XHuman41 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 41).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var XHuman51 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 29).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var XHuman61 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 35).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var XHuman81 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 19).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var Position21 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 5).Select(s => s.Position.PostionName).FirstOrDefault();
var XHuman71 = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == 23).Select(s => s.LastName.Substring(0, 1) + " " + s.MiddleName.Substring(0, 1) + " " + s.FirstName).FirstOrDefault();
var Position31 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 9).Select(s => s.Position.PostionName).FirstOrDefault();
var Position41 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 41).Select(s => s.Position.PostionName).FirstOrDefault();
var Position51 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 29).Select(s => s.Position.PostionName).FirstOrDefault();
var Position61 = AccountingEquipmentEntities.GetContext().Worker.Include(i => i.Position).Where(w => w.id == 23).Select(s => s.Position.PostionName).FirstOrDefault();
var GetDate1 = DateTime.Today.ToShortDateString();
var datein1 = TestCaseUse2.InventoryDate.ToShortDateString();
var iddoc1 = TestCaseUse2.id;
var dateout1 = DateTime.Now.AddDays(3).ToShortDateString();
var dateoutBuh1 = DateTime.Now.AddDays(7).ToShortDateString();
var dateoutBuh2 = DateTime.Now.AddDays(10).ToShortDateString();
ReplaceWordStub("{Worker}", XHuman81, doc2);
ReplaceWordStub("{Worker1}", XHuman11, doc2);
ReplaceWordStub("{F.M.Lname1}", XHuman21, doc2);
ReplaceWordStub("{F.M.Lname2}", XHuman31, doc2);
ReplaceWordStub("{F.M.Lname3}", XHuman41, doc2);
ReplaceWordStub("{F.M.Lname4}", XHuman51, doc2);
ReplaceWordStub("{F.M.Lname4}", XHuman61, doc2);
ReplaceWordStub("{Position1}", Position21, doc2);
ReplaceWordStub("{F.M.Lname5}", XHuman61, doc2);
ReplaceWordStub("{Position2}", Position31, doc2);
ReplaceWordStub("{Position3}", Position41, doc2);
ReplaceWordStub("{Position4}", Position51, doc2);
ReplaceWordStub("{Position5}", Position61, doc2);
ReplaceWordStub("{Date1}", GetDate1, doc2);
ReplaceWordStub("{InventoryDate}", datein1, doc2);
ReplaceWordStub("{GetDate1}", datein1, doc2);
ReplaceWordStub("{GetDate2}", dateout1, doc2);
ReplaceWordStub("{GetDate3}", dateoutBuh1, doc2);
ReplaceWordStub("{GetDate4}", dateoutBuh2, doc2);
ReplaceWordStub("{GetDate5}", dateoutBuh2, doc2);
ReplaceWordStub("{idInvent}", iddoc1.ToString(), doc2);
ReplaceWordStub("{id}", iddoc1.ToString(), doc2);
ReplaceWordStub("{id1}", iddoc1.ToString(), doc2);
ReplaceWordStub("{GetDate5}", GetDate1, doc2);
ReplaceWordStub("{FirstComm}", XHuman21, doc2);
ReplaceWordStub("{SecondComm}", XHuman31, doc2);
ReplaceWordStub("{ThreeComm}", XHuman41, doc2);
ReplaceWordStub("{Comment}", TestCaseUse2.Comment, doc2);
doc2.SaveAs2(openDlg.FileName);
doc2.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
break;
}
}
}
public RoomPage()
{
InitializeComponent();
DataContext = _CurrentRoom;
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().Room.ToList();
}
public void load()
{
DgridMyPage_Copy.ItemsSource = AccountingEquipmentEntities.GetContext().Repair.ToList();
}