private void LoadData()
{
IList <InLabClient> query = RoomDataDA.GetCurrentUsersInRoom(ddlRoom.SelectedValue);
gvUsers.DataSource = query;
gvUsers.DataBind();
rptUsers.DataSource = query;
rptUsers.DataBind();
}
protected void DdlTool_SelectedIndexChanged(object sender, EventArgs e)
{
DateTime d = DateTime.Now.AddMonths(-1);
DataTable dtRes = ReservationDA.GetReservationsByResourceIDAndDate(Convert.ToInt32(ddlTool.SelectedValue), d);
DataTable dtRoomAccess = RoomDataDA.GetCleanRoomAccessData(d);
int count = 0;
foreach (DataRow dr in dtRes.Rows)
{
DateTime sDate = Convert.ToDateTime(dr["ActualBeginDateTime"]);
DateTime eDate;
try
{
eDate = Convert.ToDateTime(dr["ActualEndDateTime"]);
}
catch
{
eDate = sDate;
}
DataRow[] rows = dtRoomAccess.Select(string.Format("ClientID = {0} AND ExitDT >= '{1}' AND ExitDT <= '{2}'", dr["ClientID"], sDate.ToString("MM/dd/yyyy HH:mm:ss"), eDate.ToString("MM/dd/yyyy HH:mm:ss")));
if (rows.Length > 0)
{
count += 1;
dr["EntryTime"] = rows[0]["EntryDT"];
dr["ExitTime"] = rows[0]["ExitDT"];
}
else
{
dr.Delete();
}
}
lblMsg.Text = string.Format("There are {0} illegal reservations out of total {1}", count, dtRes.Rows.Count);
gv.DataSource = dtRes;
gv.DataBind();
}
private void PopulateRss(string roomName, string channelName = "", string userName = "")
{
rss.Channel = new Channel();
rss.Version = "2.0";
rss.Channel.Title = string.Format("LNF Users in {0}", roomName);
rss.Channel.PubDate = DateTime.Now;
rss.Channel.LastBuildDate = DateTime.Now;
rss.Channel.WebMaster = "*****@*****.**";
rss.Channel.Description = "Users currently in one of the LNF lab areas";
rss.Channel.Link = GetFullUrl("~/AccInLab.aspx");
if (!string.IsNullOrEmpty(channelName))
{
rss.Channel.Title += " '" + channelName + "'";
if (!string.IsNullOrEmpty(userName))
{
rss.Channel.Title += string.Format(" (generated for {0})", userName);
}
}
rss.Channel.Items = RoomDataDA.GetCurrentUsersInRoom(roomName).Select(CreateRssItem).ToList();
}
