private void button_Click(object sender, RoutedEventArgs e)
 {
     using (CRMContext dbContext = new CRMContext())
     {
         status.Status = l_id.Text; var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
         var context = new ValidationContext(status);
         if (!Validator.TryValidateObject(status, context, results, true))
         {
             foreach (var error in results)
             {
                 MessageBox.Show(error.ErrorMessage);
             }
         }
         else
         {
             try
             {
                 dbContext.Entry(status).State = System.Data.Entity.EntityState.Modified;
                 dbContext.SaveChanges();
             }
             catch
             {
                 MessageBox.Show("Ошибка!");
             }
         }
         if (Validator.TryValidateObject(status, context, results, true))
         {
             this.Close();
         }
     }
 }
Beispiel #2
0
        public async Task <IActionResult> Post([FromBody] Customer customer)
        {
            if (customer == null)
            {
                return(BadRequest());
            }

            _context.Customer.Add(customer);
            await _context.SaveChangesAsync();

            // This loads the nested details object onto the customer object, without it customer.details is null
            _context.Entry(customer).Reference(c => c.details).Load();

            CustomerDTO customerDto = new CustomerDTO()
            {
                Id      = customer.customer_id,
                Name    = customer.name,
                Email   = customer.email,
                Phone   = customer.phone,
                Age     = customer.age,
                Details = customer.details
            };

            return(CreatedAtRoute("GetCustomer", new { id = customer.customer_id }, customerDto));
        }
