protected void removeGroup(object sender, EventArgs e)
{
GroupsDAO groupsDAO = new GroupsDAO();
string result = groupsDAO.removeGroup(this.idGroupChosen.Text);
this.chooseGroupForm.Visible = false;
this.response.Visible = true;
this.responseText.Text = result;
}
protected void updateGroup(object sender, EventArgs e)
{
if (this.mainMember.Text.Equals("") || this.secondMember.Text.Equals(""))
{
this.errorMsg.Visible = true;
this.errorMsg.Text = "At least 2 members have to be selected in order to update a group.";
}
else if (this.groupName.Text.Equals(""))
{
this.errorMsg.Visible = true;
this.errorMsg.Text = "Please insert a name for the Group.";
}
else
{
Groups group = new Groups();
GroupsDAO groupDAO = new GroupsDAO();
group.id = this.GroupID.Text;
group.idMainMember = this.idMainMember.Text;
group.name = this.groupName.Text;
group.idSecond = this.idSecondMember.Text;
if (!this.idThirdMember.Text.Equals("") && !this.idThirdMember.Text.Equals(" "))
{
group.idThird = this.idThirdMember.Text;
}
else
{
group.idThird = null;
}
if (!this.idFourthMember.Text.Equals("") && !this.idFourthMember.Text.Equals(" "))
{
group.idFourth = this.idFourthMember.Text;
}
else
{
group.idFourth = null;
}
if (!this.idFithMember.Text.Equals("") && !this.idFithMember.Text.Equals(" "))
{
group.idFith = this.idFithMember.Text;
}
else
{
group.idFith = null;
}
if (!this.idSixthMember.Text.Equals("") && !this.idSixthMember.Text.Equals(" "))
{
group.idSixth = this.idSixthMember.Text;
}
else
{
group.idSixth = null;
}
string result = groupDAO.updateGroup(group, this.Page.User.Identity.Name.ToString());
this.editGroupForm.Visible = false;
this.response.Visible = true;
this.responseText.Text = result;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.User.Identity.IsAuthenticated)
{
FormsAuthentication.RedirectToLoginPage();
}
string userName = "******";
string name = this.Page.User.Identity.Name.ToString();
if (name != null && name != "")
{
if (name.IndexOf(".") >= 0)
{
userName = name.Substring(0, 1).ToUpper() + name.Substring(1, name.IndexOf(".") - 1);
}
else
{
userName = name.Substring(0, 1).ToUpper() + name.Substring(1, name.Length - 1);
}
}
this.timeAndDate.Text = "User: "******" - " + System.DateTime.Today.Date.ToLongDateString();
GroupsDAO groupDAO = new GroupsDAO();
List<Groups> groups = groupDAO.getAllGroups();
System.Data.DataTable tbl = new DataTable();
DataColumn col = new DataColumn("Group Name");
tbl.Columns.Add(col);
col = new DataColumn("Main Member");
tbl.Columns.Add(col);
col = new DataColumn("Second Member");
tbl.Columns.Add(col);
col = new DataColumn("Third Member");
tbl.Columns.Add(col);
col = new DataColumn("Fourth Member");
tbl.Columns.Add(col);
col = new DataColumn("Fith Member");
tbl.Columns.Add(col);
col = new DataColumn("Sixth Member");
tbl.Columns.Add(col);
col = new DataColumn("Group ID");
tbl.Columns.Add(col);
col = new DataColumn("Main Member ID");
tbl.Columns.Add(col);
col = new DataColumn("Second Member ID");
tbl.Columns.Add(col);
col = new DataColumn("Third Member ID");
tbl.Columns.Add(col);
col = new DataColumn("Fourth Member ID");
tbl.Columns.Add(col);
col = new DataColumn("Fith Member ID");
tbl.Columns.Add(col);
col = new DataColumn("Sixth Member ID");
tbl.Columns.Add(col);
foreach (Groups group in groups)
{
DataRow dr = tbl.NewRow();
dr["Group Name"] = group.name;
dr["Main Member"] = group.mainMemberName;
dr["Second Member"] = group.secondMemberName;
dr["Third Member"] = group.thirdMemberName;
dr["Fourth Member"] = group.fourthMemberName;
dr["Fith Member"] = group.fithMemberName;
dr["Sixth Member"] = group.sixthMemberName;
dr["Group ID"] = group.id;
dr["Main Member ID"] = group.idMainMember;
dr["Second Member ID"] = group.idSecond;
dr["Third Member ID"] = group.idThird;
dr["Fourth Member ID"] = group.idFourth;
dr["Fith Member ID"] = group.idFith;
dr["Sixth Member ID"] = group.idSixth;
tbl.Rows.Add(dr);
}
searchGroups.DataSource = tbl;
searchGroups.DataBind();
ViewState.Add("TBL", tbl);
}
