Questions on UI for ASP.NET AJAX Forum

2 answers

131 views

[Solved] Confirm Insert based on DB Query

Hello,

I'm currently working on a DataGrid to show and insert events with an id, name and start- / end date. Trying to achieve a probably comforting, but also useful info for the user, I have following problem:

The user gets a custom edit form as a popup to enter a new event. Now, when clicking on "Insert", he should be notified if there already exists an event (DB side) and confirm again (!) the insert. I read the post here http://www.telerik.com/forums/adding-confirmation-to-update-insert-cancel-buttons which is helpful, but not sufficient to solve this expected behaviour. So in short again:

- after inserting new values for a new event
- click "Insert"
- server-side call the database and check if one or more events exist in given period of the new entry
- if not, just insert entry
- if so, show confirmation dialog "There is already an event. Do you want to continue (inserting) ? "
- if yes, insert
- if no, cancel

Thanks very much!

Regards,

Jan

Grid

answered on 05 May 2014

1 answer

100 views

Changing the background while the grid is refreshing

Hi,
Is there any way to change the background while the grid is refreshing due to filtering. Its like 5-7 sec delay and dont want the user to see a blank screen (grid portion) till then. It could be an image or a text.

Thanks in advance
Kiran

Grid

answered on 05 May 2014

1 answer

96 views

Selecting a value from list box throws an error

Hi,

We have a Telerik Grid and also a list box. When I select a value from the multiple value list box drop down, I'm getting the following error

Unhandled exception at line 15, column 16485
in http://localhost:37039/CrossEntitiesReport UAT Backup_Modify_28_4/
Telerik.Web.UI.WebResource.axd?_
TSM_HiddenField_=RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=;
;System.Web.Extensions,+Version=4.0.0.0,+Culture=neutral,
+PublicKeyToken=31bf3856ad364e35:en-US:5924cf72-83cf-477d-98eb-a608a92942c5:ea597d4b:b25378d2
;Telerik.Web.UI,+Version=2012.2.912.35,+Culture=neutral,+
PublicKeyToken=121fae78165ba3d4:en-US:9957980a-8113-4265-a8ae

Please let me know the solution for this

Thanks in advance

ListBox

answered on 05 May 2014

6 answers

421 views

[Solved] Combo box in inside EditFormSetting FormTemplate

Can you have a Combobox inside:

<EditFormSettings EditFormType="Template">

<FormTemplate>

??? combo bound to datafield from grid????

</FormTemplate>

</EditFormSettings>

Grid

answered on 05 May 2014

5 answers

205 views

[Solved] RadGrid1_ItemCommand Can't get cell value

I have this block of code which worked at the prior version (VS 2010, older RadGrid control). Now I upgraded to VS 2013 and use RadGrid control in version 2013.3.114.45, I can't figure out why I can't get the "ApplicationId" value from e.item.

