Example #1
0
 public Change(BD.Tasks task)
 {
     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);
         }
         l_id.Text               = task.Id.ToString();
         l_manager.Text          = task.Manager;
         l_info.Text             = task.Info;
         l_status.SelectedItem   = task.Status;
         l_client.Text           = task.Client;
         l_task.Text             = task.Task;
         d_complete.SelectedDate = task.DateComplete;
         d_start.SelectedDate    = task.DateStart;
         del_task = task;
     }
 }
Example #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);
 }
Example #3
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();
                }
            }
        }
Example #4
0
        static public void openXml_tasks()
        {
            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.Tasks task;

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

                            for (XmlNode k = d.FirstChild; k != null; k = k.NextSibling)
                            {
                                if ("ID".Equals(k.Name))
                                {
                                    task.Id = Convert.ToInt16(k.FirstChild.Value);
                                }
                                else if ("Заказчик".Equals(k.Name))
                                {
                                    task.Client = k.FirstChild.Value;
                                }
                                else if ("Исполнитель".Equals(k.Name))
                                {
                                    task.Manager = k.FirstChild.Value;
                                }
                                else if ("Задача".Equals(k.Name))
                                {
                                    task.Task = k.FirstChild.Value;
                                }
                                else if ("Информация".Equals(k.Name))
                                {
                                    task.Info = k.FirstChild.Value;
                                }
                                else if ("Дата_начала".Equals(k.Name))
                                {
                                    task.DateStart = Convert.ToDateTime(k.FirstChild.Value);
                                }
                                else if ("Дата_завершения".Equals(k.Name))
                                {
                                    task.DateComplete = Convert.ToDateTime(k.FirstChild.Value);
                                }
                                else if ("Статус".Equals(k.Name))
                                {
                                    task.Status = k.FirstChild.Value;
                                }
                            }
                            using (CRMContext dbContext = new CRMContext())
                            {
                                try
                                {
                                    dbContext.Tasks.Add(task);
                                    dbContext.SaveChanges();
                                }
                                catch (Exception ee)
                                {
                                    MessageBox.Show("Ошибка!" + ee.Message);
                                }
                            }
                        }
                    }
                }
            }
        }
 public Delete(BD.Tasks t)
 {
     InitializeComponent();
     del_obj = t;
 }