Questions on UI for ASP.NET AJAX Forum

110,808 questions

2 answers

147 views

[Solved] Editor SQL Data Type

Hello,

I want to know which the most suitable SQL server data type to store RadEditor's content.

Thanks in advance

Editor

answered on 23 Mar 2012

1 answer

130 views

Accessing items in edit form from outside the grid

I have a panel that is located outside of my radgrid and when I click a button in the panel I want to access a control in the edit form of the grid. Is this possible?

Grid

answered on 23 Mar 2012

4 answers

74 views

Unwanted solid line border appearing after upgrading from 2008.2.1001.35 to 2012.1.215.40

Hi,

I just upgraded from 2008.2.1001.35 to 2012.1.215.40 version of Telerik.Web.UI.dll and noticed that a new solid line border is appearing on my RadDock controls. Please see before and after screenshot attachments (I have crossed out some information to protect the privacy).

Note:
- I am running my app on IE7.
- The project has been upgraded from VS2008 to VS2010
- The driving force for the upgrade/update of the control is to resolve the encountered JavaScript error. Error was resolved after the upgrade.

Any idea why?

Cheers,
Midas

Dock

answered on 22 Mar 2012

7 answers

200 views

[Solved] RadGrid. FilterIcon wraps to next line. IE8 Compatibility mode

I have a Gridview which works fine on IE8. In IE8 Compatibility mode the Filter Icon wraps to next line. I have attached a snap shot of the issue. I researched previous posts and added below css style, which didn't work.
.Grid .rgFilterRow .RadPicker
{
float: left ;
}

Please help.

Below are CSS, Content and MaterPage.

CSS

html,

body

{

font-family: Verdana, Tahoma, sans-serif;

font-size: 8pt;

margin: 0;

padding: 0;

text-align:left;

background-color: #CDDCF7; /* EAF0FC DEE8FA D7E3F9 CDDCF7 205CCA change to the light blue later */

height: 100%;

width: 100%;

min-width: 800px;

}

h1

{

font-size: 18pt;

margin: 5px 3px 3px 3px;

}

h2

{

font-size: 14pt;

margin: 5px 3px 3px 3px;

}

h3

{

font-size: 12pt;

margin: 5px 3px 3px 3px;

}

h4

{

font-size: 11pt;

margin: 4px 2px 2px 2px;

}

input /* necessary for the text boxes */

{

font-family: Arial, Tahoma, sans-serif;

font-size: 100%;

background-color: #D3E8E8;

}

select /* necessary for the drop down lists */

{

font-family: Arial, Tahoma, sans-serif;

font-size: 100%;

}

/* fieldset styling */

fieldset

{

padding: 1em;

/*

padding-left: 1em;

padding-right: 1em;

padding-bottom: 1em;

*/

border : 0px solid #ccc;

background-color:#EAF0FC;

}

/* legend styling */

legend

{

font-weight: normal;

font-size: 11pt;

color: #002C76; /* #002C76; */

/*margin: 5px 3px 3px 3px;*/

border-bottom: solid 1px #002C76; /* #437BE1 */

width: 750px;

}

/* -------- Form Layout --------------------------- */

.formLayout

{

border: 0px solid #989898;

padding: 0px 0px ;

/* padding: 5px 5px ; */

background: #EAF0FC; /* #E3F0F0; #FBFDFD; #D3E8E8; #E5F1F4; #F7FBFB; */

/* border-left: 1px solid #87CEFA; */

/* border-right: 1px solid #87CEFA; */

width: 98%;

}

.formLayoutB

{

border: 0px solid #989898;

background: #CDDCF7; /* #E3F0F0; #FBFDFD; #D3E8E8; #E5F1F4; #F7FBFB; */

/* border: 1px solid #87CEFA; */

width: 100%;

border-bottom: solid 1px #6291E6;

}

.formLayoutC

{

border: 0px solid #989898;

background: #EAF0FC; /* #E3F0F0; #FBFDFD; #D3E8E8; #E5F1F4; #F7FBFB; */

/* border: 1px solid #87CEFA; */

width: 800px;

}

.formLayoutNote

{

background: #EAF0FC; /* #E3F0F0; #FBFDFD; #D3E8E8; #E5F1F4; #F7FBFB; */

}

.formLayoutB .label, .formLayoutB .labelTop

{

font-weight: normal;

text-align: right;

/* vertical-align: top; */

height: 10px;

/* border: .1em dotted black; */

padding-right: .5em;

color: #002C76;

}

.formLayout td

{

padding: 1px;

}

.formLayout .label, .formLayout .labelTop

{

font-weight: normal;

text-align: right;

/* vertical-align: top; */

height: 10px;

/* border: .1em dotted black; */

padding-right: .5em;

}

.formLayoutD td

{

padding: 1px;

}

.formLayoutD .label, .formLayout .labelTop

{

font-weight: normal;

text-align: right;

/* vertical-align: top; */

height: 10px;

/* border: .1em dotted black; */

padding-right: .5em;

}

.formLayoutD

{

border: 0px solid #989898;

padding: 0px 0px ;

/* padding: 5px 5px ; */

background: #EAF0FC; /* #E3F0F0; #FBFDFD; #D3E8E8; #E5F1F4; #F7FBFB; */

/* border-left: 1px solid #87CEFA; */

/* border-right: 1px solid #87CEFA; */

width: 100.5%;

}

.formLayoutE

{

border: 0px solid #989898;

padding: 0px 0px ;

/* padding: 5px 5px ; */

background: #EAF0FC; /* #E3F0F0; #FBFDFD; #D3E8E8; #E5F1F4; #F7FBFB; */

/* border-left: 1px solid #87CEFA; */

/* border-right: 1px solid #87CEFA; */

width: 100px;

}

.formLayout .label

{

/* vertical-align: top; */

}

.formLayout .labelTop

{

vertical-align: top;

}

.formButtons

{

padding: .5em 0em .5em 0em;

text-align: left;

}

.formButtonsLeft

{

padding: .5em 0em .5em 0em;

text-align: left;

}

.formButtonsRight

{

padding: .5em 0em .5em 0em;

text-align: right;

}

.formLayout .formButtons td

{

padding-top: 1em;

text-align: left;

}

.formColumn

{

float: left;

margin-right: 40px;

}

.leftPanelBarContainer

{

float: left;

width: 250px;

height:250px;

overflow: auto;

position:relative; /* Required to workaround IE rendering bug*/

}

.TimeOutCounter

{

Left: 130px;

top:90px;

POSITION: absolute;

font-weight:bold

}

/* ----------------------------------- */

#container

{

}

#header

{

width: 100%;

}

#menu

{

height: 25px;

}

#navigation

{

float: left;

width: 19%;

height: 500px;

}

#content

{

float: right;

width: 99%;

/*height: 500px; */

}

#footer

{

clear: both;

width: 100%;

}

/*********************** Master Page Styles *******************/

#wrapper

{

width: 100%;

margin: 0 auto;

text-align: left;

background-color: #CDDCF7;

/* Make footer sticks to the bottom */

min-height: 100%;

position: relative;

height: auto !important; /* IE6 compatibility for footer*/

height: 100%; /* IE6 compatibility for footer*/

}

/* Make footer sticks to the bottom */

#headerBody

{

padding-bottom: 30px;

}

.MasterTop

{

position: relative; /*background: #C0DEDD;*/ /*padding-bottom: .3em;*/

overflow: auto;

z-index: 3000; /*this is needed to enure the menu is always above everything else */

background: #E0E0E0; /*url(images/bgAccuroGradient.gif) top left repeat-y; */

}

.MasterTop a

{

font-weight: bold;

font-size: 98%;

color: white;

text-decoration: none;

}

.MasterTop a:hover

{

text-decoration: underline;

}

.MasterTop a:visited

{

}

.MasterTop .EnterpriseInfo

{

float: right;

color: #999999;

clear: both;

}

.MasterTop .UserInfo

{

float: right;

color: DarkBlue;

margin-top: 2em;

margin-right: .4em;

clear: both;

}

.MasterTop .Header

{

float: left;

vertical-align: bottom;

color: #999999;

font-weight: bold;

font-size: 2.2em;

padding-left: 1em;

padding-top: .6em;

}

.MasterTop .HeaderReg

{

display: inline;

color: #999999;

font-weight: bold;

font-size: 0.66em;

}

.MasterTop .SubHeader

{

float: right;

color: #999999;

font-weight: bold;

font-size: 1.6em;

}

.Logo

{

float: left;

background: url(images/MedAssets.gif);

background-repeat: no-repeat;

width: 135px;

height: 35px;

margin-top: .5em;

margin-left: .5em;

}

.BeveledRule

{

clear: both;

width: 100%;

height: 4px;

background: transparent url(images/bgBeveledBorder.gif) repeat-x;

}

.MasterTop .LinkGroup

{

margin-right: .4em;

float: right;

clear: both;

}

/***********************Start: MASTER MENU *******************/

.MasterMenu

{

/* background-color: #cccccc;*/

font-weight: bold;

font-size: 100%;

left: 0em;

top: 0em;

position: relative; /* padding: 2em 0 0 0 ; */

vertical-align: bottom;

z-index: 2000; /*this is needed to enure the menu is always above everything else */

}

.MasterMenu table

{

background-color: #cccccc;

}

.MasterMenu table tr td a

{

color: Black;

background-color: #cccccc;

}

.MasterMenu table tr:hover td:hover a:hover

{

background: #7795BD;

color: White;

}

.MasterMenu table tr td

{

/* width: 6.0em; */

}

/*********************** MASTER Content *******************/

.MasterContent

{

margin: .5em;

width: 95%; /* margin-left: 1em; */ /* padding: .5em; */

width: auto;

/*min-height: 700px; */ /* QQ Does not seem to be needed */

}

.MasterNestedContent

{

margin: 1em;

}

.MasterFooter

{

clear: both;

position: relative;

text-align: center;

color: #777777;

font-weight: normal;

font-size: 70%;

margin-top: 2em;

margin-bottom: 1em;

padding-top: .5em;

border-top: solid 1px black;

}

/************************ Grid ****************************/

.Grid

{

font-size: .9em;

border: solid 1px #7f7f7f;

width: 99%;

}

.GridHeader th

{

/* background: url(../../images/sprite.png) repeat-x 0px 0px; color: #000; */

background: #328AA4 url(images/grid_tr_back.gif) repeat-x;

color: #FFFFFF;

border-color: #989898 #cbcbcb #989898 #989898;

border-style: solid solid solid none;

border-width: 1px 1px 1px medium;

padding: 4px 5px 4px 10px;

text-align: left;

vertical-align: bottom;

}

.GridHeader th a

{

text-decoration: none;

display: block;

padding-right: 0px;

color: #FFFFFF;

}

.GridHeader .sortAsc a

{

background: url(images/sort-up.png) no-repeat right 90%;

}

.GridHeader .sortDesc a

{

background: url(images/sort-down.png) no-repeat right 90%;

}

.Grid td

{

padding: 4px 10px 4px 10px;

border-right: solid 1px #cbcbcb;

}

.Grid .GridAltDataRow

{

background-color: #E5F1F4; /* #edf5ff; /* #CFECEC;*/

}

/* mouseover row style */

.Grid .GridRowOver

{

background-color: #b2d2ff;

}

/* select row style */

.Grid .GridRowSelected

{

background-color: #FFFFCC;

font-weight: bold;

}

/** hack for DE6570 **/

/** GridClientSelectColumn in a RadGrid and set it to allow scroll, it will get a scroll bar for the outer body**/

/**This behavior comes from the way checkboxes are decorated. display:block css is needed to fix checkbox styling **/

.Grid input.rfdRealInput

