/// <summary> /// Get StieMap entity records /// </summary> /// <param name="controller"></param> /// <param name="action"></param> /// <param name="dbContext"></param> /// <returns>int</returns> /// <method>GetSiteMap(string controller, string action, CDCavellDbContext dbContext)</method> public static SiteMap GetSiteMap(string controller, string action, CDCavellDbContext dbContext) { return(dbContext.SiteMap .Where(x => x.Controller == controller.Clean()) .Where(x => x.Action == action.Clean()) .FirstOrDefault()); }
/// <summary> /// Get count of controller and action in StieMap entity /// </summary> /// <param name="controller"></param> /// <param name="action"></param> /// <param name="dbContext"></param> /// <returns>int</returns> /// <method>GetCount(string controller, string action, CDCavellDbContext dbContext)</method> public static int GetCount(string controller, string action, CDCavellDbContext dbContext) { return(dbContext.SiteMap .Where(x => x.Controller == controller.Clean()) .Where(x => x.Action == action.Clean()) .Count()); }
/// <summary> /// Delete record /// </summary> /// <param name="dbContext"></param> public virtual void Delete(CDCavellDbContext dbContext) { if (!this.IsNew) { dbContext.Attach <DataModel <T> >(this); dbContext.Remove <DataModel <T> >(this); dbContext.SaveChanges(); } }
/// <summary> /// Initialize method /// <br /> /// To Initialize: dotnet ef migrations add InitialCreate --context CDCavellDbContext /// <br /> /// To Update: dotnet ef migrations add UpdateDatabase_<<YYYY-MM-DD>> --context CDCavellDbContext /// <br /> /// To Revert: dotnet ef database update <previous migration name> (Then - dotnet ef migrations remove) /// </summary> /// <param name="context">CDCavellDdContext</param> /// <method>Initialize(MigrateDdContext context)</method> public static void Initialize(CDCavellDbContext context) { IEnumerable <string> pending = context.Database.GetPendingMigrations(); if (pending.Any()) { context.Database.Migrate(); } }
/// <summary> /// Add/Update record /// </summary> /// <method>AddUpdate(CDCavellDbContext dbContext)</method> public virtual void AddUpdate(CDCavellDbContext dbContext) { if (this.IsNew) { dbContext.Add <DataModel <T> >(this); } else { dbContext.Update <DataModel <T> >(this); } dbContext.SaveChanges(); }
/// <summary> /// Get StieMap entity records that have not been submitted /// </summary> /// <param name="dbContext"></param> /// <returns>int</returns> /// <method>GetNotSubmittedSiteMap(CDCavellDbContext dbContext)</method> public static List <SiteMap> GetNotSubmittedSiteMap(CDCavellDbContext dbContext) { return(dbContext.SiteMap .Where(x => x.LastSubmitDate == DateTime.MinValue) .ToList()); }
/// <summary> /// Get all StieMap entity records /// </summary> /// <param name="dbContext"></param> /// <returns>int</returns> /// <method>GetAllSiteMap(CDCavellDbContext dbContext)</method> public static List <SiteMap> GetAllSiteMap(CDCavellDbContext dbContext) { return(dbContext.SiteMap.ToList()); }