Telerik Forums
Kendo UI for jQuery Forum
2 answers
134 views
Hi, I have been trying all kinds of tricks to get the 'create' working on my grid. Please find attached my Controller and View.

<!----------------------------------------------CONTROLLER------------------------------------------------------------------------>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web;
using System.Web.Http;
using AttributeRouting.Web.Http;
using HomeBudget.Models;
using HomeBudget.ViewModels;


// ReSharper disable UnusedMember.Global
// ReSharper disable FieldCanBeMadeReadOnly.Local
namespace HomeBudget.Controllers
{
    public class ProductController : ApiController
    {
        IRepository _repository = new Repository();
        private HttpRequest _request = HttpContext.Current.Request;


        public Response Get()
        {
            int take = _request["take"] == null ? 10 : int.Parse(_request["take"]);
            int skip = _request["skip"] == null ? 0 : int.Parse(_request["skip"]);


            var products = (from p in _repository.GetAllItems<Product>()
                           select new ProductViewModel
            {
                ProductID = p.ProductID,
                ProductName = p.ProductName,
                CategoryName = _repository.GetLookupValue<Category>(info => info.CategoryID == p.CategoryID, info => info.CategoryName),
                //Category = p.Category,
                Discontinued = p.Discontinued
            }).Skip(skip).Take(take).ToArray();


            return new Response(products, _repository.GetAllItems<Product>().Count);
        }


        public Response Delete(Guid id)
        {
            try
            {
                var product = _repository.GetAllItems<Product>().SingleOrDefault(info => info.ProductID == id);
                _repository.Delete(product);
                _repository.SaveAllChanges();
                return new Response();
            }
            catch (Exception ex)
            {
                return new Response(string.Format("There was an error deleting object popup: custom editors", id.ToString(), ex.Message));
            }
        }
        
        [POST("api/product/create")]
        public Response Create()
        {
            try
            {
                var product = _repository.Create<Product>();
                return new Response(product);
            }
            catch (Exception ex)
            {
                return new Response("There was an error creating object popup: custom editors");
            }
        }


        [POST("api/product/{id}")]
        public HttpResponseMessage Post(Guid id)
        {
            var response = new HttpResponseMessage();
            try
            {
                var product = _repository.GetItemById<Product>(info => info.ProductID == id);
                if (product != null)
                {
                    product.ProductName = string.IsNullOrEmpty(_request["ProductName"]) ? product.ProductName : _request["ProductName"];
                    product.UnitPrice = _request["UnitPrice"] == null ? product.UnitPrice : Convert.ToDecimal(_request["UnitPrice"]);
                    _repository.SaveAllChanges();
                    response.StatusCode = HttpStatusCode.OK;
                }
                else
                {
                    response.StatusCode = HttpStatusCode.InternalServerError;
                    response.Content = new StringContent(string.Format("The employee with id popup was not found in the database", id.ToString()));
                }
            }
            catch (Exception ex)
            {
                response.StatusCode = HttpStatusCode.InternalServerError;
                response.Content = new StringContent(string.Format("The database updated failed: popup", ex.Message));
            }
            return response;
        }
    }
}


<!----------------------------------------------PAGE------------------------------------------------------------------------>


<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeBehind="Default.aspx.cs" Inherits="HomeBudget._Default" %>


