Пример #1
0
        public void Button_Save(object sender, RoutedEventArgs e)
        {
            List <BD.Managers> manager = new List <BD.Managers>();

            using (CRMContext dbContext = new CRMContext())
            {
                foreach (var item in dbContext.Managers)
                {
                    manager.Add(item);
                }
            }
            XMLE.XML.Save_Managers(manager);
        }
Пример #2
0
        private void Button_Save(object sender, RoutedEventArgs e)
        {
            List <BD.Tasks> task = new List <BD.Tasks>();

            using (CRMContext dbContext = new CRMContext())
            {
                foreach (var item in dbContext.Tasks)
                {
                    task.Add(item);
                }
            }
            XMLE.XML.Save_Tasks(task);
        }
Пример #3
0
        private void Button_Save(object sender, RoutedEventArgs e)
        {
            List <BD.Clients> clients = new List <BD.Clients>();

            using (CRMContext dbContext = new CRMContext())
            {
                foreach (var item in dbContext.Clients)
                {
                    clients.Add(item);
                }
            }
            XMLE.XML.Save_Clients(clients);
        }
        private void button_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                using (CRMContext dbContext = new CRMContext())
                {
                    var position = new BD.CatalogPositions();
                    position.Position = l_position.Text;
                    if (l_pay.Text != "")
                    {
                        position.Pay = Convert.ToDecimal(l_pay.Text);
                    }
                    else
                    {
                        position.Pay = Convert.ToDecimal(1);
                    }

                    var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
                    var context = new ValidationContext(position);
                    if (!Validator.TryValidateObject(position, context, results, true))
                    {
                        foreach (var error in results)
                        {
                            MessageBox.Show(error.ErrorMessage);
                        }
                    }
                    else
                    {
                        try
                        {
                            dbContext.CatalogPositions.Add(position);
                            dbContext.SaveChanges();
                        }
                        catch
                        {
                            MessageBox.Show("Ошибка");
                        }
                    }
                    if (Validator.TryValidateObject(position, context, results, true))
                    {
                        this.Close();
                    }
                }
                this.Close();
            }
            catch
            {
                MessageBox.Show("Неверно введены данные");
            }
        }
Пример #5
0
 /// <summary>
 /// Удаление клиента из базы
 /// </summary>
 /// <param name="client"></param>
 private void DeleteClient(Client client)
 {
     using (var dataBase = new CRMContext())
     {
         Client tempClient = dataBase.Clients
                             .Where(o => o.Id == client.Id)
                             .FirstOrDefault();
         if (tempClient != null)
         {
             dataBase.Clients.Remove(tempClient);
             dataBase.SaveChanges();
         }
     }
 }
Пример #6
0
 private List <Person> GenerateData()
 {
     using (CRMContext dbContext = new CRMContext())
     {
         List <Person> personList = new List <Person>();
         foreach (var item in dbContext.Managers)
         {
             personList.Add(new Person {
                 Name = item.Name.ToString()
             });
         }
         return(personList);
     }
 }
Пример #7
0
        public Clients(ref Grid rG)
        {
            InitializeComponent();
            Menu m = new Menu(rG, p_Clients);

            G1.Children.Add(m);

            using (CRMContext dbContext = new CRMContext())
            {
                foreach (var item in dbContext.Clients)
                {
                    dg_Clients.Items.Add(item);
                }
            }
        }
Пример #8
0
 public Add_Manager()
 {
     InitializeComponent();
     using (CRMContext dbContext = new CRMContext())
     {
         foreach (var item in dbContext.CatalogPositions)
         {
             cb_position.Items.Add(item.Position);
         }
         foreach (var item in dbContext.CatalogGroupManagers)
         {
             cb_group.Items.Add(item.Group);
         }
     }
 }
