public Boolean deleteMembership(String pUser, String pGroup) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { _result = _dbc.ExecuteProcedures("Exec sp_DeleteMembership " + pUser + "," + pGroup, 1); } catch (Exception ex) { _dbc.CloseConnection(); return(false); } _dbc.CloseConnection(); if (_result != null) { if (((int)_result[0]) == 0) { return(true); } else { return(false); } } return(false); }
public Boolean updateUser(String pFirstName, String pSecondName, String pSurName, String pSurName2, String pStatus, String pLoginName, int pActualUser) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { _result = _dbc.ExecuteProcedures("Exec sp_UpdateUser N'" + pFirstName + "', N'" + pSecondName + "', N'" + pSurName + "', N'" + pSurName2 + "', '" + pStatus + "', NULL, NULL, NULL, " + pActualUser + ", N'" + pLoginName + "', NULL, NULL, 0", 1); } catch (Exception ex) { _dbc.CloseConnection(); return(false); } _dbc.CloseConnection(); if (_result != null) { if (((int)_result[0]) == 0) { return(true); } else { return(false); } } return(false); }
public Boolean passwordChange(String pLoginName, String pOldPass, String pNewPass, String pCurrentUser) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { _result = _dbc.ExecuteProcedures("Exec sp_UpdatePassword N'" + pLoginName + "', N'" + pOldPass + "', N'" + pNewPass + "', " + pCurrentUser, 1); } catch (Exception e) { _dbc.CloseConnection(); return(false); } _dbc.CloseConnection(); if (_result != null) { if (((int)_result[0]) == 0) { return(true); } else { return(false); } } return(false); }
public List <object> searchForUsers(String pHint, int pType) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { if (pType == 5) { _result = _dbc.ExecuteProcedures("Exec sp_SearchForUsers N'" + pHint + "', " + pType, 2); } else { _result = _dbc.ExecuteProcedures("Exec sp_SearchForUsers N'" + pHint + "', " + pType, 7); } _dbc.CloseConnection(); return(_result); } catch (Exception e) { _dbc.CloseConnection(); _result = null; return(_result); } }
public Boolean Login(String pPassword, String pUserName) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { _result = _dbc.ExecuteProcedures("Exec sp_Login N'" + pUserName + "', N'" + pPassword + "'", 1); } catch (Exception e) { _dbc.CloseConnection(); return(false); } _dbc.CloseConnection(); if (_result != null) { if (((int)_result[0]) == 0) { return(true); } else { return(false); } } return(false); }
public Boolean Validate(String username, String passwd) { db.OpenConnection(); string stmt = "select * from users where username=@username and passwd=@passwd"; MySqlCommand cmd = new MySqlCommand(stmt, db.myConnection); cmd.Parameters.AddWithValue("@username", username); cmd.Parameters.AddWithValue("@passwd", passwd); //Get the element of the query var reader = cmd.ExecuteReader(); if (reader.HasRows) { Console.WriteLine("Connected"); reader.Close(); db.CloseConnection(); return(true); } else { Console.WriteLine("Wrong username/pass"); } db.CloseConnection(); reader.Close(); return(false); }
public Boolean updateGroup(String pName, String pDescription, int pStatus) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { _result = _dbc.ExecuteProcedures("Exec sp_UpdateUserGroups N'" + pName + "'," + pStatus + ", N'" + pDescription + "'", 1); } catch (Exception ex) { _dbc.CloseConnection(); return(false); } _dbc.CloseConnection(); if (_result != null) { if (((int)_result[0]) == 0) { return(true); } else { return(false); } } return(false); }
public Boolean insertUser(String pLoginName, String pPassword, String pName, String pMName, String pSurName1, String pSurName2, String pCurrentUser) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { _result = _dbc.ExecuteProcedures("Exec sp_SearchForUsers N'" + pCurrentUser + "', " + 5, 3); _result = _dbc.ExecuteProcedures("Exec sp_InsertUser N'" + pLoginName + "', " + "N'" + pName + "', " + "N'" + pMName + "', " + "N'" + pSurName1 + "', N' " + pSurName2 + "'," + "N'" + pPassword + "', " + _result[0], 1); } catch (Exception ex) { _dbc.CloseConnection(); return(false); } _dbc.CloseConnection(); if (_result != null) { if (((int)_result[0]) == 0) { return(true); } else { return(false); } } return(false); }
//menu tab control private void TabControlSystem_SelectedIndexChanged(object sender, EventArgs e) { try { if (TabControlSystem.SelectedTab == TabControlSystem.TabPages["Movies"]) { MoviesTableGridDataBind(); groupBoxMovie.Visible = true; CustomerBox.Visible = false; } else if (TabControlSystem.SelectedTab == TabControlSystem.TabPages["Customers"]) { groupBoxMovie.Visible = false; CustomerBox.Visible = true; BindGridCustomersTbl(); } else if (TabControlSystem.SelectedTab == TabControlSystem.TabPages["RentedMovies"]) { RentedMovieGridData(); //show all rented movies groupBoxMovie.Visible = false; CustomerBox.Visible = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); DataBaseConnection.CloseConnection(); // close connection with database when error occured } }
public void AfterAllTests() { _driver.Close(); _driver.Quit(); HelperSet.DeleteAllTestData(UserEmail); _dbConn.CloseConnection(); }
public Boolean DeleteRights(String pGroup, String pType, String pIdentifier) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); String _query = ""; int plap = String.Compare("Category", "Category"); int plop = String.Compare(pType, "Category"); if (pType == "Section") { _query = "Exec sp_DeleteSectionRights "; } else if (pType == "Category") { _query = "Exec sp_DeleteCategoryRights "; } else if (pType == "Page") { _query = "Exec sp_DeletePageRights "; } List <object> _result; try { _result = _dbc.ExecuteProcedures(_query + pIdentifier + ", " + pGroup, 1); } catch (Exception ex) { _dbc.CloseConnection(); return(false); } _dbc.CloseConnection(); if (_result != null) { if (((int)_result[0]) == 0) { return(true); } else { return(false); } } return(false); }
public List <String> getUserRights(String pIdUser, String pType) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _queryResult; List <String> _result = new List <string>(); String _query = ""; if (pType == "Section") { _query = "Exec sp_SelectSectionsByUser "; } else if (pType == "Category") { _query = "Exec sp_SelectCategoriesByUser "; } else if (pType == "Page") { _query = "Exec sp_SelectPagesByUser "; } try { _queryResult = _dbc.ExecuteProcedures(_query + pIdUser, 1); } catch (Exception e) { _dbc.CloseConnection(); _result = null; return(_result); } _dbc.CloseConnection(); if (_queryResult != null) { for (int i = 0; i < _queryResult.Count; i++) { _result.Add((String)_queryResult[i]); } } return(_result); }
public List <object> searchForGroups(String pHint, int ptype) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { _result = _dbc.ExecuteProcedures("Exec sp_SearchForGroups N'" + pHint + "', " + ptype, 4); _dbc.CloseConnection(); return(_result); } catch (Exception e) { _dbc.CloseConnection(); _result = null; return(_result); } }
protected override void OnExit(ExitEventArgs e) { try { DataBaseConnection.CloseConnection(); } catch (System.Exception exception) { Log.LogException(exception); } base.OnExit(e); }
public List <Game> ReturnGames() { List <Game> games = new List <Game>(); db.OpenConnection(); string stmt = "SELECT * FROM game g"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(stmt, db.myConnection); var reader = cmd.ExecuteReader(); while (reader.Read()) { Game game = new Game { id = reader.GetInt32("game_id"), team1 = reader.GetString("home"), team2 = reader.GetString("away"), title = reader.GetString("title"), tickets = reader.GetInt16("nr_seats"), price = reader.GetInt32("price") }; games.Add(game); } db.CloseConnection(); reader.Close(); return(games); }
public int searchForGroup(String pHint, int ptype) { DataBaseConnection _dbc = new DataBaseConnection(); _dbc.SetConnectionString(_ConnectionString); _dbc.OpenConnection(); List <object> _result; try { _result = _dbc.ExecuteProcedures("Exec sp_SearchForGroups N'" + pHint + "', " + ptype, 3); } catch (Exception e) { _dbc.CloseConnection(); return(-1); } _dbc.CloseConnection(); if (_result != null) { return((int)_result[0]); } return(-1); }
public void Buy(string name_client, int nr_seats, int game_id) { db.OpenConnection(); string stmt = "insert into clients(name_client, nr_seats, game_id) values(@name_client, @nr_seats, @game_id)"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(stmt, db.myConnection); cmd.Parameters.AddWithValue("@name_client", name_client); cmd.Parameters.AddWithValue("@nr_seats", nr_seats); cmd.Parameters.AddWithValue("@game_id", game_id); var reader = cmd.ExecuteReader(); GameRepository sRepo = new GameRepository(db); db.CloseConnection(); sRepo.UpdateSeats(nr_seats, game_id); //Get the element of the query // db.CloseConnection(); reader.Close(); }
//Delete Customer from db private void DeleteCustomer_Click(object sender, EventArgs e) { try { string custId = tbxCustomerID.Text; if (new Customer().DeleteCustomerTblData(custId)) { BindDdlWithCustomer(); // method calling to Bind comboBox Customer BindGridCustomersTbl(); // method calling to Bind GridView Customer AddCustomer.Enabled = true; MessageBox.Show("Customer Deleted Successfully!"); TextBoxFirstName.Text = ""; textBoxLastName.Text = ""; textBox1FatherName.Text = ""; textBoxAddress.Text = ""; textBoxPhone.Text = ""; tbxCustomerID.Text = ""; } else { MessageBox.Show("Unable to delete this customer"); } } catch (Exception ex) { if (ex.Message.Contains("REFERENCE")) { MessageBox.Show("Can not delete this customer as the customer rented a movie!"); } else { MessageBox.Show(ex.Message); DataBaseConnection.CloseConnection(); // close connection with database when error occured } } }
// Lets Fire the GUN private void btFire_Click(object sender, EventArgs e) { try { try { if (tryFire == 2) // Only 2 chances { btFire.Enabled = false; btLoad.Enabled = false; btSpin.Enabled = false; } else { bool status = new PlayerTask().BulletFire(NewChamber); PlayerData data; // when Bullet Fired if (status == true) { // get Player's win count data = new PlayerTask().GetPlayerRecord(PlayerID); data.PlayerID = PlayerID; data.Win = data.Win + 1; data.Loss = 0; // update player's score if (new PlayerTask().UpdatePlayerData(data)) { lbBullectCOunt.Text = ""; KilledCount = data.Win;; lbScore.Text = "Killed: " + KilledCount.ToString(); btFire.Enabled = false; btLoad.Enabled = true; lbWasted.Text = "Good Job! Load 1 Bullet Again"; } } else { // when Bullet NOT Fired tryFire = tryFire + 1; NewChamber = NewChamber + 1; if (tryFire == 2) { // get Player's record data = new PlayerTask().GetPlayerRecord(PlayerID); data.Win = KilledCount; data.Loss = 1; data.PlayerID = PlayerID; if (new PlayerTask().UpdatePlayerData(data)) { btFire.Enabled = true; lbScore.Text = "Killed: " + data.Win; lbTotalScore.Text = "Total Score: " + KilledCount.ToString(); btSpin.Enabled = false; btFire.Enabled = false; DataBaseConnection.CloseConnection(); if (KilledCount > 0) { lbWasted.Text = "You Dead! Your Total Score: " + KilledCount; lbTotalScore.Text = ""; } else { lbWasted.Text = "Wasted Youth!"; DataBaseConnection.CloseConnection(); } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void OnConnectButtonClicked(object sender, RoutedEventArgs e) { DataBaseConnection.CloseConnection(); DataBaseConnection.OpenConnection(); }
//Update movie private void BtnUpdate_Click(object sender, EventArgs e) { try { string MovieId = TextBoxMovieID.Text; string Title, RentCost, Year, Rating, Genre, StoryLine; Title = TextBoxMOvieTitle.Text; RentCost = TextBoxRent.Text; Rating = TextBoxStarRating.Text; Year = TextBoxYear.Text; Genre = TextBoxGenre.Text; StoryLine = textBoxStoryLine.Text; if (Title == "") { MessageBox.Show("Movie title is required!"); TextBoxMOvieTitle.Focus(); } else if (Year == "") { MessageBox.Show("Movie released year is required!"); TextBoxYear.Focus(); } else if (Genre == "") { MessageBox.Show("Movie genre is required!"); TextBoxGenre.Focus(); } else if (RentCost == "") { MessageBox.Show("Movie rent cost is required!"); } else if (StoryLine == "") { MessageBox.Show("Story Line is required!"); textBoxStoryLine.Focus(); } else if (Rating == "") { MessageBox.Show("Movie rating is required!"); TextBoxStarRating.Focus(); } else { MoviesData data = new MoviesData { Title = Title, Year = Year, Rating = Rating, Genre = Genre, RentCost = int.Parse(RentCost), MovieId = int.Parse(MovieId), StoryLine = StoryLine }; if (new Movies().UpdateMovie(data)) { MoviesGridViewDataBind(); BindDropDownMovie(); btnAddMOvie.Enabled = true; // enable Add movie button MessageBox.Show("Movie Updated Successfully!"); TextBoxMovieID.Text = ""; TextBoxMOvieTitle.Text = "Movie Title..."; TextBoxYear.Text = "Release Year..."; TextBoxStarRating.Text = "Star Rating..."; TextBoxGenre.Text = "Genre..."; TextBoxRent.Text = "($)Rent... "; textBoxStoryLine.Text = "Story Line..."; } else { MessageBox.Show("Unable to update this movie!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); DataBaseConnection.CloseConnection(); // close connection with database when error occured } }
//Update Customer Information private void UpdateCustomer_Click(object sender, EventArgs e) { try { string custId = tbxCustomerID.Text; string FirstName, LastName, address, phone; LastName = textBoxLastName.Text; FirstName = TextBoxFirstName.Text; address = textBoxAddress.Text; phone = textBoxPhone.Text; if (FirstName == "") { MessageBox.Show("First name is required!"); TextBoxFirstName.Focus(); } else if (LastName == "") { MessageBox.Show("Last name is required!"); textBoxLastName.Focus(); } else if (address == "") { MessageBox.Show("Address is required!"); textBoxAddress.Focus(); } else if (phone == "") { MessageBox.Show("Phone number is required!"); textBoxPhone.Focus(); } else { CustomerData data = new CustomerData { FirstName = FirstName, LastName = LastName, Address = address, Phone = phone, CustId = int.Parse(custId) }; if (new Customer().UpdateCustomerInformation(data)) { AddCustomer.Enabled = true; BindDdlCustomer(); // method calling to Bind comboBox Customer BindGridCustomersInfo(); // method calling to Bind GridView Customer MessageBox.Show("Customer Updated Successfully!"); TextBoxFirstName.Text = "First Name..."; textBoxLastName.Text = "Last Name..."; textBoxAddress.Text = "Address..."; textBoxPhone.Text = "Phone..."; tbxCustomerID.Text = ""; } else { MessageBox.Show("Unable to update this customer!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); DataBaseConnection.CloseConnection(); // close connection with database when error occured } }
//Update movie private void btnUpdate_Click(object sender, EventArgs e) { try { string MovieId = TextBoxMovieID.Text; string Title, RentCost, Year, Rating, Genre, StoryLine; Title = TextBoxMOvieTitle.Text; RentCost = TextBoxRent.Text; Rating = TextBoxStarRating.Text; Year = TextBoxYear.Text; Genre = TextBoxGenre.Text; StoryLine = textBoxStoryLine.Text; if (Title == "") { MessageBox.Show("Movie title required!"); TextBoxMOvieTitle.Focus(); } else if (Year == "") { MessageBox.Show("Movie released year required!"); TextBoxYear.Focus(); } else if (Genre == "") { MessageBox.Show("Movie genre required!"); TextBoxGenre.Focus(); } else if (RentCost == "") { MessageBox.Show("Movie rent cost required!"); } else if (StoryLine == "") { MessageBox.Show("Story required!"); textBoxStoryLine.Focus(); } else if (Rating == "") { MessageBox.Show("Movie rating required!"); TextBoxStarRating.Focus(); } else { MoviesDataTbl data = new MoviesDataTbl(); data.Title = Title; data.Year = Year; data.Rating = Rating; data.Genre = Genre; data.RentCost = int.Parse(RentCost); data.MovieId = int.Parse(MovieId); data.StoryLine = StoryLine; if (new Movies().UpdateMovie(data)) { MoviesTableGridDataBind(); BindDropDownMovie(); btnAddMOvie.Enabled = true; // enable Add movie button MessageBox.Show("Movie Updated!!"); TextBoxMovieID.Text = ""; TextBoxMOvieTitle.Text = ""; TextBoxYear.Text = ""; TextBoxStarRating.Text = ""; TextBoxGenre.Text = ""; TextBoxRent.Text = ""; textBoxStoryLine.Text = ""; } else { MessageBox.Show("Unable to update this movie!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); DataBaseConnection.CloseConnection(); // close connection with database when error occured } }
//Add Customers to database private void AddCustomer_Click(object sender, EventArgs e) { try { string Firstname, Lastname, address, phone, fatherName; Firstname = TextBoxFirstName.Text; Lastname = textBoxLastName.Text; address = textBoxAddress.Text; phone = textBoxPhone.Text; fatherName = textBox1FatherName.Text; if (Firstname == "") { MessageBox.Show("First name required!"); TextBoxFirstName.Focus(); } else if (Lastname == "") { MessageBox.Show("Last name required!"); textBoxLastName.Focus(); } else if (fatherName == "") { MessageBox.Show("Father's name required!"); textBox1FatherName.Focus(); } else if (address == "") { MessageBox.Show("Address required!"); textBoxAddress.Focus(); } else if (phone == "") { MessageBox.Show("Phone number required!"); textBoxPhone.Focus(); } else { CustomerDataTbl data = new CustomerDataTbl(); data.FirstName = Firstname; data.LastName = Lastname; data.fatherName = fatherName; data.Address = address; data.Phone = phone; if (new Customer().AddCustomerData(data)) { BindDdlWithCustomer(); // bind customer table to combobox BindGridCustomersTbl(); // Bind GridView with Customer table MessageBox.Show("Customer Saved to Database!!"); TextBoxFirstName.Text = ""; textBoxLastName.Text = ""; textBoxAddress.Text = ""; textBox1FatherName.Text = ""; textBoxPhone.Text = ""; } else { MessageBox.Show("Unable to add this customer!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); DataBaseConnection.CloseConnection(); // close DB connection when error occured } }
//Update Customer table data private void UpdateCustomer_Click(object sender, EventArgs e) { try { string custId = tbxCustomerID.Text; string FirstName, LastName, fatherName, address, phone; LastName = textBoxLastName.Text; FirstName = TextBoxFirstName.Text; address = textBoxAddress.Text; phone = textBoxPhone.Text; fatherName = textBox1FatherName.Text; if (FirstName == "") { MessageBox.Show("First name required!"); TextBoxFirstName.Focus(); } else if (LastName == "") { MessageBox.Show("Last name required!"); textBoxLastName.Focus(); } else if (fatherName == "") { MessageBox.Show("Father's name required!"); textBox1FatherName.Focus(); } else if (address == "") { MessageBox.Show("Address required!"); textBoxAddress.Focus(); } else if (phone == "") { MessageBox.Show("Phone number required!"); textBoxPhone.Focus(); } else { CustomerDataTbl data = new CustomerDataTbl(); data.FirstName = FirstName; data.LastName = LastName; data.Address = address; data.Phone = phone; data.fatherName = fatherName; data.CustId = int.Parse(custId); if (new Customer().UpdateCustomerInformation(data)) { AddCustomer.Enabled = true; BindDdlWithCustomer(); // Bind comboBox with Customer table BindGridCustomersTbl(); // BindGridView with Customer table MessageBox.Show("Customer Data Updated!"); TextBoxFirstName.Text = ""; textBoxLastName.Text = ""; textBoxAddress.Text = ""; textBox1FatherName.Text = ""; textBoxPhone.Text = ""; tbxCustomerID.Text = ""; } else { MessageBox.Show("Unable to update this customer!!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); DataBaseConnection.CloseConnection(); // close connection with database when error occured } }
//Exit from Game private void btExit_Click(object sender, EventArgs e) { DataBaseConnection.CloseConnection(); Application.ExitThread(); }