|
<%@ 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; |
|
} |
|
} |
|
|
|
|