<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<html>
<head>
    <title>Products</title>
    <link href="Content/kendo/2012.2.710/kendo.common.min.css" rel="stylesheet" type="text/css" />
    <link href="Content/kendo/2012.2.710/kendo.default.min.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <div id="productGrid"></div>


    <script src="Scripts/jquery-1.8.2.js" type="text/javascript"></script>
    <script src="Scripts/kendo/2012.2.710/kendo.web.min.js" type="text/javascript"></script>
    
    <script type="text/javascript">


        $(function () {
            $("#productGrid").kendoGrid({
                editable: "inline",
                toolbar: ["create", "edit", "destroy"],
                pageable: true,
                selectable: "multiple cell",
                scrollable: false,
                navigatable: true,
                columns: [
                    { field: "ProductName", title: "Product" },
                    { field: "CategoryName", title: "Category" },
                    //{ field: "Category", title: "Category2", width: "150px", editor: categoryDropDownEditor, template: "#=Category.CategoryName#" },
                    { field: "UnitPrice", title: "UnitPrice" },
                    { field: "Discontinued", title: "Discontinued?" },
                    { command: ["edit", "destroy"], title: " " }
                ],
                dataSource: new kendo.data.DataSource({
                    transport: {
                        read: "api/product",
                        update: {
                            url: function (product) {
                                return "api/product/" + product.ProductID;
                            },
                            type: "POST"
                        },
                        destroy: {
                            url: function (product) {
                                return "api/product/" + product.ProductID;
                            },
                            type: "DELETE"
                        },
                        create: {
                            url: function () {
                                return "api/product/create";
                            },
                            type: "POST"
                        }
                    },
                    pageSize: 10,
                    serverPaging: true,
                    serverSorting: true,
                    schema: {
                        data: "Data",
                        total: "Count",
                        errors: "Errors",
                        model: {
                            id: "ProductID",
                            fields: {
                                ProductID: { editable: false, nullable: true },
                                PropductName: { editable: true, validation: { required: true} },
                                UnitPrice: { type: "number", editable: true, nullable: true },
                                Discontinued: { type: "boolean", editable: true, nullable: true },
                                CategoryName: { editable: true, nullable: true }
                                //Category: { editable: true, nullable: true }
                            }
                        }
                    },
                    error: function (e) {
                        alert("The action failed. Please consult the web master.");
                        this.cancelChanges();
                    }
                }),
                change: function (e) {
                    var product = this.dataSource.getByUid(this.select().data("uid"));
                    console.log(product.ProductID);
                },
                parameterMap: function (options, operation) {
                    if (operation !== "read" && options.models) {
                        return { models: kendo.stringify(options.models) };
                    }
                }
            });
        });
        
        function categoryDropDownEditor(container, options) {
            var data = [
                { text: "Food", value: "3F3CC554-5577-412D-BF12-6161E6198181" },
                { text: "Toiletries", value: "3F3CC554-5577-412D-BF12-7161E6198181" }
            ];
            $('<input data-text-field="CategoryName" data-value-field="CategoryID" data-bind="value:' + options.field + '"/>')
                .appendTo(container)
                .kendoDropDownList({
                    autoBind: false,
                    dataSource: data,
                    dataTextField: "text",
                    dataValueField: "value"
                });
        }
    </script>
</body>
</html>
</asp:Content>



Please help.
Jon
Top achievements
Rank 1
 answered on 11 Oct 2012
5 answers
1.0K+ views
Hi,

Anyone know how to resizing window of popup editor?
like resizing width and height.
Nohinn
Top achievements
Rank 1
 answered on 11 Oct 2012
1 answer
154 views
has anyone else come across the issue of filtering on a Custom Editor Column?

Following This Editor Example, after trying to add a filter, i notice that you can't filter on the column.
Daniel
Telerik team
 answered on 11 Oct 2012
1 answer
124 views
My Banks dropdownlist is populated, but once I select a bank, it never fires the JsonResult of the Accounts dropdown.  I feel like I'm doing exactly what the demos are, but I must be missing something.  Any Help would be greatly appreciated.

My Popup Template.cshtml:

<table id="table">
    <tr>
        <td>
            Bank
        </td>
        <td>
            @(Html.Kendo().DropDownList()
          .Name("banks")
                  .OptionLabel("-- Select Item --")
          .DataTextField("BankName")
          .DataValueField("BankId")
          .DataSource(source => {
               source.Read(read =>
                               {
                                   read.Action("GetCascadeBanks", "Home");
                               });
          })

                  ) 
        </td>
    </tr>
    <tr>
        <td>
            Account
        </td>
        <td>
            <script>
                function filterAccounts() {
                    return {
                        banks: $("#banks").val()
                    };
                }
            </script>
           
            @(Html.Kendo().DropDownList()
          .Name("accounts")
                  .OptionLabel("-- Select Item --")
          .DataTextField("AccountName")
          .DataValueField("AccountID")
          .DataSource(source => {
              source.Read(read =>
              {
                  read.Action("GetCascadeAccounts", "Home")
                      .Data("filterAccounts");
              })
              .ServerFiltering(true);
          })
          .Enable(false)
          .AutoBind(false)
          .CascadeFrom("banks")
                  )
        </td>
    </tr>
