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