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;
}
