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 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 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(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);
}
}
public Book GetBook(string bookId)
{
string query = "SELECT * from Books WHERE BookId = '" + bookId + "'";
Book b = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
b = new Book();
b.BookId = sdr["BookID"].ToString();
b.BookTitle = sdr["BookTitle"].ToString();
b.AuthorName = sdr["AuthorName"].ToString();
b.Price = Convert.ToDouble(sdr["Price"]);
b.Quantity = Convert.ToInt32(sdr["Quantity"]);
}
dcc.CloseConnection();
return(b);
}
public Employee GetEmployee(string employeeId)
{
string query = "SELECT * from Employees WHERE EmployeeID = '" + employeeId + "'";
Employee emp = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
emp = new Employee();
emp.EmployeeId = sdr["EmployeeID"].ToString();
emp.EmployeeName = sdr["EmployeeName"].ToString();
emp.Salary = Convert.ToDouble(sdr["Salary"]);
emp.Designation = sdr["Designation"].ToString();
emp.Password = sdr["Password"].ToString();
}
dcc.CloseConnection();
return(emp);
}
public List <Employee> GetAllEmployee()
{
string query = "SELECT * from Employees";
List <Employee> empList = new List <Employee>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Employee emp = new Employee();
emp.EmployeeId = sdr["EmployeeID"].ToString();
emp.EmployeeName = sdr["EmployeeName"].ToString();
emp.Salary = Convert.ToDouble(sdr["Salary"]);
emp.Designation = sdr["Designation"].ToString();
empList.Add(emp);
}
dcc.CloseConnection();
return(empList);
}
public bool UserLoginValidation(Employee emp)
{
string query = "SELECT * from Employees WHERE EmployeeID = '" + emp.EmployeeId + "' AND EmployeePassword='******'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
// dcc.CloseConnection();
if (sdr.Read())
{
emp.EmployeeName = sdr["EmployeeName"].ToString();
emp.Salary = Convert.ToDouble(sdr["Salary"]);
emp.Designation = sdr["Designation"].ToString();
dcc.CloseConnection();
return(true);
}
else
{
dcc.CloseConnection();
return(false);
}
}
public List <Book> GetAllBooks()
{
string query = "SELECT * from Books";
List <Book> bList = new List <Book>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Book b = new Book();
b.BookId = sdr["BookID"].ToString();
b.BookTitle = sdr["BookTitle"].ToString();
b.AuthorName = sdr["AuthorName"].ToString();
b.Price = Convert.ToDouble(sdr["Price"]);
b.Quantity = Convert.ToInt32(sdr["Quantity"]);
bList.Add(b);
}
dcc.CloseConnection();
return(bList);
}
