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