示例#1
0
 private void ButtonBase_OnClick(object sender, RoutedEventArgs routedEventArgs)
 {
     if (currentUser == "user1")
     {
         if (currentPassword == passwords[0])
         {
             var newForm = new User1_NewTasks();
             newForm.Show();
             Close();
         }
         else
         {
             MessageBox.Show("Incorrect password");
         }
     }
     else if ((currentUser == "user2" && currentPassword == passwords[1]) ||
              (currentUser == "user3" && currentPassword == passwords[2]) ||
              (currentUser == "user4" && currentPassword == passwords[3]))
     {
         var newForm = new User234_InProgress(currentUser);
         newForm.Show();
         XmlTransformer xmlTranformer = new XmlTransformer();
         Close();
     }
     else
     {
         MessageBox.Show("Incorrect credentails");
     }
 }
示例#2
0
        private void FetchMails_onClick(object sender, RoutedEventArgs e)
        {
            listView.Items.Clear();
            Mail        mail      = new Mail();
            List <Mail> listItems = mail.fetch("user1");


            Dictionary <string, KeyValuePair <int, int> > sync
                = new Dictionary <string, KeyValuePair <int, int> >();

            foreach (var item in listItems)
            {
                listView.Items.Add(item);

                if (sync.Count == 0 || !sync.ContainsKey(item.ID)) //zliczaj maile które przysz³y
                {
                    sync.Add(item.ID, new KeyValuePair <int, int>(/*employeesIncluded*/ 3, 0));
                }

                sync[item.ID] = new KeyValuePair <int, int>(sync[item.ID].Key, sync[item.ID].Value + 1);
            }

            foreach (var v in sync)
            {
                if (v.Value.Key == v.Value.Value)          //sprawdzaj iloϾ maili
                {
                    List <Mail> mails = new List <Mail>(); //kontener na maile które chcemy zebraæ
                    foreach (var m in listItems)
                    {
                        if (m.ID == v.Key)
                        {
                            mails.Add(m);
                            m.downloadAttachment(m.Attachment, m.Content); //pobierz nag³owek
                        }
                    }

                    //scalanie xmli
                    string[] att = new string[mails.Count];

                    for (int i = 0; i < mails.Count; i++)
                    {
                        att[i] = mails[i].Attachment;
                    }
                    XmlTransformer.MergeXmls(att);
                }
            }
        }
示例#3
0
        public static void ExcelToXML(string pathToExcel)
        {
            var excelFile = new FileInfo(pathToExcel);

            var     xmlDoc   = new XmlDocument();
            XmlNode rootNode = xmlDoc.CreateElement("orders");

            xmlDoc.AppendChild(rootNode);


            using (var excel = new ExcelPackage(excelFile))
            {
                foreach (var worksheet in excel.Workbook.Worksheets)
                {
                    var orderNode = xmlDoc.CreateElement("order");
                    rootNode.AppendChild(orderNode);

                    var orderNumber   = worksheet.Cells["G2"].Value.ToString();
                    var status        = (string)worksheet.Cells["H2"].Value.ToString();
                    var clientId      = (string)worksheet.Cells["I2"].Value.ToString();
                    var clientName    = (string)worksheet.Cells["J2"].Value.ToString();
                    var clientSurname = (string)worksheet.Cells["K2"].Value.ToString();

                    XmlTransformer.AddOrderInformation(xmlDoc, orderNode, orderNumber, status, clientId, clientName, clientSurname);

                    var orderColumn = "A";
                    var orderIndex  = 1;

                    do
                    {
                        orderIndex++;
                        try
                        {
                            var cellValue = worksheet.Cells[orderColumn + orderIndex].Value.ToString();
                        }
                        catch (Exception e)
                        {
                            break;
                        }

                        var type           = (string)worksheet.Cells["B" + orderIndex].Value.ToString();
                        var detail         = (string)worksheet.Cells["C" + orderIndex].Value.ToString();
                        var amount         = (string)worksheet.Cells["D" + orderIndex].Value.ToString();
                        var product_status = (string)worksheet.Cells["E" + orderIndex].ToString();

                        var productNode = xmlDoc.CreateElement("order");

                        var typeNode = xmlDoc.CreateElement("type");
                        typeNode.InnerText = type;

                        var detailNode = xmlDoc.CreateElement("detail");
                        detailNode.InnerText = detail;

                        var amountNode = xmlDoc.CreateElement("type");
                        amountNode.InnerText = amount;

                        var productStatusNode = xmlDoc.CreateElement("type");
                        productStatusNode.InnerText = product_status;

                        productNode.AppendChild(typeNode);
                        productNode.AppendChild(detailNode);
                        productNode.AppendChild(amountNode);
                        productNode.AppendChild(productStatusNode);


                        XmlTransformer.AddProduct(xmlDoc, orderNode, productNode);
                    } while (true);
                }
            }

            String orderPath = "..\\..\\xmls_result\\excel_order.xml";

            xmlDoc.Save(orderPath);
            XmlTransformer.DivideOrders(orderPath);
        }