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 void Delete_CAR(string ID_CAR) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 25); param[0].Value = ID_CAR; DAL.Executecommand("Delete_CAR", param); DAL.close(); }
public void DELETE_CLIENT(string ID_CUSTOMER) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID_CUSTOMER", SqlDbType.VarChar, 25); param[0].Value = ID_CUSTOMER; DAL.Executecommand("DELETE_CLIENT", param); DAL.close(); }
public void DELETE_BILLS(string BILL_ID) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@BILL_ID", SqlDbType.VarChar, 25); param[0].Value = BILL_ID; DAL.Executecommand("DELETE_BILLS", param); DAL.close(); }
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); }
public void UPDATE_BILLS(int BILL_ID, DateTime BILL_DATE, string BILL_STATUS, int TOTAL_AMOUNT, int ID_RESERVATION) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@BILL_ID", SqlDbType.Int); param[0].Value = BILL_ID; param[1] = new SqlParameter("@BILL_DATE", SqlDbType.Date); param[1].Value = BILL_DATE; param[2] = new SqlParameter("@BILL_STATUS", SqlDbType.Char, 1); param[2].Value = BILL_STATUS; param[3] = new SqlParameter("@TOTAL_AMOUNT", SqlDbType.Int); param[3].Value = TOTAL_AMOUNT; param[4] = new SqlParameter("@ID_RESERVATION", SqlDbType.Int); param[4].Value = ID_RESERVATION; DAL.Executecommand("UPDATE_BILLS", param); DAL.close(); }
public void UPDATE_CAR(int ID_CAR, char AVAILABILITY_FLAG, string MODEL_NAME, int MODEL_YEAR, int MILEAGE, string CAR_CATEGORY_NAME) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@ID_C", SqlDbType.Int); param[0].Value = ID_CAR; param[1] = new SqlParameter("@AVAILABILITY_FLAG", SqlDbType.Char, 1); param[1].Value = AVAILABILITY_FLAG; param[2] = new SqlParameter("@MODEL_NAME", SqlDbType.VarChar, 25); param[2].Value = MODEL_NAME; param[3] = new SqlParameter("@MODEL_YEAR", SqlDbType.Int); param[3].Value = MODEL_YEAR; param[4] = new SqlParameter("@MILEAGE", SqlDbType.Int); param[4].Value = MILEAGE; param[5] = new SqlParameter("@CAR_CATEGORY_NAME", SqlDbType.VarChar, 25); param[5].Value = CAR_CATEGORY_NAME; DAL.Executecommand("UPDATE_CAR", param); DAL.close(); }
public void UPDATE_RESERVATION(int ID_RESERVATION, DateTime DATE_RESERVATION, int RENTAL_DAYS, string STATUS, string MODEL_NAME, string CIN_COSTUMER) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@ID_RESERVATION", SqlDbType.Int); param[0].Value = ID_RESERVATION; param[1] = new SqlParameter("DATE_RESERVATION", SqlDbType.Date); param[1].Value = DATE_RESERVATION; param[2] = new SqlParameter("@RENTAL_DAYS", SqlDbType.Int); param[2].Value = RENTAL_DAYS; param[3] = new SqlParameter("@STATUS", SqlDbType.Char, 1); param[3].Value = STATUS; param[4] = new SqlParameter("@MODEL_NAME", SqlDbType.VarChar, 25); param[4].Value = MODEL_NAME; param[5] = new SqlParameter("@CIN_COSTUMER", SqlDbType.VarChar, 25); param[5].Value = CIN_COSTUMER; DAL.Executecommand("UPDATE_RESERVATION", param); DAL.close(); }
public void UPDATE_RESERVATION(int BOOKING_ID, DateTime DATE_RESERVATION, int AMOUNT, string STATUS, string MODEL_NAME, string CIN) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@BOOKING_ID", SqlDbType.Int); param[0].Value = BOOKING_ID; param[1] = new SqlParameter("DATE_RESERVATION", SqlDbType.Date); param[1].Value = DATE_RESERVATION; param[2] = new SqlParameter("@AMOUNT", SqlDbType.Int); param[2].Value = AMOUNT; param[3] = new SqlParameter("@STATUS", SqlDbType.Char, 1); param[3].Value = STATUS; param[4] = new SqlParameter("@MODEL_NAME", SqlDbType.VarChar, 25); param[4].Value = MODEL_NAME; param[5] = new SqlParameter("@CIN", SqlDbType.VarChar, 25); param[5].Value = CIN; DAL.Executecommand("UPDATE_RESERVATION", param); DAL.close(); }
public void UPDATE_CLIENT(int ID_CUSTOMER, string CIN, string FNAME, string LNAME, int PHONE_NUMBER, string DRIVER_LICENSE) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@ID_CUSTOMER", SqlDbType.Int); param[0].Value = ID_CUSTOMER; param[1] = new SqlParameter("@CIN", SqlDbType.VarChar, 25); param[1].Value = CIN; param[2] = new SqlParameter("@FNAME", SqlDbType.VarChar, 25); param[2].Value = FNAME; param[3] = new SqlParameter("@LNAME", SqlDbType.VarChar, 25); param[3].Value = LNAME; param[4] = new SqlParameter("@PHONE_NUMBER", SqlDbType.Int); param[4].Value = PHONE_NUMBER; param[5] = new SqlParameter("@DRIVER_LICENSE", SqlDbType.VarChar, 25); param[5].Value = DRIVER_LICENSE; DAL.Executecommand("UPDATE_CLIENT", param); DAL.close(); }
public void update_manager(int ID_eddit, string USERNAME, string PASSWORD, string FULLNAME, string usertype, int phone, string email) { DAL.Data_access_layer DAL = new DAL.Data_access_layer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@ID_edit", SqlDbType.Int); param[0].Value = ID_eddit; param[1] = new SqlParameter("@USERNAME", SqlDbType.VarChar, 25); param[1].Value = USERNAME; param[2] = new SqlParameter("@PASSWORD", SqlDbType.VarChar, 25); param[2].Value = PASSWORD; param[3] = new SqlParameter("@FULLNAME", SqlDbType.VarChar, 25); param[3].Value = FULLNAME; param[4] = new SqlParameter("@usertype", SqlDbType.VarChar, 25); param[4].Value = usertype; param[5] = new SqlParameter("@phone", SqlDbType.Int); param[5].Value = phone; param[6] = new SqlParameter("@email", SqlDbType.VarChar, 25); param[6].Value = email; DAL.Executecommand("update_manager", param); DAL.close(); }