public List <dtoShowingRoom> GetShowingRooms() { dalShowingRoom dalShowingRoom = new dalShowingRoom(); List <dtoShowingRoom> listEmp = new List <dtoShowingRoom>(); DataTable ShowingRooms = dalShowingRoom.GetShowingRooms(); for (int i = 0; i < ShowingRooms.Rows.Count; i++) { dtoShowingRoom ShowingRoom = new dtoShowingRoom(); DataRow row = ShowingRooms.Rows[i]; ShowingRoom.RoomID = Convert.ToInt32(row[0]); ShowingRoom.RoomType = row[1].ToString(); ShowingRoom.NumberOfSeats = Convert.ToInt32(row[2]); listEmp.Add(ShowingRoom); } return(listEmp); }
/// <summary> /// Hàm thêm phòng chiếu /// </summary> /// <param name="room"></param> /// <returns></returns> public int InsertShowingRoom(dtoShowingRoom room) { int count = 0; try { string sql = "INSERT [dbo].[ShowingRoom] ([RoomType], [NumberOfSeats]) VALUES ( @RoomType, @NumberOfSeats)"; SqlParameter parameterRoomType = new SqlParameter("@RoomType", SqlDbType.NVarChar); parameterRoomType.Value = room.RoomType; SqlParameter parameterNumberOfSeats = new SqlParameter("@NumberOfSeats", SqlDbType.Int); parameterNumberOfSeats.Value = room.NumberOfSeats; count = InsertUpdateDeleteData(sql, new[] { parameterRoomType, parameterNumberOfSeats }); } finally { CloseConnection(); } return(count); }
/// <summary> /// Hàm cập nhập phòng chiếu /// </summary> /// <param name="room"></param> /// <returns></returns> public int UpdateShowingRoom(dtoShowingRoom room) { int count = 0; try { string sql = "UPDATE [dbo].[ShowingRoom] SET [RoomType] = @RoomType, [NumberOfSeats] = @NumberOfSeats WHERE [RoomID] = @RoomID"; SqlParameter parameterRoomID = new SqlParameter("@RoomID", SqlDbType.Int); parameterRoomID.Value = room.RoomID; SqlParameter parameterRoomType = new SqlParameter("@RoomType", SqlDbType.NVarChar); parameterRoomType.Value = room.RoomType; SqlParameter parameterNumberOfSeats = new SqlParameter("@NumberOfSeats", SqlDbType.Int); parameterNumberOfSeats.Value = room.NumberOfSeats; count = InsertUpdateDeleteData(sql, new[] { parameterRoomType, parameterNumberOfSeats }); } finally { CloseConnection(); } return(count); }