public DeviceModelManager() { using (var ctx = new FiscalDbContext()) { AllData = ctx.DeviceModels.ToList(); } }
private void LoginUser(object sender, RoutedEventArgs e) { string username = users.Text; string salt; using (var ctx = new FiscalDbContext()) { salt = ctx.Set <Serviceman>(). Where(x => x.Name + " " + x.Surname == username). Select(x => x.Salt). FirstOrDefault(); } var hashedPassword = SHA256Hasher(passwd.Password, salt); if (IsPasswordValid(username, hashedPassword)) { using (var ctx = new FiscalDbContext()) { LoggedUser = ctx.Set <Serviceman>(). Where(x => x.Name + " " + x.Surname == username). FirstOrDefault(); } GoToMainWindow(username); } else { // WriteLoginFailedMessage(); } }
public RevenueManager() { using (var ctx = new FiscalDbContext()) { AllData = ctx.Set <Revenue>().ToList(); } }
public virtual void TestCleanup() { using (var db = new FiscalDbContext()) if (db.Database.Exists()) { db.Database.Delete(); } }
private ObservableCollection <Serviceman> GetUsersFromDB() { ObservableCollection <Serviceman> allServicemen; using (var ctx = new FiscalDbContext()) { allServicemen = new ObservableCollection <Serviceman>(ctx.Set <Serviceman>().ToList()); } return(allServicemen); }
public virtual void TestInitialize() { using (var db = new FiscalDbContext()) { if (db.Database.Exists()) { db.Database.Delete(); } db.Database.Create(); } }
private void GetDataFromDB() { using (var ctx = new FiscalDbContext()) { EntitySearcher.Collection = new ObservableCollection <Client> ( ctx.Clients .Include("Revenue") .Include("Devices") .Include("Devices.Place") ); } }
private bool IsPasswordValid(string username, string hashpwd) { string hashtOfUser; using (var ctx = new FiscalDbContext()) { hashtOfUser = ctx.Set <Serviceman>(). Where(x => x.Name + " " + x.Surname == username). Select(x => x.Hash). FirstOrDefault(); } return(hashtOfUser == hashpwd); }
public DeviceEditViewModel(Device dev) { StateManager = new StateManager(); Entity = dev; using (var ctx = new FiscalDbContext()) { Client = ctx.Clients.FirstOrDefault(); } Entity.Client = Client; DeviceModel = new DeviceModel(); DeviceModelManager = new DeviceModelManager(); ButtonText = "Edytuj"; WindowTitle = "Edytowanie urządzenia"; }
public override void OperateOnDatabase(Device entity) { using (var ctx = new FiscalDbContext()) { Place oldPlace = ctx.Places.Include("Devices").FirstOrDefault(x => x.ID == entity.Place.ID); // Is old place different than new place if (!oldPlace.Equals(entity.Place)) { Place newPlace = entity.Place; Place NewPlaceExist = ctx.Places.FirstOrDefault(x => x.State == newPlace.State && x.City == newPlace.City && x.Street == newPlace.Street); newPlace.Devices = null; newPlace.ID = 0; if (NewPlaceExist == null) { Place z = ctx.Places.Add(newPlace); entity.Place = z; entity.PlaceId = z.ID; } else { entity.Place = NewPlaceExist; entity.PlaceId = NewPlaceExist.ID; ctx.Entry(ctx.Set <Place>().Find(entity.PlaceId)).CurrentValues.SetValues(entity.Place); } oldPlace = ctx.Places.FirstOrDefault(x => x.ID == oldPlace.ID); if (oldPlace.Devices.Count == 0) { ctx.Places.Remove(oldPlace); } } ctx.Entry(ctx.Set <Device>().Find(entity.ID)).CurrentValues.SetValues(entity); ctx.SaveChanges(); } }
public AddEditOperationViewModel(FiscalDbContext context) { Context = context; }