Skip to main content

on demand parameter in kendo grid load

On demand event

  // Bouquet combo change event  
   $('#BooketID').live('change', function () {  
     FillChannelGridByBouquetID();  
   });

set parameter for grid load

 /* Load kendo grid by bouquetID*/  
   function FillChannelGridByBouquetID() {  
     var a = {};  
     a.BooketID = $("#BooketID option:selected").val();  
     var mAGrid = $('#CustomerPackageChannelKendoGrid').data('kendoGrid');  
     mAGrid.dataSource.read(a);  
     }

Grid

 $("#CustomerPackageChannelKendoGrid").kendoGrid({  
     dataSource:  
     {  
       transport:  
       {  
         read: "ChannelReadByBooketID",  
       },  
       schema:  
       {  
         model:  
         {  
           fields:  
           {  
             SelectColumn: {type: "boolean"},  
             ChannelID: { type: "string" },  
             BooketName: { type: "string" },  
             ChannelName: { type: "string" },  
           }  
         }  
       },  
       pageSize: 20,  
       serverPaging: false,  
       serverFiltering: false,  
       serverSorting: false  
     },  
     height: 200,  
     filterable: true,  
     groupable: true,  
     sortable: true,  
     resizable: true,                                  
     pageable:  
     {  
       refresh: false,  
       pageSizes: [20, 40, 60, 80, 100]  
     },  
     columns:  
     [  
       {  
         field: "SelectColumn", title: " ", width: "5%",  
         template: "<input type='checkbox' #= SelectColumn ? checked='checked':'' # class='chkbx' />"  
       },  
       { field: "ChannelID", title: "ChannelID", hidden: true, filterable: false, sortable: false },  
       { field: "BooketName", title: "Bouquet Name", width: "30%" },  
       { field: "ChannelName", title: "Channel Name", width: "30%" },  
     ]  
   });

Controller:

 public JsonResult ChannelReadByBooketID(CustomerPackageViewModel booketModel)  
     {  
       var models = GetAllChannelByBooketID(booketModel.BooketID.ToString());  
       return Json(models, JsonRequestBehavior.AllowGet);  
     }     
  private List<ChannelViewModel> GetAllChannelByBooketID(string pBooketID)  
     {  
       Guid gBooketID;  
       if (!Guid.TryParse(pBooketID, out gBooketID))  
       {  
         return null;  
       }  
       var ViewModels = _bCService.BillingUnit.ChannelRepository.Get(t => t.BooketID == gBooketID).ToList().Select(  
          md => new ChannelViewModel  
          {  
            ChannelID = md.ChannelID,  
            ChannelName = md.ChannelName,  
            BooketID = md.BooketID,  
            BooketName = md.DJBL_tblBooket.BooketName  
          }).OrderBy(o => o.BooketName);  
       return ViewModels.ToList();  
     }


Labels:

Comments

Post a Comment

Popular posts from this blog

WPF datagrid cell textbox change event

Entity/Class: public class FeesDetails : INotifyPropertyChanged { public int Id { get; set; } public string FeesName { get; set;} public string FeesDetailsName { get; set; } public int? PaidAmount { get; set; } public event PropertyChangedEventHandler PropertyChanged; private void NotifyPropertyChanged(System.String info) { if (PropertyChanged != null) { PropertyChanged(this, new PropertyChangedEventArgs(info)); } } public int feesAmount { get; set; } public int FeesAmount { get { return this.feesAmount; } set { if (value != this.feesAmount) { this.feesAmount = value; NotifyPropertyChanged("FeesAmount"); } } } } XAML: <DataGrid AutoGenerateColumns="False" Height="21
Post a Comment
Read more

ASP.NET MVC razor SAP Crystal report

Crete a new project: Add a aspx Master Page Create a new folder Reports and 2 sub folder crystal & crystalviewer Now add a web form page in crystalviewer  folder. Add the master page namespace in your web form page. MasterPageFile ="~/Views/Shared/ReportSite.Master" Replace your web form by this code < asp : Content ID ="Content1" ContentPlaceHolderID ="ContentPlaceHolder1" runat ="server">      </ asp : Content > Now go to design mode of your web form drag & drop the crystal report viewer in your web form. After that your page will be look look like this. Replace the code: < CR : CrystalReportViewer ID ="EmployeeList" runat ="server"   HasCrystalLogo ="False"     AutoDataBind ="True"   Height ="50px"   EnableParameterPrompt ="false" EnableDatabaseLogonPrompt
Post a Comment
Read more

C# run powershell script as administrator

Recently I was fetching a problem that I need to run a PowerShell script that will change TFS user Display name and SID. I was trying to run that script from C# that was not working due to TFS security update and TLS certificate. Using this code block I resolve the Issue. var newProcessInfo = new System.Diagnostics.ProcessStartInfo(); newProcessInfo.FileName = @"C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe"; newProcessInfo.Verb = "runas"; // Define Run as administrator newProcessInfo.Arguments = script; //Define your powershell script newProcessInfo.UseShellExecute = false; newProcessInfo.RedirectStandardOutput = true; // This will enable to read Powershell run output newProcessInfo.RedirectStandardError = true; Process proces = System.Diagnostics.Process.Start(newProcessInfo); proces.WaitForExit(); // I want to read the output string from powershell window StringBuilder output = new StringBuilder(); output.Append("Started"); while (!proces.St
Post a Comment
Read more