/// <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); } }
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}"); } }