Please see code below:
private void LoadData()
        {
            if (RadGrid1.Items.Count > 0) RadGrid1.DataSource = new Object[0];            //If Academic year is selected
            if (editAcademicYear.SelectedValue !="Select One")
            {
                var academicyear = (from ay in context.AcademicYears
                                    where ay.Name == editAcademicYear.SelectedValue
                                    select ay).First();
                yearID = academicyear.AcademicYearID;
            }   if (rbLName.Checked)
   {
    if (editSName.Text.Length > 0)
    {
     if (yearID > 0)
     {
      application = from s in context.Applications.Include("AcademicYear")
           where s.LastName.StartsWith(editSName.Text.Trim()) &&
           s.AcademicYear.AcademicYearID == yearID
           orderby s.LastName, s.FirstName
           select s;
     }
     else
     {
      application = from s in context.Applications
           where s.LastName.StartsWith(editSName.Text.Trim())
           orderby s.LastName, s.FirstName
           select s;
     }
     ShowApps(application, application.Count());   //Show data to RadGrid1 for selection.    }
    else
    {
     lblmissing.Visible = true;
     lblmissing.Text = "Please enter the last name.";
     return;
    }
   }
         }

//question: how can I get the value for dataItem below? What is wrong here?
protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {

            LoadData();
            //from debugging, I saw "application" value, but I did not see value
              from RadGrid1 or its "items".            try
            {
                if (e.Item.ItemIndex > -1)
                {
                    var dataItem = e.Item as GridDataItem;   //dataItem has no value here
                    string appid = dataItem["ApplicationId"].Text;    //therefore, appid has no value
                    Response.Redirect("DisplayApp.aspx?appid=" + appid);
                }
            }
            catch (Exception ex)
            {
                logger.ErrorException("Could not get appid from the grid row", ex);
                lblMessage.Visible = true;
                RadGrid1.Visible = false;
                lblMessage.Text = "<b>Error exists in the grid level. Please contact the Care Tech Support.</b>";
            }
    }

I have spent a few hours searching, the site is in production, but just can't get the "appid" of the selected row to display the detail page. Your quick response is much appreciated.

Thanks in advance!

Grid

answered on 05 May 2014

1 answer

90 views

Shaping PanelBar data with Underscore

Hi All:

I was working with underscore and figured out that I could reformat the data for the PanelBar control.
Here is my example code:

//

$(function () {

//

var meetingDataSource = new kendo.data.DataSource({

data: [

{ MeetingId: 65, Year: 2014, MeetingDate: '2014-05-14 18:00:00', Title: "30 tools for modern .net web development in 60 minutes" },

{ MeetingId: 64, Year: 2014, MeetingDate: '2014-04-09 18:00:00', Title: "azure websites deep dive" },

{ MeetingId: 63, Year: 2014, MeetingDate: '2014-03-12 18:00:00', Title: "cancelled" },

{ MeetingId: 62, Year: 2014, MeetingDate: '2014-02-12 18:00:00', Title: "getting to know windows azure mobile services" },

{ MeetingId: 60, Year: 2013, MeetingDate: '2013-12-11 18:00:00', Title: "custom graphics for your web application: the html5 canvas and kinetic.js" },

{ MeetingId: 59, Year: 2013, MeetingDate: '2013-11-13 18:00:00', Title: "four platforms. one codebase. xamarin." },

{ MeetingId: 58, Year: 2013, MeetingDate: '2013-10-09 18:00:00', Title: "it’s cheaper than therapy: building an “eliza” psychotherapist app in windows 8" },

{ MeetingId: 57, Year: 2013, MeetingDate: '2013-09-11 18:00:00', Title: "if typescript is the answer, what is the question?" }

]

});

//

meetingDataSource.fetch(function () {

//

var meetings = meetingDataSource.data();

//

var years = _.chain(meetings)

.pluck('Year')

.uniq()

.value();

//

var shapedData = _.reduce(years, function (memo, year) {

var exp = false;

if (memo.length == 0) exp = true;

//

var det = _.chain(meetings)

.filter(function (meeting) { return meeting.Year == year; })

.map(function (meeting) {

var m = meeting;

return { value: m.MeetingId, text: m.Title };

})

.value();

memo.push({ value: year, text: year, expanded: exp, items: det });

return memo;

}, []);

//

$("#inline-listview").kendoPanelBar({

dataSource: shapedData,

expandMode: "single"

}).data("kendoPanelBar");

});

//

});

I read the data with a dataSource fetch command. In the fetch function, I first extract the years for the level 0 of the panel-bar, then I use the years as input for the reduce function and reprocess the input data. The years are the level 0 and the level 1 is the reprocessed data.

Phil

PanelBar

answered on 04 May 2014

6 answers

153 views

[Solved] Radgrid demo WebUserTemplate not inserting/updating

I have copied as it is this demo but I am unable to insert/update the records.

private static DataTable GetDataTable(string queryString)

{

String connString = ConfigurationManager.ConnectionStrings["NORTHWNDConnectionString"].ConnectionString;

SqlConnection mySqlConnection = new SqlConnection(connString);

SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();

mySqlDataAdapter.SelectCommand = new SqlCommand(queryString, mySqlConnection);

DataTable myDataTable = new DataTable();

mySqlConnection.Open();

try

{

mySqlDataAdapter.Fill(myDataTable);

}

finally

{

mySqlConnection.Close();

}

return myDataTable;

}

private DataTable Employees

{

get

{

object obj = this.Session["Employees"];

if ((!(obj == null)))

{

return ((DataTable)(obj));

}

DataTable myDataTable = new DataTable();

myDataTable = GetDataTable("SELECT * FROM Employees");

this.Session["Employees"] = myDataTable;

return myDataTable;

}

protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)

{

this.RadGrid1.DataSource = this.Employees;

this.Employees.PrimaryKey = new DataColumn[] { this.Employees.Columns["EmployeeID"] };

}

protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)

{

GridEditableItem editedItem = e.Item as GridEditableItem;

UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);

//Prepare new row to add it in the DataSource

DataRow[] changedRows = this.Employees.Select("EmployeeID = " + editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["EmployeeID"]);

if (changedRows.Length != 1)

{

RadGrid1.Controls.Add(new LiteralControl("Unable to locate the Employee for updating."));

e.Canceled = true;

return;

}

//Update new values

Hashtable newValues = new Hashtable();

newValues["Country"] = (userControl.FindControl("TextBox7") as TextBox).Text;

newValues["City"] = (userControl.FindControl("TextBox8") as TextBox).Text;

newValues["Region"] = (userControl.FindControl("TextBox9") as TextBox).Text;

newValues["HomePhone"] = (userControl.FindControl("HomePhoneBox") as RadMaskedTextBox).Text;

newValues["BirthDate"] = (userControl.FindControl("BirthDatePicker") as RadDatePicker).SelectedDate.ToString();

newValues["TitleOfCourtesy"] = (userControl.FindControl("ddlTOC") as DropDownList).SelectedItem.Value;

newValues["Notes"] = (userControl.FindControl("TextBox1") as TextBox).Text;

newValues["Address"] = (userControl.FindControl("TextBox6") as TextBox).Text;

newValues["FirstName"] = (userControl.FindControl("TextBox2") as TextBox).Text;

newValues["LastName"] = (userControl.FindControl("TextBox3") as TextBox).Text;

newValues["HireDate"] = (userControl.FindControl("HireDatePicker") as RadDatePicker).SelectedDate.ToString();

newValues["Title"] = (userControl.FindControl("TextBox4") as TextBox).Text;

changedRows[0].BeginEdit();

try

{

foreach (DictionaryEntry entry in newValues)

{

changedRows[0][(string)entry.Key] = entry.Value;

}

changedRows[0].EndEdit();

this.Employees.AcceptChanges();

}

catch (Exception ex)

{

changedRows[0].CancelEdit();

Label lblError = new Label();

lblError.Text = "Unable to update Employees. Reason: " + ex.Message;

lblError.ForeColor = System.Drawing.Color.Red;

RadGrid1.Controls.Add(lblError);

e.Canceled = true;

}

protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)

{

UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);

//Create new row in the DataSource

DataRow newRow = this.Employees.NewRow();

//Insert new values