I have made scaffolding using (syncfusion) Extinsion, for one model by selecting remote data and here is the scaffolding controler:
================================
public class BranchController : Controller
{
private PSDbContext _context;
public BranchController(PSDbContext Context)
{
this._context=Context;
}
public ActionResult Index()
{
return View();
}
public ActionResult UrlDatasource([FromBody]DataManagerRequest dm)
{
IEnumerable DataSource = _context.Branch.ToList();
DataOperations operation = new DataOperations();
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = operation.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Cast<Branch>().Count();
if (dm.Skip != 0)//Paging
{
DataSource = operation.PerformSkip(DataSource, dm.Skip);
}
if (dm.Take != 0)
{
DataSource = operation.PerformTake(DataSource, dm.Take);
}
return Json(new { result = DataSource, count = count });
}
public ActionResult Insert([FromBody]CRUDModel<Branch> value)
{
//do stuff
_context.Branch.Add(value.Value);
_context.SaveChanges();
return Json(value);
}
public ActionResult Update([FromBody]CRUDModel<Branch> value)
{
//do stuff
var ord = value;
Branch val = _context.Branch.Where(or => or.BranchId == ord.Value.BranchId).FirstOrDefault();
val.BranchId=ord.Value.BranchId;
val.Name=ord.Value.Name;
val.Description=ord.Value.Description;
_context.SaveChanges();
return Json(value);
}
public ActionResult Delete([FromBody]CRUDModel<Branch> value)
{
//do stuff
Branch order = _context.Branch.Where(c => c.BranchId == (int)value.Key).FirstOrDefault();
_context.Branch.Remove(order);
_context.SaveChanges();
return Json(order);
}
}
==========================================
and Also this is the view file generated after scaffolding:
=========================================
<ejs-grid id="Grid" height="272" allowPaging="true" allowSorting="true" toolbar="@(new List<string>() { "Search", "Add", "Edit", "Delete","Update","Cancel" , "ExcelExport" , "CsvExport" ,"PdfExport"})" allowFiltering="true" allowSelection="true" allowExcelExport="true" allowPdfExport="true" toolbarClick="toolbarClick">
<e-data-manager url="/Branch/UrlDataSource" adaptor="UrlAdaptor" insertUrl="/Branch/Insert" updateUrl="/Branch/Update" removeUrl="/Branch/Delete"></e-data-manager>
<e-grid-filterSettings type="Excel"></e-grid-filterSettings>
<e-grid-editSettings allowAdding="true" allowDeleting="true" allowEditing="true" mode="Dialog"></e-grid-editSettings>
<e-grid-selectionsettings type="Single"></e-grid-selectionsettings>
<e-grid-columns>
<e-grid-column field="BranchId" headerText="BranchId" isPrimaryKey="true" isIdentity="true"></e-grid-column>
<e-grid-column field="Name" headerText="Name"></e-grid-column>
<e-grid-column field="Description" headerText="Description"></e-grid-column>
</e-grid-columns>
</ejs-grid>
<script>
function toolbarClick(args)
{
if (args.item.id === this.element.id+'_pdfexport')
{
this.pdfExport();
}
if (args.item.id === this.element.id+'_csvexport')
{
this.csvExport();
}
if (args.item.id === this.element.id + '_excelexport')
{
this.excelExport();
}
}
</script>
==========================================
Now the connecting to SQL server is working good and i can view data but when I adding new records I got this error
{reference not set to an instance of an object }
in this line:
_context.Branch.Add(value.Value);
Any help please
