コード例 #1
0
        private void saveBtn_Click(object sender, RoutedEventArgs e)
        {
            if (_contractor != null)
            {
                using (var db = new ContractorContext())
                {
                    _contractor.ContractorName = ContractorNameBox.Text;
                    _contractor.ManagerName = ManagerNameBox.Text;
                    _contractor.ContactEmail = Email.Text;
                    _contractor.ContactPhone = PhoneNumber.Text;

                    db.Contractors.AddOrUpdate(_contractor);
                    db.SaveChanges();
                }
            }
            else
            {
                using (var db = new ContractorContext())
                {
                    Contractor nc = new Contractor()
                    {
                        ContractorName = ContractorNameBox.Text,
                        ManagerName = ManagerNameBox.Text,
                        ContactEmail = Email.Text,
                        ContactPhone = PhoneNumber.Text
                    };

                    db.Contractors.AddOrUpdate(nc);
                    db.SaveChanges();
                }
            }
            this.Close();
        }
コード例 #2
0
 private void DeleteOrderBtn_Click(object sender, RoutedEventArgs e)
 {
     if (OrdersListBox.SelectedItem == null) return;
     using (var db = new ContractorContext())
     {
         Order item = (Order) OrdersListBox.SelectedItem;
         db.Orders.Remove(db.Orders.Find(item.OrderId));
         db.SaveChanges();
         FillContractorOrders();
         ClearContractorDetails();
     }
 }
コード例 #3
0
        private void RemoveBtn_Click(object sender, RoutedEventArgs e)
        {
            if (ContractorList.SelectedItem == null) return;
            Contractor item = (Contractor) ContractorList.SelectedItem;
            using (var db = new ContractorContext())
            {

                if (db.Contractors.Find(item.ContractorId).Orders != null)
                {
                    foreach (var order in db.Contractors.Find(item.ContractorId).Orders)
                    {
                        db.Orders.Remove(order);
                    }
                }
                db.Contractors.Remove(db.Contractors.Find(item.ContractorId));
                db.SaveChanges();
                FillContractorList();
            }
        }
コード例 #4
0
 private void FillContractorOrders(object sender, EventArgs e)
 {
     OrdersListBox.Items.Clear();
     Contractor theOne = (Contractor) ContractorList.SelectedItem;
     if (theOne == null) return;
     using (var db = new ContractorContext())
     {
         foreach (var item in db.Orders.ToList())
         {
             if (item.ContractorId == theOne.ContractorId)
             {
                 OrdersListBox.Items.Add(item);
             }
         }
     }
 }
コード例 #5
0
 private void FillContractorList()
 {
     using (var db = new ContractorContext())
     {
         ContractorList.Items.Clear();
         if (db.Contractors.ToList().Count <= 0) return;
         foreach (var item in db.Contractors.ToList())
         {
             ContractorList.Items.Add(item);
         }
     }
 }
コード例 #6
0
 private void delPositionBtn_Click(object sender, RoutedEventArgs e)
 {
     if (_order != null)
     {
         using (var db = new ContractorContext())
         {
             if (((PositionsQty)OrderPositions.SelectedItem).OrderId == _order.OrderId)
             {
                 db.PositionsQties.Remove(db.PositionsQties.Find(((PositionsQty)OrderPositions.SelectedItem).Id));
                 db.SaveChanges();
             }
         }
     }
     GridItems.Remove((PositionsQty)OrderPositions.SelectedItem);
     OrderPositions.Items.Refresh();
 }
コード例 #7
0
        private void SaveBtn_Click(object sender, RoutedEventArgs e)
        {
            using (var db = new ContractorContext())
            {
                if (_order == null)
                {
                    Order order = new Order();
                    if (InvoiceNumberBox.Text != null)
                        order.InvoiceNumber = InvoiceNumberBox.Text;
                    order.DeliveryDate = DeliveryDatePick.SelectedDate ?? DateTime.Now;
                    order.OrderDate = OrderDatePick.SelectedDate ?? DateTime.Now;
                    if (InvoiceSumBox.Text != null)
                        order.Sum = Decimal.Parse(InvoiceSumBox.Text.Replace('.', ','));
                    order.ContractorId = _contractor.ContractorId;
                    order.PositionsQty = new List<PositionsQty>();
                    foreach (PositionsQty item in GridItems)
                    {
                        db.PositionsQties.AddOrUpdate(item);
                    }
                    db.Orders.AddOrUpdate(order);
                    db.SaveChanges();
                    this.Close();
                }
                else
                {
                    Order order = _order;
                    if (InvoiceNumberBox.Text != null)
                        order.InvoiceNumber = InvoiceNumberBox.Text;
                    order.DeliveryDate = DeliveryDatePick.SelectedDate ?? DateTime.Now;
                    order.OrderDate = OrderDatePick.SelectedDate ?? DateTime.Now;
                    if (InvoiceSumBox.Text != null)
                        order.Sum = decimal.Parse(InvoiceSumBox.Text.Replace('.', ','));
                    order.ContractorId = _contractor.ContractorId;
                    order.PositionsQty = new List<PositionsQty>();
                    foreach (PositionsQty item in GridItems)
                    {
                        db.PositionsQties.AddOrUpdate(item);
                    }
                    db.Orders.AddOrUpdate(order);
                    db.SaveChanges();
                    this.Close();
                }

            }
        }
コード例 #8
0
        private void FillOrderInfo()
        {
            InvoiceNumberBox.Text = _order.InvoiceNumber;
            OrderDatePick.SelectedDate = _order.OrderDate;
            DeliveryDatePick.SelectedDate = _order.DeliveryDate;
            InvoiceSumBox.Text = _order.Sum.ToString(CultureInfo.CurrentCulture);
            using (var db = new ContractorContext())
            {
                foreach (var item in db.PositionsQties.ToList().Where(item => item.OrderId == _order.OrderId))
                {
                    GridItems.Add(item);
                }

            }
        }