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));
}
