protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Username = User.Identity.Name;
// fill data
var tt = AgendaClass.GetAgenda(3, "MAlhazmi");
foreach (var t in tt)
{
HtmlTableCell cell1 = new HtmlTableCell();
HtmlTableCell cell2 = new HtmlTableCell();
HtmlTableCell cell3 = new HtmlTableCell();
HtmlTableCell cell4 = new HtmlTableCell();
HtmlTableCell cell5 = new HtmlTableCell();
HtmlTableRow row = new HtmlTableRow();
string html = @"<a id=""discussion"" href=""Discussion.aspx?aid=" + t.AgendaID + @""" class=""win-commandicon""><span class=""win-commandicon icon-chat-2""></span></a><a id=""file"" href=""File.aspx?aid=" + t.AgendaID + @""" class=""win-commandicon""><span class=""win-commandicon icon-file-3""></span></a><a id=""privacy"" title="""" href=""#"" class=""win-commandicon""><span class=""win-commandicon icon-locked""></span></a><a id=""edit"" href=""#"" class=""win-commandicon""><span class=""win-commandicon icon-pencil""></span></a><a id=""delete"" href=""#"" class=""win-commandicon""><span class=""win-commandicon icon-trash""></span></a>";
cell1.InnerText = t.AgendaCount.ToString();
cell2.InnerText = t.AgendaTitle;
cell3.InnerText = t.AgendaDesc;
cell4.InnerHtml = html;
row.Cells.Add(cell1);
row.Cells.Add(cell2);
row.Cells.Add(cell3);
row.Cells.Add(cell5);
row.Cells.Add(cell4);
tblAgenda.Rows.Add(row);
}
}
}
public AgendaClass GetAll(User user)
{
AgendaClass agendaClass = new AgendaClass();
agendaClass.Owner = user;
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("select agendaitems.ID ,agendaitems.Name,agendaitems.Description,agendaitems.StartTime, agendaitems.EndTime from agendaitems ", con))
{
try
{
List <AgendaItem> agendaItems = new List <AgendaItem>();
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AgendaItem agendaItem = new AgendaItem();
agendaItem.ID = (int)reader["ID"];
agendaItem.Description = (string)reader["Description"];
agendaItem.Name = (string)reader["Name"];
agendaItem.StartTime = (DateTime)reader["StartTime"];
agendaItem.EndTime = (DateTime)reader["EndTime"];
agendaItems.Add(agendaItem);
}
agendaClass.AgendaItems = agendaItems;
}
catch (Exception ex)
{
if (con.State != System.Data.ConnectionState.Closed)
{
con.Close();
}
throw new Exception(ex.Message);
}
if (con.State != System.Data.ConnectionState.Closed)
{
con.Close();
}
return(agendaClass);
}
}
public static string DeleteAgendum(int AgendumID)
{
var result = AgendaClass.DeleteAgendum(AgendumID);
return(result.ToString());
}
public static List <AgendaClass> getAgendaInfo(int meetingID)
{
var result = AgendaClass.GetAgendaAjax(meetingID, Username);
return(result);
}