/// <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());
}
