private void FillInvitationsTable() { StringBuilder sb = new StringBuilder(); Invitations.Clear(); using (Database db = new MySqlDatabase()) { DataTable dt = db.GetInvitations(Util.UserId); pendingInvitationsHeader.Visible = (dt.Rows.Count > 0); foreach (DataRow row in dt.Rows) { long confId = Convert.ToInt64(row["confirmation_id"]); long userId = Convert.ToInt64(row["requesting_user_id"]); int relType = Convert.ToInt32(row["relationtype"]); UserInfo ui = db.GetUser(userId); ClientInfo ci = db.GetClientInfo(userId); AddInvitationsRow(Invitations, ci.GetFullName(), ui.Email, confId, relType); } Invitations.DefaultView.Sort = "name ASC"; pendingInvitations.DataSource = Invitations; pendingInvitations.DataBind(); } }
private void FillInvitationsTable() { StringBuilder sb = new StringBuilder(); using (Database db = new MySqlDatabase()) { DataTable dt = db.GetInvitations(Util.UserId); DataTable pendingInvitationTable = dt.Clone(); DataTable pendingManageInvitationTable = dt.Clone(); foreach (DataRow row in dt.Rows) { if (Convert.ToInt32(row["relationtype"]) == 0) pendingInvitationTable.ImportRow(row); else pendingManageInvitationTable.ImportRow(row); } if (Invitations == null) { DataTable tempDt = new DataTable("confirmations"); tempDt.Columns.Add("name", typeof(string)); tempDt.Columns.Add("email", typeof(string)); tempDt.Columns.Add("confirmation_id", typeof(long)); tempDt.Columns.Add("relation_type", typeof(int)); Invitations = tempDt; } Invitations.Clear(); if (pendingInvitationTable.Rows.Count > 0) { pendingInvitationsHeader.Visible = (dt.Rows.Count > 0); foreach (DataRow row in pendingInvitationTable.Rows) { long confId = Convert.ToInt64(row["confirmation_id"]); long userId = Convert.ToInt64(row["requesting_user_id"]); relType = Convert.ToInt32(row["relationtype"]); UserInfo ui = db.GetUser(userId); ClientInfo ci = db.GetClientInfo(userId); AddInvitationsRow(Invitations, ci.GetFullName(), ui.Email, confId, relType); } Invitations.DefaultView.Sort = "name ASC"; pendingInvitations.DataSource = Invitations; pendingInvitations.DataBind(); } else { pendingInvitations.DataSource = null; pendingInvitations.DataBind(); } if (ManagedInvitations == null) { DataTable tempDt = new DataTable("confirmations"); tempDt.Columns.Add("name", typeof(string)); tempDt.Columns.Add("email", typeof(string)); tempDt.Columns.Add("confirmation_id", typeof(long)); tempDt.Columns.Add("relation_type", typeof(int)); ManagedInvitations = tempDt; } ManagedInvitations.Clear(); if (pendingManageInvitationTable.Rows.Count > 0) { pendingManageInvitationsHeader.Visible = (dt.Rows.Count > 0); foreach (DataRow row in pendingManageInvitationTable.Rows) { long confId = Convert.ToInt64(row["confirmation_id"]); long userId = Convert.ToInt64(row["requesting_user_id"]); relType = Convert.ToInt32(row["relationtype"]); UserInfo ui = db.GetUser(userId); ClientInfo ci = db.GetClientInfo(userId); AddInvitationsRow(ManagedInvitations, ci.GetFullName(), ui.Email, confId, relType); } ManagedInvitations.DefaultView.Sort = "name ASC"; pendingManageInvitations.DataSource = ManagedInvitations; pendingManageInvitations.DataBind(); } else { pendingManageInvitations.DataSource = null; pendingManageInvitations.DataBind(); } } }