public ActionResult DeleteConfirmed(int id)
{
MeetingRoom meetingRoom = _mrdb.GetMeetingRoomById(id);
_mrdb.RemoveMeetingRoom(meetingRoom, _mdb);
return(RedirectToAction("Index"));
}
public void Save(MeetingRoom model)
{
model.Number = model.Number.ToUpper();
DB.MeetingRooms.AddOrUpdate(model);
DB.SaveChanges();
}
public IQueryable <Meeting> GetMeetingByMeetingRoom(DateTime startDate, DateTime endDate, string meetingRoomId)
{
MeetingRoom meetingRoom = new MeetingRoom();
try
{
if (!String.IsNullOrEmpty(meetingRoomId))
{
meetingRoom = _context.MeetingRooms.Find(meetingRoomId);
}
}catch (System.InvalidOperationException ex)
{
throw new InvalidOperationException("MeetingRoom is not correct", ex);
}
try
{
var meetings = from m in _context.Meetings
where m.IsCanceled == false && m.MeetingRoom.Id == meetingRoom.Id && ((m.BeginningTime > startDate && m.BeginningTime < endDate) || (m.EndTime > startDate && m.EndTime < endDate))
select m;
return(meetings);
}catch (Exception e)
{
_logger.Error(e.Message, e);
}
return(null);
}
public void PerformMeeting()
{
IMeeting meeting = new Meeting();
MeetingRoom meetingStarted = new MeetingRoom("Code Quality Improvement Meeting");
meetingStarted.StartMeeting(meeting);
}
public ObservableCollection <MeetingRoom> FetchRepository(string StartTime, string EndTime)
{
// Connect to PostgreSQL
NpgsqlConnection conn = null;
try
{
conn = DBUtil.GetDBConnection();
conn.Open();
String sql = "SELECT \"ROOM_ID\",\"ROOM_NAME\" FROM \"MEETING_ROOM\" WHERE \"ROOM_ID\" NOT IN (SELECT \"ROOM_ID\" FROM \"MEETING\" WHERE \"FROM_DATE_TS\"<=to_timestamp(:to_date_ts,'DD/MM/YYYY HH24:MI') AND \"TO_DATE_TS\">to_timestamp(:from_date_ts,'DD/MM/YYYY HH24:MI'))";
NpgsqlCommand command = new NpgsqlCommand(sql, conn);
command.Parameters.AddWithValue("from_date_ts", NpgsqlTypes.NpgsqlDbType.Text, StartTime);
command.Parameters.AddWithValue("to_date_ts", NpgsqlTypes.NpgsqlDbType.Text, EndTime);
NpgsqlDataReader dr = command.ExecuteReader();
_meetingRooms = new ObservableCollection <MeetingRoom>();
// Output the rows of the first result set
while (dr.Read())
{
MeetingRoom meetingRoom = new MeetingRoom((int)dr[0], (string)dr[1]);
_meetingRooms.Add(meetingRoom);
}
}
catch (Exception e)
{
Console.WriteLine("Exception in FetchRepository : " + e.ToString());
throw;
}
finally
{
conn.Close();
}
return(_meetingRooms);
}
/// <summary>
/// 画面起動時の初期処理を行います。
/// </summary>
public void Initialize()
{
using (var conn = DbProvider.CreateConnection())
{
// 場所を名前順に取得
Locations = conn.SelectLocations().ToArray();
// 初期値設定
if (EditMode == EditMode.AddNew)
{
MeetingRoom = new MeetingRoom();
}
else
{
// 会議室の最新データを読み込む
MeetingRoom = conn.Query <MeetingRoom, Location, MeetingRoom>(@"
select
*
from
MEETING_ROOM MR
inner join LOCATION LC on LC.ID = MR.LOCATION_ID
where
MR.ID = :ID
",
(mr, loc) => { mr.Location = loc; return(mr); },
new { ID = MeetingRoom.Id }
)
.Single();
}
}
}
public 予約希望(MeetingRoom room, ReserverId reserverId, 予約期間 range, 想定使用人数 想定使用人数)
{
this.room = room;
this.range = range;
this.想定使用人数 = 想定使用人数;
this.reserverId = reserverId;
}
public ActionResult AddRoom(MeetingRoom meetingroom)
{
if (meetingroom.NumberRoom <= 0)
{
ViewBag.inscription = "Неправильно введен номер комнаты";
return(View());
}
foreach (var r in mrc.MeetingRooms)
{
if (r.NumberRoom == meetingroom.NumberRoom)
{
ViewBag.inscription = "Комната с таким номером существует";
return(View());
}
}
if (meetingroom.CountSeats <= 0)
{
ViewBag.inscription = "Неправильно указано количество сидений";
return(View());
}
ViewBag.inscription = "Комната №" + meetingroom.NumberRoom + " успешно создана";
mrc.MeetingRooms.Add(meetingroom);
mrc.SaveChanges();
return(View());
}
public ActionResult VenueSetup()
{
MeetingRoom app = new MeetingRoom();
app.ID = Guid.NewGuid();
return(View(app));
}
static void Main(string[] args)
{
Interval[] arr = new Interval[4];
arr[0] = new Interval(0, 30);
arr[1] = new Interval(5, 10);
arr[2] = new Interval(15, 20);
arr[3] = new Interval(25, 30);
MeetingRoom m = new MeetingRoom();
bool canattend = m.CanAttendAllMeetings(arr);
Console.WriteLine("Can attend all meetings: " + canattend);
Interval[] arr1 = new Interval[2];
arr1[0] = new Interval(7, 10);
arr1[1] = new Interval(2, 4);
MeetingRoom m1 = new MeetingRoom();
bool canattend1 = m1.CanAttendAllMeetings(arr1);
Console.WriteLine("Can attend all meetings: " + canattend1);
}
public JsonResult VenueSetup(MeetingRoom meetRoom)
{
string statuscode = "200";
string msg = "";
meetRoom.ID = Guid.NewGuid();
meetRoom.XXID = xxid;
if (ModelState.IsValid)
{
meetRoom.CreatorName = user.loginname;
meetRoom.CreatorDisplayName = user.username;
meetRoom.CreateTime = DateTime.Now;
meetRoom.Memo = "启用";
try
{
bll.addVenueSet(meetRoom);
}
catch (Exception ex)
{
statuscode = "500";
msg = ex.ToString();
}
}
JsonResult jr = new JsonResult {
Data = new { statuscode, msg }
};
return(Json(jr, JsonRequestBehavior.AllowGet));
}
//[Route("meetingroom")]
public IActionResult Put(string id, [FromBody] MeetingRoom location)
{
try
{
//location.Id = Convert.ToInt64(id);
if (!ModelState.IsValid)
{
_logger.LogInformation("Invalid meeting room data received");
return(BadRequest("Invalid meeting room data"));
}
if (_locationRepository.GetLocationById(id) == null)
{
return(Post(location));
}
else
{
return(Ok(_locationRepository.UpdateLocation(location)));
}
}
catch (Exception ex)
{
return(BadRequest($"Invalid id or location: {ex.Message}"));
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string roomCode = txtRoomCode.Text;
string roomName = txtRoomName.Text;
int capacity = Convert.ToInt32(txtCapacity.Text);
MeetingRoomStatus status = (MeetingRoomStatus)Convert.ToInt32(rblStatus.SelectedValue);
string description = txtDescription.Text;
MeetingRoom room = new MeetingRoom();
room.RoomCode = roomCode;
room.RoomName = roomName;
room.Capacity = capacity;
room.Status = status;
room.Description = description;
RoomOpResult result = BLLRoom.AddRoom(room);
string script;
if (result == RoomOpResult.Duplicate)
{
script = "<script type='text/javascript'>alert('会议室编号或名称已存在，请更换编号或名称!');</script>";
Page.ClientScript.RegisterStartupScript(this.GetType(), "duplicate", script);
}
else if (result == RoomOpResult.Success)
{
txtRoomCode.Text = "";
txtRoomName.Text = "";
txtCapacity.Text = "";
txtDescription.Text = "";
rblStatus.SelectedIndex = 0;
script = "<script type='text/javascript'>alert('会议室:" + room.RoomName + "添加成功!');</script>";
Page.ClientScript.RegisterStartupScript(this.GetType(), "success", script);
}
}
/// <summary>
/// Obtem uma lista de horários de um determinado dia ( ocupado e nao ocupado ) para uma room específica
/// </summary>
/// <param name="day"></param>
/// <param name="meetingRoom"></param>
/// <returns></returns>
public IEnumerable <Scheduling> GetAvailbleTimesByDayAndRoom(DateTime day, MeetingRoom meetingRoom)
{
// Nessa momento eu assumo que o horario útil varia de 8 as 18;
var initialDate = new DateTime(day.Year, day.Month, day.Day, 8, 0, 0);
var finalDate = new DateTime(day.Year, day.Month, day.Day, 18, 0, 0);
var hoursUnavailbe = Context.Schedulings.Include(l => l.Room)
.Where(wr => (wr.SchedulingStart > initialDate || wr.SchedulingEnd < finalDate) && wr.Room.MeetingRoomId == meetingRoom.MeetingRoomId)
.ToList();
var result = new List <Scheduling>();
while (initialDate < finalDate)
{
var test = hoursUnavailbe.Find(w => w.SchedulingStart <= initialDate && w.SchedulingEnd > initialDate);
if (test == null)
{
result.Add(new Scheduling
{
SchedulingStart = initialDate,
SchedulingEnd = initialDate.AddMinutes(intervalMeetingInMinutes)
});
}
else
{
result.Add(test);
}
initialDate = initialDate.AddMinutes(intervalMeetingInMinutes);
}
return(result);
}
private void BindRoom()
{
int roomID = Convert.ToInt32(Request["roomid"]);
MeetingRoom room = BLLRoom.GetRoomByID(roomID);
if (room != null)
{
if (room.Status == MeetingRoomStatus.Deleted) // 如果会议室已被删除，则不允许进行任何修改
{
txtRoomCode.Enabled = false;
txtRoomName.Enabled = false;
txtCapacity.Enabled = false;
rblStatus.Enabled = false;
txtRoomCode.Enabled = false;
}
txtRoomCode.Text = room.RoomCode;
txtRoomName.Text = room.RoomName;
txtCapacity.Text = room.Capacity.ToString();
rblStatus.SelectedValue = Convert.ToInt32(room.Status).ToString();
txtDescription.Text = room.Description;
}
else
{
btnSubmit.Enabled = false;
}
}
public void IndexTestNameLike()
{
//Arrange
TestBookingContext tbc = new TestBookingContext();
MeetingRoomsController controller = new MeetingRoomsController(tbc);
MeetingRoom room1 = new MeetingRoom()
{
Name = "Chat Room", Size = 4, Location = "Ground Floor"
};
MeetingRoom room2 = new MeetingRoom()
{
Name = "Board Room", Size = 8, Location = "First Floor"
};
tbc.MeetingRooms.Add(room1);
tbc.MeetingRooms.Add(room2);
// Act
ViewResult result = controller.Index("", "hat") as ViewResult;
// Assert
var rooms = (List <MeetingRoom>)result.ViewData.Model;
foreach (var r in rooms)
{
StringAssert.Contains(r.Name, "hat");
}
Assert.AreEqual(1, rooms.Count);
}
public void UpdateMeetingRoom(MeetingRoom meetingRoom)
{
Run(context =>
{
context.Entry(meetingRoom).State = EntityState.Modified;
context.SaveChanges();
});
}
public void AddMeetingRoom(MeetingRoom meetingRoom)
{
Run(context =>
{
context.MeetingRooms.Add(meetingRoom);
context.SaveChanges();
});
}
public ActionResult DeleteConfirmed(string id)
{
MeetingRoom meetingRoom = db.MeetingRooms.Find(id);
db.MeetingRooms.Remove(meetingRoom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 用户点击页面左侧导航菜单中的相应会议室时，返回会议室预定情况
/// </summary>
/// <param name="Id">参数Id是MeetingRoom会议室的Id</param>
/// <returns></returns>
public ActionResult MeetingRoom(string Id)
{
MeetingRoom meetingRoom = _context.MeetingRooms.Find(Id);
ViewBag.MeetingName = meetingRoom.Name;
ViewBag.MeetingRoomId = Id;
return(View());
}
public async Task <MeetingRoom> DeleteMeetingRoom(MeetingRoom meetingRoom)
{
await Context.MeetingRoomRepository.Delete(meetingRoom);
await Context.ReservationRepository.DeleteAll(await Context.ReservationRepository.GetOn(rs => rs.MeetingRoomCode == meetingRoom.Code));
return(meetingRoom);
}
/// <summary>
/// 作用：创建会议室
/// 作者：汪建龙
/// 编写时间：2017年2月20日11:08:08
/// </summary>
/// <param name="room"></param>
/// <returns></returns>
public int Save(MeetingRoom room)
{
using (var db = GetDbContext())
{
db.Meeting_Rooms.Add(room);
db.SaveChanges();
return(room.ID);
}
}
public async Task <bool> Update(MeetingRoom meetingRoom)
{
var updateResult = await _context
.MeetingRooms
.ReplaceOneAsync(filter : g => g.Id == meetingRoom.Id, replacement : meetingRoom);
return(updateResult.IsAcknowledged &&
updateResult.ModifiedCount > 0);
}
public void RemoveMeetingRoom(MeetingRoom meetingRoom, IMeetingsRepository meetingRepo)
{
Run(context =>
{
meetingRepo.DeleteAllMeetingsWithRoom(meetingRoom.Id);
context.MeetingRooms.Remove(context.MeetingRooms.Find(meetingRoom.Id));
context.SaveChanges();
});
}
public ActionResult Edit(MeetingRoom meetingRoom)
{
if (ModelState.IsValid)
{
_mrdb.UpdateMeetingRoom(meetingRoom);
return(RedirectToAction("Index"));
}
return(View(meetingRoom));
}
public bool この会議室は予約可能ですか(MeetingRoom room, ReserverId id, 予約期間 range, 想定使用人数 ninzu)
{
var other = new 予約希望(room, range);
bool 被っている = list.Any(x => x.かぶってますか(other));
bool 予約可能である = !被っている;
return(予約可能である);
}
public static MeetingRoomResponse MapVirtualCourtToResponse(MeetingRoom meetingRoom) => meetingRoom == null
? null
: new MeetingRoomResponse
{
AdminUri = meetingRoom.AdminUri,
JudgeUri = meetingRoom.JudgeUri,
ParticipantUri = meetingRoom.ParticipantUri,
PexipNode = meetingRoom.PexipNode,
TelephoneConferenceId = meetingRoom.TelephoneConferenceId
};
public MeetingRoomDetailForm(EditMode editMode, MeetingRoom meetingRoom) : this()
{
model = new MeetingRoomDetailModel(editMode, meetingRoom);
// ウィンドウタイトル設定
editModeName =
model.EditMode == EditMode.AddNew ? "登録" :
model.EditMode == EditMode.Modify ? "変更" :
"削除";
}
public async Task Should_close_conference_and_remove_court_room_for_given_valid_conference_id()
{
var meetingRoom = new MeetingRoom("admin", "judge", "participant", "node", "12345678");
VideoPlatformServiceMock.Setup(v => v.GetVirtualCourtRoomAsync(It.IsAny <Guid>())).ReturnsAsync(meetingRoom);
await Controller.CloseConferenceAsync(Guid.NewGuid());
CommandHandlerMock.Verify(c => c.Handle(It.IsAny <CloseConferenceCommand>()), Times.Once);
VideoPlatformServiceMock.Verify(v => v.DeleteVirtualCourtRoomAsync(It.IsAny <Guid>()), Times.Once);
}
public MeetingRoom GetMeetingRoomById(int id)
{
MeetingRoom result = new MeetingRoom();
Run(context =>
{
result = context.MeetingRooms.Find(id);
});
return(result);
}
public static List<MeetingRoomBooking> list(IDbConnection db, MeetingRoom mr, long day)
{
using (IDbCommand command = db.CreateCommand())
{
command.CommandText = "select id, day, [from], till, _user, _meetingroom, users_notified, users_to_be_notified, users_checkedin from booking where day= @Day";
List<MeetingRoomBooking> MeetingRoomBooking = new List<MeetingRoomBooking>();
IDbDataParameter p = command.CreateParameter();
p.ParameterName = "@Day";
p.Value = day;
command.Parameters.Add(p);
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
MeetingRoomBooking.Add(new MeetingRoomBooking(reader));
}
return MeetingRoomBooking;
}
}
}
public static List<MeetingRoomBooking> list(IDbConnection db, MeetingRoom mr)
{
using (IDbCommand command = db.CreateCommand())
{
command.CommandText = "select id, day, [from], till, _user, _meetingroom, users_notified, users_to_be_notified, users_checkedin from booking";
List<MeetingRoomBooking> MeetingRoomBooking = new List<MeetingRoomBooking>();
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
MeetingRoomBooking.Add(new MeetingRoomBooking(reader));
}
return MeetingRoomBooking;
}
}
}
public static bool IsBooking(IDbConnection db, MeetingRoom mr, long day, long till, long from)
{
using (IDbCommand command = db.CreateCommand())
{
command.CommandText = "select count(*) from booking where day = @Day and _meetingroom = @Meetingroom and (till between @From and @Till or [from] between @From and @Till)";
IDbDataParameter p1 = command.CreateParameter();
p1.ParameterName = "@Day";
p1.Value = day;
command.Parameters.Add(p1);
IDbDataParameter p2 = command.CreateParameter();
p2.ParameterName = "@Meetingroom";
p2.Value = mr.Id;
command.Parameters.Add(p2);
IDbDataParameter p3 = command.CreateParameter();
p3.ParameterName = "@Till";
p3.Value = till;
command.Parameters.Add(p3);
IDbDataParameter p4 = command.CreateParameter();
p4.ParameterName = "@From";
p4.Value = from;
command.Parameters.Add(p4);
return (int)command.ExecuteScalar() > 0;
}
}