{

display:block;

position: static !important;

float: right;

outline: 0;

width: 0;

height: 0;

margin-top: -5px;

FILTER: alpha(opacity=0);

-moz-opacity: 0;

opacity: 0;

}

.Grid .rgFilterRow .RadPicker

{

float: left ;

display: -moz-inline-stack;

}

.BenefitGrid

{

font-size: .8em;

border: solid 1px #7f7f7f;

width: 99%;

}

.BenefitGridHeader th

{

/* background: url(../../images/sprite.png) repeat-x 0px 0px; color: #000; */

background: #328AA4 url(images/grid_tr_back.gif) repeat-x;

color: #FFFFFF;

border-color: #989898 #cbcbcb #989898 #989898;

border-style: solid solid solid none;

border-width: 1px 1px 1px medium;

padding: 4px 5px 4px 10px;

text-align: left;

vertical-align: bottom;

}

.BenefitGridHeader th a

{

text-decoration: none;

display: block;

padding-right: 0px;

color: #FFFFFF;

}

.BenefitGridHeader .sortAsc a

{

background: url(images/sort-up.png) no-repeat right 90%;

}

.BenefitGridHeader .sortDesc a

{

background: url(images/sort-down.png) no-repeat right 90%;

}

.BenefitGrid td

{

padding: 4px 10px 4px 10px;

border-right: solid 1px #cbcbcb;

}

.BenefitGrid .GridAltDataRow

{

background-color: #E5F1F4; /* #edf5ff; /* #CFECEC;*/

}

/* mouseover row style */

.BenefitGrid .GridRowOver

{

background-color: #b2d2ff;

}

/* select row style */

.BenefitGrid .GridRowSelected

{

background-color: #FFFFCC;

font-weight: bold;

}

/****************************************************************

ValidationSummary

****************************************************************/

.validationSummary

{

display: block;

border: 1px solid;

height: 20px;

margin: 0px 0px 5px 0px;

font-weight: bold;

color: #D8000C;

background-color: #FFBABA;

background-image: url(images/error.png);

background-repeat: no-repeat;

background-position: .7em .5em;

padding: 1em 0em 1em 4em;

}

.validationSummary img

{

border: none;

}

/****************************************************************

MessageBox Panel

****************************************************************/

.msgInfo, .msgSuccess, .msgWarning, .msgError, .msgValidation

{

display: block;

border: 1px solid;

/* margin: 10px 0px; */

font-weight: bold;

background-repeat: no-repeat;

background-position: 5px 3px;

}

.msgInfo

{

color: #00529B;

background-color: #BDE5F8;

background-image: url(images/information.png);

}

.msgSuccess

{

color: #4F8A10;

background-color: #DFF2BF;

background-image: url(images/checkmark.png);

}

.msgWarning

{

color: #9F6000;

background-color: #FEEFB3;

background-image: url(images/warning.png);

}

.msgError

{

color: #D8000C;

background-color: #FFBABA;

background-image: url(images/error.png);

}

.msgInfo p, .msgSuccess p, .msgWarning p, .msgError p

{

padding: 0px 35px;

margin: .8em 0

}

.msgInfo a, .msgSuccess a, .msgWarning a, .msgError a

{

cursor: pointer;

}

.msgContainer img

{

border: none;

}

/****************************************************/

.LoginStatus a

{

padding-right: 2px;

vertical-align: text-bottom;

font-weight: normal;

}

/*******************************************************/

.modalBackground, #progressBackgroundFilter

{

position:absolute;

top: 0px;

bottom: 0px;

left: 0px;

right: 0px;

overflow: hidden;

padding: 0;

margin: 0;

background-color: #D8D8D8;

filter: alpha(opacity=50);

opacity: 0.5;

z-index: 1000;

}

#processMessage

{

position: absolute;

top: 30%;

left: 43%;

padding: 1em;

width: 7em;

height: 1em;

z-index: 1001;

background-color: #fff;

background: #fff url(images/loading.gif) 95% 80% no-repeat;

border: 1px solid black

}

.ModalPopupX

{

border: solid 1px #c0c0c0;

background: #f0f0f0;

padding: 10px;

position: absolute;

top: -1000px;

}

.ModalPopup

{

padding: 2px;

background: #00529B;

border: solid 1px black;

}

.ModalPopupHeader

{

padding: 2px;

cursor: move;

width: 100%;

}

.ModalPopupHeaderTitle

{

font-size: 12pt;

font-weight: bold;

width: 100%;

}

.ModalPopupHeaderCancel

{

text-align: right;

cursor: pointer;

/*

background-image: url(images/cancel.gif);

background-repeat: no-repeat;

border: 1px solid black;

*/

}

/***

.ModalPopup th

{

background: #328AA4 url(images/grid_tr_back.gif) repeat-x;

font-size: 120%;

color: White;

font-weight: bold;

}

*/

.tabStrip

{

font-size: 4pt;

}

div.RadListBox .rlbText{

white-space: nowrap;

font: 10px;

}

div.RadListBox {

width: 250px;

}

div.RadTabStripVertical .rtsLink

{

text-align:left;

}

.HeaderTitle

{

font-size: 11pt;

color: #002C76;

/*margin: 5px 3px 3px 3px;*/

}

.HeaderSubTitle

{

font-weight: bold;

font-size: 10pt;

/* margin: 5px 3px 3px 3px; */

}

.verticalMenu

{

border-style: none;

width: 200px;

}

.rtsSelected

{

background: transparent !important;

border-left: solid 1px Gray !important;

border-top: solid 1px Gray !important;

border-right: solid 1px Gray !important;

}

.rtsSelected .rtsOut

{

background: transparent !important;

}

.rtsSelected .rtsIn

{

background: transparent !important;

}

.rtsSelected .rtsTxt

{

background: transparent !important;

}

div.RadTabStripVertical .verticalTab

{

border-right: solid 1px Gray !important;

}

div.RadTabStripVertical .verticalTabSelected

{

background: transparent !important;

border-left: solid 1px Gray !important;

border-top: solid 1px Gray !important;

border-right: none 0px Gray !important;

}

.formLayoutLogin

{

border: 0px solid #989898;

padding: 0px 0px;

/* padding: 5px 5px ; */

/* background: #EAF0FC; *//* #E3F0F0; #FBFDFD; #D3E8E8; #E5F1F4; #F7FBFB; */

/* border-left: 1px solid #87CEFA; */

/* border-right: 1px solid #87CEFA; */

background: #CDDCF7; /* #B7C8F6; *//* for non-css3 browsers */

width: 100%;

height: 100%;

}

.formPadding

{

padding-top: 40px;

padding-left: 20px;

}

.tableTitle

{

font-size: 12pt;

font-weight:bold;

}

.tableLabel

{

font-Size: 10pt;

font-family:Verdana, Tahoma, sans-serif;

font-weight:normal;

}

.tableInput

{

font-family:Verdana,Arial;

font-size:8pt;

}

html body form .RadInput

{

Font-Size: 8pt;

font-family: Verdana, Tahoma, sans-serif;

font-weight: normal;

}

.tableAnnouncement

{

font-size: 14pt;

}

.failureNotification

{

color: Red;

}

/* Brandzone Header styles start here */

#brandzoneHeader .topBar{

height:18px;

border-bottom:#0b4988 1px solid;

background-color:#dfe9f7;

font-family:Tahoma, Geneva, Arial, Helvetica, sans-serif;

font-size:80%;

}

#brandzoneHeader .topBar .welcomeMsg{

margin:4px 0 0 10px;

float:left;

}

#brandzoneHeader .topBar .facilityInfo{

float:right;

margin:4px 45px 0 0;

}

#brandzoneHeader .topBar .facilityInfo a{

text-decoration:underline;

font-weight:bold;

color:#144884;

}

#brandzoneHeader .topBar .topLinks{

float:right;

margin:5px 0 0 0;

}

#brandzoneHeader .topBar .topLinks img{

margin:0 16px 0 0;

border:0;

}

#brandzoneHeader .bannerContainer{

background:url(brandZoneImages/bannerBack.gif) repeat-x;

height:47px;

}

#brandzoneHeader .banner{

background:url(brandZoneImages/productName.jpg) no-repeat;

height:46px;

/*border-bottom:#0b4988 1px solid;*/

}

#brandzoneHeader .banner .logo{

background:url(brandZoneImages/logo.png) no-repeat;

float:right;

width:110px;

height:46px;

margin-right:22px;

}

/* Brandzone Footer styles start here */

#brandzoneFooter .footer{

background:url(brandZoneImages/bottomShadow.gif) 0 0 repeat-x #dfe9f7;

padding:10px 0px 5px 0px;

color:#144884;

font-size:100%;

text-align:right;

line-height:15px;

font-family:Tahoma, Geneva, Arial, Helvetica, sans-serif;

/* Stick footer to bottom */

height: 30px;

position:absolute;

bottom:0px;

width:100%;

}

#brandzoneFooter .footer a{

color:#144884;

text-decoration:none;

}

#brandzoneFooter .footer a:hover{

color:#144884;

text-decoration:underline;

}

/***************Main menu styles starts here***************/

#mainMenu {

MARGIN: 0 0 0 10px;

float:left;

padding:0px;

height:19px;

background:url(brandZoneImages/topNavBack.gif) repeat-x;

margin-top:27px;

}

#mainMenu UL {

PADDING: 0px; MARGIN: 0px; WHITE-SPACE: nowrap; LIST-STYLE-TYPE: none; TEXT-ALIGN: left; DISPLAY: inline;

}

#mainMenu LI {

PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; DISPLAY: inline

}

#mainMenu UL UL {

LEFT: -9999px; POSITION: absolute; margin:0px; padding:0px;

}

#mainMenu UL.level1 {

MARGIN: 0;

}

#mainMenu UL.level2{

margin-left:-2px;

}

#mainMenu UL.level2, #mainMenu UL.level3, #mainMenu UL.level4{

background:url(brandZoneImages/topSubNavBack.gif);

margin-top:0px;

border:#304682 1px solid;

margin-top:1px;

}

#mainMenu UL.level2 li a, #mainMenu UL.level3 li a, #mainMenu UL.level4 li a{

font-weight:normal;

color: #304682;

margin-top:0px;

padding:0 15px 1px 10px;

}

#mainMenu UL.level1 LI.level1-li {

DISPLAY: block; FLOAT: left; POSITION: relative;

border-right:#a4bad8 1px solid;

border-left:#FFFFFF 1px solid;

margin-top:1px;

}

#mainMenu li.level1-li-selected {

background: #FFFFFF;

border-top:#165790 1px solid;

border-right:#165790 1px solid;

border-left:#165790 1px solid;

text-decoration:none;

DISPLAY: block; FLOAT: left; POSITION: relative;

padding:0 0 2px 0;

margin-top:-1px;

}

#mainMenu .level1-li-selected > a{

font-size:75%;

font-family:Tahoma;

font-weight:bold;

color:#165790;

text-decoration:none;

}

#mainMenu A {

PADDING-RIGHT: 25px; DISPLAY: block; PADDING-LEFT: 15px; PADDING-BOTTOM: 0px; FONT: 11px/25px Tahoma,arial,sans-serif; font-weight:bold;

color:#501d47; PADDING-TOP: 0px; TEXT-DECORATION: none; line-height:18px;

}

#mainMenu UL.level1 LI.level1-li A.level1-a {

FLOAT: left

}

#mainMenu UL LI:hover > UL {

LEFT: 0px; VISIBILITY: visible; TOP: 18px

}

#mainMenu UL UL LI:hover > UL {

MARGIN-TOP: -20px; LEFT: 100%; VISIBILITY: visible; TOP: auto

}

#mainMenu LI.left:hover > UL {

RIGHT: 0px; LEFT: auto; VISIBILITY: visible; TOP: 18px

}

#mainMenu LI.left UL LI:hover > UL {

