Exemplo n.º 1
0
        /// <summary>
        /// Method check account exists in Admins_List
        /// </summary>
        /// <param name="Login"></param>
        /// <param name="Password"></param>
        /// <returns>
        /// If exists return true
        /// Else return flase
        /// </returns>
        public bool Check_Admin(string Login, string Password)
        {
            if (Admins_List.Exists(x => x.Login == Login && x.Password == Password))
            {
                Classes.Session.Admin_Login    = Login;
                Classes.Session.Admin_Password = Password;

                // Create instance of Database Connection
                Classes.Database conn = new Classes.Database();

                // Wait for results
                var query = $"UPDATE admins SET last_logedin = NOW() WHERE login='******'";

                // Send IP data into server
                conn.Update(query);

                // Check error flag
                if (conn.Error_Flag)
                {
                    // Set main error flag as true
                    Error_Flag = true;
                    // Set main error message
                    Error_Message = conn.Error_Message;
                }

                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 2
0
        public void Update_As_Paid()
        {
            // Copy pack id
            string pack_id = Display_DataGridView.CurrentRow.Cells[0].Value.ToString();
            // Copy UID
            string UID = Display_DataGridView.CurrentRow.Cells[1].Value.ToString();
            // Copy pack name
            string name = Display_DataGridView.CurrentRow.Cells[20].Value.ToString();

            string User_Email = null;

            // Find User e-mail
            foreach (var user in PC_Admin_Panel.Core.Process.Users_list)
            {
                if (UID.ToString() == user.Uid.ToString())
                {
                    User_Email = user.Email;
                }
            }

            if (User_Email == null)
            {
                MessageBox.Show("We can't find User in our Database!");
            }
            else
            {
                string message = $"We've just received your payment for <b>{name}</b>, pack id: <b>{pack_id}</b> <br /> Thank you!";
                string subject = "Information about payment";

                DateTime now = DateTime.Now;

                var query = $"UPDATE warehouse SET status = 'paid', paid_data = NOW(), status_checked = '{Classes.Session.Admin_Login}' WHERE id = '{pack_id}' ";

                Database.Update(query);

                Classes.Send_Mail.Mail("*****@*****.**", User_Email, message, subject);

                if (pointer == 2)
                {
                    // Update Display_DataGridView
                    Display_DataGridView.DataSource = Database.Load_Unpaied_Packs_List();
                }

                MessageBox.Show($"Mail about the payment has been sent to the address: {User_Email}");
            }
        }