Advertisement
Guest User

Entvex

a guest
Jan 28th, 2010
287
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 8.08 KB | None | 0 0
  1. using System;
  2. using System.Collections;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Linq;
  6. using System.Web;
  7. using System.Web.Security;
  8. using System.Web.UI;
  9. using System.Web.UI.HtmlControls;
  10. using System.Web.UI.WebControls;
  11. using System.Web.UI.WebControls.WebParts;
  12. using System.Xml.Linq;
  13. using System.Data.OracleClient;
  14. using System.Collections.Generic;
  15. using System.Diagnostics;
  16.  
  17. public partial class GroupView : System.Web.UI.Page
  18. {
  19.     protected override void OnInit(EventArgs e)
  20.     {
  21.         String Project;
  22.         try
  23.         {
  24.             Project = Session["ddl1value"].ToString();
  25.         }
  26.         catch
  27.         {
  28.             Project = "All";
  29.         }        
  30.         DataTable SelectedGroups = new DataTable();
  31.  
  32.  
  33.         GroupListControlNew GroupListControlNew = (GroupListControlNew)LoadControl("GroupListControlNew.ascx");
  34.         PanelAddNewGroup.Controls.Add(GroupListControlNew);
  35.  
  36.         GroupListControlNew.ID = "GroupListControlNew";
  37.  
  38.         GroupListControlEditor GroupListControlEditor = (GroupListControlEditor)LoadControl("GroupListControlEditor.ascx");
  39.         PanelEdit.Controls.Add(GroupListControlEditor);
  40.  
  41.         GroupListControlEditor.ID = "GroupListControlEditor";
  42.  
  43.         if (Project == "All")
  44.         {
  45.             SelectedGroups = Oracle.DB.Select("select * from Online_calendar_grouplists");
  46.         }
  47.         else
  48.         {
  49.             if (Project == "Miscellaneous")
  50.             {
  51.                 SelectedGroups = Oracle.DB.Select("select * from Online_calendar_grouplists where PROJECT_ID = 'Miscellaneous'");
  52.             }
  53.             else
  54.             {
  55.                     //Loop up project ID
  56.                     DataTable ProjectID = Oracle.DB.Select("SELECT DISTINCT project_id FROM TERCONS.TER_PROJECT_NAME_DJE where description = :1", new OracleParameter(":1", Project));
  57.                     SelectedGroups = Oracle.DB.Select("select * from Online_calendar_grouplists where PROJECT_ID = :1", new OracleParameter(":1", ProjectID.Rows[0]["project_id"]));
  58.             }
  59.  
  60.         }
  61.  
  62.         // now, create n GroupListControls, adding them to the Panel PanelGroupList
  63.         foreach (DataRow row in SelectedGroups.Rows)
  64.         {
  65.             PanelGroupList.Controls.Add(new GroupListControl());
  66.         }
  67.         int x = 0;
  68.         for (int i = 0; i < PanelGroupList.Controls.Count; i++)
  69.         {
  70.             if (PanelGroupList.Controls[i].GetType().ToString().Equals("GroupListControl") && PanelGroupList.Controls[i].ID == null)
  71.             {
  72.  
  73.                 GroupListControlNew connew = (GroupListControlNew)PanelAddNewGroup.FindControl("GroupListControlNew");
  74.  
  75.                 GroupListControl con = (GroupListControl)PanelGroupList.Controls[i];
  76.  
  77.                 con = new GroupListControl();
  78.  
  79.                 con = (GroupListControl)LoadControl("GroupListControl.ascx");
  80.  
  81.                 con.ID = SelectedGroups.Rows[x]["GROUP_ID"].ToString();
  82.  
  83.                 con.GroupName = SelectedGroups.Rows[x]["PROJECT_ID"].ToString();
  84.                 con.NickName = SelectedGroups.Rows[x]["NICKNAME"].ToString();
  85.  
  86.                 //gets data
  87.                 con.GetGroupData();
  88.  
  89.                 PanelGroupControls.Controls.Add(con);
  90.  
  91.                 x++;
  92.             }
  93.         }
  94.     }
  95.  
  96.     protected void Page_Load(object sender, EventArgs e)
  97.     {
  98.         LoadProjectsToSearch();
  99.  
  100.         try
  101.         {
  102.             Debug.WriteLine(Session["ddl1value"]);
  103.             ddlProject.SelectedValue = Session["ddl1value"].ToString();
  104.         }
  105.         catch
  106.         {
  107.         }
  108.        
  109.     }
  110.     /// <summary>
  111.     /// Fills the DropDownBox with projects
  112.     /// </summary>
  113.     private void LoadProjectsToSearch()
  114.     {
  115.         if (IsPostBack == false)
  116.         {
  117.             DataTable CreatedProjects = Oracle.DB.Select("SELECT DISTINCT project_id FROM Online_calendar_grouplists");
  118.  
  119.             List<String> ProjectsList = new List<string>();
  120.  
  121.             foreach (DataRow row in CreatedProjects.Rows)
  122.             {
  123.  
  124.                 try
  125.                 {
  126.                     DataTable Projects = Oracle.DB.Select("SELECT DISTINCT description FROM tercons.ter_project_name_dje where project_id = :1 ", new OracleParameter(":1", row["project_id"]));
  127.                     ProjectsList.Add(Projects.Rows[0]["description"].ToString());
  128.                 }
  129.                 catch
  130.                 {
  131.                 }
  132.             }
  133.             ddlProject.Items.Add("All");
  134.             ddlProject.Items.Add("Miscellaneous");
  135.  
  136.             foreach (string item in ProjectsList)
  137.             {
  138.                 ddlProject.Items.Add(item);
  139.             }
  140.         }
  141.     }
  142.     protected void btnRemove_Click(object sender, EventArgs e)
  143.     {
  144.         string user = Oracle.UserManagement.GetCurrentUserInformation(Oracle.UserManagement.UserInformation.Initials);
  145.  
  146.         foreach (DataRow row in Oracle.DB.Select("SELECT * FROM Online_calendar_GROUPSELECT where cbselect = 'TRUE' and initials = :1", new OracleParameter(":1", user)).Rows)
  147.         {
  148.             //Delets all Subscribers
  149.             Oracle.DB.ExecuteNonQuery("DELETE FROM Online_Calendar_listsubscribers where group_ID = :1", new OracleParameter(":1", row["Group_id"]));
  150.  
  151.             //Delete all group selects
  152.             Oracle.DB.ExecuteNonQuery("DELETE from Online_CALENDAR_GROUPSELECT where GROUP_ID = :1", new OracleParameter(":1", row["Group_id"]));
  153.  
  154.             //delete all members of the grop
  155.             Oracle.DB.ExecuteNonQuery("DELETE FROM Online_Calendar_Group where group_ID = :1", new OracleParameter(":1", row["Group_id"]));
  156.  
  157.             //delete the group
  158.             Oracle.DB.ExecuteNonQuery("DELETE FROM Online_Calendar_GroupLISTS where group_ID = :1", new OracleParameter(":1", row["Group_id"]));
  159.  
  160.             Response.Redirect("GroupView.aspx");
  161.         }
  162.     }
  163.     protected void btnNewGroup_Click(object sender, EventArgs e)
  164.     {
  165.         PanelAddNewGroup.Visible = true;
  166.         PanelEdit.Visible = false;
  167.         GroupListControlNew connew = (GroupListControlNew)PanelAddNewGroup.FindControl("GroupListControlNew");
  168.         connew.LoadProjects();
  169.     }
  170.     protected void btnEdit_Click(object sender, EventArgs e)
  171.     {
  172.         string user = Oracle.UserManagement.GetCurrentUserInformation(Oracle.UserManagement.UserInformation.Initials);
  173.  
  174.         //Checks if only one group is selected
  175.         if (Oracle.DB.Select("SELECT * FROM Online_calendar_GROUPSELECT where cbselect = 'TRUE' and initials = :1", new OracleParameter(":1", user)).Rows.Count == 1)
  176.         {
  177.             GroupListControlEditor GroupListCont = (GroupListControlEditor)PanelEdit.FindControl("GroupListControlEditor");
  178.  
  179.             DataTable Group_ID = Oracle.DB.Select("SELECT GROUP_ID FROM Online_calendar_GROUPSELECT where cbselect = 'TRUE' and initials = :1", new OracleParameter(":1", user));
  180.  
  181.             GroupListCont.LoadData(int.Parse(Group_ID.Rows[0][0].ToString()));
  182.  
  183.             PanelEdit.Visible = true;
  184.             PanelAddNewGroup.Visible = false;
  185.         }
  186.     }
  187.     protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
  188.     {
  189.         DataTable result;
  190.         DataTable IfsDescription;
  191.  
  192.         try
  193.         {
  194.  
  195.             IfsDescription = Oracle.DB.Select("SELECT project_id FROM TERCONS.TER_PROJECT_NAME_DJE where description = :1", new OracleParameter(":1", ddlProject.SelectedValue));
  196.  
  197.             //result = Oracle.DB.Select("SELECT NICKNAME FROM Online_CALENDAR_GROUPLISTS where PROJECT_ID = :1", new OracleParameter(":1", IfsDescription.Rows[0]["project_id"]));
  198.  
  199.             //foreach (DataRow row in result.Rows)
  200.             //{
  201.             //    ddlNickName.Items.Add(row[0].ToString());
  202.             //}
  203.  
  204.             Session["ddl1value"] = ddlProject.SelectedItem.Text;
  205.             Server.Transfer("GroupView.aspx");
  206.  
  207.         }
  208.         catch
  209.         {
  210.                 Session["ddl1value"] = ddlProject.SelectedItem.Text;
  211.                 Server.Transfer("GroupView.aspx");
  212.         }
  213.     }
  214.     protected void ddlProject_TextChanged(object sender, EventArgs e)
  215.     {        
  216.         Debug.WriteLine(e.ToString());
  217.     }
  218. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement