or
protected
void
Page_Load(
object
sender, EventArgs e)
{
UI ui = GetUI();
//if (!IsPostBack)
//{
// BindTvCaseType(ui);
//}
if
(Session[Common.userSession] ==
null
|| ((AdManager.UserInfo)Session[Common.userSession]).Status == AdManager.LoginStatus.Error)
Response.Redirect(
"default.aspx"
);
//UI ui = GetUI();
BindCmbSeverity(ui);
BindCmbCharacter(ui);
BindTvCaseType(ui);
BindTvCaseType(ui);
//This is where i bind the treeview
ui.tvType.ID =
"tvCaseType"
;
ui.labEmail.Text = (((AdManager.UserInfo)Session[Common.userSession]).Email);
if
((((AdManager.UserInfo)Session[Common.userSession]).Email) ==
""
)
{
ui.panEmailNotification.Visible =
false
;
}
ui.btnStep2.Attributes.Add(
"OnClick"
,
"checkStep1(); return false;"
);
ui.btnStep3.Attributes.Add(
"OnClick"
,
"checkStep2(); return false;"
);
}
private
void
BindTvCaseType(UI ui)
{
ui.tvType.Nodes.Clear();
dsHelpdeskG2TableAdapters.typesTableAdapter taCaseTypes =
new
dsHelpdeskG2TableAdapters.typesTableAdapter();
dsHelpdeskG2.typesDataTable dtCaseTypes = taCaseTypes.GetData();
ui.tvType.Nodes.AddRange(TreeviewBuilder.BuildRecursive(
null
, 0,
null
, dtCaseTypes,
null
));
}
public
static
List<RadTreeNode> BuildRecursive(dsHelpdeskG2.typesRow drNodeRow,
int
rowLevel, dsHelpdeskG2.permissionsDataTable dtPermissions, dsHelpdeskG2.typesDataTable dtTypes,
AdManager.UserInfo us)
{
List<RadTreeNode> nodeList =
new
List<RadTreeNode>();
if
(rowLevel > 5)
return
nodeList;
int
c_ty_id = 0;
if
(drNodeRow !=
null
)
c_ty_id = drNodeRow.ty_id;
var nodeTable = from c
in
dtTypes
where c.ty_parent_id == c_ty_id
orderby c.ty_id
select c;
foreach
(var nodeRow
in
nodeTable)
{
RadTreeNode node =
new
RadTreeNode();
node.Value = nodeRow.ty_id.ToString();
node.Text = nodeRow.ty_name;
node.Nodes.AddRange(BuildRecursive(nodeRow, rowLevel + 1, dtPermissions, dtTypes, us));
//node.ID = "tvTypeNode" + nodeRow.ty_id;
if
(node.Nodes.Count > 0)
{
//om den inte har childs
node.Checkable =
false
;
}
else
{
//har childs..
//node.ch
}
nodeList.Add(node);
}
return
nodeList;
}
protected
void
btnSendCase_Click(
object
sender, EventArgs e)
{
UI ui = GetUI();
dsHelpdeskG2TableAdapters.casesTableAdapter dtaCases =
new
dsHelpdeskG2TableAdapters.casesTableAdapter();
double
anstId = ((AdManager.UserInfo)Session[Common.userSession]).AnstId;
var temp = Request.Params;
int
caseTypeId =
int
.Parse(ui.tvType.CheckedNodes[0].Value);
//This is where i set a int value and trye to retreave the checked node.
int
caseSeverity =
int
.Parse(ui.cmbSeverity.SelectedValue);
int
caseCharacter =
int
.Parse(ui.cmbCharacter.SelectedValue);
string
userIP = Request.ServerVariables[
"REMOTE_ADDR"
];
string
userHostname = Request.ServerVariables[
"REMOTE_HOST"
];
string
caseHeader = ui.txtRubrik.Text;
bool
caseNotification;
if
(ui.rbEmailYes.Checked)
caseNotification =
true
;
else
caseNotification =
false
;
dtaCases.Insert(anstId,
null
, caseTypeId, caseSeverity, caseCharacter, DateTime.Now, userIP,
null
, caseHeader, 1, caseNotification,
null
,
null
, userHostname);
}
<
telerik:RadComboBox
ID
=
"cmbCaseType"
runat
=
"server"
Skin
=
"Windows7"
Height
=
"160px"
Style
=
"vertical-align: middle;"
Width
=
"225px"
>
<
ItemTemplate
>
<
div
id
=
"div1"
>
<
telerik:RadTreeView
ID
=
"tvCaseType"
runat
=
"server"
CheckBoxes
=
"True"
Height
=
"160px"
Width
=
"100%"
OnClientNodeChecked
=
"nodeClicking"
>
</
telerik:RadTreeView
>
</
div
>
</
ItemTemplate
>
<
Items
>
<
telerik:RadComboBoxItem
Text
=
""
/>
</
Items
>
<
CollapseAnimation
Type
=
"None"
/><
ExpandAnimation
Type
=
"None"
/>
</
telerik:RadComboBox
><
br
/>
<
asp:CustomValidator ID="CustomValidator1" runat="server" ClientValidationFunction="checkTypeTreeview" ErrorMessage="CustomValidator" Display="Dynamic" ValidationGroup="Step1">Vnligen ange En rendetyp</asp:CustomValidator
>
<br
/>
var
oldNode;
function
nodeClicking(sender, args)
{
var
comboBox = $find(
"ctl00_phContent_pbCaseRegistration_i0_i0_cmbCaseType"
);
var
node = args.get_node()
if
(oldNode !=
null
)
{
oldNode.set_checked(
false
);
}
node.set_checked(
true
);
oldNode = node;
comboBox.set_text(node.get_text());
comboBox.trackChanges();
comboBox.get_items().getItem(0).set_text(node.get_text());
comboBox.commitChanges();
comboBox.hideDropDown();
}
function
checkTypeTreeview(source, arguments)
{
var
treeView = document.getElementById(
"ctl00_phContent_pbCaseRegistration_i0_i0_cmbCaseType_i0_tvCaseType"
);
var
checkBoxes = treeView.getElementsByTagName(
"input"
);
var
checkedCount = 0;
for
(
var
i = 0; i < checkBoxes.length; i++)
{
if
(checkBoxes[i].checked)
{
checkedCount++;
}
}
if
(checkedCount > 0 && checkedCount < 2)
{
arguments.IsValid =
true
;
}
else
{
arguments.IsValid =
false
;
}
}
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowFilteringByColumn
=
"True"
AllowPaging
=
"True"
AllowSorting
=
"True"
GridLines
=
"None"
Skin
=
"WebBlue"
OnNeedDataSource
=
"RadGrid1_NeedDataSource"
OnDataBound
=
"RadGrid1_DataBound"
width
=
"100%"
AutoGenerateColumns
=
"False"
>
<
ExportSettings
ExportOnlyData
=
"True"
IgnorePaging
=
"true"
OpenInNewWindow
=
"true"
>
<
Excel
Format
=
"ExcelML"
/>
</
ExportSettings
>
<
ClientSettings
AllowColumnsReorder
=
"True"
ReorderColumnsOnClient
=
"True"
>
</
ClientSettings
>
<
MasterTableView
CommandItemDisplay
=
"Top"
PageSize
=
"10"
>
<
CommandItemSettings
>
</
CommandItemSettings
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridButtonColumn
CommandName
=
"Edit"
Text
=
"Edit"
UniqueName
=
"EditColumn"
ButtonType
=
"ImageButton"
></
telerik:GridButtonColumn
>
<
telerik:GridBoundColumn
DataField
=
"ID"
FilterControlWidth
=
"30px"
HeaderText
=
"Comment ID"
UniqueName
=
"ID"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CommentDate"
FilterControlWidth
=
"30px"
HeaderText
=
"Comment Date"
UniqueName
=
"column2"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Commentor"
HeaderText
=
"Commentor"
UniqueName
=
"column3"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Comment"
HeaderText
=
"Comment"
UniqueName
=
"column4"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"InsertDate"
FilterControlWidth
=
"30px"
HeaderText
=
"Insert Date"
UniqueName
=
"column5"
>
</
telerik:GridBoundColumn
>
</
Columns
>
<
CommandItemTemplate
>
<
a
href
=
"#"
onclick
=
"return ShowInsertForm();"
>Add New Comment</
a
>
<
asp:ImageButton
ID
=
"excelExport"
runat
=
"server"
ImageUrl
=
"~/images/ExportToExcel.gif"
CommandName
=
"ExportToExcel"
ImageAlign
=
"Right"
/>
</
CommandItemTemplate
>
<
EditFormSettings
EditFormType
=
"Template"
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
UniqueName
=
"editTemplate"
></
EditColumn
>
<
FormTemplate
>
<
table
id
=
"Table1"
cellspacing
=
"1"
cellpadding
=
"1"
border
=
"0"
class
=
"module"
>
<
tr
>
<
td
colspan
=
"2"
><
strong
>Update Comment:</
strong
>
</
td
>
</
tr
>
<
tr
>
<
td
>
ID:
</
td
>
<
td
>
<
asp:label
ID
=
"ID_TextBox"
runat
=
"server"
Text='<%# Bind("ID") %>'>
</
asp:label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Comment Date:
</
td
>
<
td
>
<
telerik:RadDatePicker
ID
=
"cmDate"
Runat
=
"server"
DateInput-EmptyMessage
=
"Select a Date"
Skin
=
"WebBlue"
SelectedDate='<%# Bind("CommentDate") %>' >
</
telerik:RadDatePicker
>
<
asp:RequiredFieldValidator
ID
=
"PickerRequiredFieldValidator"
runat
=
"server"
Display
=
"Dynamic"
ControlToValidate
=
"cmDate"
ErrorMessage
=
"Please select a date"
ForeColor
=
"Black"
Font-Bold
=
"True"
Font-Italic
=
"True"
/>
</
td
>
</
tr
>
<
tr
>
<
td
>
Comment:
</
td
>
<
td
>
<
asp:RequiredFieldValidator
ID
=
"TextBoxRequiredFieldValidator"
runat
=
"server"
Display
=
"Dynamic"
ControlToValidate
=
"txtComment"
ErrorMessage
=
"Must Enter Comment"
ForeColor
=
"Black"
Font-Bold
=
"True"
Font-Italic
=
"True"
/><
br
/>
<
telerik:RadEditor
ID
=
"txtComment"
runat
=
"server"
Skin
=
"WebBlue"
EnableResize
=
"False"
Width
=
"600px"
Height
=
"250px"
Content='<%# Bind("Comment")%>'>
<
CssFiles
>
<
telerik:EditorCssFile
value
=
"~Style/EditorContentArea.css"
/>
</
CssFiles
>
<
Tools
>
<
telerik:EditorToolGroup
Tag
=
"MainToolbar"
>
<
telerik:EditorTool
Name
=
"FindAndReplace"
/>
<
telerik:EditorSeparator
/>
<
telerik:EditorSplitButton
Name
=
"Undo"
>
</
telerik:EditorSplitButton
>
<
telerik:EditorSplitButton
Name
=
"Redo"
>
</
telerik:EditorSplitButton
>
<
telerik:EditorSeparator
/>
<
telerik:EditorTool
Name
=
"Cut"
/>
<
telerik:EditorTool
Name
=
"Copy"
/>
<
telerik:EditorTool
Name
=
"Paste"
ShortCut
=
"CTRL+V"
/>
</
telerik:EditorToolGroup
>
<
telerik:EditorToolGroup
Tag
=
"Formatting"
>
<
telerik:EditorTool
Name
=
"Bold"
/>
<
telerik:EditorTool
Name
=
"Italic"
/>
<
telerik:EditorTool
Name
=
"Underline"
/>
<
telerik:EditorSeparator
/>
<
telerik:EditorSplitButton
Name
=
"ForeColor"
>
</
telerik:EditorSplitButton
>
<
telerik:EditorSplitButton
Name
=
"BackColor"
>
</
telerik:EditorSplitButton
>
<
telerik:EditorSeparator
/>
<
telerik:EditorDropDown
Name
=
"FontName"
>
</
telerik:EditorDropDown
>
<
telerik:EditorDropDown
Name
=
"RealFontSize"
>
</
telerik:EditorDropDown
>
</
telerik:EditorToolGroup
>
</
Tools
>
<
Content
>
</
Content
>
</
telerik:RadEditor
>
</
td
>
</
tr
>
<
tr
>
<
td
align
=
"right"
colspan
=
"2"
>
<
asp:Button
ID
=
"btnUpdate"
Text='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "Insert", "Update") %>'
runat="server" CommandName='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "PerformInsert", "Update")%>' >
</
asp:Button
>
<
asp:Button
ID
=
"btnCancel"
Text
=
"Cancel"
runat
=
"server"
CausesValidation
=
"False"
CommandName
=
"Cancel"
></
asp:Button
>
</
td
>
</
tr
>
</
table
>
</
FormTemplate
>
</
EditFormSettings
>
</
MasterTableView
>
</
telerik:RadGrid
>
Private
Sub
RadGrid1_UpdateCommand(
ByVal
sender
As
Object
,
ByVal
e
As
Telerik.Web.UI.GridCommandEventArgs)
Handles
RadGrid1.UpdateCommand
'Get User's name
connSql.ConnectionString = sqlConn.ToString()
Dim
exSqlUser
As
New
SqlCommand(
"dbo.getUser"
, connSql)
exSqlUser.CommandType = CommandType.StoredProcedure
exSqlUser.Parameters.AddWithValue(
"@UID"
, user)
exSqlUser.Parameters.Add(
"@UserName"
, SqlDbType.VarChar, 40)
exSqlUser.Parameters(
"@UserName"
).Direction = ParameterDirection.Output
connSql.Open()
exSqlUser.ExecuteNonQuery()
connSql.Close()
Dim
username
As
String
= exSqlUser.Parameters(
"@UserName"
).Value.ToString()
'get Values and compare
Dim
gridediteditem
As
GridEditFormItem =
CType
(e.Item, GridEditFormItem)
Dim
newValues
As
Hashtable =
New
Hashtable
e.Item.OwnerTableView.ExtractValuesFromItem(newValues, gridediteditem)
'e.Item.OwnerTableView.ExtractValuesFromItem(oldValues, gridediteditem.SavedOldValues)
Dim
Comment
As
String
, CommentDate
As
DateTime, Updating
As
String
Dim
oldComment
As
String
= gridediteditem.SavedOldValues(
"Comment"
)
Dim
oldDate
As
DateTime = gridediteditem.SavedOldValues(
"CommentDate"
)
Dim
ID
As
Integer
If
newValues.Item(
"ID"
) =
Nothing
Then
ID =
""
Else
ID =
CInt
(newValues.Item(
"ID"
))
End
If
Dim
newCommentDate
As
DateTime
If
newValues.Item(
"CommentDate"
) =
Nothing
Then
newCommentDate =
""
Else
newCommentDate = newValues.Item(
"CommentDate"
).ToString()
End
If
Dim
newComment
As
String
If
newValues.Item(
"Comment"
) =
Nothing
Then
newComment =
""
Else
newComment = newValues.Item(
"Comment"
).ToString()
End
If
If
oldComment <> newComment
And
newComment <>
""
Then
Updating =
"Yes"
If
oldDate <> newCommentDate
Then
Comment = newComment &
"<br />Modified by "
& username &
" on "
& Today().ToString() &
"<br />"
&
"Date changed from: "
& oldDate &
" to: "
& newCommentDate &
" by "
& username &
" on "
& Today().ToString() &
"<br /><br />"
& oldComment
CommentDate = newCommentDate
Else
Comment = newComment &
"<br />Modified by "
& username &
" on "
& Today().ToString() & oldComment
End
If
Else
If
oldDate <> newCommentDate
Then
Updating =
"Yes"
CommentDate = newCommentDate
Comment =
"<br /> Date changed from: "
& oldDate &
" to: "
& newCommentDate &
" by "
& username &
" on "
& Today().ToString() &
"<br /><br />"
& oldComment
End
If
End
If
If
Updating =
"Yes"
Then
Dim
exSqlCom
As
New
SqlCommand(
"dbo.EditComment"
, connSql)
exSqlCom.CommandType = CommandType.StoredProcedure
exSqlCom.Parameters.AddWithValue(
"@ID"
, ID)
exSqlCom.Parameters.AddWithValue(
"@RapID"
, RadComboBox1.SelectedValue)
exSqlCom.Parameters.AddWithValue(
"@User"
, user)
exSqlCom.Parameters.AddWithValue(
"@CommentDate"
, CommentDate)
exSqlCom.Parameters.AddWithValue(
"@Comment"
, Comment)
exSqlCom.Parameters.Add(
"@ReturnValue"
, SqlDbType.Int)
exSqlCom.Parameters(
"@ReturnValue"
).Direction = ParameterDirection.Output
connSql.Open()
exSqlCom.ExecuteNonQuery()
connSql.Close()
End
If
End
Sub
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="ImageRotator.ascx.vb" Inherits="ImageRotator" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<
div
id
=
"scrollingImages"
>
<
telerik:RadRotator
ID
=
"RadRotator1"
runat
=
"server"
FrameDuration
=
"4000"
SlideShowAnimation-Duration
=
"1000"
Width
=
"100%"
ItemWidth
=
"100%"
Height
=
"400px"
PauseOnMouseOver
=
"true"
ItemHeight
=
"400px"
ScrollDirection
=
"Left"
>
<
Items
>
<
telerik:RadRotatorItem
ID
=
"item1"
runat
=
"server"
>
<
ItemTemplate
>
<
asp:Image
ID
=
"Image1"
runat
=
"server"
ImageUrl
=
"~/images/managedservices2.jpg"
/>
</
ItemTemplate
>
</
telerik:RadRotatorItem
>
<
telerik:RadRotatorItem
ID
=
"item2"
runat
=
"server"
>
<
ItemTemplate
>
<
asp:Image
ID
=
"Image2"
runat
=
"server"
ImageUrl
=
"~/images/managedservices2.jpg"
/>
</
ItemTemplate
>
</
telerik:RadRotatorItem
>
<
telerik:RadRotatorItem
ID
=
"item3"
runat
=
"server"
>
<
ItemTemplate
>
<
asp:Image
ID
=
"Image3"
runat
=
"server"
ImageUrl
=
"~/images/managedservices2.jpg"
/>
</
ItemTemplate
>
</
telerik:RadRotatorItem
>
</
Items
>
</
telerik:RadRotator
>
</
div
>
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="ImageRotator.ascx.vb" Inherits="ImageRotator" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<
div
id
=
"scrollingImages"
>
<
telerik:RadRotator
ID
=
"RadRotator1"
runat
=
"server"
FrameDuration
=
"4000"
WrapFrames
=
"true"
SlideShowAnimation-Duration
=
"1000"
Width
=
"100%"
ItemWidth
=
"100%"
Height
=
"400px"
PauseOnMouseOver
=
"true"
ItemHeight
=
"400px"
ScrollDirection
=
"Left"
>
<
Items
>
<
telerik:RadRotatorItem
ID
=
"item1"
runat
=
"server"
>
<
ItemTemplate
>
<
asp:Image
ID
=
"Image1"
runat
=
"server"
ImageUrl
=
"images/managedservices2.jpg"
/>
</
ItemTemplate
>
</
telerik:RadRotatorItem
>
<
telerik:RadRotatorItem
ID
=
"item2"
runat
=
"server"
>
<
ItemTemplate
>
<
asp:Image
ID
=
"Image2"
runat
=
"server"
ImageUrl
=
"images/managedservices2.jpg"
/>
</
ItemTemplate
>
</
telerik:RadRotatorItem
>
<
telerik:RadRotatorItem
ID
=
"item3"
runat
=
"server"
>
<
ItemTemplate
>
<
asp:Image
ID
=
"Image3"
runat
=
"server"
ImageUrl
=
"images/managedservices2.jpg"
/>
</
ItemTemplate
>
</
telerik:RadRotatorItem
>
</
Items
>
</
telerik:RadRotator
>
</
div
>