Пример #1
0
        private void LoadDate()
        {
            CustomerEntities db = new CustomerEntities();

            customers = db.Customers;
            foreach (var item in customers)
            {
                //Debug.WriteLine(item.Name + " " + item.Surname);
                dGv_dane_z_bazy.Rows.Add(item.Name, item.Surname);
            }
        }
Пример #2
0
        private void btn_SaveChanges_Click(object sender, EventArgs e)
        {
            CustomerEntities db = new CustomerEntities();

            if (log_add)
            {
                Customers cst = new Customers();
                cst.Name     = txB_Name.Text;
                cst.Surname  = txB_Surname.Text;
                cst.Country  = txB_Country.Text;
                cst.City     = txB_City.Text;
                cst.Birthday = dTP_Birthday.Value;
                db.Customers.Add(cst);

                log_add = false;
                btn_SaveChanges.Text       = "Zapisz zmiany";
                cBx_deleteCustomer.Visible = true;
            }
            else
            {
                Customers cust     = customers.ToList()[curRow];
                var       customer = db.Customers.Where(s => s.ID == cust.ID).First();

                if (cBx_deleteCustomer.Checked == false)
                {
                    customer.Name     = txB_Name.Text;
                    customer.Surname  = txB_Surname.Text;
                    customer.Country  = txB_Country.Text;
                    customer.City     = txB_City.Text;
                    customer.Birthday = dTP_Birthday.Value;
                }
                else
                {
                    db.Customers.Remove(customer);
                }
            }
            db.SaveChanges();
            RestartDate();
        }