Questions on UI for ASP.NET AJAX Forum

3 answers

215 views

Do Stored Procedures work with RadGrid Controls?

Do Stored Procedures work with the RadGrid Controls? It appears that my Insert stored procedure has no effect on the RadGrid control and everytime I try to enter a new record, no new records get inserted. The following is my stored procedure:

    
            USE [EmployeeScreening]  
        
            GO  
        
            /****** Object:  StoredProcedure [dbo].[InsertMemberFamilyInfo]    Script Date: 07/15/2009 06:45:46 ******/  
        
            SET ANSI_NULLS ON 
        
            GO  
        
            SET QUOTED_IDENTIFIER ON 
        
            GO  
        
            -- =============================================  
        
            -- Author:      <user>  
        
            -- Create date: <07/13/09>  
        
            -- Description: <Insert Employee Family Information>  
        
            -- =============================================  
        
            ALTER PROCEDURE [dbo].[InsertMemberFamilyInfo]  
        
                -- Add the parameters for the stored procedure here   
        
                @MemberFamilyID             int = NULL OUTPUT,  
        
                @EmployeeID                 int,  
        
                @MemberFamilyNumber         int,  
        
                @Allergies                  nvarchar(50),  
        
                @Weight                     int,  
        
                @Age                        int,  
        
                @DateOfBirth                datetime,  
        
                @MemberFamilyCreatedDate    datetime,  
        
                @MemberFamilyCreatedBy      nvarchar(50)  
        
            AS 
        
            BEGIN 
        
                    -- Insert statements for procedure here  
        
                INSERT INTO MemberFamilyInfo (EmployeeID, MemberFamilyNumber, Allergies,  
        
                Weight, Age, DateOfBirth, MemberFamilyCreatedDate, MemberFamilyCreatedBy) VALUES 
        
            (@EmployeeID, @MemberFamilyNumber, @Allergies, @Weight, @Age, @DateOfBirth,  
        
            @MemberFamilyCreatedDate, @MemberFamilyCreatedBy);  
        
            SET @MemberFamilyID = SCOPE_IDENTITY();  
        
                END;  
        
            DECLARE @ID INT;  
        
            EXEC dbo.InsertMemberFamilyInfo @MemberFamilyID = @ID OUT,  
        
            @EmployeeID = 1,  
        
            @MemberFamilyNumber = 1,  
        
            @Allergies='',  
        
            @Weight=1,  
        
            @Age = 99,  
        
            @DateOfBirth='19000101',  
        
            @MemberFamilyCreatedDate = '20090714',  
        
            @MemberFamilyCreatedBy = 'Me' 
        
            SELECT @ID ID;

General Discussions

answered on 15 Jul 2009

3 answers

116 views

Icones

Hi,

I put an AppTemplate on my RadScheduler.

here is my code :

public class AppTemplate : ITemplate

