Entvex

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OracleClient;
using System.Collections.Generic;
using System.Diagnostics;

public partial class GroupView : System.Web.UI.Page
{
    protected override void OnInit(EventArgs e)
    {
        String Project;
        try
        {
            Project = Session["ddl1value"].ToString();
        }
        catch
        {
            Project = "All";
        }
        DataTable SelectedGroups = new DataTable();


        GroupListControlNew GroupListControlNew = (GroupListControlNew)LoadControl("GroupListControlNew.ascx");
        PanelAddNewGroup.Controls.Add(GroupListControlNew);

        GroupListControlNew.ID = "GroupListControlNew";

        GroupListControlEditor GroupListControlEditor = (GroupListControlEditor)LoadControl("GroupListControlEditor.ascx");
        PanelEdit.Controls.Add(GroupListControlEditor);

        GroupListControlEditor.ID = "GroupListControlEditor";

        if (Project == "All")
        {
            SelectedGroups = Oracle.DB.Select("select * from Online_calendar_grouplists");
        }
        else
        {
            if (Project == "Miscellaneous")
            {
                SelectedGroups = Oracle.DB.Select("select * from Online_calendar_grouplists where PROJECT_ID = 'Miscellaneous'");
            }
            else
            {
                    //Loop up project ID
                    DataTable ProjectID = Oracle.DB.Select("SELECT DISTINCT project_id FROM TERCONS.TER_PROJECT_NAME_DJE where description = :1", new OracleParameter(":1", Project));
                    SelectedGroups = Oracle.DB.Select("select * from Online_calendar_grouplists where PROJECT_ID = :1", new OracleParameter(":1", ProjectID.Rows[0]["project_id"]));
            }

        }

        // now, create n GroupListControls, adding them to the Panel PanelGroupList
        foreach (DataRow row in SelectedGroups.Rows)
        {
            PanelGroupList.Controls.Add(new GroupListControl());
        }
        int x = 0;
        for (int i = 0; i < PanelGroupList.Controls.Count; i++)
        {
            if (PanelGroupList.Controls[i].GetType().ToString().Equals("GroupListControl") && PanelGroupList.Controls[i].ID == null)
            {

                GroupListControlNew connew = (GroupListControlNew)PanelAddNewGroup.FindControl("GroupListControlNew");

                GroupListControl con = (GroupListControl)PanelGroupList.Controls[i];

                con = new GroupListControl();

                con = (GroupListControl)LoadControl("GroupListControl.ascx");

                con.ID = SelectedGroups.Rows[x]["GROUP_ID"].ToString();

                con.GroupName = SelectedGroups.Rows[x]["PROJECT_ID"].ToString();
                con.NickName = SelectedGroups.Rows[x]["NICKNAME"].ToString();

                //gets data
                con.GetGroupData();

                PanelGroupControls.Controls.Add(con);

                x++;
            }
        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        LoadProjectsToSearch();

        try
        {
            Debug.WriteLine(Session["ddl1value"]);
            ddlProject.SelectedValue = Session["ddl1value"].ToString();
        }
        catch
        {
        }

    }
    /// <summary>
    /// Fills the DropDownBox with projects
    /// </summary>
    private void LoadProjectsToSearch()
    {
        if (IsPostBack == false)
        {
            DataTable CreatedProjects = Oracle.DB.Select("SELECT DISTINCT project_id FROM Online_calendar_grouplists");

            List<String> ProjectsList = new List<string>();

            foreach (DataRow row in CreatedProjects.Rows)
            {

                try
                {
                    DataTable Projects = Oracle.DB.Select("SELECT DISTINCT description FROM tercons.ter_project_name_dje where project_id = :1 ", new OracleParameter(":1", row["project_id"]));
                    ProjectsList.Add(Projects.Rows[0]["description"].ToString());
                }
                catch
                {
                }
            }
            ddlProject.Items.Add("All");
            ddlProject.Items.Add("Miscellaneous");

            foreach (string item in ProjectsList)
            {
                ddlProject.Items.Add(item);
            }
        }
    }
    protected void btnRemove_Click(object sender, EventArgs e)
    {
        string user = Oracle.UserManagement.GetCurrentUserInformation(Oracle.UserManagement.UserInformation.Initials);

        foreach (DataRow row in Oracle.DB.Select("SELECT * FROM Online_calendar_GROUPSELECT where cbselect = 'TRUE' and initials = :1", new OracleParameter(":1", user)).Rows)
        {
            //Delets all Subscribers
            Oracle.DB.ExecuteNonQuery("DELETE FROM Online_Calendar_listsubscribers where group_ID = :1", new OracleParameter(":1", row["Group_id"]));

            //Delete all group selects
            Oracle.DB.ExecuteNonQuery("DELETE from Online_CALENDAR_GROUPSELECT where GROUP_ID = :1", new OracleParameter(":1", row["Group_id"]));

            //delete all members of the grop
            Oracle.DB.ExecuteNonQuery("DELETE FROM Online_Calendar_Group where group_ID = :1", new OracleParameter(":1", row["Group_id"]));

            //delete the group
            Oracle.DB.ExecuteNonQuery("DELETE FROM Online_Calendar_GroupLISTS where group_ID = :1", new OracleParameter(":1", row["Group_id"]));

            Response.Redirect("GroupView.aspx");
        }
    }
    protected void btnNewGroup_Click(object sender, EventArgs e)
    {
        PanelAddNewGroup.Visible = true;
        PanelEdit.Visible = false;
        GroupListControlNew connew = (GroupListControlNew)PanelAddNewGroup.FindControl("GroupListControlNew");
        connew.LoadProjects();
    }
    protected void btnEdit_Click(object sender, EventArgs e)
    {
        string user = Oracle.UserManagement.GetCurrentUserInformation(Oracle.UserManagement.UserInformation.Initials);

        //Checks if only one group is selected
        if (Oracle.DB.Select("SELECT * FROM Online_calendar_GROUPSELECT where cbselect = 'TRUE' and initials = :1", new OracleParameter(":1", user)).Rows.Count == 1)
        {
            GroupListControlEditor GroupListCont = (GroupListControlEditor)PanelEdit.FindControl("GroupListControlEditor");

            DataTable Group_ID = Oracle.DB.Select("SELECT GROUP_ID FROM Online_calendar_GROUPSELECT where cbselect = 'TRUE' and initials = :1", new OracleParameter(":1", user));

            GroupListCont.LoadData(int.Parse(Group_ID.Rows[0][0].ToString()));

            PanelEdit.Visible = true;
            PanelAddNewGroup.Visible = false;
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataTable result;
        DataTable IfsDescription;

        try
        {

            IfsDescription = Oracle.DB.Select("SELECT project_id FROM TERCONS.TER_PROJECT_NAME_DJE where description = :1", new OracleParameter(":1", ddlProject.SelectedValue));

            //result = Oracle.DB.Select("SELECT NICKNAME FROM Online_CALENDAR_GROUPLISTS where PROJECT_ID = :1", new OracleParameter(":1", IfsDescription.Rows[0]["project_id"]));

            //foreach (DataRow row in result.Rows)
            //{
            //    ddlNickName.Items.Add(row[0].ToString());
            //}

            Session["ddl1value"] = ddlProject.SelectedItem.Text;
            Server.Transfer("GroupView.aspx");

        }
        catch
        {
                Session["ddl1value"] = ddlProject.SelectedItem.Text;
                Server.Transfer("GroupView.aspx");
        }
    }
    protected void ddlProject_TextChanged(object sender, EventArgs e)
    {
        Debug.WriteLine(e.ToString());
    }
}