MARGIN-TOP: -20px; RIGHT: 100%; LEFT: auto; VISIBILITY: visible; TOP: auto

}

#mainMenu A:hover UL {

LEFT: 0px; TOP: 18px

}

#mainMenu LI.left A:hover UL {

RIGHT: -1px; LEFT: auto; TOP: 18px

}

#mainMenu LI.left UL A {

PADDING-RIGHT: 10px; PADDING-LEFT: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; TEXT-ALIGN: right

}

#mainMenu A:hover A:hover UL {

LEFT: 100%; VISIBILITY: visible

}

#mainMenu A:hover A:hover A:hover UL {

LEFT: 100%; VISIBILITY: visible

}

#mainMenu LI.left A:hover A:hover UL {

RIGHT: 0px; LEFT: auto; VISIBILITY: visible

}

#mainMenu LI.left A:hover A:hover A:hover UL {

RIGHT: 0px; LEFT: auto; VISIBILITY: visible

}

#mainMenu A:hover UL UL {

LEFT: -9999px

}

#mainMenu A:hover A:hover UL UL {

LEFT: -9999px

}

#mainMenu LI.left A:hover UL UL {

LEFT: -9999px

}

#mainMenu LI.left A:hover A:hover UL UL {

LEFT: -9999px

}

#mainMenu LI A.drop {

BACKGROUND: url(brandZoneImages/white-down.gif) no-repeat right center

}

#mainMenu LI A.fly {

BACKGROUND: url(brandZoneImages/white-right.gif) no-repeat right center

}

#mainMenu LI.left UL A.fly {

BACKGROUND: url(brandZoneImages/white-left.gif) no-repeat left center

}

#mainMenu LI A:hover {

text-decoration:none; DIRECTION: ltr

}

#mainMenu LI A.fly:hover {

text-decoration:none; DIRECTION: ltr

}

#mainMenu LI:hover > A {

text-decoration:none

}

#mainMenu UL LI:hover > A.fly {

text-decoration:none

}

#mainMenu TABLE {

MARGIN-TOP: -4px; LEFT: 0px; WIDTH: 0px; POSITION: absolute; BORDER-COLLAPSE: collapse; HEIGHT: 0px

}

#mainMenu TABLE TABLE {

MARGIN-TOP: -29px; LEFT: 99%; WIDTH: 0px; POSITION: absolute; BORDER-COLLAPSE: collapse; HEIGHT: 0px

}

#mainMenu LI.left TABLE {

MARGIN-TOP: -4px; RIGHT: 0px; LEFT: auto; WIDTH: 0px; POSITION: absolute; BORDER-COLLAPSE: collapse; HEIGHT: 0px

}

#mainMenu LI.left TABLE TABLE {

MARGIN-TOP: -29px; RIGHT: 100%; LEFT: auto; WIDTH: 0px; POSITION: absolute; BORDER-COLLAPSE: collapse; HEIGHT: 0px

}

/***************Main menu styles ends here***************/

.RadListBox li.rlbItem, .RadListBox li.rlbSelected, .RadListBox span.rlbText

{

padding:0 0 0 1;

line-height:12px;

}

.RadListBox span.rlbText

{

padding:0 0 0 1;

line-height:12px;

}

.RadTreeView {

line-height: 16px;

}

.RadTreeView .rtSp {

height: 14px;

}

.RadTreeView .rtHover .rtIn,

.RadTreeView .rtSelected .rtIn {

padding: 0px 1px 0px;

}

.RadTreeView .rtIn {

padding: 1px 2px 1px;

}

Content Page

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="True"

CodeBehind="Worklist.aspx.cs" Inherits="MedAssets.AMS.Web.Worklist" MaintainScrollPositionOnPostback="true" %>

<%@ Register TagPrefix="ams" Namespace="MedAssets.AMS.Web.Controls" Assembly="MedAssets.AMS.Web" %>

<%@ Register TagPrefix="uc" TagName="UsersComboBox" Src="~/Admin/WorkDistribution/UsersComboBox.ascx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="cph1" runat="server">

<telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="grdAccountsA">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="grdAccountsA" LoadingPanelID="lp1" />

<telerik:AjaxUpdatedControl ControlID="RadToolTipManager1" />

<telerik:AjaxUpdatedControl ControlID="lblWorklist" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="btnSearch">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="pnlMain" LoadingPanelID="lp1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadToolTipManager1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="grdAccountsA" LoadingPanelID="lp1" />

<telerik:AjaxUpdatedControl ControlID="RadToolTipManager1" LoadingPanelID="lp1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="WorkListToolBar">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="pnlMain" LoadingPanelID="lp1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="pnlCaseAssignmentToolBar">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="pnlMain" LoadingPanelID="lp1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="pnlAccountOverride">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="pnlMain" LoadingPanelID="lp1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadAjaxManager1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="pnlMain" LoadingPanelID="lp1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManagerProxy>

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript">

function RowDblClick(sender, args) {

sender.get_masterTableView().fireCommand("RowDblClickServer", args.get_itemIndexHierarchical());

}

</script>

<script type="text/javascript">

Telerik.Web.UI.RadToolTip.prototype._oldResetAutoCloseDelay = Telerik.Web.UI.RadToolTip.prototype._resetAutoCloseDelay;

Telerik.Web.UI.RadToolTip.prototype._resetAutoCloseDelay = function () {

this.cancelAutoCloseDelay();

if (this.get_leaveTargetAndToolTip()) return;

this.oldResetAutoCloseDelay();

};

</script>

<script type="text/javascript">

var column = null;

var item = null;

