public KPPShipments(DB.Shipment shipment)
{
IdShipment = shipment.IdShipment;
FIO = shipment.IdDriverNavigation?.Family + " " + shipment.IdDriverNavigation?.Name + " " + shipment.IdDriverNavigation?.Patronymic;
Phone = shipment.IdDriverNavigation?.Phone;
if (shipment.IdTimeNavigation.DateTimeFactRegist.HasValue)
{
PlanDateFact = shipment.IdTimeNavigation.DateTimeFactRegist.Value;
PlanDateFactString = PlanDateFact.ToString();
}
if (shipment.IdDriverNavigation.AutoNumber != null)
{
NumAuto = shipment.IdDriverNavigation.AutoNumber;
}
if (shipment.IdTimeNavigation?.DateTimeLeft != null)
{
TextStatus = "Покинул склад";
btn_arrive = "Collapsed";
btn_left = "Collapsed";
}
else if (shipment.IdTimeNavigation?.DateTimeLeft == null && shipment.IdTimeNavigation?.DateTimeEndLoad != null)
{
TextStatus = "Отгрузка завершена";
btn_left = "Visible";
btn_arrive = "Collapsed";
}
else if (shipment.IdTimeNavigation?.DateTimeEndLoad == null && shipment.IdTimeNavigation?.DateTimeLoad != null)
{
TextStatus = "Отгрузка";
btn_arrive = "Collapsed";
btn_left = "Collapsed";
}
else if (shipment.IdTimeNavigation?.DateTimeLoad == null && shipment.IdTimeNavigation?.DateTimeArrive != null)
{
TextStatus = "На территории склада";
btn_left = "Visible";
btn_arrive = "Collapsed";
}
else if (shipment.IdTimeNavigation?.DateTimeArrive == null && shipment.IdTimeNavigation?.DateTimeFactRegist != null)
{
TextStatus = "Зарегистрирован";
btn_arrive = "Visible";
btn_left = "Collapsed";
}
else if (shipment.IdTimeNavigation?.DateTimeFactRegist == null && shipment.IdTimeNavigation?.DateTimePlanRegist != null)
{
TextStatus = "";
btn_arrive = "Collapsed";
btn_left = "Collapsed";
}
else if (shipment.IdTimeNavigation?.DateTimePlanRegist == null && shipment.IdTimeNavigation?.DateTimeFactRegist != null)
{
TextStatus = "Зарегистрирован";
btn_arrive = "Visible";
btn_left = "Collapsed";
}
}
public KppShipments(DB.Shipment shipment)
{
IdShipment = shipment.IdShipment;
Fio = $"{shipment.IdDriverNavigation?.Family} {shipment.IdDriverNavigation?.Name} {shipment.IdDriverNavigation?.Patronymic}";
Phone = shipment.IdDriverNavigation?.Phone;
if (shipment.IdTimeNavigation.DateTimeFactRegist.HasValue)
{
PlanDateFact = shipment.IdTimeNavigation.DateTimeFactRegist.Value;
PlanDateFactString = PlanDateFact.ToString(CultureInfo.GetCultureInfo("ru-ru"));
}
if (shipment.IdDriverNavigation.AutoNumber != null)
{
NumAuto = shipment.IdDriverNavigation.AutoNumber;
}
if (shipment.IdTimeNavigation?.DateTimeLeft != null)
{
TextStatus = "Покинул склад";
ArriveButtonVisibility = Visibility.Collapsed;
LeftButtonVisibility = Visibility.Collapsed;
}
else if (shipment.IdTimeNavigation?.DateTimeLeft == null && shipment.IdTimeNavigation?.DateTimeEndLoad != null)
{
TextStatus = "Отгрузка завершена";
LeftButtonVisibility = Visibility.Visible;
ArriveButtonVisibility = Visibility.Collapsed;
}
else if (shipment.IdTimeNavigation?.DateTimeEndLoad == null && shipment.IdTimeNavigation?.DateTimeLoad != null)
{
TextStatus = "Отгрузка";
ArriveButtonVisibility = Visibility.Collapsed;
LeftButtonVisibility = Visibility.Collapsed;
}
else if (shipment.IdTimeNavigation?.DateTimeLoad == null && shipment.IdTimeNavigation?.DateTimeArrive != null)
{
TextStatus = "На территории склада";
LeftButtonVisibility = Visibility.Visible;
ArriveButtonVisibility = Visibility.Collapsed;
}
else if (shipment.IdTimeNavigation?.DateTimeArrive == null && shipment.IdTimeNavigation?.DateTimeFactRegist != null)
{
TextStatus = "Зарегистрирован";
ArriveButtonVisibility = Visibility.Visible;
LeftButtonVisibility = Visibility.Collapsed;
}
else if (shipment.IdTimeNavigation?.DateTimeFactRegist == null && shipment.IdTimeNavigation?.DateTimePlanRegist != null)
{
TextStatus = "";
ArriveButtonVisibility = Visibility.Collapsed;
LeftButtonVisibility = Visibility.Collapsed;
}
else if (shipment.IdTimeNavigation?.DateTimePlanRegist == null && shipment.IdTimeNavigation?.DateTimeFactRegist != null)
{
TextStatus = "Зарегистрирован";
ArriveButtonVisibility = Visibility.Visible;
LeftButtonVisibility = Visibility.Collapsed;
}
}
public PrintShipments(DB.Shipment shipment)
{
IdShipment = shipment.IdShipment;
if (shipment.IdDriverNavigation != null)
{
FioTelephone = $"{shipment.IdDriverNavigation.Family} {shipment.IdDriverNavigation.Name} {shipment.IdDriverNavigation.Patronymic} {shipment.IdDriverNavigation.Phone}";
}
DatePlan = shipment.IdTimeNavigation.DateTimePlanRegist.HasValue ? shipment.IdTimeNavigation.DateTimePlanRegist.Value.ToString(CultureInfo.CurrentCulture) : "";
DateArrive = shipment.IdTimeNavigation.DateTimeArrive.HasValue ? shipment.IdTimeNavigation.DateTimeArrive.Value.ToString(CultureInfo.CurrentCulture) : "";
DateLoad = shipment.IdTimeNavigation.DateTimeLoad.HasValue ? shipment.IdTimeNavigation.DateTimeLoad.Value.ToString(CultureInfo.CurrentCulture) : "";
DateEndLoad = shipment.IdTimeNavigation.DateTimeEndLoad.HasValue ? shipment.IdTimeNavigation.DateTimeEndLoad.Value.ToString(CultureInfo.CurrentCulture) : "";
Contragent = shipment.IdContragentNavigation?.Name;
Attorney = shipment.IdDriverNavigation?.Attorney;
Auto = shipment.IdDriverNavigation?.Auto + " " + shipment.IdDriverNavigation?.AutoNumber;
PlanDate = DatePlan;
//PlanTime = DatePlan.ToShortTimeString();
DateFact = shipment.IdTimeNavigation.DateTimeFactRegist.ToString();
DateLeft = shipment.IdTimeNavigation.DateTimeLeft.ToString();
Sklad = "МВП";
NumRealese = shipment.NumRealese;
PacketDocuments = shipment.PacketDocuments;
TochkaLoad = shipment.TochkaLoad;
ServiceInfo = shipment.ServiceInfo;
Destination = shipment.Destination;
Nomenclature = shipment.Nomenclature;
Size = shipment.Size;
CountPodons = shipment.CountPodons;
Family = shipment.IdDriverNavigation?.Family;
NumAuto = shipment.IdDriverNavigation?.AutoNumber;
TimeLoad = shipment.IdTimeNavigation.DateTimeLoad?.ToShortTimeString();
TimeEnd = shipment.IdTimeNavigation.DateTimeEndLoad?.ToShortTimeString();
if (shipment.IdTimeNavigation.DateTimeLoad != null && shipment.IdTimeNavigation.DateTimeEndLoad != null)
{
DateTime date1 = shipment.IdTimeNavigation.DateTimeLoad.Value;
DateTime date2 = shipment.IdTimeNavigation.DateTimeEndLoad.Value;
var res = date2 - date1;
TimeTotal = res.ToString(@"hh\:mm");
}
StoreKeeper = shipment.StoreKeeper;
TypeLoad = shipment.TypeLoad;
Description = shipment.Description;
}
public PlanShipment(DB.Shipment shipment)
{
IdShipment = shipment.IdShipment;
FIO = shipment.IdDriverNavigation?.Family + " " + shipment.IdDriverNavigation?.Name + " " + shipment.IdDriverNavigation?.Patronymic;
Phone = shipment.IdDriverNavigation?.Phone;
if (shipment.IdTimeNavigation.DateTimePlanRegist.HasValue)
{
PlanDateTime = shipment.IdTimeNavigation.DateTimePlanRegist.Value;
PlanDateTimeString = PlanDateTime.ToString();
}
if (shipment.IdDriverNavigation.AutoNumber != null)
{
NumAuto = shipment.IdDriverNavigation.AutoNumber;
}
}
public PlanShipment(DB.Shipment shipment)
{
IdShipment = shipment.IdShipment;
if (shipment.IdDriverNavigation != null)
{
Fio = $"{shipment.IdDriverNavigation.Family} {shipment.IdDriverNavigation.Name} {shipment.IdDriverNavigation.Patronymic}";
Phone = shipment.IdDriverNavigation.Phone;
}
if (shipment.IdTimeNavigation.DateTimePlanRegist.HasValue)
{
PlanDateTime = shipment.IdTimeNavigation.DateTimePlanRegist.Value;
PlanDateTimeString = PlanDateTime.ToString(CultureInfo.CurrentCulture);
}
if (shipment.IdDriverNavigation.AutoNumber != null)
{
NumAuto = shipment.IdDriverNavigation.AutoNumber;
}
}
/// Добавить соответственно
private void btn_add_Click(object sender, RoutedEventArgs e)
{
try
{
using (DB.RegistrantCoreContext ef = new DB.RegistrantCoreContext())
{
DB.Shipment shipment = new DB.Shipment();
if (cb_drivers.SelectedItem != null)
{
var test = cb_drivers as ComboBox;
var current = test.SelectedItem as Models.Drivers;
shipment.IdDriver = current.IdDriver;
}
DB.Time time = new DB.Time();
shipment.IdTimeNavigation = time;
if (dt_plan.Value != null)
{
time.DateTimePlanRegist = dt_plan.Value;
}
if (dt_fact.Value != null)
{
time.DateTimeFactRegist = dt_fact.Value;
}
if (dt_arrive.Value != null)
{
time.DateTimeArrive = dt_arrive.Value;
}
if (dt_load.Value != null)
{
time.DateTimeLoad = dt_load.Value;
}
if (dt_endload.Value != null)
{
time.DateTimeEndLoad = dt_endload.Value;
}
if (dt_left.Value != null)
{
time.DateTimeLeft = dt_left.Value;
}
if (tb_numrealese.Text != null)
{
shipment.NumRealese = tb_numrealese.Text;
}
if (tb_packetdoc.Text != null)
{
shipment.PacketDocuments = tb_packetdoc.Text;
}
if (tb_tochkaload.Text != null)
{
shipment.TochkaLoad = tb_tochkaload.Text;
}
if (tb_CountPodons.Text != null)
{
shipment.CountPodons = tb_CountPodons.Text;
}
if (tb_nomencluture.Text != null)
{
shipment.Nomenclature = tb_nomencluture.Text;
}
if (tb_size.Text != null)
{
shipment.Size = tb_size.Text;
}
if (tb_Destination.Text != null)
{
shipment.Destination = tb_Destination.Text;
}
if (tb_typeload.Text != null)
{
shipment.TypeLoad = tb_typeload.Text;
}
if (tb_descript.Text != null)
{
shipment.Description = tb_descript.Text;
}
if (tb_storekeeper.Text != null)
{
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);
}
}
public Shipments(DB.Shipment shipment)
{
IdShipment = shipment.IdShipment;
IdDriver = shipment.IdDriver;
NumRealese = shipment.NumRealese;
CountPodons = shipment.CountPodons;
PacketDocuments = shipment.PacketDocuments;
TochkaLoad = shipment.TochkaLoad;
Nomenclature = shipment.Nomenclature;
Size = shipment.Size;
Destination = shipment.Destination;
TypeLoad = shipment.TypeLoad;
Description = shipment.Description;
StoreKeeper = shipment.StoreKeeper;
ServiceInfo = shipment.ServiceInfo;
Contragent = shipment.IdContragentNavigation?.Name;
Family = shipment.IdDriverNavigation?.Family;
Name = shipment.IdDriverNavigation?.Name;
Patronymic = shipment.IdDriverNavigation?.Patronymic;
Fio = $"{Family} {Name} {Patronymic}";
Phone = shipment.IdDriverNavigation?.Phone;
if (shipment.IdTimeNavigation.DateTimePlanRegist.HasValue)
{
DateTimePlanRegist = shipment.IdTimeNavigation.DateTimePlanRegist.Value;
}
if (shipment.IdTimeNavigation.DateTimeFactRegist.HasValue)
{
DateTimeFactRegist = shipment.IdTimeNavigation.DateTimeFactRegist.Value;
}
if (shipment.IdTimeNavigation.DateTimeArrive.HasValue)
{
DateTimeArrive = shipment.IdTimeNavigation.DateTimeArrive.Value;
}
if (shipment.IdTimeNavigation.DateTimeArrive.HasValue)
{
DateTimeArrive = shipment.IdTimeNavigation.DateTimeArrive.Value;
}
if (shipment.IdTimeNavigation.DateTimeLoad.HasValue)
{
DateTimeLoad = shipment.IdTimeNavigation.DateTimeLoad.Value;
}
if (shipment.IdTimeNavigation.DateTimeEndLoad.HasValue)
{
DateTimeEndLoad = shipment.IdTimeNavigation.DateTimeEndLoad.Value;
}
if (shipment.IdTimeNavigation.DateTimeLeft.HasValue)
{
DateTimeLeft = shipment.IdTimeNavigation.DateTimeLeft.Value;
}
if (shipment.IdTimeNavigation.DateTimeLeft != null)
{
TextStatus = "Покинул склад (" + DateTimeLeft.ToString(CultureInfo.CurrentCulture) + ")";
}
else if (shipment.IdTimeNavigation?.DateTimeLeft == null && shipment.IdTimeNavigation?.DateTimeEndLoad != null)
{
TextStatus = "Отгрузка завершена (" + DateTimeEndLoad.ToString(CultureInfo.CurrentCulture) + ")";
}
else if (shipment.IdTimeNavigation?.DateTimeEndLoad == null && shipment.IdTimeNavigation?.DateTimeLoad != null)
{
TextStatus = "Отгрузка (" + DateTimeLoad.ToString(CultureInfo.CurrentCulture) + ")";
}
else if (shipment.IdTimeNavigation?.DateTimeLoad == null && shipment.IdTimeNavigation?.DateTimeArrive != null)
{
TextStatus = "На территории склада (" + DateTimeArrive.ToString(CultureInfo.CurrentCulture) + ")";
Color = "#FFF9C38B";
}
else if (shipment.IdTimeNavigation?.DateTimeArrive == null && shipment.IdTimeNavigation?.DateTimeFactRegist != null)
{
TextStatus = "Зарегистрирован (" + DateTimeFactRegist.ToString(CultureInfo.CurrentCulture) + ")";
Color = "#FFFFEEDC";
}
else if (shipment.IdTimeNavigation?.DateTimeFactRegist == null && shipment.IdTimeNavigation?.DateTimePlanRegist != null)
{
TextStatus = "";
}
else if (shipment.IdTimeNavigation?.DateTimePlanRegist == null && shipment.IdTimeNavigation?.DateTimeFactRegist != null)
{
TextStatus = "Зарегистрирован (" + DateTimeFactRegist.ToString(CultureInfo.CurrentCulture) + ")";
Color = "#FFFFEEDC";
}
}
/// Добавить соответственно
private void btn_add_Click(object sender, RoutedEventArgs e)
{
if (cb_drivers.Text != "")
{
if (cb_contragent.Text != "")
{
if (dt_plan.Value != null)
{
try
{
using (DB.RegistrantCoreContext ef = new DB.RegistrantCoreContext())
{
DB.Shipment shipment = new DB.Shipment();
if (cb_drivers.SelectedItem != null)
{
var test = cb_drivers as ComboBox;
var current = test.SelectedItem as Models.Drivers;
shipment.IdDriver = current.IdDriver;
}
else
{
//Если водителя нет в списках
DB.Driver driver = new DB.Driver();
shipment.IdDriverNavigation = driver;
var temp = SplitNames(cb_drivers.Text + " ");
driver.Name = temp.name.Replace(" ", "");
driver.Family = temp.family.Replace(" ", "");
driver.Patronymic = temp.patronomyc.Replace(" ", "");
driver.AutoNumber = tb_autonum.Text;
driver.Attorney = tb_attorney.Text;
driver.Phone = tb_phone.Text;
driver.Auto = tb_auto.Text;
driver.Active = "1";
driver.ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил водителя";
}
if (cb_contragent.SelectedItem != null)
{
var test = cb_contragent as ComboBox;
var current = test.SelectedItem as DB.Contragent;
shipment.IdContragent = current.IdContragent;
}
else
{
DB.Contragent contragent = new DB.Contragent();
contragent.Name = cb_contragent.Text;
contragent.Active = "1";
contragent.ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил контрагента";
shipment.IdContragentNavigation = contragent;
}
DB.Time time = new DB.Time();
shipment.IdTimeNavigation = time;
if (dt_plan.Value != null)
{
time.DateTimePlanRegist = dt_plan.Value;
}
if (dt_fact.Value != null)
{
time.DateTimeFactRegist = dt_fact.Value;
}
if (dt_arrive.Value != null)
{
time.DateTimeArrive = dt_arrive.Value;
}
if (dt_load.Value != null)
{
time.DateTimeLoad = dt_load.Value;
}
if (dt_endload.Value != null)
{
time.DateTimeEndLoad = dt_endload.Value;
}
if (dt_left.Value != null)
{
time.DateTimeLeft = dt_left.Value;
}
if (tb_numrealese.Text != null)
{
shipment.NumRealese = tb_numrealese.Text;
}
if (tb_packetdoc.Text != null)
{
shipment.PacketDocuments = tb_packetdoc.Text;
}
if (tb_tochkaload.Text != null)
{
shipment.TochkaLoad = tb_tochkaload.Text;
}
if (tb_CountPodons.Text != null)
{
shipment.CountPodons = tb_CountPodons.Text;
}
if (tb_nomencluture.Text != null)
{
shipment.Nomenclature = tb_nomencluture.Text;
}
if (tb_size.Text != null)
{
shipment.Size = tb_size.Text;
}
if (tb_Destination.Text != null)
{
shipment.Destination = tb_Destination.Text;
}
if (tb_typeload.Text != null)
{
shipment.TypeLoad = tb_typeload.Text;
}
if (tb_descript.Text != null)
{
shipment.Description = tb_descript.Text;
}
if (tb_storekeeper.Text != null)
{
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);
}
}
else
{
MessageBox.Show("Дата плановой загрузки не заполнена!", "Внимание!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("Контрагент не выбран", "Внимание!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("Водитель не выбран", "Внимание!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void btn_add_add_Click(object sender, RoutedEventArgs e)
{
if (cb_drivers.Text == "")
{
return;
}
try
{
using (DB.RegistrantCoreContext ef = new DB.RegistrantCoreContext())
{
DB.Shipment shipment = new DB.Shipment();
if (cb_drivers.SelectedItem != null)
{
var test = cb_drivers as ComboBox;
var current = test.SelectedItem as Models.Drivers;
shipment.IdDriver = current.IdDriver;
}
else
{
//Если водителя нет в списках
DB.Driver driver = new DB.Driver();
shipment.IdDriverNavigation = driver;
var temp = SplitNames(cb_drivers.Text + " ");
driver.Name = temp.name.Replace(" ", "");
driver.Family = temp.family.Replace(" ", "");
driver.Patronymic = temp.patronomyc.Replace(" ", "");
driver.AutoNumber = tb_autonum.Text;
driver.Attorney = tb_attorney.Text;
driver.Phone = tb_phone.Text;
driver.AutoNumber = tb_autonum.Text;
driver.Passport = tb_passport.Text;
driver.Active = "1";
driver.ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил водителя";
}
DB.Time time = new DB.Time();
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);
}
/*
* if (tb_family.Text != "")
* {
* try
* {
* using (DB.RegistrantCoreContext ef = new DB.RegistrantCoreContext())
* {
* DB.Shipment shipment = new DB.Shipment();
* shipment.IdDriverNavigation = new DB.Driver();
* shipment.IdTimeNavigation = new DB.Time();
* shipment.IdDriverNavigation.Family = tb_family.Text;
* shipment.IdDriverNavigation.Name = tb_name.Text;
* shipment.IdDriverNavigation.Patronymic = tb_patronymic.Text;
* shipment.IdDriverNavigation.Phone = tb_phone.Text;
* shipment.IdDriverNavigation.AutoNumber = tb_autonum.Text;
* shipment.IdDriverNavigation.Passport = tb_passport.Text;
* shipment.IdDriverNavigation.Info = tb_info.Text;
* shipment.IdDriverNavigation.ServiceInfo = DateTime.Now + " " + App.ActiveUser + " добавил карточку водителя";
*
* shipment.IdTimeNavigation.DateTimeFactRegist = DateTime.Now;
*
* shipment.ServiceInfo = DateTime.Now + " " + App.ActiveUser + " каскадное добавление с карточкой водителя";
*
* ef.Add(shipment);
* ef.SaveChanges();
* ContentAdd.Hide();
* btn_refresh_Click(sender, e);
* }
* }
* catch (Exception ex)
* {
* ((MainWindow)System.Windows.Application.Current.MainWindow).ContentErrorText.ShowAsync();
* ((MainWindow)System.Windows.Application.Current.MainWindow).text_debuger.Text = ex.ToString();
* }
* }
* else
* {
* MessageBox.Show("Введите хотябы фамилию водителя!", "Внимание!", MessageBoxButton.OK, MessageBoxImage.Error);
* }*/
}
