/// <summary>
/// Кнопка сохранить изменения
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_save_edit_Click(object sender, RoutedEventArgs e)
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var contragent = ef.Contragents.FirstOrDefault(x => x.IdContragent == Convert.ToInt32(tb_idcontragent.Text));
if (contragent != null)
{
contragent.Name = tb_edit_name.Text;
contragent.ServiceInfo =
$"{contragent.ServiceInfo}\n {DateTime.Now} {App.ActiveUser} изменил название контрагента";
}
ef.SaveChanges();
btn_refresh_Click(sender, e);
ContentEdit.Hide();
}
catch (Exception ex)
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = ex.ToString();
}
}
}
private void btn_add_add_Click(object sender, RoutedEventArgs e)
{
ContentAddUser.Hide();
if (tb_login.Text != "")
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
User user = new User
{
Name = tb_name.Text,
Login = tb_login.Text,
Password = tb_pass.Text
};
user.LevelAccess = cb_access.SelectedIndex switch
{
0 => "kpp",
1 => "reader",
2 => "warehouse",
3 => "shipment",
4 => "admin",
_ => user.LevelAccess
};
ef.Add(user);
ef.SaveChanges();
LoadUser();
}
catch (Exception ex)
{
((MainWindow)Application.Current.MainWindow).ContentErrorText.ShowAsync();
((MainWindow)Application.Current.MainWindow).text_debuger.Text = ex.ToString();
}
ContentSave.ShowAsync();
}
}
/// <summary>
/// Кнопка добавление, реального добавления
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_add_add_Click(object sender, RoutedEventArgs e)
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
Contragent contragent = new Contragent
{
Name = tb_namecontragent.Text,
ServiceInfo = $"{DateTime.Now} {App.ActiveUser} добавил контрагента",
Active = "1"
};
ef.Add(contragent);
ef.SaveChanges();
ContentAdd.Hide();
}
catch (Exception ex)
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = ex.ToString();
}
}
}
/// Кнопка удалить
private void btn_delete_Click(object sender, RoutedEventArgs e)
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var driver = ef.Drivers.FirstOrDefault(x => x.IdDriver == Convert.ToInt32(tb_id.Text));
if (driver != null)
{
driver.Active = "0";
driver.ServiceInfo = driver.ServiceInfo + "\n" + DateTime.Now + " " + App.ActiveUser + " удалил водителя";
}
ef.SaveChanges();
ContentAddEdit.Hide();
btn_refresh_Click(sender, e);
}
catch (Exception ex)
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = ex.ToString();
}
}
}
private void btn_load_Click(object sender, RoutedEventArgs e)
{
var bt = e.OriginalSource as Button;
var current = bt?.DataContext as Shipments;
if (current != null)
{
MessageBoxResult?result = MessageBox.Show("Сменить статус водителя " + current.Fio + " на Загрузка начата?", "Внимание", MessageBoxButton.YesNo, MessageBoxImage.Information);
if (result == MessageBoxResult.Yes)
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var shipment = ef.Shipments.FirstOrDefault(x => x.IdShipment == current.IdShipment);
if (shipment != null)
{
shipment.IdTimeNavigation.DateTimeLoad = DateTime.Now;
}
ef.SaveChanges();
}
catch (Exception ex)
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = ex.ToString();
}
;
}
}
}
btn_refresh_Click(sender, e);
}
private void btn_add_add_Click(object sender, RoutedEventArgs e)
{
if (cb_drivers.Text == "")
{
return;
}
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
Shipment shipment = new Shipment();
if (cb_drivers.SelectedItem != null)
{
var current = cb_drivers.SelectedItem as Drivers;
shipment.IdDriver = current?.IdDriver;
}
else
{
//Если водителя нет в списках
var splitNames = SplitNames(cb_drivers.Text + " ");
Driver driver = new Driver
{
Name = splitNames.name.Replace(" ", ""),
Family = splitNames.family.Replace(" ", ""),
Patronymic = splitNames.patronomyc.Replace(" ", ""),
AutoNumber = tb_autonum.Text,
Attorney = tb_attorney.Text,
Phone = tb_phone.Text,
Passport = tb_passport.Text,
Active = "1",
ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил водителя"
};
shipment.IdDriverNavigation = driver;
}
Time time = new Time
{
DateTimeFactRegist = DateTime.Now
};
shipment.IdTimeNavigation = time;
shipment.Description = tb_info.Text;
shipment.Active = "1";
shipment.ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил отгрузку";
ef.Add(shipment);
ef.SaveChanges();
ContentAdd.Hide();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Программное исключене", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
//Кнопка удалить
private void btn_delete_Click(object sender, RoutedEventArgs e)
{
if (tb_idcontragent != null)
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var temp = ef.Contragents.FirstOrDefault(x => x.IdContragent == Convert.ToInt32(tb_idcontragent.Text));
if (temp != null)
{
temp.Active = "0";
}
ef.SaveChanges();
ContentEdit.Hide();
}
catch (Exception ex)
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = ex.ToString();
}
}
}
//Кнопа перенесена в другоме место,
/*var bt = e.OriginalSource as Button;
* var current = bt.DataContext as DB.Contragent;
*
* try
* {
* using RegistrantCoreContext ef = new RegistrantCoreContext();
* var contragent = ef.Contragents.FirstOrDefault(x => x.IdContragent == current.IdContragent);
* if (contragent != null)
* {
* contragent.Active = "0";
* contragent.ServiceInfo = $"{contragent.ServiceInfo}\n{DateTime.Now} {App.ActiveUser} изменил удалил";
* }
* ef.SaveChanges();
* btn_refresh_Click(sender, e);
* }
* catch (Exception ex)
* {
* MainWindow mainWindow = (MainWindow) Application.Current.MainWindow;
* if (mainWindow != null)
* {
* mainWindow.ContentErrorText.ShowAsync();
* mainWindow.text_debuger.Text = ex.ToString();
* }
* }
* }*/
}
/// Непосредственное редактирование
private void btn_edit_Click1(object sender, RoutedEventArgs e)
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var driver = ef.Drivers.FirstOrDefault(x => x.IdDriver == Convert.ToInt32(tb_id.Text));
if (driver != null)
{
driver.Family = tb_Family.Text;
driver.Name = tb_name.Text;
driver.Patronymic = tb_patronomyc.Text;
driver.Phone = tb_phone.Text;
driver.Attorney = tb_attorney.Text;
driver.Auto = tb_auto.Text;
driver.AutoNumber = tb_autonum.Text;
driver.Passport = tb_passport.Text;
driver.Info = tb_info.Text;
driver.ServiceInfo = driver.ServiceInfo + "\n" + DateTime.Now + " " + App.ActiveUser + " внес изменения";
ef.SaveChanges();
btn_close_Click(sender, e);
ContentAddEdit.Hide();
}
ef.SaveChanges();
btn_close_Click(sender, e);
ContentAddEdit.Hide();
btn_refresh_Click(sender, e);
}
catch (Exception ex)
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = ex.ToString();
}
}
}
/// Кнопка добавления водителя
private void btn_add_Click(object sender, RoutedEventArgs e)
{
if (tb_Family.Text == "")
{
MessageBox.Show("Введите хотя бы фамилию водителя!", "Внимание!", MessageBoxButton.OK,
MessageBoxImage.Error);
return;
}
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
Driver driver = new Driver
{
Family = tb_Family.Text,
Name = tb_name.Text,
Patronymic = tb_patronomyc.Text,
Phone = tb_phone.Text,
Attorney = tb_attorney.Text,
Auto = tb_auto.Text,
AutoNumber = tb_autonum.Text,
Passport = tb_passport.Text,
Info = tb_info.Text,
Active = "1",
ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил водителя"
};
ef.Add(driver);
ef.SaveChanges();
btn_close_Click(sender, e);
}
catch (Exception ex)
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = ex.ToString();
}
}
}
private void btn_deluser_Click(object sender, RoutedEventArgs e)
{
var bt = e.OriginalSource as Button;
var current = bt?.DataContext as User;
if (current != null)
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
ef.Remove(current);
ef.SaveChanges();
LoadUser();
ContentSave.ShowAsync();
}
catch (Exception ex)
{
((MainWindow)Application.Current.MainWindow).ContentErrorText.ShowAsync();
((MainWindow)Application.Current.MainWindow).text_debuger.Text = ex.ToString();
}
}
}
private void btn_del_yes_Click(object sender, RoutedEventArgs e)
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var shipment = ef.Shipments.FirstOrDefault(x => x.IdShipment == Convert.ToInt32(idcont.Text));
if (shipment != null)
{
shipment.Active = "0";
shipment.Description = shipment.Description + " " + tb_reasofordel.Text;
shipment.ServiceInfo = shipment.ServiceInfo + "\n" + DateTime.Now + " " + App.ActiveUser +
" удалил отгрузку";
}
ef.SaveChanges();
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btn_save_Click(object sender, RoutedEventArgs e)
{
if (tb_login.Text != "")
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var user = ef.Users.FirstOrDefault(x => x.IdUser == Convert.ToInt32(tb_id.Text));
if (tb_pass.Text == user?.Password)
{
user.Login = tb_login.Text;
user.Password = tb_passnew.Text;
ef.SaveChanges();
ContentSave.ShowAsync();
tb_pass.Text = "";
tb_passnew.Text = "";
}
else
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = "Пароль не совпадает со старым";
}
}
}
else
{
MainWindow mainWindow = (MainWindow)Application.Current.MainWindow;
if (mainWindow != null)
{
mainWindow.ContentErrorText.ShowAsync();
mainWindow.text_debuger.Text = "Новый логин не должен быть пустым";
}
}
}
private void EditByAdminRole()
{
if (cb_drivers.Text == "")
{
MessageBox.Show("Водитель не выбран", "Внимание!", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
if (cb_contragent.Text == "")
{
MessageBox.Show("Контрагент не выбран", "Внимание!", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var shipment =
ef.Shipments.FirstOrDefault(x => x.IdShipment == Convert.ToInt64(idcont.Text));
if (shipment != null)
{
if (cb_drivers.SelectedItem != null)
{
var current = cb_drivers.SelectedItem as Drivers;
shipment.IdDriver = current?.IdDriver;
shipment.IdDriverNavigation.Phone = tb_phone.Text;
shipment.IdDriverNavigation.Attorney = tb_attorney.Text;
shipment.IdDriverNavigation.Auto = tb_auto.Text;
shipment.IdDriverNavigation.AutoNumber = tb_autonum.Text;
}
else
{
//Если водителя нет в списках
var splitNames = SplitNames(cb_drivers.Text + " ");
Driver driver = new Driver
{
Name = splitNames.name.Replace(" ", ""),
Family = splitNames.family.Replace(" ", ""),
Patronymic = splitNames.patronomyc.Replace(" ", ""),
AutoNumber = tb_autonum.Text,
Attorney = tb_attorney.Text,
Phone = tb_phone.Text,
Auto = tb_auto.Text,
Active = "1",
ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил водителя"
};
shipment.IdDriverNavigation = driver;
}
if (cb_contragent.SelectedItem != null)
{
var current = cb_contragent.SelectedItem as Contragent;
shipment.IdContragent = current?.IdContragent;
}
else
{
Contragent contragent = new Contragent
{
Name = cb_contragent.Text,
Active = "1",
ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил контрагента"
};
shipment.IdContragentNavigation = contragent;
}
if (dt_plan.Value.HasValue)
{
shipment.IdTimeNavigation.DateTimePlanRegist = dt_plan.Value;
}
if (dt_fact.Value.HasValue)
{
shipment.IdTimeNavigation.DateTimeFactRegist = dt_fact.Value;
}
if (dt_arrive.Value.HasValue)
{
shipment.IdTimeNavigation.DateTimeArrive = dt_arrive.Value;
}
if (dt_load.Value.HasValue)
{
shipment.IdTimeNavigation.DateTimeLoad = dt_load.Value;
}
if (dt_endload.Value.HasValue)
{
shipment.IdTimeNavigation.DateTimeEndLoad = dt_endload.Value;
}
if (dt_left.Value.HasValue)
{
shipment.IdTimeNavigation.DateTimeLeft = dt_left.Value;
}
if (string.IsNullOrWhiteSpace(tb_numrealese.Text))
{
shipment.NumRealese = tb_numrealese.Text;
}
if (string.IsNullOrWhiteSpace(tb_packetdoc.Text))
{
shipment.PacketDocuments = tb_packetdoc.Text;
}
if (string.IsNullOrWhiteSpace(tb_tochkaload.Text))
{
shipment.TochkaLoad = tb_tochkaload.Text;
}
if (string.IsNullOrWhiteSpace(tb_CountPodons.Text))
{
shipment.CountPodons = tb_CountPodons.Text;
}
if (string.IsNullOrWhiteSpace(tb_nomencluture.Text))
{
shipment.Nomenclature = tb_nomencluture.Text;
}
if (string.IsNullOrWhiteSpace(tb_size.Text))
{
shipment.Size = tb_size.Text;
}
if (string.IsNullOrWhiteSpace(tb_Destination.Text))
{
shipment.Destination = tb_Destination.Text;
}
if (string.IsNullOrWhiteSpace(tb_typeload.Text))
{
shipment.TypeLoad = tb_typeload.Text;
}
if (string.IsNullOrWhiteSpace(tb_descript.Text))
{
shipment.Description = tb_descript.Text;
}
if (string.IsNullOrWhiteSpace(tb_storekeeper.Text))
{
shipment.StoreKeeper = tb_storekeeper.Text;
}
shipment.Active = "1";
shipment.ServiceInfo = shipment.ServiceInfo + "\n" + DateTime.Now + " " + App.ActiveUser +
" внес изменения в отгрузку";
}
ef.SaveChanges();
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Программное исключене", MessageBoxButton.OK,
MessageBoxImage.Error);
}
}
private void EditByWarehouseRole()
{
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
var shipment = ef.Shipments.FirstOrDefault(x => x.IdShipment == Convert.ToInt32(idcont.Text));
if (shipment != null)
{
if (dt_load.Value.HasValue)
{
shipment.IdTimeNavigation.DateTimeLoad = dt_load.Value;
}
if (dt_endload.Value.HasValue)
{
shipment.IdTimeNavigation.DateTimeEndLoad = dt_endload.Value;
}
if (string.IsNullOrWhiteSpace(tb_CountPodons.Text))
{
shipment.CountPodons = tb_CountPodons.Text;
}
if (string.IsNullOrWhiteSpace(tb_nomencluture.Text))
{
shipment.Nomenclature = tb_nomencluture.Text;
}
if (string.IsNullOrWhiteSpace(tb_size.Text))
{
shipment.Size = tb_size.Text;
}
if (string.IsNullOrWhiteSpace(tb_Destination.Text))
{
shipment.Destination = tb_Destination.Text;
}
if (string.IsNullOrWhiteSpace(tb_typeload.Text))
{
shipment.TypeLoad = tb_typeload.Text;
}
if (string.IsNullOrWhiteSpace(tb_descript.Text))
{
shipment.Description = tb_descript.Text;
}
if (string.IsNullOrWhiteSpace(tb_storekeeper.Text))
{
shipment.StoreKeeper = tb_storekeeper.Text;
}
else
{
shipment.StoreKeeper = App.ActiveUser;
}
shipment.ServiceInfo = shipment.ServiceInfo + "\n" + DateTime.Now + " " + App.ActiveUser +
" внес изменения в отгрузку";
ef.SaveChanges();
Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Программное исключене", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
/// Добавить соответственно
private void btn_add_Click(object sender, RoutedEventArgs e)
{
if (cb_drivers.Text == "")
{
MessageBox.Show("Водитель не выбран", "Внимание!", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
if (cb_contragent.Text == "")
{
MessageBox.Show("Контрагент не выбран", "Внимание!", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
if (dt_plan.Value == null)
{
MessageBox.Show("Дата плановой загрузки не заполнена!", "Внимание!", MessageBoxButton.OK,
MessageBoxImage.Error);
return;
}
try
{
using RegistrantCoreContext ef = new RegistrantCoreContext();
Shipment shipment = new Shipment();
if (cb_drivers.SelectedItem != null)
{
var current = cb_drivers.SelectedItem as Drivers;
shipment.IdDriver = current?.IdDriver;
}
else
{
//Если водителя нет в списках
var splitNames = SplitNames(cb_drivers.Text + " ");
Driver driver = new Driver
{
Name = splitNames.name.Replace(" ", ""),
Family = splitNames.family.Replace(" ", ""),
Patronymic = splitNames.patronomyc.Replace(" ", ""),
AutoNumber = tb_autonum.Text,
Attorney = tb_attorney.Text,
Phone = tb_phone.Text,
Auto = tb_auto.Text,
Active = "1",
ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил водителя"
};
shipment.IdDriverNavigation = driver;
}
if (cb_contragent.SelectedItem != null)
{
var current = cb_contragent.SelectedItem as Contragent;
shipment.IdContragent = current?.IdContragent;
}
else
{
Contragent contragent = new Contragent
{
Name = cb_contragent.Text,
Active = "1",
ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил контрагента"
};
shipment.IdContragentNavigation = contragent;
}
Time time = new Time
{
//При добавлении можно сохранять прям DateTime? не боясь за null-ы
DateTimePlanRegist = dt_plan.Value,
DateTimeFactRegist = dt_fact.Value,
DateTimeArrive = dt_arrive.Value,
DateTimeLoad = dt_load.Value,
DateTimeEndLoad = dt_endload.Value,
DateTimeLeft = dt_left.Value
};
shipment.IdTimeNavigation = time;
if (string.IsNullOrWhiteSpace(tb_numrealese.Text))
{
shipment.NumRealese = tb_numrealese.Text;
}
if (string.IsNullOrWhiteSpace(tb_packetdoc.Text))
{
shipment.PacketDocuments = tb_packetdoc.Text;
}
if (string.IsNullOrWhiteSpace(tb_tochkaload.Text))
{
shipment.TochkaLoad = tb_tochkaload.Text;
}
if (string.IsNullOrWhiteSpace(tb_CountPodons.Text))
{
shipment.CountPodons = tb_CountPodons.Text;
}
if (string.IsNullOrWhiteSpace(tb_nomencluture.Text))
{
shipment.Nomenclature = tb_nomencluture.Text;
}
if (string.IsNullOrWhiteSpace(tb_size.Text))
{
shipment.Size = tb_size.Text;
}
if (string.IsNullOrWhiteSpace(tb_Destination.Text))
{
shipment.Destination = tb_Destination.Text;
}
if (string.IsNullOrWhiteSpace(tb_typeload.Text))
{
shipment.TypeLoad = tb_typeload.Text;
}
if (string.IsNullOrWhiteSpace(tb_descript.Text))
{
shipment.Description = tb_descript.Text;
}
if (string.IsNullOrWhiteSpace(tb_storekeeper.Text))
{
shipment.StoreKeeper = tb_storekeeper.Text;
}
shipment.Active = "1";
shipment.ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил отгрузку";
ef.Add(shipment);
ef.SaveChanges();
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Программное исключене", MessageBoxButton.OK,
MessageBoxImage.Error);
}
}