function MenuShowing(sender, args) {

if (column == null) return;

var menu = sender; var items = menu.get_items();

if (column.get_dataType() == "System.String") {

var i = 0;

while (i < items.get_count()) {

if (!(items.getItem(i).get_value() in { 'NoFilter': '', 'Contains': '', 'NotEqualTo': '', 'EqualTo': '', 'StartsWith': '' })) {

item = items.getItem(i);

if (item != null)

item.set_visible(false);

}

else {

item = items.getItem(i);

if (item != null)

item.set_visible(true);

} i++;

}

if (column.get_dataType() == "System.DateTime") {

var j = 0; while (j < items.get_count()) {

if (!(items.getItem(j).get_value() in { 'NoFilter': '', 'EqualTo': '', 'GreaterThan': '', 'LessThan': '' })) {

item = items.getItem(j); if (item != null)

item.set_visible(false);

}

else { item = items.getItem(j); if (item != null) item.set_visible(true); } j++;

}

column = null;

}

function filterMenuShowing(sender, eventArgs) {

column = eventArgs.get_column();

}

function OnClientClose(oWnd, args) {

//get the transferred arguments

var hasArgs = args.get_argument();

if (hasArgs) {

var popuptype = hasArgs.action;

if (popuptype == "save") {

$find("<%= RadAjaxManager.GetCurrent(Page).ClientID %>").ajaxRequest("overrideSelected");

}

else if (popuptype == "saveAll") {

$find("<%= RadAjaxManager.GetCurrent(Page).ClientID %>").ajaxRequest("overrideAll");

}

</script>

</telerik:RadCodeBlock>

<div class="formLayoutD">

<div style='padding: 5px 5px 5px 5px;'>

<asp:Panel ID="pnlMain" runat="server" Height="99%" Width="100%">

<table style="height: 100%">

<tr valign="top">

<td>

<asp:Panel runat="server" ID="pnlCaseAssignmentToolBar" Visible="false">

<h3>

Permanent Worklist Reassignment</h3>

<table style="width: 100%;">

<tr>

<td colspan="3">

<asp:ValidationSummary ID="ValidationSummary1" runat="server" DisplayMode="BulletList"

CssClass="validationSummary" ShowSummary="true" ValidationGroup="CaseReassignment" />

</td>

</tr>

<tr>

<td width="10%">

Assigned To:

</td>

<td width="22%">

<uc:UsersComboBox ID="ddlFromQueue" runat="server" Enabled="true" OnUserInfoSelected="ddlFromQueue_UserInfoSelected" />

</td>

<td>

<asp:RequiredFieldValidator ID="valFromQueue" runat="server" ControlToValidate="ddlFromQueue"

ValidationGroup="CaseReassignment" SetFocusOnError="true" Display="Dynamic" Text="Assigned To User/userGroup is required" />

</td>

</tr>

<tr>

<td>

Reassign To:

</td>

<td>

<uc:UsersComboBox ID="ddlToQueue" runat="server" Enabled="false" />

</td>

<td>

<asp:RequiredFieldValidator ID="valToQueue" runat="server" ControlToValidate="ddlToQueue"

ValidationGroup="CaseReassignment" SetFocusOnError="true" Text="*" ErrorMessage="Reassign To is required"

Display="Dynamic" />

<asp:CustomValidator ID="valToQueueIsNotFromQueue" runat="server" ControlToValidate="ddlToQueue"

OnServerValidate="CustomValidationToQueueIsNotFromQueue" ValidationGroup="CaseReassignment"

ErrorMessage="Reassign To cannot be the same as Assigned To" SetFocusOnError="true"

Text="*" Display="Dynamic" />

</td>

</tr>

<tr>

<td colspan="2">

<asp:Button runat="server" ID="btnAssign" Text="Assign Accounts" ValidationGroup="CaseReassignment"

OnClick="btnAssign_Click" Enabled="false" />

</td>

</tr>

<tr>

<td>

<asp:CustomValidator ID="valSelectAccounts" runat="server" ControlToValidate="ddlToQueue"

ValidationGroup="CaseReassignment" OnServerValidate="valSelectAccounts_ServerValidate"

ErrorMessage="Select Accounts to be reassigned from the grid" Text="*" Display="Dynamic" />

</td>

</tr>

</table>

</asp:Panel>

<asp:Panel runat="server" ID="pnlAccountOverride" Visible="false">

<h3>

Account Override</h3>

<table style="width: 100%;">

<tr>

<td colspan="3">

<asp:ValidationSummary ID="ValidationSummary2" runat="server" DisplayMode="BulletList"

CssClass="validationSummary" ShowSummary="true" ValidationGroup="AccountOverride" />

</td>

</tr>

<tr>

<td colspan="3">

<ams:MessageBox ID="msgBox" runat="server" EnableViewState="false" />

</td>

</tr>

<tr>

<td width="10%">

Assigned To:

</td>

<td width="22%">

<uc:UsersComboBox ID="ddlAccountOverrideQueue" runat="server" Enabled="true" OnUserInfoSelected="ddlAccountOverrideQueue_UserInfoSelected" />

</td>

<td>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="ddlAccountOverrideQueue"

ValidationGroup="AccountOverride" SetFocusOnError="true" Display="Dynamic" Text="Assigned To User/userGroup is required" />

</td>

</tr>

<tr>

<td colspan="3">

<asp:Button runat="server" ID="btnAccountOverride" Text="Override Selected Accounts"

ValidationGroup="AccountOverride" OnClick="btnAccountOverride_Click" Enabled="false" />

<asp:Button runat="server" ID="btnAllAccountOverride" Text="Override All Accounts"

ValidationGroup="AccountOverride" OnClick="btnAllAccountOverride_Click" Enabled="false" />

</td>

</tr>

</table>

<telerik:RadToolBar runat="server" ID="AccountOverrideWorklistToolbar" OnButtonClick="WorkListToolBar_ButtonClick"

Width="100%" Skin="Windows7">

<Items>

<telerik:RadToolBarButton>

<ItemTemplate>

<span>Filter: </span>

</ItemTemplate>

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="EnableFilters" Text="On" CommandName="EnableFilters">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="DisableFilters" Text="Off" CommandName="DisableFilters">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="ClearFilter" Text="Clear" CommandName="ClearFilters">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

</Items>

</telerik:RadToolBar>

</asp:Panel>

<asp:Panel runat="server" ID="pnlWorklistToolBar" Visible="true">

<telerik:RadToolBar runat="server" ID="WorkListToolBar" OnButtonClick="WorkListToolBar_ButtonClick"

Width="100%" Skin="Windows7">

<Items>

<telerik:RadToolBarButton runat="server" Value="Users" Text="Users" CommandName="MyUsers"

Group="Accounts" CheckOnClick="true">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server">

<ItemTemplate>

<telerik:RadComboBox runat="server" ID="ddlUserList" AutoPostBack="true" MaxHeight="240px"

Skin="Windows7" AppendDataBoundItems="true" OnSelectedIndexChanged="ddlUserList_SelectedIndexChanged" />

</ItemTemplate>

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="Accounts" Text="My Accounts" CommandName="MyAccounts"

Group="Accounts" CheckOnClick="true">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="PreRegAccounts" Text="My Pre Reg"

CommandName="MyPreRegAccounts" Group="Accounts" CheckOnClick="true">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="History" Text="My History" CommandName="MyHistory"

Group="Accounts" CheckOnClick="true">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Width="30" Enabled="false" Value="tbbSearchSpace" />

<telerik:RadToolBarButton>

<ItemTemplate>

<span>

<asp:Panel ID="pnlSearch" runat="server" class="text" DefaultButton="btnSearch" Visible="true">

<telerik:RadTextBox ID="txtSearch" SelectionOnFocus="SelectAll" runat="server" Width="100px"

Text="Search Account" ToolTip="Enter Last Name, MRN or Account Number" ValidationGroup="search" />

<asp:Button Text="Go" ID="btnSearch" runat="server" OnClick="btnSearch_Click" ValidationGroup="search"

CausesValidation="true" />

<br />

<asp:RequiredFieldValidator ID="txtSearchValidator" runat="server" Display="Dynamic"

EnableClientScript="true" ValidationGroup="search" ControlToValidate="txtSearch"

InitialValue="Search Account" ErrorMessage="You must enter search criteria." ForeColor="red" />

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" Display="Dynamic"

EnableClientScript="true" ValidationGroup="search" ControlToValidate="txtSearch"

InitialValue="" ErrorMessage="You must enter search criteria." ForeColor="red" />

</asp:Panel>

</span>

</ItemTemplate>

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" Width="30" Enabled="false" Value="tbbSearchSpace" />

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Width="30" Enabled="false" Value="tbbSearchSpace" />

<telerik:RadToolBarButton>

<ItemTemplate>

<span>Filter: </span>

</ItemTemplate>

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="EnableFilters" Text="On" CommandName="EnableFilters">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="DisableFilters" Text="Off" CommandName="DisableFilters">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

<telerik:RadToolBarButton runat="server" Value="ClearFilter" Text="Clear" CommandName="ClearFilters">

</telerik:RadToolBarButton>

<telerik:RadToolBarButton runat="server" IsSeparator="true" />

</Items>

</telerik:RadToolBar>

</asp:Panel>

<asp:Panel ID="pnlWorklistGridSettings" Visible="false" runat="server">

<h3>

Worklist Grid Settings</h3>

<br />

*Right click on any column header to add or remove columns from the worklist grid.<br />

*Drag and drop a column header to the top of the page to group the worklist grid

by that criteria.<br />

*Drag and drop column headers to the desired position in the worklist grid.<br />

*Select desired page size.

<br />

</asp:Panel>

<table>

<tr>

<td>

<telerik:RadGrid ID="grdAccountsA" runat="server" AutoGenerateColumns="False" DataKeyNames="FacilityId,AccountId,AccountNumber"

CssClass="Grid" Width="100%" Height="405" Skin="Windows7" GridLines="None" AllowSorting="True"

AllowPaging="True" PageSize="10" OnSelectedIndexChanged="grdAccountsA_SelectedIndexChanged"

OnNeedDataSource="grdAccountsA_NeedDataSource" OnItemDataBound="grdAccountsA_ItemDataBound"

EnablePostBackOnRowClick="False" OnItemCommand="grdAccountsA_ItemCommand" OnPageSizeChanged="grdAccountsA_PageSizeChanged"

OnPageIndexChanged="grdAccountsA_PageIndexChanged" OnSortCommand="grdAccountsA_SortCommand"

ShowGroupPanel="true" GroupingEnabled="true" OnGroupsChanging="grdAccountsA_GroupsChanging"

OnPreRender="grdAccountsA_PreRender" OnColumnsReorder="grdAccountsA_ColumnsReorder">

<GroupingSettings ShowUnGroupButton="true" />

<HeaderStyle Width="100px" />

<PagerStyle AlwaysVisible="True" Mode="NextPrevAndNumeric" HorizontalAlign="Center"

Height="45px"></PagerStyle>

<ClientSettings EnableRowHoverStyle="true" ReorderColumnsOnClient="false" AllowDragToGroup="True"

AllowColumnsReorder="True" ColumnsReorderMethod="Reorder">

<Resizing AllowColumnResize="true" EnableRealTimeResize="false" ClipCellContentOnResize="true"

ResizeGridOnColumnResize="true" />

<Selecting AllowRowSelect="true" />

<Scrolling AllowScroll="true" UseStaticHeaders="True" SaveScrollPosition="False" />

<ClientEvents OnRowDblClick="RowDblClick" OnFilterMenuShowing="filterMenuShowing" />

</ClientSettings>

<MasterTableView IsFilterItemExpanded="true" AllowMultiColumnSorting="true"

GridLines="None" EnableColumnsViewState="true" GroupLoadMode="Server">

<GroupByExpressions>

</GroupByExpressions>

<Columns>

<telerik:GridClientSelectColumn CommandName="grdClientSelectColumn" UniqueName="grdClientSelectColumn"

Visible="false" HeaderStyle-Width="35px" />

<telerik:GridBoundColumn DataField="FacilityId" DefaultInsertValue="" Display="False"

ReadOnly="True" SortExpression="FacilityId" UniqueName="FacilityId" Visible="False" />

<telerik:GridBoundColumn DataField="AccountId" DefaultInsertValue="" Display="False"

ReadOnly="True" SortExpression="AccountId" UniqueName="AccountId" Visible="False" />

<telerik:GridBoundColumn DataField="AccountNumber" DefaultInsertValue="" HeaderText="Account #"

SortExpression="AccountNumber" UniqueName="AccountNumber" HeaderStyle-Width="80px"

AllowFiltering="false" />

<telerik:GridBoundColumn DataField="FacilityName" DefaultInsertValue="" HeaderText="Facility Name"

SortExpression="FacilityName" UniqueName="FacilityName" HeaderStyle-Width="85px"

Visible="true" AllowFiltering="false" />

<telerik:GridBoundColumn DataField="PatientName" DefaultInsertValue="" HeaderText="Patient"

SortExpression="PatientName" UniqueName="PatientName" FilterDelay="4000" HeaderStyle-Width="140px"

AllowFiltering="false" />

<telerik:GridBoundColumn DataField="AdmitDateOnly" DefaultInsertValue="" HeaderText="Admit Date"

SortExpression="AdmitDateOnly" UniqueName="AdmitDate" HeaderStyle-Width="95px"

FilterControlWidth="65px" CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true"

ShowFilterIcon="true" DataFormatString="{0:MM/dd/yyyy}" />

<telerik:GridBoundColumn DataField="VisitType" DefaultInsertValue="" HeaderText="Visit Type"

SortExpression="VisitType" UniqueName="VisitType" HeaderStyle-Width="35px" FilterControlWidth="33px"

CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true" ShowFilterIcon="false" />

<telerik:GridBoundColumn DataField="PatientType" DefaultInsertValue="" HeaderText="Pt Type"

SortExpression="PatientType" UniqueName="PatientType" HeaderStyle-Width="35px"

FilterControlWidth="33px" CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true"

ShowFilterIcon="false" />

<telerik:GridBoundColumn DataField="ServiceType" DefaultInsertValue="" HeaderText="Service"

SortExpression="ServiceType" UniqueName="ServiceType" HeaderStyle-Width="60px"

FilterControlWidth="60px" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"

ShowFilterIcon="false" />

<telerik:GridBoundColumn DataField="Location" DefaultInsertValue="" HeaderText="Location"

SortExpression="Location" UniqueName="Location" HeaderStyle-Width="50px" FilterControlWidth="50px"

CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true" ShowFilterIcon="false" />

<telerik:GridBoundColumn DataField="FinancialClass" DefaultInsertValue="" HeaderText="Fin Class"

SortExpression="FinancialClass" UniqueName="FinancialClass" HeaderStyle-Width="40px"

FilterControlWidth="38px" CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true"

ShowFilterIcon="false" />

<telerik:GridBoundColumn DataField="PlanCode" DefaultInsertValue="" HeaderText="Plan Code"

SortExpression="PlanCode" UniqueName="PlanCode" HeaderStyle-Width="50px" FilterControlWidth="38px"

CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true" ShowFilterIcon="false" />

<telerik:GridBoundColumn DataField="PlanCodeDescription" DefaultInsertValue="" HeaderText="Plan Description"

SortExpression="PlanCodeDescription" UniqueName="PlanCodeDescription" HeaderStyle-Width="100px"

FilterControlWidth="90px" CurrentFilterFunction="StartsWith" ShowFilterIcon="false"

AutoPostBackOnFilter="true" />

<telerik:GridBoundColumn DataField="MRN" DefaultInsertValue="" HeaderText="MRN" SortExpression="MRN"

UniqueName="MRN" HeaderStyle-Width="65px" Visible="true" />

<telerik:GridBoundColumn DataField="PreAdmitTestDateOnly" DefaultInsertValue="" HeaderText="Pre-Admit Testing Date"

FilterControlWidth="65px" SortExpression="PreAdmitTestDateOnly" UniqueName="PreAdmitTestDateOnly"

HeaderStyle-Width="95px" Visible="true" CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true"

ShowFilterIcon="true" DataFormatString="{0:MM/dd/yyyy}" />

<telerik:GridBoundColumn DataField="AdmitDateTimeExpectedOnly" DefaultInsertValue=""

HeaderText="Expected Admit Date" FilterControlWidth="65px" SortExpression="AdmitDateTimeExpectedOnly"

UniqueName="AdmitDateTimeExpectedOnly" HeaderStyle-Width="95px" Visible="true"

CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true" ShowFilterIcon="true"

DataFormatString="{0:MM/dd/yyyy}" />

<telerik:GridBoundColumn DataField="AssignedUser" DefaultInsertValue="" HeaderText="Assigned User"

SortExpression="AssignedUser" UniqueName="AssignedUser" HeaderStyle-Width="100px"

Visible="false" AllowFiltering="false" />

<telerik:GridTemplateColumn HeaderText="Status" SortExpression="Status" HeaderStyle-Width="35px"

AllowFiltering="false" Groupable="false">

<ItemTemplate>

<asp:Image ID="statusImage" runat="server" ImageUrl="~/app_themes/default/images/statusNotStarted.png" />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

<FilterMenu OnClientShown="MenuShowing" />

<GroupingSettings CaseSensitive="False" />

</telerik:RadGrid>

<telerik:RadToolTipManager ID="RadToolTipManager1" runat="server" EnableViewState="false"

Animation="fade" EnableShadow="true" Width="280" Height="100%" Position="BottomLeft"

RenderInPageRoot="true" HideEvent="LeaveTargetAndToolTip" AutoCloseDelay="10000"

RelativeTo="Element" OnAjaxUpdate="OnAjaxUpdate" Skin="Windows7" />

</td>

</tr>

</table>

</td>

</tr>

</table>

<table width="1012px">

<tr>

<td align="right">

<asp:Panel runat="server" ID="PnlWorklistGridSettingsButtions" Visible="false">

<asp:Button runat="server" ID="btnSaveGridSettings" Text="Save" Width="60" OnClick="btnSaveGridSettings_Click"

Enabled="true" />

<asp:Button runat="server" ID="btnCanceGridSettings" Text="Cancel" Width="60" OnClick="btnCancelGridSettings_Click"

Enabled="true" />

</asp:Panel>

</td>

</tr>

</table>

<telerik:RadWindowManager ID="RadWindowManager1" runat="server" EnableViewState="false"

OnClientClose="OnClientClose" Width="435" Height="120" Skin="Windows7" />

</asp:Panel>

</div>

</asp:Content>

Master Page

<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="MasterPage.master.cs"

Inherits="MedAssets.AMS.Web.MasterPage" %>

<%@ Register Assembly="TSC.Timeout" Namespace="TSC.Timeout" TagPrefix="tsc" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title id="title" runat="server">Access Management</title>

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript" src="<%= ResolveUrl("~/Javascript/jquery-1.4.4.min.js") %>"></script>

<script type="text/javascript" src="<%= ResolveUrl("~/Javascript/jquery-ui-1.7.0.min.js") %>"></script>

<script type="text/javascript" src="<%= ResolveUrl("~/Javascript/jquery.bgiframe-2.1.1.pack.js") %>"></script>

</telerik:RadCodeBlock>

</head>

<body id="body" runat="server">

<div id="wrapper" style="width: 100%; height: 100%">

<div id="headerBody" style="width: 100%; height: 100%">

<form id="form1" runat="server">

<telerik:RadScriptManager ID="sm1" runat="server" />

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" />

<telerik:RadAjaxLoadingPanel ID="lp1" runat="server" Skin="Vista" Height="200" Width="200" />

<telerik:RadFormDecorator ID="RadFormDecorator1" DecoratedControls="All" runat="server"

Skin="Vista" EnableRoundedCorners="false" ControlsToSkip="fieldset" />

<span id="dirtyForm" style="display: none;"></span>

<tsc:Timeout ID="Timeout1" runat="server" title="Session Expiring" Enabled="true"

TimeoutURL="~/Timeout.aspx" ResetSessionOnAsyncPostback="true" CountDownSpanID="tscCounter"

DirtyFormSpanID="dirtyForm">

<Template>

<p>

<span class="ui-icon ui-icon-alert" style="float: left; margin: 1px 10px 20px 0;">

</span>For your security, your session is about to expire.

</p>

<br />

<span id="tscCounter" class="TimeOutCounter" ></span>

<br />

<p>

Click <b>Ok</b> to continue your session.</p>

</Template>

</tsc:Timeout>

<asp:Panel runat="server">

<ams:Header ID="Header" runat="server" />

<asp:ContentPlaceHolder ID="cphLogin" runat="server">

</asp:ContentPlaceHolder>

<div class="MasterContent" style="width: 99%; height: 100%;">

<asp:ContentPlaceHolder ID="cph1" runat="server">

</asp:ContentPlaceHolder>

</div>

</asp:Panel>

</form>

</div>

<span id="brandzoneFooter">

<div class="footer">

MedAssets® and AccessIntegrity® are registered trademarks of MedAssets,

<br />

<a href="http://www.medassets.com/Utilities/Pages/Privacy-Policy.aspx">Privacy Policy</a>

| <a href="http://ir.medassets.com/documentdisplay.cfm?DocumentID=2870">Standards of

Business Conduct</a> | <a href="http://www.medassets.com/Utilities/Pages/Terms-of-Use.aspx">

Terms of Use</a>

</div>

</span>

</div>

</body>

</html>

Grid

answered on 22 Mar 2012

1 answer

179 views

Clientside validation in Advanced Template - how?

I am using a modal Advanced template with a resource that has mutiple values just like the demo - http://demos.telerik.com/aspnet-ajax/scheduler/examples/advancedformtemplate/defaultcs.aspx.
Going with that example, I would like to be able to add a client side validation that ensures at least one User check box is selected. If not, then alert a pop up to the user and cancel the save/update. How can I accomplish this?

I looked at OnclientAppointmentInserting event, however it fired when the appointment window opens up and not when the save button is clicked...

Thanks.

Edit: I found this post - http://www.telerik.com/community/forums/aspnet-ajax/scheduler/need-client-side-fxn-called-by-save-close-and-cancel-button-on-appointment-edit-form.aspx and followed it (see below). I put an alert in the handler and i see it get fired. However, the save proceeds as normal. I.e. the window closes and the appointment gets saved. What am I doing wrong?

var schedulerTemplates = {};

function schedulerFormCreated(scheduler, eventArgs) {

// Create a client-side object only for the advanced templates

var mode = eventArgs.get_mode();

if (mode == Telerik.Web.UI.SchedulerFormMode.AdvancedInsert ||

mode == Telerik.Web.UI.SchedulerFormMode.AdvancedEdit) {

// Initialize the client-side object for the advanced form

var formElement = eventArgs.get_formElement();

var templateKey = scheduler.get_id() + "_" + mode;

var advancedTemplate = schedulerTemplates[templateKey];

if (!advancedTemplate)

{

// Initialize the template for this RadScheduler instance

// and cache it in the schedulerTemplates dictionary

var schedulerElement = scheduler.get_element();

var isModal = scheduler.get_advancedFormSettings().modal;

advancedTemplate = new window.SchedulerAdvancedTemplate(schedulerElement, formElement, isModal);

advancedTemplate.initialize();

schedulerTemplates[templateKey] = advancedTemplate;

// Remove the template object from the dictionary on dispose.

scheduler.add_disposing(function() {

schedulerTemplates[templateKey] = null;

});

}

// Are we using Web Service data binding?

if (!scheduler.get_webServiceSettings().get_isEmpty()) {

// Populate the form with the appointment data

var apt = eventArgs.get_appointment();

var isInsert = mode == Telerik.Web.UI.SchedulerFormMode.AdvancedInsert;

advancedTemplate.populate(apt, isInsert);

}

// Override the save button for validation check

var saveButton = $telerik.$("[id$='RadScheduler1_Form_AdvancedInsertForm1_UpdateButton']");

saveButton.click(validateAppointmentSave);

}

function validateAppointmentSave(sender, eventArgs) {

// var advancedEditForm = sender.get_AdvancedEditForm();

// advancedEditForm.close();

var scheduler = $telerik.$("[id$='RadScheduler1']");

scheduler.hideAdvancedForm();

eventArgs.set_cancel(true);

}

Scheduler

answered on 22 Mar 2012

4 answers

235 views

RadDataPager Alignment

i'm not sure if I'm missing something here or not, but how do I center a RadDataPager??? It seems to always want to align to the left. Below is the RadDataPager code I'm using.

                            <center>         
                        <telerik:RadDataPager EnableEmbeddedBaseStylesheet="False" ID="RadDataPager2" runat="server"          
                            PagedControlID="RadListView1">         
                            <Fields>         
                                <telerik:RadDataPagerButtonField FieldType="FirstPrev" />         
                                <telerik:RadDataPagerButtonField FieldType="Numeric" />         
                                <telerik:RadDataPagerButtonField FieldType="NextLast" />         
                            </Fields>         
                        </telerik:RadDataPager>         
                    </center>         
                     

ListView

answered on 22 Mar 2012

7 answers

472 views

[Solved] GridButtonColumn and OnDeleteCommand

Hello,

I used a GridButtonColumn of my RadGrid as a "Delete Column" :

 <trk:RadGrid ID="gridTaskList" runat="server" OnDeleteCommand="gridTasksList_OnDeleteCommand">
...
<trk:GridButtonColumn ConfirmText="Are you sure?" ConfirmDialogType="RadWindow"
 ConfirmTitle="Delete"          ButtonType="LinkButton"              CommandName="Delete" UniqueName="DeleteColumn" />
...

If I used this column as a link button (by default), the event OnDeleteCommand of the RadGrid is fired.
If I specified the column as an ImageButton, the event OnDeleteCommand is not fired.

<trk:GridButtonColumn ConfirmText="Are you sure?" ConfirmDialogType="RadWindow"
 ConfirmTitle="Delete"          ButtonType="ImageButton"              CommandName="Delete" UniqueName="DeleteColumn" />

I'm using the OnNeedDataSource event to populate the grid and I databind my grid in each PageLoad.

Thank you in advance.

Ajax

answered on 22 Mar 2012

4 answers

653 views

Programmatically fire up add new from rad grid (InitInsert)

I’m using Telerik Controls for ASP.NET AJAX.
Basically I want to programatically (in C#) click on the “Add New” button
from a Rad Grid. So on page load I want the "add new window" to
be visible rather than the user has to click on the button.
I think this would simply be just calling a function but I just can’t
figure it out.
Can someone help please?
The CommandName for this action is InitInsert.

Grid

answered on 22 Mar 2012

1 answer

116 views

TimelineView GroupBy is not working

Hello,

We purchased Telerik control, and we are using it in our firm.

In one of my dotnet webapplication i wanted to use scheduler as TimelineView ,with GroupBy of my custom attribure field(which is combobox) here it is Initiative.

Appointments are there with initiative field, it will display without GroupBy ,but when i will configure with GroupBy=Initiative none of the data will display in my scheduler.

Below is my code :Aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="RadSchedulerWebForm.aspx.cs"

Inherits="RadSchedulerWebForm" %>

<!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 runat="server">

<title></title>

<telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server" />

</head>

<body>

<form id="form1" runat="server">

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

<Scripts>

<%--Needed for JavaScript IntelliSense in VS2010--%>

<%--For VS2008 replace RadScriptManager with ScriptManager--%>

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />

</Scripts>

</telerik:RadScriptManager>

<script type="text/javascript">

//Put your JavaScript code here.

function insertAppointment(sender, e) {

var slot = sender.get_activeModel().getTimeSlotFromDomElement(e.get_domEvent().target);

sender.showInsertFormAt(slot);

}

function editAppointment(sender, e) {

var apt = e.get_appointment();

sender.editAppointmentWithConfirmation(apt);

}

</script>

<telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1" />

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadScheduler1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadScheduler1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxPanel runat="server" RenderMode="Block" ID="ajaxPanel" EnableAJAX="true">

<br />

<div>

<asp:Label ID="lblInitiaveName" AssociatedControlID="ddlInitiave" Text="" runat="server">Show Task By Initiative:</asp:Label>

<telerik:RadComboBox ID="ddlInitiave" DataTextField="InitiativeName" DataValueField="ID"

Skin="Outlook" runat="server" AutoPostBack="true">

</telerik:RadComboBox>

<br />

</div>

<telerik:RadScheduler runat="server" ID="RadScheduler1" Width="100%" OnFormCreated="RadScheduler1_FormCreated"

OnAppointmentInsert="RadScheduler1_AppointmentInsert" OnAppointmentUpdate="RadScheduler1_AppointmentUpdate"

OnAppointmentDelete="RadScheduler1_AppointmentDelete" DataKeyField="ID" DataSubjectField="Subject"

DataStartField="Start" DataEndField="End" DataRecurrenceField="RecurrenceRule"

DataRecurrenceParentKeyField="RecurrenceParentId" OnClientTimeSlotClick="insertAppointment"

OnClientAppointmentClick="editAppointment" StartInsertingInAdvancedForm="True"

AppointmentStyleMode="Default" OnAppointmentDataBound="RadScheduler1_AppointmentDataBound"

AdvancedForm-Modal="true" CustomAttributeNames="Comments,agencyValue,statusValue,initiativeName,task,assetType"

AdvancedForm-EnableCustomAttributeEditing="true" SelectedView="MonthView" Skin="Outlook"

Height="100%" OverflowBehavior="Expand" EditFormDateFormat="MM/dd/yyyy" EnableCustomAttributeEditing="True"

RowHeight="30px" >

<ResourceTypes>

<telerik:ResourceType KeyField="ID" Name="Initiative" TextField="InitiativeName"

ForeignKeyField="ID" DataSourceID="SqlDataSourceInitiative" />

</ResourceTypes>

<TimelineView UserSelectable="true" GroupBy="Initiative" GroupingDirection="Vertical" />

<InlineInsertTemplate>

<div id="InlineInsertTemplate">

<asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Subject") %>' TextMode="MultiLine"></asp:TextBox>

<asp:LinkButton ID="InsertButton" runat="server" CommandName="Insert">Insert</asp:LinkButton>

<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel">Cancel</asp:LinkButton>

<asp:LinkButton ID="InsertMoreButton" runat="server" CommandName="More">Advanced</asp:LinkButton>

</div>

</InlineInsertTemplate>

<InlineEditTemplate>

<div id="InlineEditTemplate">

<asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Subject") %>' TextMode="MultiLine"></asp:TextBox>

<asp:LinkButton ID="InsertButton" runat="server" CommandName="Update">Update</asp:LinkButton>

<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel">Cancel</asp:LinkButton>

<asp:LinkButton ID="InsertMoreButton" runat="server" CommandName="More">Advanced</asp:LinkButton>

</div>

</InlineEditTemplate>

<AdvancedForm EnableCustomAttributeEditing="True" DateFormat="MM/dd/yyyy"></AdvancedForm>

<AdvancedEditTemplate>

<div class="rsAdvancedEdit rsAdvancedModal" style="position: relative">

<div class="rsModalBgTopLeft">

</div>

<div class="rsModalBgTopRight">

</div>

<div class="rsModalBgBottomLeft">

</div>

<div class="rsModalBgBottomRight">

</div>

<div class="rsAdvTitle">

<h1 class="rsAdvInnerTitle">

Update Schedule</h1>

<asp:LinkButton runat="server" ID="AdvancedEditCloseButton" CssClass="rsAdvEditClose"

CommandName="Cancel" CausesValidation="false" ToolTip='<%# Container.Appointment.Owner.Localization.AdvancedClose %>'>

<%# Container.Appointment.Owner.Localization.AdvancedClose%>

</asp:LinkButton>

</div>

<div class="rsAdvContentWrapper">

<div>

<asp:Label ID="lblInitiaveName" AssociatedControlID="ddlInitiaveName" Text="" runat="server">Initiative:</asp:Label>

<telerik:RadComboBox ID="ddlInitiaveName" DataTextField="InitiativeName" DataValueField="ID"

SelectedValue='<%# Bind("initiativeName") %>' runat="server">

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblTask" AssociatedControlID="ddlTask" runat="server">Task:</asp:Label>

<telerik:RadComboBox ID="ddlTask" DataTextField="Title" DataValueField="ID" SelectedValue='<%# Bind("task") %>'

runat="server">

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblAssetType" AssociatedControlID="ddlAssetType" Text="" runat="server">AssetType:</asp:Label>

<telerik:RadComboBox ID="ddlAssetType" DataTextField="AssetType" DataValueField="ID"

SelectedValue='<%# Bind("assetType") %>' runat="server">

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblTitle" AssociatedControlID="TitleTextBox" runat="server">Description:</asp:Label>

<telerik:RadTextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Subject") %>'>

</telerik:RadTextBox>

<asp:RequiredFieldValidator runat="server" ID="rfvTitleTextBox" ControlToValidate="TitleTextBox"

ErrorMessage="Please enter Description">

</asp:RequiredFieldValidator>

<br />

</div>

<div>

<asp:Label ID="lblAgency" AssociatedControlID="ddlAgency" runat="server">Agency:</asp:Label>

<telerik:RadComboBox ID="ddlAgency" runat="server" DataTextField="Text" DataValueField="Value"

SelectedValue='<%# Bind("agencyValue") %>'>

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblStartDate" AssociatedControlID="StartInput" runat="server">Start Date:</asp:Label>

<telerik:RadDateTimePicker ID="StartInput" runat="server" SelectedDate='<%# Bind("Start") %>'

TimeView-StartTime="09:00:00" TimeView-EndTime="17:00:00" TimeView-Interval="00:30:00"

TimeView-Columns="2">

</telerik:RadDateTimePicker>

<%--<telerik:RadDateInput ID="StartInput" SelectedDate='<%# Bind("Start") %>' runat="server">

</telerik:RadDateInput>--%><br />

<br />

</div>

<div>

<asp:Label ID="lblEndDate" AssociatedControlID="EndInput" runat="server">End Date:</asp:Label>

<telerik:RadDateTimePicker ID="EndInput" SelectedDate='<%# Bind("End") %>' runat="server"

TimeView-StartTime="09:00:00" TimeView-EndTime="17:00:00" TimeView-Interval="00:30:00"

TimeView-Columns="2">

</telerik:RadDateTimePicker>

<%--<telerik:RadDateInput ID="EndInput" SelectedDate='<%# Bind("End") %>' runat="server">

</telerik:RadDateInput>--%><br />

<br />

</div>

<div>

<asp:Label ID="lblStatus" AssociatedControlID="ddlStatus" runat="server">Status:</asp:Label>

<telerik:RadComboBox ID="ddlStatus" runat="server" DataTextField="Text" DataValueField="Value"

SelectedValue='<%# Bind("statusValue") %>'>

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblComments" AssociatedControlID="CommentsTextBox" runat="server">Comments:</asp:Label>

<telerik:RadTextBox ID="CommentsTextBox" Rows="5" Columns="20" runat="server" Text='<%# Bind("Comments") %>'

Width="95%" TextMode="MultiLine">

</telerik:RadTextBox>

<asp:RequiredFieldValidator runat="server" ID="rfvComments" ControlToValidate="CommentsTextBox"

ErrorMessage="Please enter Comments">

</asp:RequiredFieldValidator>

<br />

</div>

<asp:Panel runat="server" ID="ButtonsPanel" CssClass="rsAdvancedSubmitArea">

<div class="rsAdvButtonWrapper">

<asp:LinkButton CommandName="Update" runat="server" ID="UpdateButton" CssClass="rsAdvEditSave">

<span>Update</span>

</asp:LinkButton>

<asp:LinkButton runat="server" ID="CancelButton" CssClass="rsAdvEditCancel" CommandName="Cancel"

CausesValidation="false">

<span><%# Container.Appointment.Owner.Localization.Cancel%></span>

</asp:LinkButton>

</div>

</asp:Panel>

</div>

</AdvancedEditTemplate>

<AdvancedInsertTemplate>

<div class="rsAdvancedEdit rsAdvancedModal" style="position: relative">

<div class="rsModalBgTopLeft">

</div>

<div class="rsModalBgTopRight">

</div>

<div class="rsModalBgBottomLeft">

</div>

<div class="rsModalBgBottomRight">

</div>

<div class="rsAdvTitle">

<h1 class="rsAdvInnerTitle">

New Schedule</h1>

<asp:LinkButton runat="server" ID="AdvancedEditCloseButton" CssClass="rsAdvEditClose"

CommandName="Cancel" CausesValidation="false" ToolTip='<%# Container.Appointment.Owner.Localization.AdvancedClose %>'>

<%# Container.Appointment.Owner.Localization.AdvancedClose%>

</asp:LinkButton>

</div>

<div class="rsAdvContentWrapper">

<div>

<asp:Label ID="lblInitiaveName" AssociatedControlID="ddlInitiaveName" Text="" runat="server">Initiative:</asp:Label>

<telerik:RadComboBox ID="ddlInitiaveName" DataTextField="InitiativeName" DataValueField="ID"

SelectedValue='<%# Bind("initiativeName") %>' runat="server">

</telerik:RadComboBox>

<asp:CompareValidator ID="initiaveValidator" runat="server" ControlToValidate="ddlInitiaveName"

ValueToCompare=" --- Select Initiative --- " Operator="NotEqual" ErrorMessage="Please select Initiative"></asp:CompareValidator>

<br />

</div>

<div>

<asp:Label ID="lblTask" AssociatedControlID="ddlTask" runat="server">Task:</asp:Label>

<telerik:RadComboBox ID="ddlTask" DataTextField="Title" DataValueField="ID" SelectedValue='<%# Bind("task") %>'

runat="server">

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblAssetType" AssociatedControlID="ddlAssetType" Text="" runat="server">AssetType:</asp:Label>

<telerik:RadComboBox ID="ddlAssetType" DataTextField="AssetType" DataValueField="ID"

SelectedValue='<%# Bind("assetType") %>' runat="server">

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblTitle" AssociatedControlID="TitleTextBox" runat="server">Description:</asp:Label>

<telerik:RadTextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Subject") %>'>

</telerik:RadTextBox>

<asp:RequiredFieldValidator runat="server" ID="rfvTitleTextBox" ControlToValidate="TitleTextBox"

ErrorMessage="Please enter Description">

</asp:RequiredFieldValidator>

<br />

</div>

<div>

<asp:Label ID="lblAgency" AssociatedControlID="ddlAgency" runat="server">Agency:</asp:Label>

<telerik:RadComboBox ID="ddlAgency" runat="server" DataTextField="Text" DataValueField="Value"

SelectedValue='<%# Bind("agencyValue") %>'>

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblStartDate" AssociatedControlID="StartInput" runat="server">Start Date:</asp:Label>

<telerik:RadDateTimePicker ID="StartInput" runat="server" SelectedDate='<%# Bind("Start") %>'

TimeView-StartTime="09:00:00" TimeView-EndTime="17:00:00" TimeView-Interval="00:30:00"

TimeView-Columns="2">

</telerik:RadDateTimePicker>

<%--<telerik:RadDateInput ID="StartInput" SelectedDate='<%# Bind("Start") %>' runat="server">

</telerik:RadDateInput>--%><br />

<br />

</div>

<div>

<asp:Label ID="lblEndDate" AssociatedControlID="EndInput" runat="server">End Date:</asp:Label>

<telerik:RadDateTimePicker ID="EndInput" SelectedDate='<%# Bind("End") %>' runat="server"

TimeView-StartTime="09:00:00" TimeView-EndTime="17:00:00" TimeView-Interval="00:30:00"

TimeView-Columns="2">

</telerik:RadDateTimePicker>

<%--<telerik:RadDateInput ID="EndInput" SelectedDate='<%# Bind("End") %>' runat="server">

</telerik:RadDateInput>--%><br />

<br />

</div>

<div>

<asp:Label ID="lblStatus" AssociatedControlID="ddlStatus" runat="server">Status:</asp:Label>

<telerik:RadComboBox ID="ddlStatus" runat="server" DataTextField="Text" DataValueField="Value"

SelectedValue='<%# Bind("statusValue") %>'>

</telerik:RadComboBox>

<br />

</div>

<div>

<asp:Label ID="lblComments" AssociatedControlID="CommentsTextBox" runat="server">Comments:</asp:Label>

<telerik:RadTextBox ID="CommentsTextBox" Rows="5" Columns="20" runat="server" Text='<%# Bind("Comments") %>'

Width="95%" TextMode="MultiLine">

</telerik:RadTextBox>

<asp:RequiredFieldValidator runat="server" ID="rfvComments" ControlToValidate="CommentsTextBox"

ErrorMessage="Please enter Comments">

</asp:RequiredFieldValidator>

<br />

</div>

<asp:Panel runat="server" ID="ButtonsPanel" CssClass="rsAdvancedSubmitArea">

<div class="rsAdvButtonWrapper">

<asp:LinkButton CommandName="Insert" runat="server" ID="SaveButton" CssClass="rsAdvEditSave"

CausesValidation="true">

<span><%# Container.Appointment.Owner.Localization.Save%></span>

</asp:LinkButton>

<asp:LinkButton runat="server" ID="CancelButton" CssClass="rsAdvEditCancel" CommandName="Cancel"

CausesValidation="false">

<span><%# Container.Appointment.Owner.Localization.Cancel%></span>

</asp:LinkButton>

</div>

</asp:Panel>

</div>

</AdvancedInsertTemplate>

<TimeSlotContextMenus>

<telerik:RadSchedulerContextMenu runat="server" ID="SchedulerTimeSlotContextMenu">

<Items>

<telerik:RadMenuItem Text="New Schedule" Value="CommandAddAppointment" />

</Items>

</telerik:RadSchedulerContextMenu>

</TimeSlotContextMenus>

<TimeSlotContextMenuSettings EnableDefault="true" />

<AppointmentContextMenuSettings EnableDefault="true" />

</telerik:RadScheduler>

</telerik:RadAjaxPanel>

<br />

<telerik:RadButton ID="btnExport" runat="server" Text="Exprot to Excel" Skin="Outlook">

</telerik:RadButton>

<asp:SqlDataSource ID="SqlDataSourceInitiative" runat="server" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>"

SelectCommand="SELECT ID,InitiativeName FROM [Initiatives]"></asp:SqlDataSource>

<%--<telerik:RadScheduler ID="RadScheduler2" runat="server" DataEndField="End" Visible="false"

DataKeyField="ID" DataRecurrenceField="RecurrenceRule" DataRecurrenceParentKeyField="RecurrenceParentID"

DataSourceID="SqlDataSource1" DataStartField="Start" DataSubjectField="Subject">

<ResourceTypes>

<telerik:ResourceType DataSourceID="SqlDataSource2" ForeignKeyField="UserID" KeyField="ID"

Name="Users" TextField="UserName" />

</ResourceTypes>

</telerik:RadScheduler>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>"

SelectCommand="SELECT [ID], [UserName] FROM [Users]"></asp:SqlDataSource>--%>

</form>

</body>

</html>

and code file

using System;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Collections.Generic;

using System.Configuration;

using System.Web.Security;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using Telerik.Web.UI;

using System.Data.SqlClient;

using System.Drawing;

using Microsoft.Office.Excel;

using Excel= Microsoft.Office.Interop.Excel;

using System.Reflection;

using System.Collections;

public partial class RadSchedulerWebForm : System.Web.UI.Page

{

string appointmentId = string.Empty;

string initiativeValue = string.Empty;

int initiaveId;

string taskValue = string.Empty;

string assetType = string.Empty;

string agencyValue = string.Empty;

string statusValue = string.Empty;

string comment = string.Empty;

string sql = string.Empty;

DateTime startdDate = DateTime.Now;

DateTime enddDate = DateTime.Now;

System.Data.DataTable appointment;

System.Data.DataTable status;

SqlDataAdapter adapter;

SqlConnection conn;

SqlCommand cmd;

private List<AppointmentInfo> Appointments

{

get

{

List<AppointmentInfo> sessApts = Session["Appointments"] as List<AppointmentInfo>;

if (sessApts == null)

{

sessApts = new List<AppointmentInfo>();

Session["Appointments"] = sessApts;

}

return sessApts;

}

private System.Data.DataTable dtApp

{

get

{

System.Data.DataTable sessdtApp = Session["dtApp"] as System.Data.DataTable;

if (sessdtApp == null)

{

sessdtApp = new System.Data.DataTable();

Session["Appointments"] = sessdtApp;

}

return sessdtApp;

}

protected void Page_Load(object sender, EventArgs e)

{

}

protected override void OnInit(EventArgs e)

{

base.OnInit(e);

if (!IsPostBack)

{

//Session.Remove("Appointments");

//RadScheduler1.DataSource = GetAppointments();

LoadInitiave(ddlInitiave);

RadScheduler1.DataSource = GetAppointments();

}

// RadScheduler1.DataSource = Appointments;

ddlInitiave.SelectedIndexChanged += new RadComboBoxSelectedIndexChangedEventHandler(ddlInitiave_SelectedIndexChanged);

btnExport.Click += new EventHandler(btnExport_Click);

RadScheduler1.SelectedView = SchedulerViewType.TimelineView;

//RadScheduler1.TimelineView.GroupBy=

}

protected void btnExport_Click(object sender, EventArgs e)

{

//// throw new NotImplementedException();

// appointment = new System.Data.DataTable();

// appointment = GetAppointments();

// //ExportToSpreadsheet(appointment, "TestExcel");

// Excel_FromDataTable(appointment);

}

protected void ddlInitiave_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)

{

if (ddlInitiave.SelectedItem.Value == "0")

{

RadScheduler1.DataSource = GetAppointments();

}

else

{

RadScheduler1.DataSource = GetAppointmentByInitiative(ddlInitiave.SelectedValue);

}

protected void RadScheduler1_AppointmentDataBound(object sender, SchedulerEventArgs e)

{

//To apply color on each appointments

appointmentId = Convert.ToString(e.Appointment.ID);

//After Inserting and appointment

if (appointmentId == string.Empty)

{

statusValue = e.Appointment.Attributes["statusValue"];

{

switch (statusValue)

{

case "1": //Scheduled

e.Appointment.BackColor = Color.SkyBlue;

break;

case "2": //Happenned

e.Appointment.BackColor = Color.PeachPuff;

break;

case "3": //Didnt Happen

e.Appointment.BackColor = Color.Orange;

break;

default:

break;

}

else

{

//for AppointmentDataBound

status = GetStatusByAppointmentId(appointmentId);

if (status.Rows.Count > 0)

{

foreach (DataRow row in status.Rows)

{

statusValue = row["Status"].ToString();

switch (statusValue)

{

case "1": //Scheduled

e.Appointment.BackColor = Color.SkyBlue;

break;

case "2": //Happenned

e.Appointment.BackColor = Color.PeachPuff;

break;

case "3": //Didnt Happen

e.Appointment.BackColor = Color.Orange;

break;

default:

break;

}

protected void RadScheduler1_AppointmentInsert(object sender, SchedulerCancelEventArgs e)

{

initiaveId=Convert.ToInt32(e.Appointment.Attributes["initiativeName"]);

initiativeValue = e.Appointment.Attributes["initiativeName"];

taskValue = e.Appointment.Attributes["task"];

assetType = e.Appointment.Attributes["assetType"];

agencyValue = e.Appointment.Attributes["agencyValue"];

statusValue = e.Appointment.Attributes["statusValue"];

comment = e.Appointment.Attributes["Comments"];

InsertAppointment(e.Appointment.Subject, Convert.ToDateTime(e.Appointment.Start), Convert.ToDateTime(e.Appointment.End), initiaveId, taskValue, assetType, agencyValue, statusValue, comment);

}

protected void RadScheduler1_AppointmentUpdate(object sender, AppointmentUpdateEventArgs e)

{

//To Update Appointment

appointmentId = e.Appointment.ID.ToString();

initiativeValue = e.ModifiedAppointment.Attributes["initiativeName"];

taskValue = e.ModifiedAppointment.Attributes["task"];

assetType = e.ModifiedAppointment.Attributes["assetType"];

agencyValue = e.ModifiedAppointment.Attributes["agencyValue"];

statusValue = e.ModifiedAppointment.Attributes["statusValue"];

comment = e.ModifiedAppointment.Attributes["Comments"];

if (initiativeValue == null || taskValue == null || agencyValue == null || statusValue == string.Empty || comment == string.Empty)

{

System.Data.DataTable dt = GetAppointmentById(appointmentId);

foreach (DataRow row in dt.Rows)

{

initiativeValue = row["InitiativeId"].ToString();

taskValue = row["TaskId"].ToString();

assetType = row["AssetType"].ToString();

agencyValue = row["Agency"].ToString();

statusValue = row["Status"].ToString();

comment = row["Description"].ToString();

}

UpdateAppointment(appointmentId, e.ModifiedAppointment.Subject, Convert.ToDateTime(e.ModifiedAppointment.Start), Convert.ToDateTime(e.ModifiedAppointment.End), initiativeValue, taskValue,assetType,agencyValue, statusValue, comment);

//AppointmentInfo ai = FindById(e.ModifiedAppointment.ID);

//ai.CopyInfo(e.ModifiedAppointment);

}

protected void RadScheduler1_AppointmentDelete(object sender, SchedulerCancelEventArgs e)

{

//To Delete Appointment

// Appointments.Remove(FindById(e.Appointment.ID));

appointmentId = e.Appointment.ID.ToString();

DeleteAppointment(appointmentId);

}

private AppointmentInfo FindById(object ID)

{

foreach (AppointmentInfo ai in Appointments)

{

if (ai.ID.Equals(ID))

{

return ai;

}

return null;

}

protected void RadScheduler1_FormCreated(object sender, SchedulerFormCreatedEventArgs e)

{

RadScheduler scheduler = (RadScheduler)sender;

//AdvanceInsert Mode

if (e.Container.Mode == SchedulerFormMode.AdvancedInsert)

{

RadComboBox ddlInitiaveName = (RadComboBox)e.Container.FindControl("ddlInitiaveName");

LoadInitiave(ddlInitiaveName);

RadComboBox ddlTask = (RadComboBox)e.Container.FindControl("ddlTask");

LoadTask(ddlTask);

RadComboBox ddlAssetType = (RadComboBox)e.Container.FindControl("ddlAssetType");

LoadAssetType(ddlAssetType);

RadTextBox subjectBox = (RadTextBox)e.Container.FindControl("TitleTextBox");

subjectBox.Text = e.Appointment.Subject;

RadComboBox ddlAgency = (RadComboBox)e.Container.FindControl("ddlAgency");

ddlAgency.LoadContentFile("~/App_Data/AgencyItems.xml");

RadDateTimePicker startInput = (RadDateTimePicker)e.Container.FindControl("StartInput");

startInput.DateInput.DateFormat = scheduler.AdvancedForm.DateFormat + " " + scheduler.AdvancedForm.TimeFormat;

startInput.SelectedDate = RadScheduler1.DisplayToUtc(e.Appointment.Start);

RadDateTimePicker endInput = (RadDateTimePicker)e.Container.FindControl("EndInput");

endInput.DateInput.DateFormat = scheduler.AdvancedForm.DateFormat + " " + scheduler.AdvancedForm.TimeFormat;

endInput.SelectedDate = RadScheduler1.DisplayToUtc(e.Appointment.End);

RadComboBox ddlStatus = (RadComboBox)e.Container.FindControl("ddlStatus");

ddlStatus.LoadContentFile("~/App_Data/StatusItems.xml");

}

//AdvanceEdit Mode

if (e.Container.Mode == SchedulerFormMode.AdvancedEdit)

{

appointmentId = e.Appointment.ID.ToString();

if (appointmentId != string.Empty)

{

System.Data.DataTable dt = GetAppointmentById(appointmentId);

foreach (DataRow row in dt.Rows)

{

initiativeValue = row["InitiativeId"].ToString();

taskValue = row["TaskId"].ToString();

assetType = row["AssetType"].ToString();

agencyValue = row["Agency"].ToString();

startdDate = Convert.ToDateTime(row["Start"].ToString());

enddDate = Convert.ToDateTime(row["End"].ToString());

statusValue = row["Status"].ToString();

comment = row["Description"].ToString();

}

RadComboBox ddlInitiaveName = (RadComboBox)e.Container.FindControl("ddlInitiaveName");

LoadInitiave(ddlInitiaveName);

ddlInitiaveName.SelectedValue = initiativeValue;

RadComboBox ddlTask = (RadComboBox)e.Container.FindControl("ddlTask");

LoadTask(ddlTask);

ddlTask.SelectedValue = taskValue;

RadComboBox ddlAssetType = (RadComboBox)e.Container.FindControl("ddlAssetType");

LoadAssetType(ddlAssetType);

ddlAssetType.SelectedValue = assetType;

RadComboBox ddlAgency = (RadComboBox)e.Container.FindControl("ddlAgency");

ddlAgency.LoadContentFile("~/App_Data/AgencyItems.xml");

ddlAgency.SelectedValue = agencyValue;

RadDateTimePicker startInput = (RadDateTimePicker)e.Container.FindControl("StartInput");

startInput.DateInput.DateFormat = scheduler.AdvancedForm.DateFormat + " " + scheduler.AdvancedForm.TimeFormat;

startInput.SelectedDate = startdDate;

RadDateTimePicker endInput = (RadDateTimePicker)e.Container.FindControl("EndInput");

endInput.DateInput.DateFormat = scheduler.AdvancedForm.DateFormat + " " + scheduler.AdvancedForm.TimeFormat;

endInput.SelectedDate = enddDate;

RadComboBox ddlStatus = (RadComboBox)e.Container.FindControl("ddlStatus");

ddlStatus.LoadContentFile("~/App_Data/StatusItems.xml");

ddlStatus.SelectedValue = statusValue;

RadTextBox commentsBox = (RadTextBox)e.Container.FindControl("CommentsTextBox");

commentsBox.Text = comment;

}

protected System.Data.DataTable GetAppointments()

{

appointment = new System.Data.DataTable();

conn = new SqlConnection(GetConnectionString());

adapter = new SqlDataAdapter("SELECT ID,Subject,Start,[End],InitiativeId,TaskId,AssetType,Agency,Status,Description,RecurrenceRule,RecurrenceParentId FROM Appointments order by ID", conn);

adapter.Fill(appointment);

return appointment;

}

//protected System.Data.DataTable GetAppointments()

//{

// appointment = new System.Data.DataTable();

// conn = new SqlConnection(GetConnectionString());

// adapter = new SqlDataAdapter("SELECT from Initiavtiv", conn);

// adapter.Fill(appointment);

// return appointment;

//}

protected System.Data.DataTable GetAppointmentById(string appointmentid)

{

appointment = new System.Data.DataTable();

conn = new SqlConnection(GetConnectionString());

adapter = new SqlDataAdapter("SELECT Subject,Start,[End],InitiativeId,TaskId,AssetType,Agency,Status,Description,RecurrenceRule,RecurrenceParentId FROM Appointments WHERE ID=" + appointmentid + "", conn);

adapter.Fill(appointment);

return appointment;

}

protected System.Data.DataTable GetStatusByAppointmentId(string appointmentid)

{

status = new System.Data.DataTable();

conn = new SqlConnection(GetConnectionString());

adapter = new SqlDataAdapter("SELECT Status FROM Appointments WHERE ID=" + appointmentid + "", conn);

adapter.Fill(status);

return status;

}

protected System.Data.DataTable GetAppointmentByInitiative(string Initiative)

{

appointment = new System.Data.DataTable();

conn = new SqlConnection(GetConnectionString());

adapter = new SqlDataAdapter("SELECT ID,Subject,Start,[End],TaskId,AssetType,Agency,Status,Description,RecurrenceRule,RecurrenceParentId FROM Appointments WHERE InitiativeId=" + Initiative + "", conn);

adapter.Fill(appointment);

return appointment;

}

protected void LoadInitiave(RadComboBox ddlinitiavename)

{

try

{

conn = new SqlConnection(GetConnectionString());

adapter = new SqlDataAdapter("SELECT InitiativeName,ID FROM [Initiatives] order by ID", conn);

System.Data.DataTable dt = new System.Data.DataTable();

adapter.Fill(dt);

ddlinitiavename.DataTextField = "InitiativeName";

ddlinitiavename.DataValueField = "ID";

ddlinitiavename.DataSource = dt;

RadComboBoxItem firstitem = new RadComboBoxItem();

firstitem.Text = " --- Select Initiative --- ";

firstitem.Value = "0";

ddlinitiavename.Items.Add(firstitem);

foreach (DataRow row in dt.Rows)

{

RadComboBoxItem item = new RadComboBoxItem();

item.Text = row["InitiativeName"].ToString();

item.Value = row["ID"].ToString();

ddlinitiavename.Items.Add(item);

}

catch (Exception ex)

{ }

finally

{

conn.Close();

}

protected void LoadTask(RadComboBox ddltask)

{

try

{

conn = new SqlConnection(GetConnectionString());

adapter = new SqlDataAdapter("SELECT Title,ID FROM [Master Task List] order by ID", conn);

System.Data.DataTable dt = new System.Data.DataTable();

adapter.Fill(dt);

ddltask.DataTextField = "Title";

ddltask.DataValueField = "ID";

ddltask.DataSource = dt;

foreach (DataRow row in dt.Rows)

{

RadComboBoxItem item = new RadComboBoxItem();

item.Text = row["Title"].ToString();

item.Value = row["ID"].ToString();

ddltask.Items.Add(item);

}

catch (Exception ex)

{ }

finally

{

conn.Close();

}

protected void LoadAssetType(RadComboBox ddlassettype)

{

try

{

conn = new SqlConnection(GetConnectionString());

adapter = new SqlDataAdapter("SELECT ID,AssetType FROM AssetType order by ID", conn);

System.Data.DataTable dt = new System.Data.DataTable();

adapter.Fill(dt);

ddlassettype.DataTextField = "AssetType";

ddlassettype.DataValueField = "ID";

ddlassettype.DataSource = dt;

foreach (DataRow row in dt.Rows)

{

RadComboBoxItem item = new RadComboBoxItem();

item.Text = row["AssetType"].ToString();

item.Value = row["ID"].ToString();

ddlassettype.Items.Add(item);

}

catch (Exception ex)

{ }

finally

{

conn.Close();

}

public string GetConnectionString()

{

return System.Configuration.ConfigurationManager.ConnectionStrings["TelerikConnectionString"].ConnectionString;

}

private void InsertAppointment(string subject, DateTime start, DateTime end, int initiative, string task,string assettype, string agency, string status, string comments)

{

conn = new SqlConnection(GetConnectionString());

sql = "INSERT INTO Appointments (Subject,Start,[End],InitiativeId,TaskId,AssetType,Agency,Status,Description) VALUES (@subject,@start,@end,@initiative,@task,@assettype,@agency,@status,@comments)";

try

{

conn.Open();

SqlCommand cmd = new SqlCommand(sql, conn);

//cmd.Parameters.AddWithValue("@id",Guid.NewGuid().ToString() );

cmd.Parameters.AddWithValue("@subject", subject);

cmd.Parameters.AddWithValue("@start", start);

cmd.Parameters.AddWithValue("@end", end);

cmd.Parameters.AddWithValue("@initiative", initiative);

cmd.Parameters.AddWithValue("@task", task);

cmd.Parameters.AddWithValue("@assettype", assettype);

cmd.Parameters.AddWithValue("@agency", agency);

cmd.Parameters.AddWithValue("@status", status);

cmd.Parameters.AddWithValue("@comments", comments);

cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();

}

catch (System.Data.SqlClient.SqlException ex)

{

string msg = "Insert Error:";

msg += ex.Message;

throw new Exception(msg);

}

finally

{

conn.Close();

}

private void UpdateAppointment(string appointmentId, string subject, DateTime start, DateTime end, string initiative, string task,string assettype, string agency, string status, string comments)

{

conn = new SqlConnection(GetConnectionString());

sql = "UPDATE Appointments SET Subject=@subject,Start=@start,[End]=@end,InitiativeId=@initiative,TaskId=@task,AssetType=@assettype,Agency=@agency,Status=@status,Description=@comments WHERE ID=" + appointmentId + "";

try

{

conn.Open();

cmd = new SqlCommand(sql, conn);

cmd.Parameters.AddWithValue("@subject", subject);

cmd.Parameters.AddWithValue("@start", start);

cmd.Parameters.AddWithValue("@end", end);

cmd.Parameters.AddWithValue("@initiative", initiative);

cmd.Parameters.AddWithValue("@task", task);

cmd.Parameters.AddWithValue("@assettype", assettype);

cmd.Parameters.AddWithValue("@agency", agency);

cmd.Parameters.AddWithValue("@status", status);

cmd.Parameters.AddWithValue("@comments", comments);

cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();

}

catch (System.Data.SqlClient.SqlException ex)

{

string msg = "Update Error:";

msg += ex.Message;

throw new Exception(msg);

}

finally

{

conn.Close();

}

private void DeleteAppointment(string appointmentId)

{

conn = new SqlConnection(GetConnectionString());

sql = "DELETE FROM Appointments WHERE ID=@id";

try

{

conn.Open();

cmd = new SqlCommand(sql, conn);

cmd.Parameters.AddWithValue("@id", appointmentId);

cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();

}

catch (System.Data.SqlClient.SqlException ex)

{

string msg = "Delete Error:";

msg += ex.Message;

throw new Exception(msg);

}

finally

{

conn.Close();

}

public static void ExportToSpreadsheet(System.Data.DataTable table, string name)

{

HttpContext context = HttpContext.Current;

context.Response.Clear();

foreach (DataColumn column in table.Columns)

{

context.Response.Write(column.ColumnName + ";");

}

context.Response.Write(Environment.NewLine);

foreach (DataRow row in table.Rows)

{

for (int i = 0; i < table.Columns.Count; i++)

{

context.Response.Write(row[i].ToString().Replace(";", string.Empty) + ";");

}

context.Response.Write(Environment.NewLine);

}

context.Response.ContentType = "text/csv";

context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + name + ".csv");

context.Response.End();

}

// TO USE:

// 1) include COM reference to Microsoft Excel Object library

// add namespace...

//using Excel = Microsoft.Office.Interop.Excel;

private static void Excel_FromDataTable(System.Data.DataTable dt)

{

// Create an Excel object and add workbook...

Excel.ApplicationClass excel = new Excel.ApplicationClass();

Excel.Workbook workbook = excel.Application.Workbooks.Add(true); // true for object template???

// Add column headings...

int iCol = 0;

foreach (DataColumn c in dt.Columns)

{

iCol++;

excel.Cells[1, iCol] = c.ColumnName;

}

// for each row of data...

int iRow = 0;

foreach (DataRow r in dt.Rows)

{

iRow++;

// add each row's cell data...

iCol = 0;

foreach (DataColumn c in dt.Columns)

{

iCol++;

excel.Cells[iRow + 1, iCol] = r[c.ColumnName];

}

// Global missing reference for objects we are not defining...

object missing = System.Reflection.Missing.Value;

// If wanting to Save the workbook...

workbook.SaveAs("Scheduler.xls",

Excel.XlFileFormat.xlXMLSpreadsheet, missing, missing,

false, false, Excel.XlSaveAsAccessMode.xlNoChange,

missing, missing, missing, missing, missing);

// If wanting to make Excel visible and activate the worksheet...

excel.Visible = true;

Excel.Worksheet worksheet = (Excel.Worksheet)excel.ActiveSheet;

((Excel._Worksheet)worksheet).Activate();

// If wanting excel to shutdown...

((Excel._Application)excel).Quit();

}

Kinldy suggest me where i made mistake ?

If i can solve it by adding Resoueces then how can i do that with Resources ?

Reply me ASAP.

Thanks a lot,
Nirav

Scheduler

answered on 22 Mar 2012

16 answers

496 views

RadGrid Custom Skin

Hi,
i am having some trouble while applying the custom skin to Rad Grid. I have followed the procedure to apply custom skin. It works very well on the grid but not the filter row and the page size. I have even tried to use your visual style builder to do it but it does not seem to work. The issue is only with filter row and page size. ... they do not seem to apply the skin or font size.Please could you provide me some feedback as to what else needs to be done to fix this issue.

Regards,
Ajit

Grid

answered on 22 Mar 2012

Top users last month