Porting existing MVC app to Abp & reusing existing code #2881

4 Answer(s)

• 

  0

  OutdoorEd created 7 years ago

  Is there any way to use EF Scaffolding to generate CRUD operations in controllers that include TenantId for CRUD and filtering <ins>directly</ins>from the Entity without using Dtos, etc.

  Save Cancel
• 

  0

  ismcagdas created 7 years ago

  Support Team

  Hi,

  Sorry for the late reply. Yes, you can inherit your entities from IMayHaveTenant or IMustHaveTenant and add your entities to original db context or you can create a second dbContext which inherits from AbpDbContext.

  In that way, ABP will filter and set according to current AbpSession.TenantId.

  You also need to derive your existing controllers from *ControllerBase.

  Thanks.

  Save Cancel
• 

  0

  OutdoorEd created 7 years ago

  Thanks. I tried setting this up with both the Default DbContent and separate DBContent but have not been able to get it to work.

  My Entity class inherits IMustHaveTenant

  using System;
  using System.Collections.Generic;
  using System.ComponentModel.DataAnnotations;
  using System.ComponentModel.DataAnnotations.Schema;
  using System.Data.Entity.Spatial;
  using Abp.Domain.Entities;
  
  [Table("idb_IncidentDamage")]
  public partial class IncidentDamage : IMustHaveTenant
  {
      public Guid Id { get; set; }
  

  My Second DbContext inherits AbpDbContext

  using System.Data.Entity; using OE_Tenant.Incidents.Entity; using Abp.EntityFramework;

  namespace OE_Tenant.EntityFramework { public class IDBDbContext: AbpDbContext { public IDBDbContext() : base("SecondDefault")

  I used the EF6 Scaffolding Wizard to generate the Controllers and Views for CRUD operations straight from the Entities and added the necessary references to Abp and inherited from the ControllerBase

  When looking at breakpoints in the Controller for the AbpSession.TenantId the correct TenantId <ins>is</ins> in the session variable however, there is no database filtering taking place. All records are shown from all Tenants. There must be something that is missing/needs to be added to the Scaffolded Controller to include the TenantId in filtering and CRUD operations.

  Controller using System; using System.Data.Entity; using System.Linq; using System.Net; using System.Web.Mvc; using Abp.Authorization; using OE_Tenant.EntityFramework; using OE_Tenant.Incidents.Entity; using OE_Tenant.Web.Controllers;

  namespace OE_Tenant.Web.Areas.Incidents.Controllers { [AbpAuthorize] public class IncidentDamageController : OE_TenantControllerBase //: Controller { private IDBDbContext db = new IDBDbContext();

      // GET: Incidents/IncidentDamage
      public ActionResult Index()
      {
          var tenantId = AbpSession.TenantId;
          var IncidentDamage = db.IncidentDamage.Include(i => i.Incident).Include(i => i.LkpDamageSeverity).Include(i => i.LkpDamageType);
          return View(IncidentDamage.ToList());
      }
  

  This is the full controller generated by EF

  using System; using System.Collections.Generic; using System.Data; using System.Data.Entity; using System.Linq; using System.Threading.Tasks; using System.Net; using System.Web; using System.Web.Mvc; using Abp.Authorization; using OE_Tenant.EntityFramework; using OE_Tenant.Incidents.Entity; using OE_Tenant.Web.Controllers;

  namespace OE_Tenant.Web.Areas.Incidents.Controllers { [AbpAuthorize] public class IncidentDamageController : OE_TenantControllerBase //: Controller { private IDBDbContext db = new IDBDbContext();

      // GET: Incidents/IncidentDamage
      public ActionResult Index()
      {
          var tenantId = AbpSession.TenantId;
          var IncidentDamage = db.IncidentDamage.Include(i => i.Incident).Include(i => i.LkpDamageSeverity).Include(i => i.LkpDamageType);
          return View(IncidentDamage.ToList());
      }
  
      // GET: Incidents/IncidentDamage/Details/5
      public ActionResult Details(Guid? id)
      {
          if (id == null)
          {
              return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
          }
          IncidentDamage IncidentDamage = db.IncidentDamage.Find(id);
          if (IncidentDamage == null)
          {
              return HttpNotFound();
          }
          return View(IncidentDamage);
      }
  
      // GET: Incidents/IncidentDamage/Create
      public ActionResult Create()
      {
          ViewBag.IncidentId = new SelectList(db.Incident, "Id", "IncidentEvent");
          ViewBag.DamageSeverityId = new SelectList(db.LkpDamageSeverity, "Id", "DamageSeverity");
          ViewBag.DamageTypeId = new SelectList(db.LkpDamageType, "Id", "DamageType");
          return View();
      }
  
      // POST: Incidents/IncidentDamage/Create
      // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
      // more details see <a class="postlink" href="http://go.microsoft.com/fwlink/?LinkId=317598">http://go.microsoft.com/fwlink/?LinkId=317598</a>.
      [HttpPost]
      [ValidateAntiForgeryToken]
      public ActionResult Create([Bind(Include = "Id,IncidentId,DamageTypeId,DamageDescription,DamageSeverityId,DamageAmount,IndexIdentity,TenantId,IsDeleted,DeletedUserId,DeletionTime,LastModificationTime,LastModifiedUserId,CreationTime,CreatorUserId")] IncidentDamage IncidentDamage)
      {
          if (ModelState.IsValid)
          {
              IncidentDamage.Id = Guid.NewGuid();
              db.IncidentDamage.Add(IncidentDamage);
              db.SaveChanges();
              return RedirectToAction("Index");
          }
  
          ViewBag.IncidentId = new SelectList(db.Incident, "Id", "Activity", IncidentDamage.IncidentId);
          ViewBag.DamageSeverityId = new SelectList(db.LkpDamageSeverity, "Id", "DamageSeverity", IncidentDamage.DamageSeverityId);
          ViewBag.DamageTypeId = new SelectList(db.LkpDamageType, "Id", "DamageType", IncidentDamage.DamageTypeId);
          return View(IncidentDamage);
      }
  
      // GET: Incidents/IncidentDamage/Edit/5
      public ActionResult Edit(Guid? id)
      {
          if (id == null)
          {
              return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
          }
          IncidentDamage IncidentDamage = db.IncidentDamage.Find(id);
          if (IncidentDamage == null)
          {
              return HttpNotFound();
          }
          ViewBag.IncidentId = new SelectList(db.Incident, "Id", "Activity", IncidentDamage.IncidentId);
          ViewBag.DamageSeverityId = new SelectList(db.LkpDamageSeverity, "Id", "DamageSeverity", IncidentDamage.DamageSeverityId);
          ViewBag.DamageTypeId = new SelectList(db.LkpDamageType, "Id", "DamageType", IncidentDamage.DamageTypeId);
          return View(IncidentDamage);
      }
  
      // POST: Incidents/IncidentDamage/Edit/5
      // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
      // more details see <a class="postlink" href="http://go.microsoft.com/fwlink/?LinkId=317598">http://go.microsoft.com/fwlink/?LinkId=317598</a>.
      [HttpPost]
      [ValidateAntiForgeryToken]
      public ActionResult Edit([Bind(Include = "Id,IncidentId,DamageTypeId,DamageDescription,DamageSeverityId,DamageAmount,IndexIdentity,TenantId,IsDeleted,DeletedUserId,DeletionTime,LastModificationTime,LastModifiedUserId,CreationTime,CreatorUserId")] IncidentDamage IncidentDamage)
      {
          if (ModelState.IsValid)
          {
              db.Entry(IncidentDamage).State = EntityState.Modified;
              db.SaveChanges();
              return RedirectToAction("Index");
          }
          ViewBag.IncidentId = new SelectList(db.Incident, "Id", "Activity", IncidentDamage.IncidentId);
          ViewBag.DamageSeverityId = new SelectList(db.LkpDamageSeverity, "Id", "DamageSeverity", IncidentDamage.DamageSeverityId);
          ViewBag.DamageTypeId = new SelectList(db.LkpDamageType, "Id", "DamageType", IncidentDamage.DamageTypeId);
          return View(IncidentDamage);
      }
  
      // GET: Incidents/IncidentDamage/Delete/5
      public ActionResult Delete(Guid? id)
      {
          if (id == null)
          {
              return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
          }
          IncidentDamage IncidentDamage = db.IncidentDamage.Find(id);
          if (IncidentDamage == null)
          {
              return HttpNotFound();
          }
          return View(IncidentDamage);
      }
  
      // POST: Incidents/IncidentDamage/Delete/5
      [HttpPost, ActionName("Delete")]
      [ValidateAntiForgeryToken]
      public ActionResult DeleteConfirmed(Guid id)
      {
          IncidentDamage IncidentDamage = db.IncidentDamage.Find(id);
          db.IncidentDamage.Remove(IncidentDamage);
          db.SaveChanges();
          return RedirectToAction("Index");
      }
  
      protected override void Dispose(bool disposing)
      {
          if (disposing)
          {
              db.Dispose();
          }
          base.Dispose(disposing);
      }
  }
  

  }

  Save Cancel
• 

  0

  ismcagdas created 7 years ago

  Support Team

  Hi,

  In order to use data filters you should not create dbContext by yourself. Instead you should inject a repository, for example IRepository<YourEntity>, and then you need to use this repository to get data.

  If you want to continue in this way, you can check the library we used for data filters here <a class="postlink" href="https://github.com/jcachat/EntityFramework.DynamicFilters">https://github.com/jcachat/EntityFramew ... micFilters</a> but I suggest you to use IRepository.

  Thanks.

  Save Cancel