Пример #9
0
        /// <summary>
        /// Удаление заказа из базы
        /// </summary>
        /// <param name="order"></param>
        private void DeleteOrder(Order order)
        {
            using (var dataBase = new CRMContext())
            {
                Order tempOrder = dataBase.Orders
                                  .Where(o => o.Id == order.Id)
                                  .FirstOrDefault();

                if (tempOrder != null)
                {
                    dataBase.Orders.Remove(tempOrder);
                    dataBase.SaveChanges();
                }
            }
        }
 public Change_Client(BD.Clients client)
 {
     InitializeComponent();
     using (CRMContext dbContext = new CRMContext())
     {
         tb_name.Text            = client.Name;
         tb_address.Text         = client.Address;
         tb_phone.Text           = client.Phone;
         tb_email.Text           = client.Email;
         tb_checkingAccoubt.Text = client.CheckingAccount;
         tb_bank.Text            = client.Bank;
         tb_director.Text        = client.Director;
         tb_acccountant.Text     = client.Accountant;
         tb_info.Text            = client.Info;
         del_client = client;
     }
 }
Пример #11
0
        public Tasks(ref Grid rG)
        {
            InitializeComponent();
            Menu m = new Menu(rG, p_Tasks);

            G1.Children.Add(m);

            using (CRMContext dbContext = new CRMContext())
            {
                foreach (var item in dbContext.Tasks)
                {
                    if (IAm.isAdmin || IAm.myName == item.Manager)
                    {
                        dg_Tasks.Items.Add(item);
                    }
                }
            }
        }
Пример #12
0
 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("Ошибка! Имеются записи, которые зависят от этой записи!");
     }
 }
Пример #13
0
        private void button_Click(object sender, RoutedEventArgs e)
        {
            using (CRMContext dbContext = new CRMContext())
            {
                var    task = new BD.Tasks();
                Random rnd  = new Random();
                try
                {
                    int i = 1 + rnd.Next(10000);
                    task.Id = i;
                }
                catch (Exception)
                {
                    MessageBox.Show("Повторите попытку");
                }
                task.Client       = l_client.Text;
                task.Manager      = l_manager.Text;
                task.Task         = l_task.Text;
                task.Info         = l_info.Text;
                task.Status       = l_status.Text;
                task.DateStart    = d_start.SelectedDate;
                task.DateComplete = d_complete.SelectedDate;

                var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
                var context = new ValidationContext(task);
                if (!Validator.TryValidateObject(task, context, results, true))
                {
                    foreach (var error in results)
                    {
                        MessageBox.Show(error.ErrorMessage);
                    }
                }
                else
                {
                    dbContext.Tasks.Add(task);
                    dbContext.SaveChanges();
                }
                if (Validator.TryValidateObject(task, context, results, true))
                {
                    this.Close();
                }
            }
        }
Пример #14
0
 private void button_Click(object sender, RoutedEventArgs e)
 {
     using (CRMContext dbContext = new CRMContext())
     {
         var    group = new BD.CatalogGroupManagers();
         Random rnd   = new Random();
         try
         {
             int i = 1 + rnd.Next(10000);
             group.Group = l_id.Text;
             group.Id    = i;
         }
         catch (Exception)
         {
             MessageBox.Show("Повторите попытку");
         }
         var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
         var context = new ValidationContext(group);
         if (!Validator.TryValidateObject(group, context, results, true))
         {
             foreach (var error in results)
             {
                 MessageBox.Show(error.ErrorMessage);
             }
         }
         else
         {
             try
             {
                 dbContext.CatalogGroupManagers.Add(group);
                 dbContext.SaveChanges();
             }
             catch
             {
                 MessageBox.Show("Ошибка");
             }
         }
         if (Validator.TryValidateObject(group, context, results, true))
         {
             this.Close();
         }
     }
 }
