public bool Delete(string bookId) { try { string query = "DELETE From Books WHERE BookID='" + bookId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Update(Book b) { try { string query = "UPDATE Books SET BookTitle = '" + b.BookTitle + "', AuthorName ='" + b.AuthorName + "', Price = " + b.Price + ", Quantity = " + b.Quantity + "WHERE BookId = '" + b.BookId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Update(Employee emp) { try { string query = "UPDATE Employees SET EmployeeName = '" + emp.EmployeeName + "', Salary =" + emp.Salary + ", Designation = '" + emp.Designation + "WHERE EmployeeID = '" + emp.EmployeeId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Insert(Book b) { try { string query = "INSERT into Books VALUES ('" + b.BookId + "', '" + b.BookTitle + "', '" + b.AuthorName + "', " + b.Price + ", " + b.Quantity + ")"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Insert(Employee emp) { try { string query = "INSERT into Employees VALUES ('" + emp.EmployeeId + "', '" + emp.Password + "', '" + emp.EmployeeName + "', " + emp.Salary + ", '" + emp.Designation + "')"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }