private void button_Click(object sender, RoutedEventArgs e)
        {
            using (CRMContext dbContext = new CRMContext())
            {
                var client = new BD.Clients();
                client.Name            = tb_name.Text;
                client.Address         = tb_address.Text;
                client.Phone           = tb_phone.Text;
                client.Email           = tb_email.Text;
                client.CheckingAccount = tb_checkingAccoubt.Text;
                client.Bank            = tb_bank.Text;
                client.Director        = tb_director.Text;
                client.Accountant      = tb_acccountant.Text;
                client.Info            = tb_info.Text;

                var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
                var context = new ValidationContext(client);
                if (!Validator.TryValidateObject(client, context, results, true))
                {
                    foreach (var error in results)
                    {
                        MessageBox.Show(error.ErrorMessage);
                    }
                }
                else
                {
                    dbContext.Clients.Add(client);
                    dbContext.SaveChanges();
                }
                if (Validator.TryValidateObject(client, context, results, true))
                {
                    this.Close();
                }
            }
        }
Esempio n. 2
0
 static public XElement getXElement(object obj)
 {
     if (obj is CRM.BD.Clients)
     {
         CRM.BD.Clients ctmp   = (CRM.BD.Clients)obj;
         XElement       client = new XElement("Client");
         client.Add(new XElement("Название", ctmp.Name));
         client.Add(new XElement("Адрес", ctmp.Address));
         client.Add(new XElement("Телефон", ctmp.Phone));
         client.Add(new XElement("E_mail", ctmp.Email));
         client.Add(new XElement("Расчетный_счёт", ctmp.CheckingAccount));
         client.Add(new XElement("Банк", ctmp.Bank));
         client.Add(new XElement("Директор", ctmp.Director));
         client.Add(new XElement("Бухгалтер", ctmp.Accountant));
         client.Add(new XElement("Информация", ctmp.Info));
         return(client);
     }
     if (obj is CRM.BD.Managers)
     {
         CRM.BD.Managers mtmp    = (CRM.BD.Managers)obj;
         XElement        manager = new XElement("Manager");
         manager.Add(new XElement("ФИО", mtmp.Name));
         manager.Add(new XElement("Логин", mtmp.Login));
         manager.Add(new XElement("Пароль", mtmp.Password));
         manager.Add(new XElement("Должность", mtmp.Position));
         manager.Add(new XElement("Группа", mtmp.Group));
         manager.Add(new XElement("Адрес", mtmp.Address));
         manager.Add(new XElement("Телефон", mtmp.Phone));
         manager.Add(new XElement("Пасспорт", mtmp.Passport));
         manager.Add(new XElement("Дата_рождения", mtmp.DateOfBirth));
         manager.Add(new XElement("Дата_приема_на_работу", mtmp.DateRecruitment));
         manager.Add(new XElement("E_mail", mtmp.Email));
         if (mtmp.Info != null)
         {
             manager.Add(new XElement("Информация", mtmp.Info));
         }
         else
         {
             manager.Add(new XElement("Информация", ""));
         }
         return(manager);
     }
     if (obj is CRM.BD.Tasks)
     {
         CRM.BD.Tasks ttmp = (CRM.BD.Tasks)obj;
         XElement     task = new XElement("Task");
         task.Add(new XElement("ID", ttmp.Id));
         task.Add(new XElement("Заказчик", ttmp.Client));
         task.Add(new XElement("Исполнитель", ttmp.Manager));
         task.Add(new XElement("Задача", ttmp.Task));
         task.Add(new XElement("Информация", ttmp.Info));
         task.Add(new XElement("Дата_начала", ttmp.DateStart));
         task.Add(new XElement("Дата_завершения", ttmp.DateComplete));
         task.Add(new XElement("Статус", ttmp.Status));
         return(task);
     }
     return(null);
 }
 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;
     }
 }
Esempio n. 4
0
        static public void openXml_clients()
        {
            OpenFileDialog ofd = new OpenFileDialog();

            ofd.InitialDirectory = @"h:\Univer\Учеба\Курсач";
            ofd.Filter           = "Файлы xml |*.xml";
            if (ofd.ShowDialog() == DialogResult.Cancel)
            {
                return;
            }
            filepath = ofd.FileName;
            XmlDocument doc = new XmlDocument();

            doc.Load(filepath);
            XmlNodeList nodes = doc.ChildNodes;

            CRM.BD.Clients client;

            foreach (XmlNode n in nodes)
            {
                if ("Client".Equals(n.Name))
                {
                    for (XmlNode d = n.FirstChild; d != null; d = d.NextSibling)
                    {
                        if ("Client".Equals(d.Name))
                        {
                            client = new CRM.BD.Clients();

                            for (XmlNode k = d.FirstChild; k != null; k = k.NextSibling)
                            {
                                if ("Название".Equals(k.Name))
                                {
                                    client.Name = (k.FirstChild.Value);
                                }
                                else if ("Адрес".Equals(k.Name))
                                {
                                    client.Address = k.FirstChild.Value;
                                }
                                else if ("Телефон".Equals(k.Name))
                                {
                                    client.Phone = k.FirstChild.Value;
                                }
                                else if ("E_mail".Equals(k.Name))
                                {
                                    client.Email = k.FirstChild.Value;
                                }
                                else if ("Расчетный_счёт".Equals(k.Name))
                                {
                                    client.CheckingAccount = k.FirstChild.Value;
                                }
                                else if ("Банк".Equals(k.Name))
                                {
                                    client.Bank = k.FirstChild.Value;
                                }
                                else if ("Директор".Equals(k.Name))
                                {
                                    client.Director = k.FirstChild.Value;
                                }
                                else if ("Бухгалтер".Equals(k.Name))
                                {
                                    client.Accountant = k.FirstChild.Value;
                                }
                                else if ("Информация".Equals(k.Name))
                                {
                                    client.Info = k.FirstChild.Value;
                                }
                            }
                            using (CRMContext dbContext = new CRMContext())
                            {
                                try
                                {
                                    dbContext.Clients.Add(client);
                                    dbContext.SaveChanges();
                                }
                                catch (Exception ee)
                                {
                                    MessageBox.Show("Ошибка!" + ee.Message);
                                }
                            }
                        }
                    }
                }
            }
        }
Esempio n. 5
0
 public Delete(BD.Clients c)
 {
     InitializeComponent();
     del_obj = c;
 }