public UnitOfWork(IDbContextFactory <APPDbContext> dbContextFactory, Microsoft.AspNetCore.Http.IHttpContextAccessor httpContextAccessor) { _dbContext = dbContextFactory.GetContext(); UserRepository = new UserRepository(_dbContext); AccountsRepository = new AccountsRepository(_dbContext); Account_RolesRepository = new Account_RolesRepository(_dbContext); RolesRepository = new RolesRepository(_dbContext); PermissionsRepository = new PermissionsRepository(_dbContext); EmployeesRepository = new EmployeesRepository(_dbContext); MenusRepository = new MenusRepository(_dbContext); JobPositionsRepository = new JobPositionsRepository(_dbContext); MotorManufactureRepository = new MotorManufactureRepository(_dbContext); MotorTypesRepository = new MotorTypesRepository(_dbContext); ServicesRepository = new ServicesRepository(_dbContext); MotorLiftsRepository = new MotorLiftsRepository(_dbContext); SupplierRepository = new SupplierRepository(_dbContext); CustomersRepository = new CustomersRepository(_dbContext); AccessoriesRepository = new AccessoriesRepository(_dbContext); TemporaryBill_ServiceRepository = new TemporaryBill_ServiceRepository(_dbContext); TemporaryBillRepository = new TemporaryBillRepository(_dbContext); TemporaryBill_AccesaryRepository = new TemporaryBill_AccesaryRepository(_dbContext); ImportReceiptRepository = new ImportReceiptRepository(_dbContext); ImportReceipt_AccessoryRepository = new ImportReceipt_AccessoryRepository(_dbContext); ServicePriceHistoryRepository = new ServicePriceHistoryRepository(_dbContext); AccessoryPriceHistoryRepository = new AccessoryPriceHistoryRepository(_dbContext); }
public UnitOfWork(IDbContextFactory <APPDbContext> dbContextFactory, Microsoft.AspNetCore.Http.IHttpContextAccessor httpContextAccessor) { _dbContext = dbContextFactory.GetContext(); UserRepository = new UserRepository(_dbContext); MenuRepository = new MenuRepository(_dbContext); RolesRepository = new RolesRepository(_dbContext); Role_PermissionsRepository = new Role_PermissionsRepository(_dbContext); AccountsRepository = new AccountsRepository(_dbContext); AccountRolesRepository = new AccountRolesRepository(_dbContext); CategoryRepository = new CategoryRepository(_dbContext); Content_CategoriesRepository = new Content_CategoriesRepository(_dbContext); AuthorsRepository = new AuthorsRepository(_dbContext); GroupsRepository = new GroupsRepository(_dbContext); NewsSourcesRepository = new NewsSourcesRepository(_dbContext); TypesRepository = new TypesRepository(_dbContext); ContentTypesRepository = new ContentTypesRepository(_dbContext); Content_GroupsRepository = new Content_GroupsRepository(_dbContext); TitleImagesRepository = new TitleImagesRepository(_dbContext); MediasRepository = new MediasRepository(_dbContext); ContentsRepository = new ContentsRepository(_dbContext); QuanLyDonGiaNhuanButRepository = new QuanLyDonGiaNhuanButRepository(_dbContext); TheLoai_HeSoRepository = new TheLoai_HeSoRepository(_dbContext); NhuanButRepository = new NhuanButRepository(_dbContext); ContactRepository = new ContactRepository(_dbContext); }
public static string getRecordingSequenceString(int id) { using (APPDbContext db = new APPDbContext()) { var res = db.SB.Find(id); if (res != null) { return(res.Data); } else { var ncount = db.SB.Count(); var rans = new RandomGenerator(); for (int i = 0; i < id - ncount; i++) { db.SB.Add(new StringSequenceObjB() { Data = rans.getRandomString(20) }); } db.SaveChanges(); res = db.SB.Find(id); if (res == null) { throw new Exception("sa id miss"); } return(res.Data); } } }
private static void _settings_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e) { APPDbContext db = new APPDbContext(); if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Add) { foreach (var t in e.NewItems) { db.Entry((t as LocalSetting)?.dbsetting).State = Microsoft.EntityFrameworkCore.EntityState.Added; } } else if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Remove) { foreach (var t in e.OldItems) { db.Entry((t as LocalSetting)?.dbsetting).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; } } else if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Replace) { var _old = db.LocalSettings.Find((e.OldItems[0] as LocalSetting)?.ID); var _listnew = e.NewItems[0] as LocalSetting; _old.Key = _listnew?.Key; _old.Value = _listnew?.Value; db.Entry(_old).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } db.SaveChanges(); }
/// <summary> /// 初始化单一实例应用程序对象。这是执行的创作代码的第一行, /// 已执行,逻辑上等同于 main() 或 WinMain()。 /// </summary> public App() { this.InitializeComponent(); this.Suspending += OnSuspending; using (APPDbContext db = new APPDbContext()) { db.Database.EnsureCreated(); } //using (APPDbContext db = new APPDbContext()) //{ // foreach (var t in db.Users.ToList()) // db.Entry(t).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; // foreach (var t in db.Recordings.ToList()) // db.Entry(t).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; // db.SaveChanges(); //} //PSK.Models.ModelController.test(); //AssetsController.test(); //var user = LoginUser.CreateObj("test", "test"); //user.TryLogin(); //var ee = Core.Current.CurrentUser.Recordings[0]; //ee.Detail = "123456789"; //Core.Current.CurrentUser.Recordings[0] = ee; //var item = new Info() { Detail = "testdetail" ,DetailName="testdetailname"}; //Core.Current.CurrentUser.Recordings.Add(item); //int a = 0; }
private static void Set_LocalSettingChanged(LocalSetting setting) { APPDbContext db = new APPDbContext(); db.Entry(setting.dbsetting).State = Microsoft.EntityFrameworkCore.EntityState.Modified; db.SaveChanges(); }
//private BehaviorSubject<VariableStorageEvent> EventSubject { get; } = new BehaviorSubject<VariableStorageEvent>(null); //public IObservable<VariableStorageEvent> EventObservable => this.EventSubject.AsObservable(); public VariablesRepository(APPDbContext appDbContext, DataEventDispatcher eventDispatcher) { EventDispatcher = eventDispatcher; _appDbContext = appDbContext; //_appDbContext.Database.EnsureCreated(); //_appDbContext.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; }
private void Recordings_CollectionChanged(object sender, NotifyCollectionChangedEventArgs e) { using (APPDbContext db = new APPDbContext()) { switch (e.Action) { case NotifyCollectionChangedAction.Add: foreach (var t in e.NewItems) { var entity = new Recording(); db.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Added; db.SaveChanges(); var ur = ((Info)t).Encode(this, entity.ID); entity.key = ur.key; entity.value = ur.value; entity.uid = ur.uid; db.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } break; case NotifyCollectionChangedAction.Remove: foreach (var t in e.OldItems) { db.Entry(((Info)t).Record).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; } break; case NotifyCollectionChangedAction.Replace: foreach (var t in e.NewItems) { db.Entry(((Info)t).Modify(this)).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } break; case NotifyCollectionChangedAction.Reset: foreach (var t in e.OldItems) { db.Entry(((Info)t).Record).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; } foreach (var t in e.NewItems) { var entity = new Recording(); db.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Added; db.SaveChanges(); var ur = ((Info)t).Encode(this, entity.ID); entity.key = ur.key; entity.value = ur.value; entity.uid = ur.uid; db.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } break; } db.SaveChanges(); } }
//useage //var spicker = new FileSavePicker(); //spicker.FileTypeChoices.Add("XML", new List<String>() { ".xml" }); //var sfs = await spicker.PickSaveFileAsync(); //await DataPacManager.SerializeAsync(sfs, "test"); public static async Task SerializeAsync(StorageFile sf, string serkey) { if (Core.Current.CurrentUser == null) { throw new Exception(); } DataPac dat = new DataPac(); await Task.Run(async() => { //create ser aesobj string pid = Core.Current.CurrentUser.PID; dat.pid = pid; string str1 = pid + serkey; string str2 = serkey + pid; var hashobj = new Helper.HashProvider(); string hstr1 = hashobj.Hash(str1); string hstr2 = hashobj.Hash(str2); string serpwd_hash = hstr1 + hstr2; Helper.AESProvider _AESobj; var ivhash = new Helper.HashProvider(HashAlgorithmNames.Md5); byte[] _iv = ivhash.Hashbytes(pid); //create token string ranstr = (new Helper.RandomGenerator()).getRandomString(20); dat.token = ranstr; string kstr1 = ranstr + serpwd_hash; string kstr2 = serpwd_hash + ranstr; var keyhash = new Helper.HashProvider(); byte[] _key = new byte[128]; byte[] btar = keyhash.Hashbytes(kstr1); Array.Copy(btar, 0, _key, 0, 64); btar = keyhash.Hashbytes(kstr2); Array.Copy(btar, 0, _key, 64, 64); _AESobj = new Helper.AESProvider(_iv, _key); //encrypt dats dat.pwd_hash = _AESobj.Encrypt(Core.Current.CurrentUser.PWD_hash); dat.sertoken = _AESobj.Encrypt(ranstr); dat.vertifystr = _AESobj.Encrypt(AssetsController.getLocalSequenceString(Core.Current.CurrentUser.UID)); List <DataPac.dRow> arr = new List <DataPac.dRow>(); using (APPDbContext db = new APPDbContext()) { foreach (var t in db.Recordings.ToList()) { if (t.uid == Core.Current.CurrentUser.UID) { DataPac.dRow obj = new DataPac.dRow() { key = _AESobj.Encrypt(t.key), value = _AESobj.Encrypt(t.value) }; arr.Add(obj); } } } dat.dRows = arr.ToArray(); await dat.SerializeAsync(sf); }); }
public void DeleteUser() { using (APPDbContext db = new APPDbContext()) { foreach (var t in CurrentUser.Recordings) { db.Entry(t.Record).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; } db.Entry(db.Users.Single(b => b.ID == CurrentUser.UID)).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; db.SaveChanges(); } }
static LocalSettingReader() { APPDbContext db = new APPDbContext(); db.Database.EnsureCreated(); foreach (var t in db.LocalSettings) { LocalSetting set = t; set.LocalSettingChanged += Set_LocalSettingChanged; _settings.Add(set); } _settings.CollectionChanged += _settings_CollectionChanged; }
public TheLoai_HeSoRepository(APPDbContext context) : base(context) { this._db = context; }
public UnitOfWork(IDbContextFactory <APPDbContext> dbContextFactory, Microsoft.AspNetCore.Http.IHttpContextAccessor httpContextAccessor) { _dbContext = dbContextFactory.GetContext(); UserRepository = new UserRepository(_dbContext); }
public async Task TryLoginAsync(UserNotFoundReceipt e) { using (APPDbContext db = new APPDbContext()) { bool b_UserVertifyEvent = false; bool b_UserPwdVertifyFailEvent = false; bool b_UserNotFoundEvent = false; await Task.Run(() => { string pwd_hash_aes = AssetsController.EncryptwithAppaesobj(PWD_hash); var iuserlist = from t in db.Users.ToList() where t.pid == PID select t; var userlist = iuserlist.ToList(); if (userlist.Count == 0) { switch (e) { case UserNotFoundReceipt.Create: User dbuser = new User() { pid = PID, pwd = pwd_hash_aes }; db.Entry(dbuser).State = Microsoft.EntityFrameworkCore.EntityState.Added; db.SaveChanges(); break; case UserNotFoundReceipt.None: b_UserNotFoundEvent = true; return; } } else { var vertifyuser = userlist[0]; if (vertifyuser.pid != this.PID || vertifyuser.pwd != pwd_hash_aes) { b_UserPwdVertifyFailEvent = true; } } int uid = (from t in db.Users.ToList() where PID == t.pid && pwd_hash_aes == t.pwd select t).ToList().ElementAt(0).ID; var rlist = (from t in db.Recordings.ToList() where t.uid == uid select t).ToList(); Core.Current.Regist(new CurrentUser(rlist, PID, PWD_hash, uid)); b_UserVertifyEvent = true; }); if (b_UserPwdVertifyFailEvent) { UserPwdVertifyFailEvent?.Invoke(this); } if (b_UserVertifyEvent) { UserVertifyEvent?.Invoke(this); } if (b_UserNotFoundEvent) { UserNotFoundEvent?.Invoke(this); } } }
public EFCoreMiddlerRepository(APPDbContext appDbContext) { AppDbContext = appDbContext; }
public EndpointRuleRepository(APPDbContext appDbContext, DataEventDispatcher eventDispatcher) { _appDbContext = appDbContext; EventDispatcher = eventDispatcher; //_appDbContext.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; }
//useage //var picker = new FileOpenPicker(); //picker.FileTypeFilter.Add(".xml"); // var sf = await picker.PickSingleFileAsync(); //await DataPacManager.DeserializeAsync(sf, "test");@throw KeyVertifyFailException public static async Task DeserializeAsync(StorageFile sf, string serkey) { var dat = await DataPac.DeserializeAsync(sf); string pid = dat.pid; string token = dat.token; string desertoken = ""; Helper.AESProvider _AESobj = null; await Task.Run(() => { //create ser aesobj string str1 = pid + serkey; string str2 = serkey + pid; var hashobj = new Helper.HashProvider(); string hstr1 = hashobj.Hash(str1); string hstr2 = hashobj.Hash(str2); string serpwd_hash = hstr1 + hstr2; var ivhash = new Helper.HashProvider(HashAlgorithmNames.Md5); byte[] _iv = ivhash.Hashbytes(pid); string kstr1 = token + serpwd_hash; string kstr2 = serpwd_hash + token; var keyhash = new Helper.HashProvider(); byte[] _key = new byte[128]; byte[] btar = keyhash.Hashbytes(kstr1); Array.Copy(btar, 0, _key, 0, 64); btar = keyhash.Hashbytes(kstr2); Array.Copy(btar, 0, _key, 64, 64); _AESobj = new Helper.AESProvider(_iv, _key); desertoken = _AESobj.Decrypt(dat.sertoken); }); if (desertoken != token) { throw new KeyVertifyFailException() { _DataPac = dat } } ; await Task.Run(() => //InvalidOperationException { using (APPDbContext db = new APPDbContext()) { //search user User user = null; foreach (var t in db.Users.ToList()) { if (t.pid == pid) { user = t; } } if (user == null) { string pwd_hash_aes = AssetsController.EncryptwithAppaesobj(_AESobj.Decrypt(dat.pwd_hash)); User dbuser = new User() { pid = pid, pwd = pwd_hash_aes }; db.Entry(dbuser).State = Microsoft.EntityFrameworkCore.EntityState.Added; db.SaveChanges(); user = db.Users.Single(b => b.pid == pid);; } //set user sa AssetsController.getLocalSequenceString(user.ID); var saobj = db.SA.Single(t => t.ID == user.ID); //saobj.Data = dat.vertifystr; saobj.Data = _AESobj.Decrypt(dat.vertifystr); db.Entry(saobj).State = Microsoft.EntityFrameworkCore.EntityState.Modified; foreach (var t in dat.dRows) { Recording obj = new Recording() { uid = user.ID, key = _AESobj.Decrypt(t.key), value = _AESobj.Decrypt(t.value) }; db.Entry(obj).State = Microsoft.EntityFrameworkCore.EntityState.Added; } db.SaveChanges(); } }); }
public AuthorsRepository(APPDbContext context) : base(context) { this._db = context; }
public TypeDefinitionRepository(APPDbContext appDbContext, DataEventDispatcher eventDispatcher) { EventDispatcher = eventDispatcher; _appDbContext = appDbContext; }