Exemplo n.º 1
0
        private static List<User_Inf> getUsers()
        {

            var contex = new WarehouseEntities();
            var users = contex.User_Inf.ToList();
            return users;
        }
        private void addItem()
        {
            if (
                Inspection.CheckNumeric( OrderWindowViewModel.AddItem.txtIdContractor.Text,18,0) &&
                Inspection.CheckNumeric(OrderWindowViewModel.AddItem.txtSumm.Text,18,2) &&
                Inspection.CheckDateTime(OrderWindowViewModel.AddItem.txtDateOrder.Text) &&
                Inspection.CheckDateTime(OrderWindowViewModel.AddItem.txtDateImport.Text)
                )
            {
                Order n = new Order()
                {
                    id_contractor = decimal.Parse(OrderWindowViewModel.AddItem.txtIdContractor.Text),
                    summ = decimal.Parse(OrderWindowViewModel.AddItem.txtSumm.Text),
                    date_order = DateTime.Parse(OrderWindowViewModel.AddItem.txtDateOrder.Text),
                    date_import = DateTime.Parse(OrderWindowViewModel.AddItem.txtDateImport.Text),
                    id_user = AdministratorWindowViewModel.Current_User.id
                };
                Order m;
                using (var context = new WarehouseEntities()) {
                    context.Order.Add(n);
                    context.SaveChanges();
                    m = context.Order.ToList().Last();
                    var orderTable = (OrderWindowViewModel)Application.Current.Resources["OrderWindowViewModel"];
                    orderTable.Orders = context.Order.ToList();
                }
                MessageBox.Show("Запись создана успешно.");

                MerchendiseWindowViewModel f = (MerchendiseWindowViewModel)Application.Current.Resources["MerchendiseWindowViewModel"];
                var carMerch = f.AddItem1(f);
                carMerch.txtConsignment.Text = m.consigment.ToString();
                carMerch.txtConsignment.IsEnabled = false;

                Card addmerch = carMerch;
                addmerch.Show();
            }
            else
            {
                MessageBox.Show("Некорректные данные!");
            }
        }
Exemplo n.º 3
0
        private void addItem()
        {
            var merchTable = (MerchendiseWindowViewModel)Application.Current.Resources["MerchendiseWindowViewModel"];
            if(
                Inspection.CheckString(merchTable.AddItem.Name.Text, 50) &&
                Inspection.CheckNumeric(merchTable.AddItem.txtConsignment.Text, 18, 0) &&
                Inspection.CheckNumeric(merchTable.AddItem.txtCountBooked.Text, 18, 0) &&
                Inspection.CheckNumeric(merchTable.AddItem.txtCountStored.Text, 18, 0) &&
                Inspection.CheckNumeric(merchTable.AddItem.txtCountOrder.Text, 18, 0) &&
                Inspection.CheckNumeric(merchTable.AddItem.txtCost.Text, 18, 2) &&
                Inspection.CheckNumeric(merchTable.AddItem.txtMargin.Text, 18, 2)
                )
            {

                var context = new WarehouseEntities();
                Merchandise n = new Merchandise()
               {
                   brand = merchTable.AddItem.Name.Text,
                   consignment = decimal.Parse(merchTable.AddItem.txtConsignment.Text),
                   arrived = merchTable.AddItem.chkArrived.IsEnabled,
                   count_booked = decimal.Parse(merchTable.AddItem.txtCountBooked.Text),
                   count_stored = decimal.Parse(merchTable.AddItem.txtCountStored.Text),
                   count_order = decimal.Parse(merchTable.AddItem.txtCountOrder.Text),
                   count_send = decimal.Parse(merchTable.AddItem.txtCountSend.Text),
                   specif_n = merchTable.AddItem.Descr.Text,
                   cost = decimal.Parse(merchTable.AddItem.txtCost.Text),
                   id_type = ((Types)merchTable.AddItem.comboType.SelectedValue).id_type,
                   margin = decimal.Parse(merchTable.AddItem.txtMargin.Text)
                };
               context.Merchandise.Add(n);            
               context.SaveChanges();   
               merchTable.Merchandises = context.Merchandise.ToList();
               MessageBox.Show("запись создана");
            }
            else 
            {
                MessageBox.Show("Некорректные данные!");
            }
        }
 private static List<Order> orders()
 {
     var context = new WarehouseEntities();
     return context.Order.ToList();
 }
Exemplo n.º 5
0
 private static List<Types> getTypes()
 {
     var context = new WarehouseEntities();
     var listOfTypes = context.Types.ToList();
     return listOfTypes;
 }
 private static List<Merchandise> merchandises()
 {
     var context = new WarehouseEntities();
     var listOfMerchandise = context.Merchandise.ToList();
     return listOfMerchandise;
 }