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