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