Example #1
0
 private void Click_Edit(object sender, RoutedEventArgs e)
 {
     try
     {
         var inMemoryDAL = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
         using (var uow = new UnitOfWork(inMemoryDAL))
         {
             XPQuery <Product_ProductReceive> items      = new XPQuery <Product_ProductReceive>(uow);
             Product_ProductReceive           searchItem = items.FirstOrDefault(i => i.ID == Convert.ToInt32(((Windows.UI.Xaml.Controls.ContentControl)sender).Content.ToString()));
             if (!String.IsNullOrEmpty(searchItem.ContainerNo))
             {
                 newContainer.Text = (searchItem.ContainerNo).ToString();
             }
             if (!String.IsNullOrEmpty(searchItem.DriverName))
             {
                 newDriver.Text = (searchItem.DriverName).ToString();
             }
             if (!String.IsNullOrEmpty(searchItem.TruckRegistration))
             {
                 newTruckReg.Text = (searchItem.TruckRegistration).ToString();
             }
             newWbTicket.Text = (searchItem.WBTicket).ToString();
         }
     }
     catch (Exception ex)
     {
         var msg = ex.Message;
     }
 }
Example #2
0
        public void UpdateRecord(int id)
        {
            var inMemoryDAL = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);

            using (var uow = new UnitOfWork(inMemoryDAL))
            {
                Product_ProductReceive product = uow.FindObject <Product_ProductReceive>(id);
            }
        }
Example #3
0
        public void saveRecord()
        {
            var inMemoryDAL = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);

            validateInput();
            try
            {
                using (var uow = new UnitOfWork(inMemoryDAL))
                {
                    string        val        = OrderLookupEdit.SelectedItem.ToString();
                    Order_OrderIn searchItem = new XPQuery <Order_OrderIn>(uow).FirstOrDefault(i => i.OrderNo.Equals(cleanString(val)));

                    //ExpectedTrucks searchTruck = new XPQuery<ExpectedTrucks>(uow).FirstOrDefault(i => i.ID.Equals(lblExpTruck.Text));
                    //Library_Supplier L_SearchItem = new XPQuery<Library_Supplier>(uow).FirstOrDefault(i => i.Name == (SupplierComboBox.SelectedValue.ToString()));
                    // var result = TransComboBox.SelectedItem.Content.ToString();
                    Library_Transporter LT_SearchItem = new XPQuery <Library_Transporter>(uow).FirstOrDefault(i => i.Name.Equals(Transporter));

                    Product_ProductReceive pr = new Product_ProductReceive(uow);
                    var item = OrderLookupEdit.SelectedItem;
                    try
                    {
                        tar           = Convert.ToDouble(txtTar.Text);
                        gross         = Convert.ToDouble(txtGross.Text);
                        txtNett.Text  = calcNettWeight(tar, gross).ToString();
                        pr.NettWeight = calcNettWeight(tar, gross);
                        //pr.SupplierID = L_SearchItem;
                        pr.RecOrderID = searchItem;
                        //pr.ExpectedID = searchTruck;
                        pr.TransporterID = LT_SearchItem;
                        pr.ArrivalDate   = DateTime.Now;
                        pr.DriverName    = newDriver.Text;

                        pr.NettWeight = calcNettWeight(Convert.ToDouble(txtGross.Text), Convert.ToDouble(txtNett.Text));

                        //pr.TruckRegistration = searchTruck.TruckRegistration;
                        //pr.ContainerNo = newContainer.Text;
                        pr.WBTicket = Convert.ToInt32(txtWbTicket.Text);
                        pr.Save();
                    }
                    catch
                    {
                        DisplayDialog("An Input Error Occured");
                        return;
                    }
                    uow.CommitChanges();
                    clearInput();
                    DisplayDialog("Transaction Saved");
                }
            }

            catch (Exception ex)
            {
                var Name = ex.Message;

                DisplayDialog("An input error occured");
            }
        }
Example #4
0
        private void commitButton_Click(object sender, RoutedEventArgs e)
        {
            var inMemoryDAL = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);

            try
            {
                using (var uow = new UnitOfWork(inMemoryDAL))
                {
                    XPQuery <Order_OrderIn> items      = new XPQuery <Order_OrderIn>(uow);
                    Order_OrderIn           searchItem = items.FirstOrDefault(i => i.OrderNo == (colorComboBox.SelectedValue.ToString()));

                    XPQuery <Library_Supplier> L_items      = new XPQuery <Library_Supplier>(uow);
                    Library_Supplier           L_SearchItem = L_items.FirstOrDefault(i => i.Name == (SupplierComboBox.SelectedValue.ToString()));

                    XPQuery <Library_Transporter> Trans_items   = new XPQuery <Library_Transporter>(uow);
                    Library_Transporter           LT_SearchItem = Trans_items.FirstOrDefault(i => i.Name == (TransComboBox.SelectedValue.ToString()));

                    var pr = new Product_ProductReceive(uow);
                    pr.SupplierID        = L_SearchItem;
                    pr.RecOrderID        = searchItem;
                    pr.TransporterID     = LT_SearchItem;
                    pr.DateModified      = DateTime.Now;
                    pr.DriverName        = newDriver.Text;
                    pr.TruckRegistration = newTruckReg.Text;
                    pr.ContainerNo       = newContainer.Text;
                    pr.WBTicket          = Convert.ToInt32(newWbTicket.Text);
                    uow.CommitChanges();
                    DisplayDialog();
                    PopulateGridControl();
                    newContainer.Text = "";
                    newWbTicket.Text  = "";
                    newTruckReg.Text  = "";
                    newDriver.Text    = "";
                }
            }
            catch (Exception ex)
            {
                Name = ex.Message;
            }
        }