{

public void InstantiateIn(Control container)

{

var subject = new Literal();

subject.DataBinding += subject_DataBinding;

container.Controls.Add(subject);

}

private static void subject_DataBinding(object sender, EventArgs e)

{

var subject = (Literal)sender;

var aptCont = (SchedulerAppointmentContainer)subject.Parent;

Appointment app = aptCont.Appointment;

var myId = app.ID.ToString().Split('_');

int idCalendar = Convert.ToInt32(myId[0]);

var calendar = new BLLCalendar().getCalendar(idCalendar);

String numAffaire;

try

{

numAffaire = calendar.Affaire.Num;

}

catch

{

//var user = new BLLUser().getUser(calendar.IdUser);

//numAffaire = user.NumeroService;

numAffaire = calendar.CodeHeure1.Libelle;

}

if (calendar.IsValider)

{

app.ForeColor = Color.Green;

}

if (calendar.IsSaisie)

{

app.ForeColor = Color.Red;

app.AllowEdit = false;

app.AllowDelete = false;

}

subject.Text = String.Format("{0} - {1}", numAffaire, calendar.Temps);

app.ToolTip = calendar.Commentaire;

app.CssClass = SchedulerCSS.getCSSHeures(calendar.CodeHeure);

}

With this I have questions :

- Is it possible to add the recurrence Icon or other Icons on appointment ?

- Why with some SchedulerCSS the proprety app.ForeColor = Color.Red; doesn't work ?

thank you.

PS : Q2 is great !!!!

Scheduler

answered on 15 Jul 2009

2 answers

129 views

[Solved] Chart: Custom message when there are no series

Hi,
How shall i show custom message when there is no series in the datasource, instead of showing the default one
"There is no or empty series".

Thanks,
Avi

Chart (Obsolete)

answered on 15 Jul 2009

1 answer

75 views

Underline any one character in RadTabStrip Caption(text)

Dear Sir,
I want to underline any one character in the RadTabStrip controls caption to make it as a Shortcut key.

For Example:
           From the MenuBar of Microsoft Word contains
                File,Edit and etc.. as F and E are underlined.

Note:
    How can I attach jpeg image and sample files to the forum.
    Please Reply for this also..

By Suriya.

TabStrip

answered on 15 Jul 2009

0 answers

89 views

Resize document

Hi All,
I have a set or rows, when I click on view button after selecting more than 1 row, a new window opens in which on the left hand side I have a list of selected documents and on the right hand side I have the first document open. I want the margin between the left and the right hand side to be able to get dragged. ie. the left and right hand side should be resizable.

Can anyone please help me with this??

thanks,
Amol Parikh

General Discussions

asked on 15 Jul 2009

5 answers

136 views

[Solved] Change column sort indicator to be more noticable

Hi All,
is there anyway we can change the column sort indicator to be more noticable. It would be great if somebody could please help me??

thanks,
Amol Parikh.

General Discussions

answered on 15 Jul 2009

2 answers

85 views

RadWindow component not found JScript runtime error

We are using RadWindow as a Login Window with RadWindowManager. After successful login and redirection to main page, it raises below error at random when we try to make this RadWindow as visible = false..

"Microsoft JScript runtime error: Sys.InvalidOperationException: Component 'LoginWindow' was not found."
Here, LogineWindow is a RadWindow object.

It throws this error from:-

function Sys$Component$_setReferences(component, references) {
    for (var name in references) {
        var setter = component["set_" + name];
        var reference = $find(references[name]);
        if (typeof(setter) !== 'function') throw new Error.invalidOperation(String.format(Sys.Res.propertyNotWritable, name));
        if (!reference) throw Error.invalidOperation(String.format(Sys.Res.referenceNotFound, references[name]));
        setter.apply(component, [reference]);
    }
}

This problem is raised in your latest Beta released version 2009.2.701.35. Before that, we were using 2008.3.1125.35 version without any problem with no change in code.

Please let us know, if any adjustment is required while working with RadWindow.

Waiting for your reply.

Venu

Window

answered on 15 Jul 2009

5 answers

161 views

[Solved] MasterEditTemplate remains visible after update

Hello,

I have a RadGrid that contains a MasterEditTemplate for editing records that is working fine (like the the other 4 RadGrids contained in this template), but for some reason it remains visible after the update.

If I place the grid in edit mode using the custom <CommandTemplate> and then click the cancel link the template closes as it should. Yet i when I place the grid in edit mode (clicking the AutoGeneratedEdit column icon) and update the database the template remains visible. I can confirm that the "UpdateSponsoredLinkSponsor()" call returns true and is assigned to the e.Cancelled member of the GridCommandEventArgs parameter to the event. In every other case on the web template this closes the MasterEditTemplate but not in this one.

                    protected void grdSponsoredLinkSponsor_ItemCommand(object source, GridCommandEventArgs e)         
                {             
                     
                    Controller controller = GlobalMethods.GetController();         
                    switch ( e.Item.OwnerTableView.Name )         
                    {         
                        case "SponsoredLinkSponsor":         
                            {         
                                switch ( e.CommandName )         
                                {         
                                    case RadGrid.InitInsertCommandName:         
                                        {         
                                            ..         
                                        }         
                                    case RadGrid.PerformInsertCommandName:         
                                        {         
                                            ..         
                                        }         
                                    case RadGrid.EditCommandName:         
                                        {         
                                           ..         
                                        }         
                                    case RadGrid.UpdateCommandName:         
                                        {         
                                            Guid primaryKey = (Guid) e.Item.OwnerTableView.DataKeyValues[0]["PrimaryKey"];         
                                            SponsoredLinkSponsor activeSponsoredLinkSponsor = (SponsoredLinkSponsor) controller.DataCache.GetObject(primaryKey);                                         
                     
                                            e.Canceled = !UpdateSponsoredLinkSponsor(activeSponsoredLinkSponsor);         
                                            if ( e.Canceled == false )         
                                            {                                             
                                                ...         
                                                grdSponsoredLinkSponsor.Rebind();         
                                            }         
                                            break;         
                                        }         
                                break;         
                            }         
                    }         
                         

I have placed a copy of the .aspx and .cs files on my server in a public folder here:

http://www.agoware.com/publicdownloads/MasterEditTemplate_Persistance.zip

Can anyone tell me what might be going on here? Again the update method returns true.

Thanks

Grid

answered on 15 Jul 2009

1 answer

70 views

Change CSS on Button Submit

Not sure if this has been explored but would it be possible to change the Tab CSS based on if a button was submitted on a page?

If there are 5 tabs in the strip, after the button is clicked, the tab color would need to change.

Thanks for any help.

TabStrip

answered on 15 Jul 2009

3 answers

132 views

Calendar Skin

Hi ,
I have trying to get the same look and feel of the rad date picker as on the web site for out look and vista skin but somehow when i click open the calendar the skin is not getting applied, it is just plain. Please could you provide any ideas.

Regards,
Ajit

Calendar

answered on 15 Jul 2009