Exemple #1
0
    public void Display()
    {
        notification = messagePrefab.getObject(true, m_DisplayMessageManager.DisplayMessageRect.transform).GetComponent <NotificationToast>();

        notification.Initialize(message);

        m_DisplayMessageManager.DisplayMessageRect.UpdateTable(notification.gameObject);

        StartCoroutine(messagePrefab.ReturnWithDelay(notification.gameObject, notification.TotalRunTime));
    }
    public void CreateNotification(string text)
    {
        GameObject notificationInstance = notificationPrefab.getObject(true, notificationPanel.transform);

        notificationInstance.transform.SetSiblingIndex(0);

        NotificationToast toast = notificationInstance.GetComponent <NotificationToast>();

        toast.Initialize(text);
        notificationPanel.UpdateTable(notificationInstance);
    }
Exemple #3
0
    public void CreateNotification(string text)
    {
        GameObject notificationInstance = Instantiate(notificationPrefab, notificationPanel);

        notificationInstance.transform.SetSiblingIndex(0);

        NotificationToast toast = notificationInstance.GetComponent <NotificationToast>();

        if (toast)
        {
            toast.Initialize(text);
        }
    }
Exemple #4
0
        private void ButtonUpdate_Click(object sender, RoutedEventArgs e)
        {
            Window.Current.CoreWindow.PointerCursor = new Windows.UI.Core.CoreCursor(Windows.UI.Core.CoreCursorType.Wait, 1);
            NotificationToast.SimpleNotification("Updating the stock minimum value...");
            List <string> code = DbUtils.RefList("Code", "kitbox");

            foreach (string i in code)
            {
                Dictionary <string, int> valuesIncStock     = DbUtils.SelectCondDb("sales", i);
                Dictionary <string, int> graphMonthIncStock = new Dictionary <string, int>();
                foreach (KeyValuePair <string, int> entry in valuesIncStock)
                {
                    string key   = entry.Key;
                    string month = key.Split('-')[0] + "/" + key.Split('-')[1];
                    if (graphMonthIncStock.ContainsKey(month))
                    {
                        graphMonthIncStock[month] = graphMonthIncStock[month] + entry.Value;
                    }
                    else
                    {
                        graphMonthIncStock.Add(month, entry.Value);
                    }
                }

                List <string> monthsIncStock = new List <string>();
                foreach (KeyValuePair <string, int> entry in graphMonthIncStock)
                {
                    monthsIncStock.Add(entry.Key);
                }
                int all = 0;
                try
                {
                    all = graphMonthIncStock[monthsIncStock[monthsIncStock.Count - 2]] +
                          graphMonthIncStock[monthsIncStock[monthsIncStock.Count - 3]] +
                          graphMonthIncStock[monthsIncStock[monthsIncStock.Count - 4]] +
                          graphMonthIncStock[monthsIncStock[monthsIncStock.Count - 5]] +
                          graphMonthIncStock[monthsIncStock[monthsIncStock.Count - 6]] +
                          graphMonthIncStock[monthsIncStock[monthsIncStock.Count - 7]];
                }
                catch
                {
                }
                int    average = all / 12;
                string x       = "";
                x = DbUtils.UpdateDb("kitbox", "MinimumStock", "Code = \"" + i + "\"", average.ToString());
            }
            FillDataGrid(DbUtils.RefreshDb("kitbox"), DataGrid1);
            DataGrid1.Columns[DataGrid1.Columns.Count - 1].CellStyle = (Style)DataGrid1.Resources["Test"];
            NotificationToast.SimpleNotification("Update completed");
            Window.Current.CoreWindow.PointerCursor = new Windows.UI.Core.CoreCursor(Windows.UI.Core.CoreCursorType.Arrow, 1);
        }
Exemple #5
0
        public void ShowToast(string body, string title, EventHandler clickHandler = null)
        {
            var toast = new NotificationToast {
                Title = title,
                Body  = body,
                SecondaryCloseDelayTime = NotificationToastSecondaryCloseDelayTime
            };

            if (clickHandler != null)
            {
                toast.Click += clickHandler;
            }

            NotificationIcon.ShowCustomBalloon(toast, PopupAnimation.Fade, NotificationToastCloseDelayTime);
        }
Exemple #6
0
        public void CheckConnection()
        {
            MySqlConnection conn = new MySqlConnection(DbUtils.MyConString);

            try
            {
                conn.Open();
                conn.Close();
                IconConnectivity.Glyph = "\uE701";
                ConText.Tag            = "Database connected";
                LoginDialog();
                NotificationToast.SimpleNotification("Database connected");
            }
            catch
            {
                IconConnectivity.Glyph = "\uEB5E";
                ConText.Tag            = "Database not connected";
                DisplayNoConnectionDialog();
                string title = "Database connection failed";
                NotificationToast.SimpleNotification(title);
            }
        }
