Questions on UI for ASP.NET AJAX Forum

1 answer

110 views

[Solved] Different Colors of appointment by changing status

Hi,

I am very new to all of this I have seen a few examples of doing this but can't seem to get it to work. I have seen some about using CSS and some of using code. Just wanted to know which is better? I would like to use CSS. So here is what I got I have a RadScheduler with custom resources not sure that is what it is called. I have Therapists, Patients and Status. What I want to do is change the color of the appointment when the status is changed. Can you please provide me with what code I need to implement and maybe a sample of what the CSS should look like. thanks here is my code.

<%@ Page Title="" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="STSchedule.aspx.vb" Inherits="ScheduleUser_STSchedule" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">

<link href="../Styles.css" rel="stylesheet" type="text/css" />

<style type="text/css">

.style3

{

width: 165px;

height: 120px;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">

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

</telerik:RadStyleSheetManager>

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

<Scripts>

<asp:ScriptReference Assembly="Telerik.Web.UI"

Name="Telerik.Web.UI.Common.Core.js">

</asp:ScriptReference>

<asp:ScriptReference Assembly="Telerik.Web.UI"

Name="Telerik.Web.UI.Common.jQuery.js">

</asp:ScriptReference>

<asp:ScriptReference Assembly="Telerik.Web.UI"

Name="Telerik.Web.UI.Common.jQueryInclude.js">

</asp:ScriptReference>

</Scripts>

</telerik:RadScriptManager>

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

</telerik:RadAjaxManager>

<div id="content-container1">

<div id="content-container2">

<div id="section-navigation">

<img alt="h2t" class="style3" src="../Pics/logoh2t.png" />

<telerik:RadTabStrip ID="RadTabStrip1" runat="server" Skin="Transparent"

Width="161px" SelectedIndex="2" >

<Tabs>

<telerik:RadTab runat="server" Text="PT"

NavigateUrl="~/ScheduleUser/PTSchedule.aspx">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="OT"

NavigateUrl="~/ScheduleUser/OTSchedule.aspx">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="ST" Selected="True"

NavigateUrl="~/ScheduleUser/STSchedule.aspx">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="MT"

NavigateUrl="~/ScheduleUser/MTSchedule.aspx">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="Patients"

NavigateUrl="~/ScheduleUser/Schedule.aspx">

</telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<asp:ListBox ID="ListBox1" runat="server" BackColor="#99CCFF"

DataSourceID="SqlDataSource6" DataTextField="TherapistName"

DataValueField="EmployeeID" Rows="30" Width="161px" AutoPostBack="True"></asp:ListBox>

<asp:SqlDataSource ID="SqlDataSource6" runat="server"

ConnectionString="<%$ ConnectionStrings:H2T2SQLConnectionString %>" SelectCommand="SELECT        EmployeeID, TherapistFirstName, TherapistLastName, Occupation, TherapistLastName + ' ' + TherapistFirstName + ' ' + Occupation AS TherapistName

FROM Therapist

WHERE (Occupation = N'SLP') OR

(Occupation = N'SLPA')

ORDER BY TherapistLastName"></asp:SqlDataSource>

</div>

<div id="content">

<telerik:RadScheduler ID="RadScheduler1" runat="server" Skin="Vista" DataEndField="EndTime"

DataKeyField="ApptID" DataSourceID="SqlDataSource1" DataStartField="StartTime"

DataSubjectField="Subject" DayEndTime="21:00:00"

DisplayRecurrenceActionDialogOnMove="True" Height="700px"

SelectedView="WeekView" ShowAllDayRow="False"

ShowFooter="False" TimeZoneID="US Mountain Standard Time"

TimeZoneOffset="-07:00:00" WorkDayEndTime="18:00:00"

DataDescriptionField="Description"

EnableDescriptionField="True" DataRecurrenceField="Recurrence"

DataRecurrenceParentKeyField="RecurrencePartentID"

DataReminderField="Reminder" style="margin-left: 3px"

HoursPanelTimeFormat="htt" TimeLabelRowSpan="1">

<ResourceTypes>

<telerik:ResourceType DataSourceID="SqlDataSource2" ForeignKeyField="PatientID"

KeyField="PatientID" Name="Patient" TextField="PatientName" />

<telerik:ResourceType DataSourceID="SqlDataSource5" ForeignKeyField="StatusID"

KeyField="ReasonID" Name="Status" TextField="Appointment" />

<telerik:ResourceType DataSourceID="SqlDataSource7"

ForeignKeyField="TherapistID" KeyField="EmployeeID" Name="Theraist"

TextField="TherapistName" />

</ResourceTypes>

<AppointmentTemplate>

<div class="AppointmentTemplate <%# Eval("Status.Text") %>">

<h4><%# Eval("Subject") %></h4>

</div>

</AppointmentTemplate>

<Localization HeaderTimeline="All Therapist " HeaderToday="Today" />

<TimelineView GroupBy="Therapist"

GroupingDirection="Vertical" />

<MultiDayView ShowHoursColumn="False" />

<Reminders Enabled="True" />

</telerik:RadScheduler>

</div>

<asp:SqlDataSource ID="SqlDataSource5" runat="server"

ConnectionString="<%$ ConnectionStrings:H2T2SQLConnectionString %>"

SelectCommand="SELECT [Appointment], [ReasonID] FROM [StatusInfo]">

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:Insurance InfoConnectionString1 %>"

SelectCommand="SELECT ApptID, RecurrencePartentID, PatientID, TherapistID, StatusID, TimeZoneID, StartTime, EndTime, Subject, Description, Reminder, Recurrence, LastModified FROM Schedule WHERE (TherapistID = @TherapistID)"

DeleteCommand="DELETE FROM [Schedule] WHERE [ApptID] = @ApptID"

InsertCommand="INSERT INTO [Schedule] ([RecurrencePartentID], [PatientID], [TherapistID], [StatusID], [TimeZoneID], [StartTime], [EndTime], [Subject], [Description], [Reminder], [Recurrence], [LastModified]) VALUES (@RecurrencePartentID, @PatientID, @TherapistID, @StatusID, @TimeZoneID, @StartTime, @EndTime, @Subject, @Description, @Reminder, @Recurrence, @LastModified)"

UpdateCommand="UPDATE [Schedule] SET [RecurrencePartentID] = @RecurrencePartentID, [PatientID] = @PatientID, [TherapistID] = @TherapistID, [StatusID] = @StatusID, [TimeZoneID] = @TimeZoneID, [StartTime] = @StartTime, [EndTime] = @EndTime, [Subject] = @Subject, [Description] = @Description, [Reminder] = @Reminder, [Recurrence] = @Recurrence, [LastModified] = @LastModified WHERE [ApptID] = @ApptID">

<DeleteParameters>

<asp:Parameter Name="ApptID" Type="Int32" />

</DeleteParameters>

<InsertParameters>

<asp:Parameter Name="RecurrencePartentID" Type="Int32" />

<asp:Parameter Name="PatientID" Type="Int32" />

<asp:Parameter Name="TherapistID" Type="Int32" />

<asp:Parameter Name="StatusID" Type="Int32" />

<asp:Parameter Name="TimeZoneID" Type="String" />

<asp:Parameter Name="StartTime" Type="DateTime" />

<asp:Parameter Name="EndTime" Type="DateTime" />

<asp:Parameter Name="Subject" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Reminder" Type="String" />

<asp:Parameter Name="Recurrence" Type="String" />

<asp:Parameter Name="LastModified" Type="String" />

</InsertParameters>

<SelectParameters>

<asp:ControlParameter ControlID="ListBox1" Name="TherapistID"

PropertyName="SelectedValue" Type="Int32" />

</SelectParameters>

<UpdateParameters>

<asp:Parameter Name="RecurrencePartentID" Type="Int32" />

<asp:Parameter Name="PatientID" Type="Int32" />

<asp:Parameter Name="TherapistID" Type="Int32" />

<asp:Parameter Name="StatusID" Type="Int32" />

<asp:Parameter Name="TimeZoneID" Type="String" />

<asp:Parameter Name="StartTime" Type="DateTime" />

<asp:Parameter Name="EndTime" Type="DateTime" />

<asp:Parameter Name="Subject" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Reminder" Type="String" />

<asp:Parameter Name="Recurrence" Type="String" />

<asp:Parameter Name="LastModified" Type="String" />

<asp:Parameter Name="ApptID" Type="Int32" />

</UpdateParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"

ConnectionString="<%$ ConnectionStrings:H2T2SQLConnectionString %>"

SelectCommand="SELECT PatientID, PatientFirstName, PatientLastName, PatientDOB, PatientLastName + ' ' + PatientFirstName AS PatientName FROM Patients ORDER BY PatientLastName">

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource3" runat="server"

ConnectionString="<%$ ConnectionStrings:H2T2SQLConnectionString %>"

SelectCommand="SELECT EmployeeID, TherapistFirstName, TherapistLastName, Occupation, TherapistLastName + ' ' + TherapistFirstName + ' ' + Occupation AS TherapistName FROM Therapist WHERE (Occupation = N'SLP') OR (Occupation = N'SLPA') ORDER BY TherapistLastName">

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource7" runat="server"

ConnectionString="<%$ ConnectionStrings:H2T2SQLConnectionString %>"

SelectCommand="SELECT EmployeeID, TherapistFirstName + ' ' + TherapistLastName AS TherapistName FROM Therapist WHERE (EmployeeID = @EmployeeID)">

<SelectParameters>

<asp:ControlParameter ControlID="ListBox1" DefaultValue="32" Name="EmployeeID"

PropertyName="SelectedValue" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource4" runat="server"

ConnectionString="<%$ ConnectionStrings:H2T2SQLConnectionString %>"

SelectCommand="SELECT Appointment FROM StatusInfo WHERE (NOT (Appointment IS NULL))">

</asp:SqlDataSource>

</asp:Content>

Scheduler

answered on 28 Sep 2012

1 answer

132 views

Setting Row Height w/Template

I am using a custom skin for my controls. In my ComboBox.css I have the following CSS code:

.RadComboBox_Hew .rcbInput,

.RadComboBox_Hew .rcbInputCell

{

text-transform: uppercase;

height:auto;

}

This works fine for a radComboBox that doesn't use a header/item template. The row height matches the font height. When used with a radComboBox with a template, the row height is roughly twice the height of the font. What CSS tag do I need to use to control the row height when using a template?

ComboBox

answered on 28 Sep 2012

1 answer

119 views

Nav bar from Scheduler on top of Advanced Insert form

Hello,

For some reason, top view bar (Day, week, month as shown in screenshot) is always on top of my AdvancedInsert form.

Main Page

<

div class="exampleContainer">

<telerik:RadScheduler ID="RadScheduler1" runat="server" DataDescriptionField="LastName"

DataEndField="ApptEnd" DataKeyField="ScheduleID" DataStartField="ApptDate" DataSubjectField="Subject"

DayEndTime="18:00:00" DayStartTime="08:00:00"

SelectedView="WeekView"

EditFormDateFormat="M/d/yyyy"

EditFormTimeFormat="h:mm tt" AllowDelete="False" AllowEdit="False"

AllowInsert="True" Height="" >

<div class="rsAdvancedEdit" style="position: relative; border: 1px solid black; background-color: white;

height: auto;">

<asp:Label ID="Label1" runat="server" Text="Edit Template"></asp:Label>

Test advanced Edit template

</div>

</AdvancedEditTemplate>

<div class="rsAdvancedInsert" style="position: relative; border: 1px solid black;

background-color: white; height: auto;">

test advanced insert

<asp:Button ID="btnInsertAppointment" runat="server" Text="Insert" />

</div>

</AdvancedInsertTemplate>

</div>

</div>

</div>

</div>

<br />

New Appointment

<asp:LinkButton runat="server" ID="AdvancedEditCloseButton" CssClass="rsAdvEditClose" CommandName="Cancel" CausesValidation="false" />

</div>

<uc1:AdvancedInsert ID="advInsert" runat="server" />

</div>

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

</asp:Panel>

</InlineInsertTemplate>

</ExportSettings>

</telerik:RadScheduler>

AdvancedInsert.ascx

all other controls.....

</table>

Scheduler

answered on 28 Sep 2012

3 answers

133 views

Rad editor dialogs - how to localize image manager pager?

Hello,

I have some difficulties to localize RadEditor ImageManager dialog. For all the other dialogs there is a key named:
Common_GridPagerText
in RadEditor.Dialogs.resx file, which successfully localize all pagers in dialogs, except Image manager, where pager is not localized. Is there any other key to translate this pager?

Thank you in advance.

Adam

Editor

answered on 28 Sep 2012

7 answers

872 views

Hide / Disable Expand column

Hello All,

I have a report which show data hierarchical data with three levels of grid.

I have used the nested view template for this.

Also, i have a selection on the top of the page, which allows the user to select the no of nested grids.

So, i need to hide the expand/collapse column based on the selection made.

Let me know, how should i approach to this.

Thanks,

Avi

Grid

answered on 28 Sep 2012

3 answers

255 views

How to get selected value from dropdown for insertCommand

Please help me on this since I am new. Thanks a lot.

I changed the text box to a dropdown as below:

from

        <telerik:GridBoundColumn DataField="name" DefaultInsertValue=""
            HeaderText="name" SortExpression="name" UniqueName="name">
        </telerik:GridBoundColumn>

to
        <telerik:GridDropDownColumn DatasourceID=sqldatasource2 ListValueField=name ListTextField=name
            EnableEmptyListItem=true EmptyListItemText="choose an option" DataField="name"
            datatype=System.String
            HeaderText="name" SortExpression="name" UniqueName="name">
        </telerik:GridDropDownColumn>

the statement below from insertCommand event handler failed since I don't know how to get the selected value from the dropdown

Dim CompanyName As String = TryCast(newItem("name").Controls(0), TextBox).Text

Please help me.
---------------------------------------------------------------------------------------------------------------------

[VB] InsertCommand event handler

'Get the GridEditableItem of the RadGrid

Dim

newItem

As GridEditableItem = TryCast(e.Item, GridEditableItem)

'Access the textbox from the edit form template and store the values in string variables.

Dim

CompanyName As String = TryCast(newItem("CompanyName").Controls(0), TextBox).Text

Dim

Phone As String = TryCast(newItem("Phone").Controls(0), TextBox).Text

Try

'Insert Query execution

SqlDataSource1.InsertCommand =

"INSERT INTO Shippers (CompanyName, Phone) Values ('" +

CompanyName +

"','" + Phone + "')"

SqlDataSource1.Insert()

Catch

ex As Exception

RadGrid1.Controls.Add(

New LiteralControl("Unable to insert Shipper. Reason: " +

ex.Message))

e.Canceled =

True

End Try
--------------------------------------------------------

Grid

answered on 28 Sep 2012

1 answer

69 views

PanelBar and globalization

Hello,

does PanelBat support globalization?
By that, I mean Rad Panel Item text.

br,
Jan

PanelBar

answered on 28 Sep 2012

1 answer

97 views

WCF Data Binding with Stored Proc

Hello all,

How can I use the Radgrid.GetBindingData with a stored procedure? When I replace the 2nd parameter with the name of a stored proc I get compilation errors. Is it possible?

I would greatly appreciate if someone can give me an answer.

GridBindingData data = RadGrid.GetBindingData("xxxxx.WCF.dbPublisherDataContext", "vPublisherQueues", startRowIndex, maximumRows, sortExpression, filterExpression);

Grid

answered on 28 Sep 2012

1 answer

142 views

Multi select Combobox with check boxes as items in radgrid

Hi All,

I want full code releted to Multi select Combobox with check boxes as items in radgrid in silverlight.

Thanks,
Himansu

ComboBox

answered on 28 Sep 2012

3 answers

158 views

WebMail in Telerik

Hai,

I have designed Web Mail using Rad Grid.I have displayed Mails in Rad Grid.On Clicking the mail,I need to the redirect to the another page with the id of the row as querystring.Can anyone pls tell me how to do it?

Grid

answered on 28 Sep 2012