Beispiel #3
0
        public async Task <IActionResult> Post([FromBody] Lead lead)
        {
            if (lead == null)
            {
                return(BadRequest());
            }

            _context.Lead.Add(lead);
            await _context.SaveChangesAsync();

            _context.Entry(lead).Reference(l => l.status).Load();
            _context.Entry(lead).Reference(l => l.priority).Load();
            _context.Entry(lead).Reference(l => l.customer).Load();
            // _context.Entry(lead).Reference(l => l.customer.details).Load(); <- figure this out, not working throws a 500
            _context.Entry(lead).Reference(l => l.employee).Load();

            LeadDTO leadDto = new LeadDTO()
            {
                Id          = lead.lead_id,
                LastContact = lead.last_contact,
                Status      = lead.status,
                Priority    = lead.priority,
                Customer    = new CustomerDTO()
                {
                    Id      = lead.customer.customer_id,
                    Name    = lead.customer.name,
                    Email   = lead.customer.email,
                    Phone   = lead.customer.phone,
                    Age     = lead.customer.age,
                    Details = lead.customer.details
                },
                Employee = new EmployeeDTO()
                {
                    Id    = lead.employee.employee_id,
                    Name  = lead.employee.name,
                    Email = lead.employee.email,
                    Phone = lead.employee.phone
                }
            };

            return(CreatedAtRoute("GetLead", new { id = lead.lead_id }, leadDto));
        }
        private void button_Click(object sender, RoutedEventArgs e)
        {
            using (CRMContext dbContext = new CRMContext())
            {
                del_manager.Name  = tb_name.Text;
                del_manager.Login = tb_login.Text;
                if (tb_password.Text != null)
                {
                    del_manager.Password = Hash.EncryptPassword(tb_login.Text, tb_password.Text);
                }
                del_manager.Position = cb_position.SelectedItem.ToString();
                del_manager.Group    = cb_group.SelectedItem.ToString();
                del_manager.Address  = tb_address.Text;
                del_manager.Phone    = tb_phone.Text;
                del_manager.Passport = tb_passport.Text;
                if (del_manager.DateOfBirth >= (DateTime.Today).AddYears(18))
                {
                    MessageBox.Show("Некорректный ввод даты рождения");
                }
                else
                {
                    del_manager.DateOfBirth = d_dateofbirth.SelectedDate;
                }
                del_manager.DateRecruitment = d_daterecruitment.SelectedDate;
                del_manager.Email           = tb_email.Text;
                del_manager.Info            = tb_info.Text;

                var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
                var context = new ValidationContext(del_manager);
                if (!Validator.TryValidateObject(del_manager, context, results, true))
                {
                    foreach (var error in results)
                    {
                        MessageBox.Show(error.ErrorMessage);
                    }
                }
                else
                {
                    try
                    {
                        dbContext.Entry(del_manager).State = System.Data.Entity.EntityState.Modified;
                        dbContext.SaveChanges();
                    }
                    catch
                    {
                        MessageBox.Show("Ошибка!");
                    }
                }
                if (Validator.TryValidateObject(del_manager, context, results, true))
                {
                    this.Close();
                }
            }
        }
 private void Button_Click_1(object sender, RoutedEventArgs e)
 {
     using (CRMContext dbContext = new CRMContext())
     {
         foreach (var item in dbContext.Tasks)
         {
             dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted;
         }
         foreach (var item in dbContext.Managers)
         {
             if (item.Name != "Харсеко Никита Игоревич")
             {
                 dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted;
             }
         }
         foreach (var item in dbContext.Clients)
         {
             dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted;
         }
         dbContext.SaveChanges();
     }
 }
 private void button_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         if (del_obj != null)
         {
             using (CRMContext dbContext = new CRMContext())
             {
                 dbContext.Entry(del_obj).State = System.Data.Entity.EntityState.Deleted;
                 dbContext.SaveChanges();
             }
         }
         this.Close();
     }
     catch (Exception)
     {
         MessageBox.Show("Ошибка! Имеются записи, которые зависят от этой записи!");
     }
 }
        private void button_Click(object sender, RoutedEventArgs e)
        {
            using (CRMContext dbContext = new CRMContext())
            {
                del_client.Name            = tb_name.Text;
                del_client.Address         = tb_address.Text;
                del_client.Phone           = tb_phone.Text;
                del_client.Email           = tb_email.Text;
                del_client.CheckingAccount = tb_checkingAccoubt.Text;
                del_client.Bank            = tb_bank.Text;
                del_client.Director        = tb_director.Text;
                del_client.Accountant      = tb_acccountant.Text;
                del_client.Info            = tb_info.Text;

                var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
                var context = new ValidationContext(del_client);
                if (!Validator.TryValidateObject(del_client, context, results, true))
                {
                    foreach (var error in results)
                    {
                        MessageBox.Show(error.ErrorMessage);
                    }
                }
                else
                {
                    try
                    {
                        dbContext.Entry(del_client).State = System.Data.Entity.EntityState.Modified;
                        dbContext.SaveChanges();
                    }
                    catch
                    {
                        MessageBox.Show("Ошибка!");
                    }
                }
                if (Validator.TryValidateObject(del_client, context, results, true))
                {
                    this.Close();
                }
            }
        }
Beispiel #8
0
        private void button_Click(object sender, RoutedEventArgs e)
        {
            using (CRMContext dbContext = new CRMContext())
            {
                del_task.Client       = l_client.Text;
                del_task.Manager      = l_manager.Text;
                del_task.Task         = l_task.Text;
                del_task.Info         = l_info.Text;
                del_task.Status       = l_status.Text;
                del_task.DateStart    = d_start.SelectedDate;
                del_task.DateComplete = d_complete.SelectedDate;

                var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
                var context = new ValidationContext(del_task);
                if (!Validator.TryValidateObject(del_task, context, results, true))
                {
                    foreach (var error in results)
                    {
                        MessageBox.Show(error.ErrorMessage);
                    }
                }
                else
                {
                    try
                    {
                        dbContext.Entry(del_task).State = System.Data.Entity.EntityState.Modified;
                        dbContext.SaveChanges();
                    }
                    catch
                    {
                        MessageBox.Show("Ошибка!");
                    }
                }
                if (Validator.TryValidateObject(del_task, context, results, true))
                {
                    this.Close();
                }
            }
        }