public TakingModification(string nameOfConnected, string surnameOfConnected, string IDOfConnetedUser, int IndexOfTaking, string NameOfSeller, string SurnameOfSeller, string SONumber, float cashPaid, float cardPaid, string dateOfBookingIn, string description, float RefundedByCash, float RefundedByCard, string lastEdited, string lastEditedName, string lastEditedSrname, TakingManager tm) { m_form = tm; server = "127.0.0.1"; database = "DailyTakings"; uid = "root"; password = ""; string connectionString; connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";"; connection = new MySqlConnection(connectionString); InitializeComponent(); this.nameOfConnected = nameOfConnected; this.surnameOfConnected = surnameOfConnected; this.IDOfConnetedUser = IDOfConnetedUser; this.IndexOfTaking = IndexOfTaking; this.NameOfSeller = NameOfSeller; this.SurnameOfSeller = SurnameOfSeller; this.SONumber = SONumber; this.cashPaid = cashPaid; this.cardPaid = cardPaid; this.dateOfBookingIn = dateOfBookingIn; this.description = description; this.RefundedByCash = RefundedByCash; this.RefundedByCard = RefundedByCard; this.lastEdited = lastEdited; this.lastEditedName = lastEditedName; this.lastEditedSrname = lastEditedSrname; }
public AddingAPurchase(string nameOfConnected, string surnameOfConnected, string IDOfConnetedUser, TakingManager tm) { m_form = tm; this.nameOfConnected = nameOfConnected; this.surnameOfConnected = surnameOfConnected; this.IDOfConnetedUser = IDOfConnetedUser; InitializeComponent(); }
//Select statement public void Select(string username, string password) { string query = String.Format("SELECT USERNAME, PASSWORD, ID, NAME, SURNAME FROM USERS WHERE USERNAME = '******' AND PASSWORD = '******'", username, password); //Open connection if (this.OpenConnection() == true) { //Create Command MySqlCommand cmd = new MySqlCommand(query, connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); try { string enteredUsername, enteredPassword, UsersID, UsersName, UsersSurname; //Read the data and store them in the list dataReader.Read(); enteredUsername = dataReader[0].ToString(); enteredPassword = dataReader[1].ToString(); UsersID = dataReader[2].ToString(); UsersName = dataReader[3].ToString(); UsersSurname = dataReader[4].ToString(); if (enteredUsername == textBox1.Text && enteredPassword == textBox2.Text) { MessageBox.Show("Success"); TakingManager TakingForm = new TakingManager(textBox1.Text, textBox2.Text, UsersID, UsersName, UsersSurname); TakingForm.Show(); this.Hide(); } else { MessageBox.Show("Fail"); } } catch { if (!dataReader.HasRows) { MessageBox.Show("No user found"); } // code of error if needed // MessageBox.Show(ex.ToString()); } //close Data Reader dataReader.Close(); //close Connection this.CloseConnection(); } }