//function to add new reservation public bool addReserv(int roomNum, int clientId, DateTime dtIn, DateTime dtOut) { MySqlCommand command = new MySqlCommand(); string addQuery = "INSERT INTO `reservation`(`RoomNo`, `ClientID`, `DateIN`, `DateOUT`) VALUES (@rn,@cid,@dtIN,@dtOUT)"; //@rn,@cid,@dtIN,@dtOUT command.CommandText = addQuery; command.Connection = conn.GetConnection(); command.Parameters.Add("@rn", MySqlDbType.Int32).Value = roomNum; command.Parameters.Add("@cid", MySqlDbType.Int32).Value = clientId; command.Parameters.Add("@dtIN", MySqlDbType.Date).Value = dtIn; command.Parameters.Add("@dtOUT", MySqlDbType.Date).Value = dtOut; conn.OpenConnection(); if (command.ExecuteNonQuery() == 1) { conn.CloseConnection(); return(true); } else { conn.CloseConnection(); return(false); } }
//function to add new clients public bool addClient(string fName, string lName, string phoneNum, string country) { MySqlCommand command = new MySqlCommand(); string addQuery = "INSERT INTO `clients`(`first_name`, `last_name`, `phone`, `country`) VALUES (@fname,@lname,@pNum,@cnt)"; command.CommandText = addQuery; command.Connection = conn.GetConnection(); command.Parameters.Add("@fname", MySqlDbType.VarChar).Value = fName; command.Parameters.Add("@lname", MySqlDbType.VarChar).Value = lName; command.Parameters.Add("@pNum", MySqlDbType.VarChar).Value = phoneNum; command.Parameters.Add("@cnt", MySqlDbType.VarChar).Value = country; conn.OpenConnection(); if (command.ExecuteNonQuery() == 1) { conn.CloseConnection(); return(true); } else { conn.CloseConnection(); return(false); } }
//function to get the list of room type public DataTable getRoomType() { MySqlCommand command = new MySqlCommand("SELECT * FROM `rooms_category`", conn.GetConnection()); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = command; adapter.Fill(table); return(table); }
private void Loginbutton_Click_1(object sender, EventArgs e) { CONNECT conn = new CONNECT(); //our connection DataTable table = new DataTable(); //creates our table in the dataset MySqlDataAdapter adapter = new MySqlDataAdapter(); //creates a link between the datasource and the dataset MySqlCommand command = new MySqlCommand(); //executes our sql queries etc. string query = "SELECT * FROM `users` WHERE `username`=@usn AND `password` = @pass"; //@pass and @usn are placeholders command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = textBoxUsername.Text; //it takes the input from the user and replace its respective placeholder of its type command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBoxPassword.Text; command.CommandText = query; command.Connection = conn.GetConnection(); adapter.SelectCommand = command; //the adapter here uses the selectcommand to retrieve data specified in the datasource i.e the database adapter.Fill(table); // if the value retrieved matches the one at the data source then it fills the table data in the dataset if the table hasn't been created then it creates one. //if the username and password exists if (table.Rows.Count > 0) //if the no of rows in the table in the dataset then execute the content within. { //show the main form this.Hide(); Main_Form mForm = new Main_Form(); mForm.Show(); } else if (textBoxUsername.Text.Trim().Equals("")) { MessageBox.Show("Enter a valid username", "Username", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (textBoxPassword.Text.Trim().Equals("")) { MessageBox.Show("Enter a valid password", "Password", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Username or Password does not exist", "Incorrect data", MessageBoxButtons.OK, MessageBoxIcon.Error); } }