示例#1
0
 internal void Init()
 {
     if (GetParser() == null) {
         ExcelParser parser = new ExcelParser();
         parser.Init();
         lock (_parsers) {
             _parsers.Add(parser);
         }
     }
 }
示例#2
0
        private bool CompareExcelDocuments(ExcelParser prevParser, ExcelParser newParser, out string msg)
        {
            bool hasChanges = false;
            StringBuilder sb = new StringBuilder();
            for (int day = 0; day < 5; ++day) {
                ExcelTable prevTable = prevParser.Doc.GetExcelTable(day);
                ExcelTable newTable = newParser.Doc.GetExcelTable(day);

                List<ngFoodItem> prevFoodsList = FoodManager.Inst.GetFoodsInternal(prevTable);
                List<ngFoodItem> newFoodList = FoodManager.Inst.GetFoodsInternal(newTable);

                foreach (ngFoodItem prevItem in prevFoodsList) {
                    ngFoodItem newItem = ApiUtils.GetFoodById(newFoodList, prevItem.FoodId);
                    if (null == newItem) {
                        hasChanges = true;
                        sb.AppendFormat("�������� ��� ������������� '{0}'\n", prevItem.Name);
                    }
                    else {
                        if (newItem.Name != null && !newItem.Name.Equals(prevItem.Name)) {
                            hasChanges = true;
                            sb.AppendFormat("������ ����� '{0}' �� '{1}'\n", prevItem.Name, newItem.Name);
                        }
                        if (newItem.Description != null && !newItem.Description.Equals(prevItem.Description)) {
                            hasChanges = true;
                            sb.AppendFormat("������ ���� '{0}' '{1}' �� '{2}'\n", prevItem.Name, prevItem.Description, newItem.Description);
                        }
                        if (!newItem.Price.Equals(prevItem.Price)) {
                            hasChanges = true;
                            sb.AppendFormat("������ ���� '{0}' '{1}' to '{2}'\n",prevItem.Name, prevItem.Price, newItem.Price);
                        }
                    }
                }

                foreach (ngFoodItem newItem in newFoodList) {
                    ngFoodItem prevItem = ApiUtils.GetFoodById(prevFoodsList, newItem.FoodId);
                    if (null == prevItem) {
                        hasChanges = true;
                        sb.AppendFormat("������ ��� �������������'{0}'\n", newItem.Name);
                    }
                }
            }

            msg = sb.ToString();
            return hasChanges;
        }
示例#3
0
        private void _timer_Elapsed(object sender, ElapsedEventArgs e)
        {
            //start sunday
            CultureInfo info = new CultureInfo("en-US");
            Thread.CurrentThread.CurrentCulture = info;
            Thread.CurrentThread.CurrentUICulture = info;
            if (DateTime.Now.Hour >= 7 || DateTime.Now.Hour <= 12) {
                ExcelParser newParser = new ExcelParser();
                newParser.Init();
                lock (_parsers) {
                    ExcelParser previous = GetParser();
                    _parsers.Add(newParser);

                    if (_parsers.Count > 2) {
                        _parsers.RemoveAt(0);
                    }
                    Debug.Assert(_parsers.Count == 2);

                    string msg = "";
                    if (CompareExcelDocuments(previous, newParser, out msg)) {
                        List<ngUserModel> users = UsersManager.Inst.GetUsers();
                        foreach (ngUserModel user in users) {
                            if (user.IsAdmin && user.Email.Contains("darwins")) {
                                ApiUtils.SendEmail(user, "�������� ������", msg);
                            }
                        }
                    }
                }
            }
        }