public DataTable GET_CAR_ID()
{
DAL.Data_access_layer DAL = new DAL.Data_access_layer();
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_CAR_ID", null);
DAL.close();
return(dt);
}
public DataTable GET_RESERVATION()
{
DAL.Data_access_layer DAL = new DAL.Data_access_layer();
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_RESERVATION", null);
DAL.close();
return(dt);
}
public DataTable search_CAR(string ID)
{
DAL.Data_access_layer DAL = new DAL.Data_access_layer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 25);
param[0].Value = ID;
dt = DAL.SelectData("search_CAR", param);
DAL.close();
return(dt);
}
public DataTable VERIFY_ID_car(string ID_CAR)
{
DAL.Data_access_layer DAL = new DAL.Data_access_layer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 25);
param[0].Value = ID_CAR;
dt = DAL.SelectData("VERIFY_ID_car", param);
DAL.close();
return(dt);
}
public DataTable SEARCH_CLIENT(string ID_CUSTOMER)
{
DAL.Data_access_layer DAL = new DAL.Data_access_layer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_CUSTOMER", SqlDbType.VarChar, 25);
param[0].Value = ID_CUSTOMER;
dt = DAL.SelectData("SEARCH_CLIENT", param);
DAL.close();
return(dt);
}
public DataTable SEARCH_BILLS(string BILL_ID)
{
DAL.Data_access_layer DAL = new DAL.Data_access_layer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@BILL_ID", SqlDbType.VarChar, 25);
param[0].Value = BILL_ID;
dt = DAL.SelectData("SEARCH_BILLS", param);
DAL.close();
return(dt);
}
public DataTable login(string USERNAME, string PASSWORD)
{
DAL.Data_access_layer DAL = new DAL.Data_access_layer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@USERNAME", SqlDbType.VarChar, 25);
param[0].Value = USERNAME;
param[1] = new SqlParameter("@PASSWORD", SqlDbType.VarChar, 25);
param[1].Value = PASSWORD;
DAL.open();
DataTable dt = new DataTable();
dt = DAL.SelectData("SP_LOGIN", param);
DAL.close();
return(dt);
}