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