| <%@ Page Language="C#" AutoEventWireup="true" CodeFile="ZZ_DashBoard.aspx.cs" Inherits="ZZ_DashBoard" | |
| EnableViewState="false" %> | |
| <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> | |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
| <html xmlns="http://www.w3.org/1999/xhtml"> | |
| <head id="Head1" runat="server"> | |
| <title>DashBoard</title> | |
| <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> | |
| <script type="text/javascript"> | |
| var currentLoadingPanel = null; | |
| var currentUpdatedControl = null; | |
| function RequestStart(sender, args) { | |
| currentLoadingPanel = $find("RadAjaxLoadingPanel1"); | |
| currentUpdatedControl = "TableLayout"; | |
| currentLoadingPanel.show(currentUpdatedControl); | |
| } | |
| function ResponseEnd() { | |
| //hide the loading panel and clean up the global variables | |
| if (currentLoadingPanel != null) | |
| currentLoadingPanel.hide(currentUpdatedControl); | |
| currentUpdatedControl = null; | |
| currentLoadingPanel = null; | |
| } | |
| function OnDateClick(sender, args) { | |
| //--when load calender dashlet | |
| args.get_domEvent().stopPropagation(); | |
| } | |
| function CustomCommand(dock, args) { | |
| alert('11'); | |
| args.set_cancel(true); | |
| } | |
| function btnAddZone_OnClientClick() { | |
| try { | |
| ctl = $find("<%= cmbTableLayouts.ClientID%>"); | |
| if (ctl.get_value() == "") { | |
| alert("Select Table Layout !"); | |
| ctl.get_inputDomElement().focus(); | |
| return false; | |
| } | |
| } | |
| catch (e) { | |
| alert("Error:- Page: ZZ_DashBoard.aspx; Method: \"btnAddZone_OnClientClick\" \n Description:- \n" + e.description); | |
| return false; | |
| } | |
| } | |
| function btnAddDock_OnClientClick() { | |
| try { | |
| ctl = $find("<%= cmbDashlets.ClientID%>"); | |
| if (ctl.get_value() == "") { | |
| alert("Select Dashlet !"); | |
| ctl.get_inputDomElement().focus(); | |
| return false; | |
| } | |
| ctl = $find("<%= cmbZone.ClientID%>"); | |
| if (ctl.get_value() == "") { | |
| alert("Select Zone !"); | |
| ctl.get_inputDomElement().focus(); | |
| return false; | |
| } | |
| } | |
| catch (e) { | |
| alert("Error:- Page: ZZ_DashBoard.aspx; Method: \"btnAddDock_OnClientClick\" \n Description:- \n" + e.description); | |
| return false; | |
| } | |
| } | |
| </script> | |
| </telerik:RadCodeBlock> | |
| </head> | |
| <body> | |
| <form id="form1" runat="server"> | |
| <asp:ScriptManager ID="scriptmanager1" runat="server"> | |
| </asp:ScriptManager> | |
| <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> | |
| <ClientEvents OnRequestStart="RequestStart" OnResponseEnd="ResponseEnd" /> | |
| <AjaxSettings> | |
| <telerik:AjaxSetting AjaxControlID="btnAddZone"> | |
| <UpdatedControls> | |
| <telerik:AjaxUpdatedControl ControlID="lblMessage" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone1" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone2" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone3" /> | |
| <telerik:AjaxUpdatedControl ControlID="cmbTableLayout" /> | |
| </UpdatedControls> | |
| </telerik:AjaxSetting> | |
| <telerik:AjaxSetting AjaxControlID="btnAddDock"> | |
| <UpdatedControls> | |
| <telerik:AjaxUpdatedControl ControlID="lblMessage" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone1" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone2" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone3" /> | |
| </UpdatedControls> | |
| </telerik:AjaxSetting> | |
| <telerik:AjaxSetting AjaxControlID="btnSaveDock"> | |
| <UpdatedControls> | |
| <telerik:AjaxUpdatedControl ControlID="lblMessage" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone1" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone2" /> | |
| <telerik:AjaxUpdatedControl ControlID="RadDockZone3" /> | |
| </UpdatedControls> | |
| </telerik:AjaxSetting> | |
| </AjaxSettings> | |
| </telerik:RadAjaxManager> | |
| <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="200px" | |
| Width="250px" Transparency="50"> | |
| <img alt="Loading..." src='Images/LoadingProgressBar.gif' style="border: 0;" /> | |
| </telerik:RadAjaxLoadingPanel> | |
| <table id="Table1" width="100%" runat="server" cellspacing="0"> | |
| <tr> | |
| <th class="tdMainHeader1" style="width: 10%;"> | |
| <img alt="Customer" src="Images/dashboard.gif" /> | |
| Dashboard | |
| </th> | |
| <th style="text-align: right;" class="tdMainHeader1"> | |
| <asp:Button ID="btnSaveDock" runat="server" Text="Save My Dashboard" OnClick="btnSaveDock_Click" /> | |
| <asp:Button ID="btnCancel" runat="server" Text="Cancel" Width="100px" /> | |
| </th> | |
| </tr> | |
| <tr id="trZoneLayout" runat="server"> | |
| <td style="width: 7%;" align="left"> | |
| Zone Layout | |
| </td> | |
| <td align="left"> | |
| <telerik:RadComboBox ID="cmbTableLayouts" runat="server"> | |
| </telerik:RadComboBox> | |
| | |
| <asp:Button ID="btnAddZone" runat="server" Text="Add Zone" OnClick="btnAddZone_Click" | |
| Width="100px" /> | |
| <%--OnClientClick="javascript:return btnAddZone_OnClientClick();"--%> | |
| </td> | |
| </tr> | |
| <tr> | |
| <td> | |
| Dashlets | |
| </td> | |
| <td> | |
| <telerik:RadComboBox ID="cmbDashlets" runat="server" Skin="Office2007"> | |
| </telerik:RadComboBox> | |
| | |
| <telerik:RadComboBox ID="cmbZone" runat="server" Skin="Office2007" DataSource="<%#GetZones() %>" | |
| DataTextField="ID" DataValueField="ClientID"> | |
| </telerik:RadComboBox> | |
| | |
| <asp:Button ID="btnAddDock" runat="server" Text="Add Dock" Width="100px" OnClick="btnAddDock_Click" /> | |
| <%--OnClientClick="javascript:return btnAddDock_OnClientClick();"--%> | |
| </td> | |
| </tr> | |
| <tr> | |
| <td colspan="2"> | |
| <telerik:RadDockLayout runat="server" ID="rdDockLayout" OnSaveDockLayout="rdDockLayout_SaveDockLayout" | |
| Skin="Office2007" OnLoadDockLayout="rdDockLayout_LoadDockLayout"> | |
| <table width="100%" id="TableLayout" cellpadding="2" cellspacing="2"> | |
| <tr id="trOneZone" runat="server"> | |
| <td colspan="2"> | |
| <asp:Label ID="lblZone3" runat="server" Visible="false" Text="Zone3"></asp:Label> | |
| <telerik:RadDockZone runat="server" ID="RadDockZone3" Width="99%" MinHeight="100" | |
| Style="background: #f5f4e8; float: left;" Orientation="Vertical" FitDocks="true" | |
| Visible="false" BorderStyle="None"> | |
| </telerik:RadDockZone> | |
| </td> | |
| </tr> | |
| <tr id="trTwoZone" runat="server"> | |
| <td style="width: 50%;" align="left" valign="top"> | |
| <table width="100%"> | |
| <tr> | |
| <td> | |
| <asp:Label ID="lblZone1" runat="server" Visible="false" Text="Zone1"></asp:Label> | |
| <telerik:RadDockZone runat="server" ID="RadDockZone1" Width="99%" MinHeight="100" | |
| Style="background: #f5f4e8; float: left;" Orientation="Vertical" FitDocks="true" | |
| Visible="false" BorderStyle="None"> | |
| </telerik:RadDockZone> | |
| </td> | |
| </tr> | |
| </table> | |
| </td> | |
| <td style="width: 50%;" align="left" valign="top"> | |
| <table width="100%"> | |
| <tr> | |
| <td> | |
| <asp:Label ID="lblZone2" runat="server" Visible="false" Text="Zone2"></asp:Label> | |
| <telerik:RadDockZone runat="server" ID="RadDockZone2" Width="99%" MinHeight="100" | |
| Style="background: #d5f0fa; float: left;" Orientation="Vertical" FitDocks="true" | |
| Visible="false" BorderStyle="None"> | |
| </telerik:RadDockZone> | |
| </td> | |
| </tr> | |
| </table> | |
| </td> | |
| </tr> | |
| </table> | |
| </telerik:RadDockLayout> | |
| </td> | |
| </tr> | |
| <tr> | |
| <td colspan="2"> | |
| <asp:Label ID="lblMessage" runat="server"></asp:Label> | |
| </td> | |
| </tr> | |
| </table> | |
| </form> | |
| </body> | |
| </html> | |
| int i = 0; | |
| string dockState = ""; | |
| string strRegisteredZones = string.Empty; | |
| string strDockTag = string.Empty; | |
| string strZone = string.Empty; | |
| string strZoneName = string.Empty; | |
| string strDockTagName = string.Empty; | |
| string strResult = string.Empty; | |
| string strZoneControlID = string.Empty; | |
| int nLoggedInUserId = 1; | |
| int nPageId = 1; | |
| DockStateWS objDockStateWS; | |
| DataSet dsDataSet; | |
| List<DockState> stateList; | |
| StringBuilder serializedList = new StringBuilder(); | |
| ArrayList zones = new ArrayList(); | |
| protected void Page_InIt(object sender, EventArgs e) | |
| { | |
| try | |
| { | |
| cmbZone.DataBind(); | |
| BindDockZoneTableLayouts(); | |
| BindDashlets(); | |
| LoadDockState(); | |
| cmbZone.Enabled = true; | |
| cmbDashlets.Enabled = true; | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "Page_InIt"); | |
| } | |
| } | |
| protected void Page_Load(object sender, EventArgs e) | |
| { | |
| //LoadDockState(); | |
| } | |
| protected void btnSaveDock_Click(object sender, EventArgs e) | |
| { | |
| try | |
| { | |
| //--Save Dock states in Database | |
| System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); | |
| stateList = rdDockLayout.GetRegisteredDocksState(); | |
| while (i < stateList.Count) | |
| { | |
| serializedList.Append(serializer.Serialize(stateList[i])); | |
| serializedList.Append("|"); | |
| i++; | |
| } | |
| dockState = serializedList.ToString(); | |
| if (dockState.Trim() != String.Empty) | |
| { | |
| objDockStateWS = new DockStateWS(); | |
| dsDataSet = new DataSet(); | |
| dsDataSet = objDockStateWS.Insert_DashBoardState(0, nLoggedInUserId, dockState, nPageId); | |
| } | |
| //LoadDockState(); | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "btnSaveDock_Click"); | |
| } | |
| } | |
| protected void rdDockLayout_LoadDockLayout(object sender, DockLayoutEventArgs e) | |
| { | |
| bool bDocStateCreate = false; | |
| //--from database | |
| DataTable dt = new DataTable(); | |
| try | |
| { | |
| System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); | |
| //--use session | |
| foreach (DockState state in CurrentDockStates) | |
| { | |
| bDocStateCreate = true; | |
| e.Positions[state.UniqueName] = state.DockZoneID; | |
| e.Indices[state.UniqueName] = state.Index; | |
| } | |
| if (bDocStateCreate == false) | |
| { | |
| objDockStateWS = new DockStateWS(); | |
| dsDataSet = new DataSet(); | |
| dsDataSet = objDockStateWS.Fetch_DashBoardState(0, nLoggedInUserId, nPageId); | |
| if (dsDataSet.Tables["DockState"].Rows.Count > 0) | |
| { | |
| dockState = Convert.ToString(dsDataSet.Tables["DockState"].Rows[0]["dock_dashboard_state"]); | |
| string[] currentDockStates = dockState.Split('|'); | |
| foreach (string stringState in currentDockStates) | |
| { | |
| if (stringState.Trim() != string.Empty) | |
| { | |
| serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); | |
| DockState state = serializer.Deserialize<DockState>(stringState); | |
| RadDock dock = CreateRadDockFromState(state); | |
| rdDockLayout.Controls.Add(dock); | |
| LoadWidget(dock); | |
| } | |
| } | |
| } | |
| } | |
| //-- Get zones from Database | |
| objDockStateWS = new DockStateWS(); | |
| dsDataSet = new DataSet(); | |
| dsDataSet = objDockStateWS.Fetch_UserZoneSettings(0, nLoggedInUserId, nPageId); | |
| if (dsDataSet.Tables["Response"].Rows[0]["ResultCode"].ToString() != "0") | |
| { | |
| strResult = dsDataSet.Tables["Response"].Rows[0]["ResultString"].ToString(); | |
| LogMessage(new Exception(strResult), 1, "rdDockLayout_LoadDockLayout"); | |
| return; | |
| } | |
| else | |
| { | |
| if (dsDataSet.Tables["DockZoneSettings"].Rows.Count > 0) | |
| { | |
| for (int i = 0; i < dsDataSet.Tables["DockZoneSettings"].Rows.Count; i++) | |
| { | |
| string strDockZoneID = Convert.ToString(dsDataSet.Tables["DockZoneSettings"].Rows[i]["zone_setting_zones_name"]); | |
| int dockZoneDesignCode = Convert.ToInt32(dsDataSet.Tables["DockZoneSettings"].Rows[i]["zone_setting_table_layout_id"]); | |
| //-- Visible already registered Zones | |
| string[] strZones = strDockZoneID.Split(','); | |
| for (int j = 0; j < strZones.Length; j++) | |
| { | |
| RadDockZone dz = (RadDockZone)rdDockLayout.FindControl(strZones[j]); | |
| if (dz != null) | |
| { | |
| dz.Visible = true; | |
| } | |
| } | |
| //-- Disable registered zone design layput from cmbZoneLayouts | |
| cmbTableLayouts.FindItemByValue(Convert.ToString(dockZoneDesignCode)).Remove(); | |
| } | |
| } | |
| } | |
| cmbZone.Enabled = true; | |
| cmbDashlets.Enabled = true; | |
| if (cmbTableLayouts.Items.Count == 0) | |
| { | |
| trZoneLayout.Visible = false; | |
| } | |
| // } | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "rdDockLayout_LoadDockLayout"); | |
| } | |
| } | |
| protected void rdDockLayout_SaveDockLayout(object sender, DockLayoutEventArgs e) | |
| { | |
| CurrentDockStates = rdDockLayout.GetRegisteredDocksState(); | |
| } | |
| protected void btnAddDock_Click(object sender, EventArgs e) | |
| { | |
| try | |
| { | |
| UserControl uclDashlets = (UserControl)Page.LoadControl(Convert.ToString(cmbDashlets.SelectedValue)); | |
| strDockTag = Convert.ToString(cmbDashlets.SelectedValue); | |
| RadDock dock = CreateRadDock(); | |
| RadDockZone dz = (RadDockZone)rdDockLayout.FindControl(Convert.ToString(cmbZone.SelectedValue)); | |
| dz.Controls.Add(dock); | |
| dock.Tag = strDockTag; | |
| LoadWidget(dock); | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "btnAddDock_Click"); | |
| } | |
| } | |
| protected void btnAddZone_Click(object sender, EventArgs e) | |
| { | |
| try | |
| { | |
| if (cmbTableLayouts.SelectedValue == "1") //-- 1 Row 1 Column | |
| { | |
| RadDockZone3.Visible = true; | |
| lblZone3.Visible = true; | |
| strRegisteredZones = RadDockZone3.ID; | |
| } | |
| else //-- 1 Row 2 Column | |
| { | |
| RadDockZone1.Visible = true; | |
| RadDockZone2.Visible = true; | |
| lblZone1.Visible = true; | |
| lblZone2.Visible = true; | |
| strRegisteredZones = RadDockZone1.ID + "," + RadDockZone2.ID; | |
| } | |
| //--Save ZoneID and ZoneLayout in Database and remove selected item from cmbTableLayouts | |
| objDockStateWS = new DockStateWS(); | |
| dsDataSet = new DataSet(); | |
| dsDataSet = objDockStateWS.Insert_UserZoneSettings(0, Convert.ToInt32(cmbTableLayouts.SelectedValue), strRegisteredZones, nLoggedInUserId, nPageId, nLoggedInUserId); | |
| if (dsDataSet.Tables["Response"].Rows[0]["ResultCode"].ToString() != "0") | |
| { | |
| strResult = dsDataSet.Tables["Response"].Rows[0]["ResultString"].ToString(); | |
| LogMessage(new Exception(strResult), 1, "btnSaveDock_Click"); | |
| return; | |
| } | |
| cmbTableLayouts.SelectedItem.Remove(); | |
| cmbZone.Enabled = true; | |
| //cmbSelectDock.Enabled = true; | |
| cmbDashlets.Enabled = true; | |
| if (cmbTableLayouts.Items.Count == 0) | |
| { | |
| trZoneLayout.Visible = false; | |
| } | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "btnAddZone_Click"); | |
| } | |
| } | |
| public ArrayList GetZones() | |
| { | |
| ArrayList zones = new ArrayList(); | |
| zones.Add(RadDockZone1); | |
| zones.Add(RadDockZone2); | |
| zones.Add(RadDockZone3); | |
| return zones; | |
| } | |
| private List<DockState> CurrentDockStates | |
| { | |
| get | |
| { | |
| List<DockState> _currentDockStates = (List<DockState>)Session["CurrentDockStatesMyPortal"]; | |
| if (Object.Equals(_currentDockStates, null)) | |
| { | |
| _currentDockStates = new List<DockState>(); | |
| Session["CurrentDockStatesMyPortal"] = _currentDockStates; | |
| } | |
| return _currentDockStates; | |
| } | |
| set | |
| { | |
| Session["CurrentDockStatesMyPortal"] = value; | |
| } | |
| } | |
| private RadDock CreateRadDockFromState(DockState state) | |
| { | |
| RadDock dock = new RadDock(); | |
| dock.ID = string.Format("RadDock{0}", state.UniqueName); | |
| dock.ApplyState(state); | |
| dock.Command += new DockCommandEventHandler(dock_Command); | |
| dock.Commands.Add(new DockCloseCommand()); | |
| dock.CommandsAutoPostBack = true; // rt now commented | |
| return dock; | |
| } | |
| private RadDock CreateRadDock() | |
| { | |
| int docksCount = CurrentDockStates.Count; | |
| string strCount = System.DateTime.Now.Millisecond.ToString(); | |
| RadDock dock = new RadDock(); | |
| dock.AutoPostBack = true; | |
| //dock.Title = cmbSelectDock.SelectedItem.Text; | |
| dock.Title = Convert.ToString(cmbDashlets.SelectedItem.Text); | |
| dock.Text = string.Format("Added at {0}", DateTime.Now); | |
| dock.ID = string.Format("RadDock{0}", strCount); | |
| dock.UniqueName = string.Format("Dock {0}", strCount); | |
| //rt now added | |
| dock.Commands.Add(new DockCloseCommand()); | |
| dock.Commands.Add(new DockExpandCollapseCommand()); | |
| dock.Command += new DockCommandEventHandler(dock_Command); | |
| return dock; | |
| } | |
| private void BindDockZoneTableLayouts() | |
| { | |
| try | |
| { | |
| objDockStateWS = new DockStateWS(); | |
| dsDataSet = new DataSet(); | |
| dsDataSet = objDockStateWS.Fetch_DockZoneTableLayouts(0); | |
| cmbTableLayouts.DataSource = dsDataSet; | |
| cmbTableLayouts.DataTextField = "dock_zone_layout"; | |
| cmbTableLayouts.DataValueField = "dock_zone_layout_id"; | |
| cmbTableLayouts.DataBind(); | |
| cmbTableLayouts.Items.Insert(0, new RadComboBoxItem("Select", "")); | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "BindDockZoneTableLayouts"); | |
| } | |
| } | |
| private void BindDashlets() | |
| { | |
| try | |
| { | |
| objDockStateWS = new DockStateWS(); | |
| dsDataSet = new DataSet(); | |
| dsDataSet = objDockStateWS.Fetch_Dashlest(0); | |
| cmbDashlets.DataSource = dsDataSet; | |
| cmbDashlets.DataTextField = "dock_dashlets_name"; | |
| cmbDashlets.DataValueField = "dock_dashlects_value"; | |
| cmbDashlets.DataBind(); | |
| cmbDashlets.Items.Insert(0, new RadComboBoxItem("Select", "")); | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "BindDashlets"); | |
| } | |
| } | |
| private void LoadWidget(RadDock dock) | |
| { | |
| try | |
| { | |
| if (string.IsNullOrEmpty(dock.Tag)) | |
| { | |
| return; | |
| } | |
| else | |
| { | |
| Control widget = LoadControl(dock.Tag); | |
| dock.ContentContainer.Controls.Add(widget); | |
| } | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "LoadWidget"); | |
| } | |
| } | |
| private void LoadDockState() | |
| { | |
| for (int i = 0; i < CurrentDockStates.Count; i++) | |
| { | |
| if (CurrentDockStates[i].Closed == false) | |
| { | |
| RadDock dock = CreateRadDockFromState(CurrentDockStates[i]); | |
| rdDockLayout.Controls.Add(dock); | |
| RadDockZone dz = (RadDockZone)rdDockLayout.FindControl(Convert.ToString(dock.DockZoneID)); | |
| if (dz != null) | |
| { | |
| dz.Visible = true; | |
| } | |
| LoadWidget(dock); | |
| } | |
| } | |
| } | |
| void dock_Command(object sender, DockCommandEventArgs e) | |
| { | |
| try | |
| { | |
| if (e.Command.Name == "Close") | |
| { | |
| (((RadDock)sender)).Closed = true; | |
| } | |
| } | |
| catch (Exception ex) | |
| { | |
| LogMessage(ex, 1, "dock_Command"); | |
| } | |
| } | |
| void LogMessage(Exception e, Int32 param, string strMethodName) | |
| { | |
| if (param == 1) | |
| { | |
| lblMessage.Text = e.Message + " Method:- " + strMethodName; | |
| lblMessage.CssClass = "error"; | |
| } | |
| else | |
| { | |
| lblMessage.Text = e.Message; | |
| lblMessage.CssClass = "success"; | |
| } | |
| } | |
| } | |
| WebMethods | |
| [WebMethod] | |
| public DataSet Fetch_DockZoneTableLayouts(long nSessionId) | |
| { | |
| int nResultCode = -1; | |
| string strResult = "Fail - "; | |
| SqlDataAdapter m_SqlDataAdapter = null; | |
| DataTable m_DataTable = new DataTable("DockZoneTableLayouts"); | |
| string szColumns = string.Empty; | |
| string szTemp = string.Empty; | |
| string szFilter = string.Empty; | |
| m_DataSet = new DataSet(); | |
| strParameters = Convert.ToString(nSessionId); | |
| try | |
| { | |
| int nState = 1; | |
| if (nSessionId > 0) | |
| nState = GetSessionState(nSessionId); | |
| if (nState == 0) | |
| { | |
| nResultCode = -1; | |
| strResult = "Your session has been expired, Please relogin again.\n " + | |
| "Method : Fetch_DockZoneTableLayouts \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| else if (nState == 2) | |
| { | |
| nResultCode = -1; | |
| strResult = "Unable to get session state.\n " + | |
| "Method : Fetch_DockZoneTableLayouts \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_DockZoneTableLayouts", strParameters); | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_DockZoneTableLayouts", strParameters); | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| try | |
| { | |
| m_Connection.Openconnection(); | |
| strTemp = "SELECT dock_zone_layout_id,dock_zone_layout FROM CRM_DOCK_Zone_Table_Layouts"; | |
| m_SqlDataAdapter = new SqlDataAdapter(strTemp, m_Connection.oCon); | |
| m_SqlDataAdapter.Fill(m_DataTable); | |
| m_DataSet.Tables.Add(m_DataTable); | |
| nResultCode = 0; | |
| strResult = "Pass"; | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult + strResult, "Fetch_DockZoneTableLayouts", strParameters); | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_DockZoneTableLayouts", strParameters); | |
| } | |
| finally | |
| { | |
| m_Connection.Closeconnection(); | |
| } | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| [WebMethod] | |
| public DataSet Fetch_Dashlest(long nSessionId) | |
| { | |
| int nResultCode = -1; | |
| string strResult = "Fail - "; | |
| SqlDataAdapter m_SqlDataAdapter = null; | |
| DataTable m_DataTable = new DataTable("Dashlets"); | |
| string szColumns = string.Empty; | |
| string szTemp = string.Empty; | |
| string szFilter = string.Empty; | |
| m_DataSet = new DataSet(); | |
| strParameters = Convert.ToString(nSessionId); | |
| try | |
| { | |
| int nState = 1; | |
| if (nSessionId > 0) | |
| nState = GetSessionState(nSessionId); | |
| if (nState == 0) | |
| { | |
| nResultCode = -1; | |
| strResult = "Your session has been expired, Please relogin again.\n " + | |
| "Method : Fetch_Dashlest \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| else if (nState == 2) | |
| { | |
| nResultCode = -1; | |
| strResult = "Unable to get session state.\n " + | |
| "Method : Fetch_Dashlest \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_Dashlest", strParameters); | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_Dashlest", strParameters); | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| try | |
| { | |
| m_Connection.Openconnection(); | |
| strTemp = "SELECT dock_dashlects_value,dock_dashlets_name FROM CRM_DOCK_Dashlets"; | |
| m_SqlDataAdapter = new SqlDataAdapter(strTemp, m_Connection.oCon); | |
| m_SqlDataAdapter.Fill(m_DataTable); | |
| m_DataSet.Tables.Add(m_DataTable); | |
| nResultCode = 0; | |
| strResult = "Pass"; | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult + strResult, "Fetch_Dashlest", strParameters); | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_Dashlest", strParameters); | |
| } | |
| finally | |
| { | |
| m_Connection.Closeconnection(); | |
| } | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| [WebMethod] | |
| public DataSet Insert_UserZoneSettings(long nSessionId, int nTableLayoutId, string strZonesName, int nUserId, int nPageId, int nLoggedInUserId) | |
| { | |
| long nResultCode = -1; | |
| string strResult = "Fail - "; | |
| m_DataSet = new DataSet(); | |
| m_SqlCommand = new SqlCommand(); | |
| strParameters = nSessionId + "," + nTableLayoutId + "," + strZonesName + "," + nUserId + "," + nPageId + "," + nLoggedInUserId + "," + strIPAddress; | |
| try | |
| { | |
| int nState = 1; | |
| if (nSessionId > 0) | |
| nState = GetSessionState(nSessionId); | |
| if (nState == 0) | |
| { | |
| nResultCode = -1; | |
| strResult = "Your session has been expired, Please relogin again.\n " + | |
| "Method : Insert_UserZoneSettings \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| else if (nState == 2) | |
| { | |
| nResultCode = -1; | |
| strResult = "Unable to get session state.\n " + | |
| "Method : Insert_UserZoneSettings \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| try | |
| { | |
| m_Connection.Openconnection(); | |
| string strTemp = "INSERT INTO CRM_DOCK_User_Zone_Settings " + | |
| "(zone_setting_table_layout_id,zone_setting_zones_name,zone_setting_user_id, " + | |
| "zone_setting_page_id,zone_setting_created_by,zone_setting_created_date, " + | |
| "zone_setting_created_ip) " + | |
| "VALUES (" + nTableLayoutId + ",@strZonesName," + nUserId + "," + nPageId + "," + nLoggedInUserId + ",GetDate(),@strIPAddress) "; | |
| m_SqlCommand = new SqlCommand(strTemp, m_Connection.oCon); | |
| m_SqlCommand.Parameters.Add("@strZonesName", SqlDbType.VarChar).Value = strZonesName; | |
| m_SqlCommand.Parameters.Add("@strIPAddress", SqlDbType.VarChar).Value = strIPAddress; | |
| m_SqlCommand.ExecuteNonQuery(); | |
| nResultCode = 0; | |
| strResult = "Pass - "; | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Insert_UserZoneSettings", strParameters); | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Insert_UserZoneSettings", strParameters); | |
| } | |
| finally | |
| { | |
| m_Connection.Closeconnection(); | |
| } | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| [WebMethod] | |
| public DataSet Insert_DashBoardState(long nSessionId, int nLoggedInUserId, string strDockState, int nPageId) | |
| { | |
| long nResultCode = -1; | |
| string strResult = "Fail - "; | |
| int value = 0; | |
| string strTemp = ""; | |
| m_DataSet = new DataSet(); | |
| m_SqlCommand = new SqlCommand(); | |
| strParameters = nSessionId + "," + nLoggedInUserId; | |
| try | |
| { | |
| int nState = 1; | |
| if (nSessionId > 0) | |
| nState = GetSessionState(nSessionId); | |
| if (nState == 0) | |
| { | |
| nResultCode = -1; | |
| strResult = "Your session has been expired, Please relogin again.\n " + | |
| "Method : Insert_DashBoardState \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| else if (nState == 2) | |
| { | |
| nResultCode = -1; | |
| strResult = "Unable to get session state.\n " + | |
| "Method : Insert_DashBoardState \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| try | |
| { | |
| m_Connection.Openconnection(); | |
| //--Delete Exist DashBoard State | |
| strTemp = "DELETE FROM CRM_DOCK_DashBoard_State WHERE dock_dashboard_state_user_id =" + nLoggedInUserId + " AND dock_dashboard_state_page_id = " + nPageId; | |
| m_SqlCommand = new SqlCommand(strTemp, m_Connection.oCon); | |
| m_SqlCommand.ExecuteNonQuery(); | |
| //--Insert DashBoard State | |
| strTemp = "INSERT INTO CRM_DOCK_DashBoard_State " + | |
| "(dock_dashboard_state,dock_dashboard_state_user_id, dock_dashboard_state_page_id ," + | |
| "dock_dashboard_state_created_by,dock_dashboard_state_created_date,dock_dashboard_state_created_ip) " + | |
| "VALUES (@strDockState," + nLoggedInUserId + "," + nPageId + "," + nLoggedInUserId + ",GetDate(),@strIPAddress) "; | |
| m_SqlCommand = new SqlCommand(strTemp, m_Connection.oCon); | |
| m_SqlCommand.Parameters.Add("@strDockState", SqlDbType.VarChar).Value = strDockState; | |
| m_SqlCommand.Parameters.Add("@strIPAddress", SqlDbType.VarChar).Value = strIPAddress; | |
| value = Convert.ToInt32(m_SqlCommand.ExecuteScalar()); | |
| if (value > 0) | |
| { | |
| nResultCode = 0; | |
| strResult = "Pass - "; | |
| } | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Insert_DashBoardState", strParameters); | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Insert_DashBoardState", strParameters); | |
| } | |
| finally | |
| { | |
| m_Connection.Closeconnection(); | |
| } | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| [WebMethod] | |
| public DataSet Fetch_DashBoardState(long nSessionId, int nLoggedInUserId, int nPageId) | |
| { | |
| int nResultCode = -1; | |
| string strResult = "Fail - "; | |
| SqlDataAdapter m_SqlDataAdapter = null; | |
| DataTable m_DataTable = new DataTable("DockState"); | |
| string szColumns = string.Empty; | |
| string szTemp = string.Empty; | |
| string szFilter = string.Empty; | |
| m_DataSet = new DataSet(); | |
| strParameters = nSessionId + "," + nLoggedInUserId + "," + nPageId; | |
| try | |
| { | |
| int nState = 1; | |
| if (nSessionId > 0) | |
| nState = GetSessionState(nSessionId); | |
| if (nState == 0) | |
| { | |
| nResultCode = -1; | |
| strResult = "Your session has been expired, Please relogin again.\n " + | |
| "Method : Fetch_DashBoardState \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| else if (nState == 2) | |
| { | |
| nResultCode = -1; | |
| strResult = "Unable to get session state.\n " + | |
| "Method : Fetch_DashBoardState \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_DashBoardState", strParameters); | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_DashBoardState", strParameters); | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| try | |
| { | |
| m_Connection.Openconnection(); | |
| strTemp = "SELECT dock_dashboard_state, dock_dashboard_state_user_id, " + | |
| "dock_dashboard_state_created_by, dock_dashboard_state_created_date, " + | |
| "dock_dashboard_state_created_ip,dock_dashboard_state_page_id " + | |
| "FROM CRM_DOCK_DashBoard_State " + | |
| "WHERE dock_dashboard_state_user_id = " + nLoggedInUserId + " AND dock_dashboard_state_page_id =" + nPageId; | |
| m_SqlDataAdapter = new SqlDataAdapter(strTemp, m_Connection.oCon); | |
| m_SqlDataAdapter.Fill(m_DataTable); | |
| m_DataSet.Tables.Add(m_DataTable); | |
| nResultCode = 0; | |
| strResult = "Pass"; | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult + strResult, "Fetch_DashBoardState", strParameters); | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_DashBoardState", strParameters); | |
| } | |
| finally | |
| { | |
| m_Connection.Closeconnection(); | |
| } | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| [WebMethod] | |
| public DataSet Fetch_UserZoneSettings(long nSessionId, int nLoggedInUserID, int nPageId) | |
| { | |
| int nResultCode = -1; | |
| string strResult = "Fail - "; | |
| SqlDataAdapter m_SqlDataAdapter = null; | |
| DataTable m_DataTable = new DataTable("DockZoneSettings"); | |
| string szColumns = string.Empty; | |
| string szTemp = string.Empty; | |
| string szFilter = string.Empty; | |
| m_DataSet = new DataSet(); | |
| strParameters = nSessionId + "," + nLoggedInUserID + "," + nPageId; | |
| try | |
| { | |
| int nState = 1; | |
| if (nSessionId > 0) | |
| nState = GetSessionState(nSessionId); | |
| if (nState == 0) | |
| { | |
| nResultCode = -1; | |
| strResult = "Your session has been expired, Please relogin again.\n " + | |
| "Method : Fetch_UserZoneSettings \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| else if (nState == 2) | |
| { | |
| nResultCode = -1; | |
| strResult = "Unable to get session state.\n " + | |
| "Method : Fetch_UserZoneSettings \n" + | |
| "SessionID: " + nSessionId; | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_UserZoneSettings", strParameters); | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_UserZoneSettings", strParameters); | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| try | |
| { | |
| m_Connection.Openconnection(); | |
| strTemp = "SELECT zone_setting_table_layout_id,zone_setting_zones_name,zone_setting_user_id, " + | |
| "zone_setting_page_id,zone_setting_created_by,zone_setting_created_date,zone_setting_created_ip " + | |
| "FROM CRM_DOCK_User_Zone_Settings " + | |
| "WHERE zone_setting_user_id =" + nLoggedInUserID + " AND zone_setting_page_id=" + nPageId; | |
| m_SqlDataAdapter = new SqlDataAdapter(strTemp, m_Connection.oCon); | |
| m_SqlDataAdapter.Fill(m_DataTable); | |
| m_DataSet.Tables.Add(m_DataTable); | |
| nResultCode = 0; | |
| strResult = "Pass"; | |
| } | |
| catch (SqlException ex) | |
| { | |
| nResultCode = ex.Number; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult + strResult, "Fetch_UserZoneSettings", strParameters); | |
| } | |
| catch (Exception ex) | |
| { | |
| nResultCode = -1; | |
| strResult = ex.Message; | |
| LogMessage(strTemp + strResult, "Fetch_Zones_Settings", strParameters); | |
| } | |
| finally | |
| { | |
| m_Connection.Closeconnection(); | |
| } | |
| m_DataSet.Tables.Add(GetResponseTable(nResultCode, strResult)); | |
| return m_DataSet; | |
| } | |
| } | |
Dear sir,
I am creating a DashBoard, and its fully customizes.In that Im not using any update panel.
the problem is when I closed any dock its closed, but continously closed next dock its not possible.
before that I have to refrsh page then it works.same with save button . once save the state then after refreshing a page then we move / close dock.
I mean on any activity i m refreshing a page then its works..
I am sending you my code.plz help me [sry 4 poor english]
and plz answere in without using update panel
thanks with regards
<TBODY><TR>
<TD>
<DIV style="FILTER: null; BACKGROUND-COLOR: #6788be; HEIGHT: 14px; opacity: null" class=rfdRoundedOuter> </DIV></TD>
<TD>
<DIV style=
"BACKGROUND-IMAGE: none; BORDER-BOTTOM: #6788be 1px solid; FILTER: null; BACKGROUND-COLOR: #ffffff; HEIGHT: 14px; BORDER-TOP: #6788be 1px solid; opacity: null" class=rfdRoundedInner> </DIV></TD>
<TD>
<DIV style=
"BACKGROUND-IMAGE: none; BORDER-BOTTOM: #6788be 1px solid; FILTER: null; BACKGROUND-COLOR: #ffffff; HEIGHT: 16px; BORDER-TOP: #6788be 1px solid; opacity: null" class=rfdRoundedInner> </DIV></TD>
<TD style=
"FONT-SIZE: 1px"><INPUT style="BORDER-RIGHT-WIDTH: 0px; MARGIN: 0px; BORDER-LEFT-WIDTH: 0px" id=ctl00_ctl00_cphMain_cphInnerMain_txtUserName class=rfdInput name=ctl00$ctl00$cphMain$cphInnerMain$txtUserName></TD>
...
DataFormatString property. Unfortunately, after the DataBind() call, the RadGrid does not have any columns in the ColumnsCollection. It looks like this ColumnsCollection only contains the columns that are declared in the ASPX page. How to access the columns collection when they are auto-generated?
-Piyush
Hi Telerik Team,
How to make the RadSliding pane title bold.
<telerik:RadSlidingPane id="RadSlidingPane1" title="Pane1" runat="server"> </telerik:RadSlidingPane>
Help me to solve this issue.
Invoices uc = (Invoices)Page.LoadControl(userControlName);
uc.OrgId = CurOrgId;
uc.ID = e.PageView.ID +
"_userControl";
e.PageView.Controls.Clear();
//Not sure if this does anything but I added it anyway.
e.PageView.Controls.Add(uc);
uc.DataBind();
protected
void dgInvoice_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
string strSP = "GetInvoices";
System.Data.SqlClient.
SqlParameter[] spParams = new System.Data.SqlClient.SqlParameter[1];
spParams[0] =
new System.Data.SqlClient.SqlParameter("isActive", "1");
this.dgInvoice.DataSource = Database.getDataSet(strSP, spParams);
}
The control with the RadGrid functions perfectly when housed alone in an aspx page. But when we load the control dynamically into the RadMultiPage, the page displays fine...but clicking on anything that would fire a partial postback causes the entire RadGrid to disappear.
Any ideas?
Thanks in advance.
Vincent