public static void CommitTransaction(this zModel db) { if (db.Database.CurrentTransaction != null) { db.Database.CurrentTransaction.Commit(); } }
public static void RollbackTransaction(this zModel db) { if (db.Database.CurrentTransaction != null) { db.Database.CurrentTransaction.Rollback(); } }
public TokenProviderMiddleware(RequestDelegate next, IOptions <TokenProviderOptions> options, ILoggerFactory logger, zModel db) { _next = next; _options = options.Value; _logger = logger.CreateLogger("TokenProviderMiddleware"); _db = db; }
public Task Invoke(HttpContext context) { if (!context.Request.Path.Equals(_options.Path, StringComparison.OrdinalIgnoreCase)) { try { if (context.Request.Headers.ContainsKey("Authorization")) { string token = context.Request.Headers["Authorization"]; if (token.StartsWith("Bearer ")) { token = token.Split(' ')[1]; } if (TokenHelper.DictionaryToken.Any(n => n.Value.Equals(token))) { var jwt = new JwtSecurityToken(token); var _tk = jwt.Claims.GetValue <eTaiKhoan>(JwtRegisteredClaimNames.Aud); if (_tk != null) { var role = new zModel().eQuyen.Where(n => n.PhanQuyenID == _tk.PhanQuyenID).Select(n => n.xChucNang); string path = context.Request.Path.Value.Trim().ToLower(); if (path.Contains("?")) { path = path.Split('?')[0].Trim(); } if (role.Any(n => n.Route.Equals(path) && n.Methods.Equals(context.Request.Method.Trim(), StringComparison.OrdinalIgnoreCase))) { context.Response.Headers.Remove("Authorization"); var encodedJwt = jwt.RefeshToken(); context.Response.Headers.Add("Authorization", "Bearer " + encodedJwt); return(_next(context)); } } } context.Response.StatusCode = 401; return(context.Response.WriteAsync("Unauthorized")); } } catch { context.Response.StatusCode = 401; return(context.Response.WriteAsync("Unauthorized")); } } // Request must be POST with Content-Type: application/x-www-form-urlencoded if (!context.Request.Method.Equals("POST") || !context.Request.HasFormContentType) { context.Response.StatusCode = 400; return(context.Response.WriteAsync("Bad request.")); } return(GenerateToken(context)); }
public Repository(zModel context, Microsoft.Extensions.Logging.ILoggerFactory logger) { Type typeParameter = typeof(T); RepositoryName = typeParameter.Name; Context = context; Logger = logger.CreateLogger(RepositoryName); }
public async Task <T> GetByID(object id) { try { Context = new zModel(); T item = await Context.Set <T>().FindAsync(id.ConvertType <T>()); return(item ?? new T()); } catch { return(new T()); } }
public async Task <IEnumerable <T> > GetAll() { try { Context = new zModel(); IEnumerable <T> lstResult = await Context.Set <T>().ToListAsync(); return(lstResult); } catch { return(new List <T>()); } }
public static void RegisterDatabase(HttpConfiguration config) { //aModel db = (aModel)ModuleHelper.HttpConfiguration.DependencyResolver.GetService(typeof(aModel)); string conString = string.Empty; if (Extension.GetWebSettings("add", "name", "ConnectionDbContext", "connectionString", ref conString)) { Define.Instance.ConnectionString = conString; Database.SetInitializer(new MigrateDatabaseToLatestVersion <zModel, CustomConfiguration>()); zModel db = new zModel(); db.Database.Initialize(false); } Log.Debug(MethodBase.GetCurrentMethod()); }
async static void InitDonViTinh() { zModel db = new zModel(); await Task.Factory.StartNew(() => { if (db.eDonViTinh.Count() == 0) { try { string Query = File.ReadAllText($@"{Directory.GetCurrentDirectory()}\wwwroot\InitData\DATA_eDonViTinh.sql"); db.Database.ExecuteSqlCommandAsync(Query, new SqlParameter[] { }).Wait(); } catch { } } }); }
void GetPrimaryKey() { zModel db = new zModel(); ModuleHelper.ListKeys = new List <IKey>(); var eTypes = db.Model.GetEntityTypes(); foreach (var eType in eTypes) { var keys = eType.GetKeys(); foreach (var key in keys) { ModuleHelper.ListKeys.Add(key); } } }
public static void SeedData(this IApplicationBuilder app) { _app = app; _db = _app.ApplicationServices.GetService <zModel>(); app.allControlller(); if (!_db.ePhanQuyen.Any(n => n.TenQuyen.Equals("Admin"))) { var nQuyen = new ePhanQuyen() { TenQuyen = "Admin" }; _db.ePhanQuyen.Add(nQuyen); if (_db.ChangeTracker.HasChanges()) { _db.SaveChanges(); } _db.xChucNang.ToList().ForEach(n => _db.eQuyen.Add(new eQuyen() { ChucNangID = n.KeyID, PhanQuyenID = nQuyen.KeyID })); if (_db.ChangeTracker.HasChanges()) { _db.SaveChanges(); } } if (!_db.eTaiKhoan.Any(n => n.AccCode.Equals("admin"))) { _db.eTaiKhoan.Add(new eTaiKhoan() { AccCode = "admin", Password = "******".Encrypt(), AccName = "admin", PhanQuyenID = 1 }); } if (_db.ChangeTracker.HasChanges()) { _db.SaveChanges(); } }
async Task <IActionResult> InitDonViTinh() { zModel db = new zModel(); if (db.eDonViTinh.Count() == 0) { try { string Query = System.IO.File.ReadAllText($@"{Directory.GetCurrentDirectory()}\wwwroot\InitData\DATA_eDonViTinh.sql"); await db.Database.ExecuteSqlCommandAsync(Query, new SqlParameter[] { }); return(Ok($"Init data {(typeof(eDonViTinh).Name)} success.")); } catch (Exception ex) { return(BadRequest($"Init data {(typeof(eDonViTinh).Name)} fail: {ex}")); } } return(Ok($"No init {(typeof(eDonViTinh).Name)} data")); }
public async Task <bool> UpdateEntry(T Item) { try { Context = new zModel(); await Context.Database.BeginTransactionAsync(); Context.Set <T>().Update(Item); await Context.SaveChangesAsync(); Context.Database.CommitTransaction(); return(true); } catch { Context.Database.RollbackTransaction(); return(false); } }
public async Task <bool> AddEntries(T[] Items) { try { Context = new zModel(); await Context.Database.BeginTransactionAsync(); await Context.Set <T>().AddRangeAsync(Items); await Context.SaveChangesAsync(); Context.Database.CommitTransaction(); return(true); } catch { Context.Database.RollbackTransaction(); return(false); } }
public async Task <bool> DeleteEntry(object id) { try { Context = new zModel(); await Context.Database.BeginTransactionAsync(); T Item = await Context.Set <T>().FindAsync(id); Context.Set <T>().Remove(Item); await Context.SaveChangesAsync(); Context.Database.CommitTransaction(); return(true); } catch { Context.Database.RollbackTransaction(); return(false); } }
public async Task <bool> DeleteEntries(T[] Items) { try { Context = new zModel(); await Context.Database.BeginTransactionAsync(); foreach (T Item in Items) { Context.Set <T>().Attach(Item); Context.Set <T>().Remove(Item); } await Context.SaveChangesAsync(); Context.Database.CommitTransaction(); return(true); } catch { Context.Database.RollbackTransaction(); return(false); } }
public Repository(zModel db) { context = db; }
public Repository() { context = new zModel(); }
public RepositoryCollection(zModel db) { this.db = db; }
public Repository(zModel db) { this.db = db; entity = db.Set <T>(); }
public static void BeginTransaction(this zModel db) { db.Database.BeginTransaction(); }
public RepositoryCollection(zModel context, Microsoft.Extensions.Logging.ILoggerFactory logger) { this._context = context; this._logger = logger; }
public UnitOfWork(zModel db) { context = db; }
public UnitOfWork() { context = new zModel(); }
public Repository(zModel db) { this.Context = db; }
public RepositoryCollection(zModel db) { this.Context = db; }