</table>


HomeController:

public JsonResult GetCascadeBanks()
        {
            var ortbanks = from bank in db.ORTBanks
                           orderby bank.BankName

                           select new TreasuryCreateItem()
                                      {
                                          BankID = bank.BankID,
                                          BankName = bank.BankName,
                                      };

            return Json(ortbanks, JsonRequestBehavior.AllowGet);
        }

        public JsonResult GetCascadeAccounts(int banks)
        {
            var ortaccounts = from account in db.ORTAccounts
                              where account.AccountName != string.Empty
                           orderby account.AccountName

                           select new TreasuryCreateItem()
                           {
                               AccountID = account.AccountID,
                               AccountName = account.AccountName,
                           };

            var accountsInBank = from p in ortaccounts where p.BankID == banks select p;

            return Json(accountsInBank, JsonRequestBehavior.AllowGet);
        }



Alex
Top achievements
Rank 1
 answered on 11 Oct 2012
0 answers
86 views
I use incell edit mode.
Can I add a row with out focus on it?

For example I want to add a row when I edit another row, and I want to continue editing.
Alex
Top achievements
Rank 1
 asked on 11 Oct 2012
1 answer
134 views
Hi!
I try to use grid created by javascript. Transport for create is:
var transport = {
                create: {
                    url: "@Url.Action("Create", "Pledge")",
                    contentType: "application/json; charset=utf-8",
                    dataType: "jsonp"
                }
            };

For create method I use MVC4 Action something like this:
public ActionResult Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<MyModel> models). 

In models I have created elements. But all of this elements are empty. Can anyone help me with this issue?
Maybe I need to change type of transport create or something like this? 
Alex
Top achievements
Rank 1
 answered on 11 Oct 2012
0 answers
104 views
how to set vertical Slider with range like horizontal Slider

thx@!!!!!!!!!!
xu
Top achievements
Rank 1
 asked on 11 Oct 2012
0 answers
64 views
Hi,

I have noticed that when selecting a date in a datetimepicker that is from a different month than the current one, it automatically defaults the time to 00:00. This thing does not happen when changing the date with one from the current month. 

Is this the intended behavior? This behavior can be seen also in the demo for the Date/Time Picker.

Thanks and have a nice day,
Bogdan
Top achievements
Rank 1
 asked on 11 Oct 2012
0 answers
104 views
I cannot select the number of items shown on each page with mouse clicks.
I can however select the drop down and move the selection via arrow keys.

My code:

