// get LoginUser data
public bool getLogingUser(String username, String password)
{
db = new DatabaseAccess();
dt = db.LogingUsingStoredProcedure(username, password);
if (dt.Rows.Count == 1)
{
setLogingUser(dt);
return true;
}
return false;
}
// delete Category
public bool deleteDSCategoryDB(String categoryID)
{
db = new DatabaseAccess();
db.DSdeleteCategory(categoryID);
return true;
}
// search rented staff
public DataTable searchDAORentedStaff(int cid, string key)
{
db = new DatabaseAccess();
dt = db.DAORentedStaff(cid, key);
return dt;
}
// Return
public bool doDAOReturn(ArrayList detaillist, DateTime today)
{
db = new DatabaseAccess();
db.DAOReturnProcess(detaillist, today);
return true;
}
// search rented
public DataTable searchDAORented(string cid, string status)
{
db = new DatabaseAccess();
dt = db.DAOsearchRented(cid, status);
return dt;
}
// update Customer
public bool updateDAOCustomer(Customer customer)
{
db = new DatabaseAccess();
db.DAOupdateCustomer(customer);
return true;
}
// search Customer ID Name
public DataTable searchDAOCustomerByIdName(string id, string name)
{
db = new DatabaseAccess();
dt = db.DAOsearchCustomerByIdName(id, name);
return dt;
}
// delete Model
public bool deleteDSModelDB(String modelID)
{
db = new DatabaseAccess();
db.DSdeleteModel(modelID);
return true;
}
// search comb ModelID
public DataTable searchDAOModelID()
{
db = new DatabaseAccess();
dt = db.DAOsearchModelID();
return dt;
}
// insert Model
public bool insertDSModelDB(ProductModel model)
{
db = new DatabaseAccess();
db.DSinsertModel(model);
return true;
}
// update Model
public bool updateDSModelDB(ProductModel model)
{
db = new DatabaseAccess();
db.DSupdateModel(model);
return true;
}
// Using Data Source
// search Model
public DataTable searchDSModel()
{
db = new DatabaseAccess();
dt = db.DSsearchModel();
return dt;
}
// delete Model
public bool deleteDAOModel(String model)
{
db = new DatabaseAccess();
db.DAOdeleteModel(model);
return true;
}
// Using DAO
// search Category
public DataTable searchDAOCategoryID()
{
db = new DatabaseAccess();
dt = db.DAOsearchCategoryID();
return dt;
}
public Customer searchDAOCustomer(int id)
{
db = new DatabaseAccess();
dt = db.DAOsearchCustomer(id.ToString(),"");
return setCustomer(dt);
}
// update Individual
public bool updateDAOIndividual(Individual ind)
{
db = new DatabaseAccess();
db.DAOupdateIndividual(ind);
return true;
}
// insert Customer
public bool insertDAOCustomer(Customer customer)
{
db = new DatabaseAccess();
db.DAOinsertCustomer(customer);
return true;
}
// Using Data Source
// search Individual
public DataTable searchDSIndividual()
{
db = new DatabaseAccess();
dt = db.DSsearchIndividual();
return dt;
}
// delete Customer
public bool deleteDAOCustomer(int id)
{
db = new DatabaseAccess();
db.DAOdeleteCustomer(id);
return true;
}
// insert Individual
public bool insertDSIndividualDB(Individual ind)
{
db = new DatabaseAccess();
db.DSinsertIndividual(ind);
return true;
}
// search Individual
public Individual searchDAOIndividualById(int id)
{
db = new DatabaseAccess();
dt = db.DAOsearchIndividualById(id);
return setIndividual(dt);
}
// update Individual
public bool updateDSModelDB(Individual ind)
{
db = new DatabaseAccess();
db.DSupdateIndividual(ind);
return true;
}
// insert Rent
public bool insertDAORent(Rent rent, ArrayList detaillist)
{
db = new DatabaseAccess();
db.DAOinsertRent(rent, detaillist);
return true;
}
// delete Individual
public bool deleteDSModelDB(int indCanoeID)
{
db = new DatabaseAccess();
db.DSdeleteIndividual(indCanoeID);
return true;
}
// search rentedByID
public RentDetail searchDAORentedByID(string rid, string iId)
{
db = new DatabaseAccess();
dt = db.DAOsearchRentedByID(rid, iId);
return setRentDetail(dt);
}
//
// -- Product search -----------------------
//
// search Product
public DataTable searchDAOProduct(string category, string model, string brand,
string price, string availability)
{
db = new DatabaseAccess();
dt = db.DAOsearchProduct(category, model, brand, price, availability);
return dt;
}
// search rented manage
public DataTable searchDAORentedManage(string key, DateTime? begin, DateTime? end)
{
db = new DatabaseAccess();
dt = db.DAORentedManage(key, begin, end);
return dt;
}
// Using DAO
// search Customer
public DataTable searchDAOCustomer(string id, string birth)
{
db = new DatabaseAccess();
dt = db.DAOsearchCustomer(id, birth);
return dt;
}
// batch
public void getCanoeBatchOverdueCheck(DateTime today)
{
db = new DatabaseAccess();
db.DAOCanoeBatchOverdueCheck(today);
}
// update Category
public bool updateDSCategoryDB(Category category)
{
db = new DatabaseAccess();
db.DSupdateCategory(category);
return true;
}