Пример #15
0
        /// <summary>
        /// Начальное заполнение списков данными из базы
        /// </summary>
        private void Connect()
        {
            ClientsList.Clear();
            OrdersList.Clear();

            using (var dataBase = new CRMContext())
            {
                var Clients = dataBase.Clients;
                var Orders  = dataBase.Orders;
                foreach (Client client in Clients)
                {
                    ClientsList.Add(client);
                }
                foreach (Order order in Orders)
                {
                    OrdersList.Add(order);
                }
            }
        }
        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();
                }
            }
        }
Пример #17
0
 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();
     }
 }
Пример #18
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();
                }
            }
        }
Пример #19
0
 public ChangeCatalog()
 {
     InitializeComponent();
     using (CRMContext dbContext = new CRMContext())
     {
         foreach (var item in dbContext.CatalogGroupManagers)
         {
             dg_cGroup.Items.Add(item);
         }
         foreach (var item in dbContext.CatalogPositions)
         {
             dg_cPositions.Items.Add(item);
         }
         foreach (var item in dbContext.CatalogStatus)
         {
             dg_cStatus.Items.Add(item);
         }
         foreach (var item in dbContext.CatalogTasks)
         {
             dg_cTask.Items.Add(item);
         }
     }
 }
Пример #20
0
 public Add()
 {
     InitializeComponent();
     using (CRMContext dbContext = new CRMContext())
     {
         foreach (var item in dbContext.CatalogTasks)
         {
             l_task.Items.Add(item.Task);
         }
         foreach (var item in dbContext.CatalogStatus)
         {
             l_status.Items.Add(item.Status);
         }
         foreach (var item in dbContext.Managers)
         {
             l_manager.Items.Add(item.Name);
         }
         foreach (var item in dbContext.Clients)
         {
             l_client.Items.Add(item.Name);
         }
     }
 }
        private void button_Click(object sender, RoutedEventArgs e)
        {
            using (CRMContext dbContext = new CRMContext())
            {
                position.Position = l_id.Text;
                position.Pay      = Convert.ToInt16(l_id_Copy.Text);

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

            this.Close();
        }
Пример #22
0
 public CustomerController(CRMContext context)
 {
     _context = context;
 }
Пример #23
0
 public EmployeeController(CRMContext context)
 {
     _context = context;
 }
Пример #24
0
 public LeadController(CRMContext context)
 {
     _context = context;
 }
Пример #25
0
        public Param(ref Grid rG)
        {
            InitializeComponent();
            Menu m = new Menu(rG, p_Param);

            G1.Children.Add(m);
            using (CRMContext dbContext = new CRMContext())
            {
                int cl = 0, ma = 0, ta = 0, tcp = 0, tnp = 0, tp = 0, tc = 0, mt = 0, mw = 0, mm = 0;
                foreach (var item in dbContext.Clients)
                {
                    cl++;
                }
                foreach (var item in dbContext.Managers)
                {
                    ma++;
                    if (item.DateRecruitment <= DateTime.Today && item.DateRecruitment > (DateTime.Today).AddDays(-1))
                    {
                        mt++;
                    }
                    if (item.DateRecruitment <= (DateTime.Today).AddDays(-1) && item.DateRecruitment >= (DateTime.Today).AddDays(-7))
                    {
                        mw++;
                    }
                    if (item.DateRecruitment <= (DateTime.Today).AddDays(-7) && item.DateRecruitment >= (DateTime.Today).AddMonths(-1))
                    {
                        mm++;
                    }
                }
                foreach (var item in dbContext.Tasks)
                {
                    ta++;
                    if (item.CatalogStatus.Status == "Выполнена")
                    {
                        tcp++;
                    }
                    if (item.CatalogStatus.Status == "Отменена")
                    {
                        tc++;
                    }
                    if (item.CatalogStatus.Status == "Не выполнена")
                    {
                        tnp++;
                    }
                    if (item.CatalogStatus.Status == "В процессе")
                    {
                        tp++;
                    }
                }
                countTask.Content       = ta;
                countClients.Content    = cl;
                countManagers.Content   = ma;
                countComplete.Content   = tcp;
                countCancel.Content     = tc;
                countNoComplete.Content = tnp;
                countInProcess.Content  = tp;
                countManToday.Content   = mt;
                countManWeek.Content    = mw;
                countManMonth.Content   = mm;
            }
        }
Пример #26
0
        private void search_task_TextChanged(object sender, TextChangedEventArgs e)
        {
            using (CRMContext dbContext = new CRMContext())
            {
                dg_Tasks.Items.Clear();
                foreach (var item in dbContext.Tasks)
                {
                    string search = Convert.ToString(search_task.Text).ToLower();
                    if (search_task.Text == "")
                    {
                        dg_Tasks.Visibility = Visibility.Collapsed;
                    }
                    else if ((item.Task.ToString().ToLower()).Contains(search) || (item.Id.ToString()).Contains(search) || (item.Client.ToString().ToLower()).Contains(search) || (item.Manager.ToString().ToLower()).Contains(search) || (item.Info.ToString().ToLower()).Contains(search) || (item.DateStart.ToString().ToLower()).Contains(search) || (item.DateComplete.ToString().Contains(search)) || (item.Status.ToString().ToLower()).Contains(search))
                    {
                        dg_Tasks.Visibility = Visibility.Visible;
                        dg_Tasks.Items.Add(item);
                    }
                    else if (dg_Tasks.Items.Count == 0)
                    {
                        dg_Tasks.Visibility = Visibility.Collapsed;
                    }
                }


                dg_Clients.Items.Clear();
                foreach (var item in dbContext.Clients)
                {
                    string search = Convert.ToString(search_task.Text).ToLower();
                    if (search_task.Text == "")
                    {
                        dg_Clients.Visibility = Visibility.Collapsed;
                    }
                    else if (item.Name.ToString().ToLower().Contains(search) || (item.Address.ToString().ToLower()).Contains(search) || (item.Phone.ToString().ToLower()).Contains(search) || (item.Email.ToString().ToLower()).Contains(search) || (item.CheckingAccount.ToString().ToLower()).Contains(search) || (item.Bank.ToString().ToLower()).Contains(search) || (item.Director.ToString().ToLower()).Contains(search) || (item.Accountant.ToString().ToLower()).Contains(search)) //|| (item.Info.ToString().ToLower()).Contains(search))
                    {
                        dg_Clients.Visibility = Visibility.Visible;
                        dg_Clients.Items.Add(item);
                    }
                    else if (dg_Clients.Items.Count == 0)
                    {
                        dg_Clients.Visibility = Visibility.Collapsed;
                    }
                }
                dg_Managers.Items.Clear();
                foreach (var item in dbContext.Managers)
                {
                    string search = Convert.ToString(search_task.Text).ToLower();
                    if (search_task.Text == "")
                    {
                        dg_Managers.Visibility = Visibility.Collapsed;
                    }
                    else if (item.Name.ToString().ToLower().Contains(search) || (item.Login.ToString().ToLower()).Contains(search) || (item.Password.ToString().ToLower()).Contains(search) || (item.Position.ToString().ToLower()).Contains(search) || (item.Group.ToString().ToLower()).Contains(search) || (item.Address.ToString().ToLower()).Contains(search) || (item.Phone.ToString().ToLower()).Contains(search) || (item.Passport.ToString().ToLower()).Contains(search) || (item.DateOfBirth.ToString().ToLower()).Contains(search) || (item.DateRecruitment.ToString().ToLower()).Contains(search) || (item.Email.ToString().ToLower()).Contains(search) || (item.Info.ToString().ToLower()).Contains(search))
                    {
                        dg_Managers.Visibility = Visibility.Visible;
                        dg_Managers.Items.Add(item);
                    }
                    else if (dg_Managers.Items.Count == 0)
                    {
                        dg_Managers.Visibility = Visibility.Collapsed;
                    }
                }
            }
        }