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();
}
}