$(document).ready(function () {
    $("#grid").kendoGrid({
        dataSource: {
 
            type: "json",
 
            transport: {
                read: {
                    url: '<%= Url.Action("GetDepartmentOffers", "Projects") %>',
                    dataType: "json",
                    type: "POST",
                    data: {
                        departmentId: 1,
                        filter: 'all'
                    }
                }
            },
            schema: {
                model: {
                    fields: {
                        status: { type: "string" },
                        ResponsibleUserName: { type: "string" },
                        OfferNumber: { type: "string" },
                        DueDate: { type: "date" },
                        ContactPhone: { type: "string" },
                        CompanyName: { type: "string" },
                        ContactPerson: { type: "string" },
                        ContactEmail: { type: "string" },
                        Description: { type: "string" },
                        SalesPrice: { type: "string" },
                        Coverage: { type: "string" }
                    }
                },
                total: function () { return 4677; }
            },
            pageSize: 50,
            serverPaging: false,
            serverFiltering: false,
            serverSorting: false
        },
        autoBind: true,
        groupable: true,
        sortable: true,
        reorderable: true,
        resizable: true,
        pageable: {
            messages: {             // To be translated
                display: "kendo.data.DataSource - {1} of {2} items",
                empty: "No items to display",
                page: "Page",
                of: "of kendo.data.DataSource",
                itemsPerPage: "visninger pÃ¥ hver side.",
                first: "GÃ¥ til første side.",
                previous: "GÃ¥ til forrige side.",
                next: "Go to the next page",
                last: "Go to the last page",
                refresh: "Refresh"
            },
            refresh: true,
            pageSizes: true,
            pageSizes: [10, 20, 50, 100]
        },
        columns:
        [
            {
                field: "status",
                width: 90,
                title: '<%= Global.State %>'
            }, {
                field: "",
                width: 90,
                title: '<%= Global.Actions %>'
            }, {
                field: "ResponsibleUserName",
                width: 100,
                title: '<%= OffersOverview.ColumnHeaderUser %>'
            }, {
                field: "OfferNumber",
                width: 100,
                title: '<%= OffersOverview.ColumnHeaderOfferNumber %>'
            }, {
                field: "DueDate",
                width: 100,
                title: '<%= Global.DueDate %>',
                format: "{0:" + settings.dateFormat + "}"
                //format: //"{0:MM/dd/yyyy}"
            }, {
                field: "ContactPhone",
                width: 100,
                title: '<%= Global.ContactPhone %>'
            }, {
                field: "CompanyName",
                width: 100,
                title: '<%= Global.Company %>'
            }, {
                field: "ContactPerson",
                width: 100,
                title: '<%= Global.ContactPerson %>'
            }, {
                field: "ContactEmail",
                width: 100,
                title: '<%= Global.ContactMail %>'
            }, {
                field: "Description",
                width: 100,
                title: '<%= Global.Description %>'
            }, {
                field: "SalesPrice",
                width: 100,
                title: '<%= Global.SalesPrice %>'
            }, {
                field: "Coverage",
                width: 100,
                title: '<%= Global.Coverage %>'
            }
        ]
    });
});

Any ideas? :)
Thomas
Top achievements
Rank 1
 asked on 11 Oct 2012
2 answers
323 views
Hi friends,

Please suggest me .. can we integrate kendo ui  features in drupal?
Help me.


Regards
Divya
Nick
Top achievements
Rank 1
 answered on 11 Oct 2012
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
DatePicker
Spreadsheet
Upload
ListView (Mobile)
ComboBox
TabStrip
MultiSelect
AutoComplete
ListView
Menu
Templates
Gantt
Validation
TreeList
Diagram
NumericTextBox
Splitter
PanelBar
Application
Map
Drag and Drop
ToolTip
Calendar
PivotGrid
ScrollView (Mobile)
Toolbar
TabStrip (Mobile)
Slider
Button (Mobile)
Filter
SPA
Drawing API
Drawer (Mobile)
Globalization
LinearGauge
Sortable
ModalView
Hierarchical Data Source
Button
FileManager
MaskedTextBox
View
Form
NavBar
Notification
Switch (Mobile)
SplitView
ListBox
DropDownTree
PDFViewer
Sparkline
ActionSheet
TileLayout
PopOver (Mobile)
TreeMap
ButtonGroup
ColorPicker
Pager
Styling
Chat
MultiColumnComboBox
Dialog
DateRangePicker
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
TextBox
OrgChart
Accessibility
Effects
PivotGridV2
Licensing
ScrollView
Switch
TextArea
BulletChart
QRCode
ResponsivePanel
Wizard
CheckBoxGroup
Localization
Barcode
Breadcrumb
Collapsible
MultiViewCalendar
Touch
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
TaskBoard
Popover
DockManager
TimePicker
FloatingActionButton
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
BottomNavigation
Ripple
SkeletonContainer
Avatar
Circular ProgressBar
FlatColorPicker
SplitButton
Signature
Chip
ChipList
VS Code Extension
AIPrompt
PropertyGrid
Sankey
Chart Wizard
OTP Input
SpeechToTextButton
InlineAIPrompt
StockChart
ContextMenu
DateTimePicker
RadialGauge
ArcGauge
AICodingAssistant
SmartPasteButton
PromptBox
SegmentedControl
+? more
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?