Example #1
0
        private void button_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                using (var db = new OrexEntities())
                {
                    if (mode == 1)
                    {
                        Warehouse warehouse = new Warehouse();

                        warehouse.City          = tbCity.Text;
                        warehouse.Country       = tbCountry.Text;
                        warehouse.Email         = tbEmail.Text;
                        warehouse.FirstName     = tbFirstName.Text;
                        warehouse.JobTitle      = tbJobTitle.Text;
                        warehouse.LastName      = tbLastName.Text;
                        warehouse.Notes         = tbNotes.Text;
                        warehouse.Phone1        = tbPhone1.Text;
                        warehouse.Phone2        = tbPhone2.Text;
                        warehouse.Phone3        = tbPhone3.Text;
                        warehouse.Phone4        = tbPhone4.Text;
                        warehouse.PostalCode    = tbPCode.Text;
                        warehouse.Province      = tbProvince.Text;
                        warehouse.Street        = tbStreet.Text;
                        warehouse.WarehouseCode = tbCode.Text;

                        db.Warehouses.Add(warehouse);
                        db.SaveChanges();
                        MessageBox.Show("Add Success", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information);
                    }
                    else if (mode == 2)
                    {
                        var warehouse = db.Warehouses.Where(m => m.WarehouseID == warehouseid).FirstOrDefault();

                        warehouse.City          = tbCity.Text;
                        warehouse.Country       = tbCountry.Text;
                        warehouse.Email         = tbEmail.Text;
                        warehouse.FirstName     = tbFirstName.Text;
                        warehouse.JobTitle      = tbJobTitle.Text;
                        warehouse.LastName      = tbLastName.Text;
                        warehouse.Notes         = tbNotes.Text;
                        warehouse.Phone1        = tbPhone1.Text;
                        warehouse.Phone2        = tbPhone2.Text;
                        warehouse.Phone3        = tbPhone3.Text;
                        warehouse.Phone4        = tbPhone4.Text;
                        warehouse.PostalCode    = tbPCode.Text;
                        warehouse.Province      = tbProvince.Text;
                        warehouse.Street        = tbStreet.Text;
                        warehouse.WarehouseCode = tbCode.Text;

                        db.SaveChanges();
                        MessageBox.Show("Update Success", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information);
                    }
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Something went wrong", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }
Example #2
0
        private void button_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                using (var db = new OrexEntities())
                {
                    if (mode == 1)
                    {
                        Contact contact = new Contact();
                        if (rbCustomer.IsChecked == true)
                        {
                            contact.Category = 1;
                        }
                        else if (rbSupplier.IsChecked == true)
                        {
                            contact.Category = 2;
                        }
                        else if (rbMisc.IsChecked == true)
                        {
                            contact.Category = 3;
                        }

                        if (chckboxSalesInvoice.IsChecked == true)
                        {
                            contact.SalesInvoice = true;
                        }
                        else
                        {
                            contact.SalesInvoice = false;
                        }

                        contact.City            = tbCity.Text;
                        contact.Company         = tbCompany.Text;
                        contact.Country         = tbCountry.Text;
                        contact.CreditLimit     = Convert.ToInt32(tbCredit.Text);
                        contact.Email           = tbEmail.Text;
                        contact.FirstName       = tbFirstName.Text;
                        contact.JobTitle        = tbJobTitle.Text;
                        contact.LastName        = tbLastName.Text;
                        contact.Notes           = tbNotes.Text;
                        contact.PaymentTermDays = Convert.ToInt32(tbTerms.Text);
                        contact.Phone1          = tbPhone1.Text;
                        contact.Phone2          = tbPhone2.Text;
                        contact.Phone3          = tbPhone3.Text;
                        contact.Phone4          = tbPhone4.Text;
                        contact.PostalCode      = tbPCode.Text;
                        contact.Province        = tbProvince.Text;
                        contact.SalesPerson     = Convert.ToInt32(cbSalesPerson.SelectedValue);
                        contact.Street          = tbStreet.Text;
                        contact.TIN             = tbTIN.Text;
                        contact.WebPage         = tbWebPage.Text;
                        contact.Street          = tbStreet.Text;

                        db.Contacts.Add(contact);
                        db.SaveChanges();
                        MessageBox.Show("Add Success", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information);
                    }

                    else if (mode == 2)
                    {
                        var contact = db.Contacts.Where(m => m.ContactID == contactid).FirstOrDefault();
                        if (rbCustomer.IsChecked == true)
                        {
                            contact.Category = 1;
                        }
                        else if (rbSupplier.IsChecked == true)
                        {
                            contact.Category = 2;
                        }
                        else if (rbMisc.IsChecked == true)
                        {
                            contact.Category = 3;
                        }

                        if (chckboxSalesInvoice.IsChecked == true)
                        {
                            contact.SalesInvoice = true;
                        }
                        else
                        {
                            contact.SalesInvoice = false;
                        }

                        contact.City            = tbCity.Text;
                        contact.Company         = tbCompany.Text;
                        contact.Country         = tbCountry.Text;
                        contact.CreditLimit     = Convert.ToInt32(tbCredit.Text);
                        contact.Email           = tbEmail.Text;
                        contact.FirstName       = tbFirstName.Text;
                        contact.JobTitle        = tbJobTitle.Text;
                        contact.LastName        = tbLastName.Text;
                        contact.Notes           = tbNotes.Text;
                        contact.PaymentTermDays = Convert.ToInt32(tbTerms.Text);
                        contact.Phone1          = tbPhone1.Text;
                        contact.Phone2          = tbPhone2.Text;
                        contact.Phone3          = tbPhone3.Text;
                        contact.Phone4          = tbPhone4.Text;
                        contact.PostalCode      = tbPCode.Text;
                        contact.Province        = tbProvince.Text;
                        contact.SalesPerson     = Convert.ToInt32(cbSalesPerson.SelectedValue);
                        contact.Street          = tbStreet.Text;
                        contact.TIN             = tbTIN.Text;
                        contact.WebPage         = tbWebPage.Text;

                        db.SaveChanges();
                        MessageBox.Show("Update Success", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information);
                    }
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Something went wrong", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }