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(); }