Exemple #7
0
        private void Refresh_Click(object sender, RoutedEventArgs e)
        {
            NotificationToast.SimpleNotification("Start updating suppliers' prices");
            Window.Current.CoreWindow.PointerCursor = new Windows.UI.Core.CoreCursor(Windows.UI.Core.CoreCursorType.Wait, 1);
            DataTable supplier1 = new DataTable();

            foreach (string i in DbUtils.RefList("SupplierId", "suppliers"))
            {
                if (i == "1")
                {
                    supplier1 = DbUtils.RefreshDb("supplierslistprices where SupplierId = \"" + i + "\"");
                }
                else
                {
                    foreach (string j in DbUtils.RefList("Code",
                                                         "supplierslistprices where SupplierId = \"" + i + "\""))
                    {
                        double value1 = Convert.ToDouble(DbUtils.RefList("SuppPrice",
                                                                         "supplierslistprices where SupplierId = \"" + i + "\" and Code = \"" + j + "\"")[0]);
                        List <string> listcode = new List <string>();
                        foreach (DataRow row in supplier1.Rows)
                        {
                            listcode.Add(row["Code"].ToString());
                        }

                        if (listcode.Contains(j))
                        {
                            double value2 = 0;
                            foreach (DataRow row in supplier1.Rows)
                            {
                                if (row["Code"].ToString() == j)
                                {
                                    value2 = Convert.ToDouble(row["SuppPrice"].ToString());
                                }
                            }

                            if (value2 - value1 > 0)
                            {
                                for (int k = supplier1.Rows.Count - 1; k >= 0; k--)
                                {
                                    DataRow dr = supplier1.Rows[k];
                                    if (dr["Code"].ToString() == j)
                                    {
                                        dr.Delete();
                                    }
                                }

                                supplier1.AcceptChanges();
                                DataRow ligne = supplier1.NewRow();
                                ligne["SupplierId"] = i;
                                ligne["Code"]       = j;
                                ligne["SuppPrice"]  = value1;
                                ligne["SuppDelay"]  = Convert.ToInt32(DbUtils.RefList("SuppDelay",
                                                                                      "supplierslistprices where SupplierId = \"" + i + "\" and Code = \"" + j +
                                                                                      "\"")[0]);
                                supplier1.Rows.Add(ligne);
                            }
                            else if (Math.Abs(value2 - value1) < 0.001)
                            {
                                int delay1 = Convert.ToInt32(DbUtils.RefList("SuppDelay",
                                                                             "supplierslistprices where SupplierId = \"" + i + "\" and Code = \"" + j +
                                                                             "\"")[0]);
                                int delay2 = 0;
                                foreach (DataRow row in supplier1.Rows)
                                {
                                    if (row["Code"].ToString() == j)
                                    {
                                        delay2 = Convert.ToInt32(row["SuppDelay"].ToString());
                                    }
                                }

                                if (delay2 - delay1 > 0)
                                {
                                    for (int k = supplier1.Rows.Count - 1; k >= 0; k--)
                                    {
                                        DataRow dr = supplier1.Rows[k];
                                        if (dr["Code"].ToString() == j)
                                        {
                                            dr.Delete();
                                        }
                                    }

                                    supplier1.AcceptChanges();
                                    DataRow ligne = supplier1.NewRow();
                                    ligne["SupplierId"] = i;
                                    ligne["Code"]       = j;
                                    ligne["SuppPrice"]  = value1;
                                    ligne["SuppDelay"]  = delay1;
                                    supplier1.Rows.Add(ligne);
                                }
                            }
                        }
                        else
                        {
                            for (int k = supplier1.Rows.Count - 1; k >= 0; k--)
                            {
                                DataRow dr = supplier1.Rows[k];
                                if (dr["Code"].ToString() == j)
                                {
                                    dr.Delete();
                                }
                            }

                            supplier1.AcceptChanges();
                            DataRow ligne = supplier1.NewRow();
                            ligne["SupplierId"] = i;
                            ligne["Code"]       = j;
                            ligne["SuppPrice"]  = value1;
                            ligne["SuppDelay"]  = Convert.ToInt32(DbUtils.RefList("SuppDelay",
                                                                                  "supplierslistprices where SupplierId = \"" + i + "\" and Code = \"" + j + "\"")[0]);
                            supplier1.Rows.Add(ligne);
                        }
                    }
                }
            }

            FillDataGrid(supplier1, DataGrid2);
            MySqlConnection connection = new MySqlConnection(DbUtils.MyConString);
            string          query      = "TRUNCATE TABLE suppliersprices";
            MySqlCommand    cmd        = new MySqlCommand(query, connection);

            connection.Open();
            cmd.ExecuteNonQuery();
            connection.Close();
            foreach (DataRow row in supplier1.Rows)
            {
                string price  = row["SuppPrice"].ToString();
                string price1 = price.Replace(',', '.');
                DbUtils.InsertDb("suppliersprices", "SupplierId,Code,SuppPrice,SuppDelay",
                                 "\"" + row["SupplierId"] + "\", \"" + row["Code"] + "\", \"" + price1 + "\", \"" +
                                 row["SuppDelay"] + "\"");
            }
            NotificationToast.SimpleNotification("Update completed");
            Window.Current.CoreWindow.PointerCursor = new Windows.UI.Core.CoreCursor(Windows.UI.Core.CoreCursorType.Arrow, 1);
        }