コード例 #1
0
        // BaseData class will be parent of BookData

        public void InsertReservation(SiCAP_GrupoCARARA.App_Domain.Reservation reservation)
        {
            SqlConnection connection = ManageDatabaseConnection("Open");

            try
            {
                using (SqlCommand sqlCommand = new SqlCommand("insert_reservation", connection))
                {
                    sqlCommand.CommandType = CommandType.StoredProcedure;
                    sqlCommand.Parameters.Add("@Date", SqlDbType.Date).Value = reservation.Date;
                    sqlCommand.Parameters.Add("@IdTimeForReservation", SqlDbType.Int).Value = reservation.IdTimeForReservation;
                    sqlCommand.Parameters.Add("@IdUser", SqlDbType.Int).Value          = reservation.IdUser;
                    sqlCommand.Parameters.Add("@IdParkingSpace", SqlDbType.Int).Value  = reservation.IdParkingSpace;
                    sqlCommand.Parameters.Add("@IdVehicle", SqlDbType.Int).Value       = reservation.IdVehicle;
                    sqlCommand.Parameters.Add("@HasBeenCanceled", SqlDbType.Bit).Value = reservation.HasBeenCanceled;

                    //connection.Open();
                    sqlCommand.ExecuteNonQuery();
                    connection = ManageDatabaseConnection("Close");
                }
            }
            catch (SqlException sqlException)
            {
                throw sqlException;
            }
        }
コード例 #2
0
        public void InsertReservationInGivenPeriod()
        {
            ReservationTransaction transaction = new ReservationTransaction();
            int checkInTime  = int.Parse(DropDownListCheckIn.SelectedItem.Value);
            int checkOutTime = int.Parse(DropDownListCheckOut.SelectedItem.Value);

            while (checkInTime <= checkOutTime)
            {
                SiCAP_GrupoCARARA.App_Domain.Reservation myReservation = FillReservation(checkInTime);
                transaction.InsertReservation(myReservation);
                checkInTime++;
            }
        }
コード例 #3
0
ファイル: ParkingLot_001.aspx.cs プロジェクト: Conkor/SiCAP
        public SiCAP_GrupoCARARA.App_Domain.Reservation FillReservation(int idTimeForReservation)
        {
            int id = 0;
            UserData userData = new UserData();
            DateTime thisDay = DateTime.Today;
            string date = thisDay.ToString("dd/MM/yyyy");
            User userInSession = userData.getUserInSession((string)Session["user"]);
            int idUser = userInSession.Id;
            int idParkingSpace = 3;  //   Aquí hay que meter lo que viene de los botones...!!!!!!!!!!!!!!!!!!!!!!!!!!
            int idVehicle = int.Parse(DropDownListVehiclesOfOneUser.SelectedItem.Value);
            bool hasBeenCanceled = false;

            SiCAP_GrupoCARARA.App_Domain.Reservation myReservation = new SiCAP_GrupoCARARA.App_Domain.Reservation(id, thisDay, idTimeForReservation, idUser, idParkingSpace, idVehicle, hasBeenCanceled);

            return myReservation;
        }
コード例 #4
0
        public SiCAP_GrupoCARARA.App_Domain.Reservation FillReservation(int idTimeForReservation)
        {
            int      id              = 0;
            UserData userData        = new UserData();
            DateTime thisDay         = DateTime.Today;
            string   date            = thisDay.ToString("dd/MM/yyyy");
            User     userInSession   = userData.getUserInSession((string)Session["user"]);
            int      idUser          = userInSession.Id;
            int      idParkingSpace  = 3; //   Aquí hay que meter lo que viene de los botones...!!!!!!!!!!!!!!!!!!!!!!!!!!
            int      idVehicle       = int.Parse(DropDownListVehiclesOfOneUser.SelectedItem.Value);
            bool     hasBeenCanceled = false;

            SiCAP_GrupoCARARA.App_Domain.Reservation myReservation = new SiCAP_GrupoCARARA.App_Domain.Reservation(id, thisDay, idTimeForReservation, idUser, idParkingSpace, idVehicle, hasBeenCanceled);


            return(myReservation);
        }
コード例 #5
0
 public void InsertReservation(SiCAP_GrupoCARARA.App_Domain.Reservation reservation)
 {
     reservationData.InsertReservation(reservation);
 }