public void Load(EnterprisesDto enterprise) { if (enterprise == null) { return; } _id = enterprise.IDEnterprise; tbAddress.Text = enterprise.Address.ToString(); tbEmail.Text = enterprise.Email.ToString(); tbNameEnterprise.Text = enterprise.NameEnterprise.ToString(); tbPhone.Text = enterprise.Phone.ToString(); tbRepresent.Text = enterprise.Representative.ToString(); tbNote.Text = enterprise.Note.ToString(); }
//private void btnEditDebt_Click(object sender, RoutedEventArgs e) //{ // //DebtDto item = dgDebt.SelectedItem as DebtDto; // //if (item == null) // //{ // // MessageBox.Show("Выберите запись для редактирования", "Редактирование"); // // return; // //} // //AddDebt window = new AddDebt(); // //window.Load(item); // //window.ShowDialog(); // //btnUpdateDebt_Click(sender, e); //} private void btnEditE_Click(object sender, RoutedEventArgs e) { EnterprisesDto item = dgEnterprises.SelectedItem as EnterprisesDto; if (item == null) { MessageBox.Show("Выберите запись для редактирования", "Редактирование"); return; } AddEnterprise window = new AddEnterprise(); window.Load(item); window.ShowDialog(); btnUpdateE_Click(sender, e); }
public static Enterprises Convert(EnterprisesDto enterpriseDto) { if (enterpriseDto == null) { return(null); } Enterprises enterprise = new Enterprises(); enterprise.Address = enterpriseDto.Address; enterprise.Email = enterpriseDto.Email; enterprise.IDEnterprise = enterpriseDto.IDEnterprise; enterprise.NameEnterprise = enterpriseDto.NameEnterprise; enterprise.Note = enterpriseDto.Note; enterprise.Phone = enterpriseDto.Phone; enterprise.Representative = enterpriseDto.Representative; return(enterprise); }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (tbAddress.Text == "") { tbAddress.BorderBrush = Brushes.Red; } if (tbNameEnterprise.Text == "") { tbNameEnterprise.BorderBrush = Brushes.Red; } if (tbPhone.Text == "") { tbPhone.BorderBrush = Brushes.Red; } if (tbRepresent.Text == "") { tbRepresent.BorderBrush = Brushes.Red; } try { EnterprisesDto enter = new EnterprisesDto(); enter.Address = tbAddress.Text; enter.Email = tbEmail.Text; enter.NameEnterprise = tbNameEnterprise.Text; enter.Note = tbNote.Text; enter.Phone = Convert.ToDouble(tbPhone.Text); enter.Representative = tbRepresent.Text; IEnterpriseProcessDb enterProcess = ProcessFactory.GetEnterpriseProcess(); if (_id == 0) { enterProcess.Add(enter); } else { enter.IDEnterprise = _id; enterProcess.Update(enter); } } catch { return; } Close(); }
private void btnDeleteE_Click(object sender, RoutedEventArgs e) { EnterprisesDto item = dgEnterprises.SelectedItem as EnterprisesDto; if (item == null) { MessageBox.Show("Выберите запись для удаления", "Удаление предприятия"); return; } MessageBoxResult result = MessageBox.Show("Удалить " + item.NameEnterprise + "?", "Удаление предприятия", MessageBoxButton.YesNo, MessageBoxImage.Warning); if (result != MessageBoxResult.Yes) { return; } ProcessFactory.GetEnterpriseProcess().Delete(item.IDEnterprise); btnUpdateE_Click(sender, e); }
public void fillExcelTableByType(IEnumerable <object> grid, string status, FileInfo xlsxFile) { try { if (grid != null) { ExcelPackage pck = new ExcelPackage(xlsxFile); var excel = pck.Workbook.Worksheets.Add(status); int x = 1; int y = 1; CultureInfo cultureInfo = new CultureInfo(Thread.CurrentThread.CurrentCulture.Name); Thread.CurrentThread.CurrentCulture = cultureInfo; cultureInfo.NumberFormat.NumberDecimalSeparator = "."; excel.Cells["A1:Z1"].Style.Font.Bold = true; excel.Cells.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left; excel.Cells.Style.Numberformat.Format = "General"; Object dtObj = new Object(); switch (status) { case "Managers": dtObj = new ManagersDto(); break; case "Enterprises": dtObj = new EnterprisesDto(); break; case "TypeReklama": dtObj = new TypeReklamaDto(); break; case "Orders": dtObj = new OrdersDto(); break; case "Carrier": dtObj = new CarrierDto(); break; case "Wage": dtObj = new WageDto(); break; } foreach (var prop in dtObj.GetType().GetProperties()) { excel.Cells[y, x].Value = prop.Name.Trim(); x++; } foreach (var item in grid) { y++; Object itemObj = item; x = 1; foreach (var prop in itemObj.GetType().GetProperties()) { object t = prop.GetValue(itemObj, null); object val; if (t == null) { val = ""; } else { val = t.ToString(); if (t is ManagersDto) { val = ((ManagersDto)t).FullName; } if (t is EnterprisesDto) { val = ((EnterprisesDto)t).NameEnterprise; } if (t is CarrierDto) { val = ((CarrierDto)t).NameCarrier; } if (t is TypeReklamaDto) { val = ((TypeReklamaDto)t).NameReklama; } } excel.Cells[y, x].Value = val; x++; } } excel.Cells.AutoFitColumns(); pck.Save(); } else { MessageBox.Show("Данные не загружены!"); } } catch (Exception exc) { // MessageBox.Show(exc.Message, "Ошибка"); } }
public void Update(EnterprisesDto enterprise) { _enterpriseDao.Update(DtoConvert.Convert(enterprise)); }
public void Add(EnterprisesDto enterprise) { _enterpriseDao.Add(DtoConvert.Convert(enterprise)); }