public ListResponse<MedicineDto> GetMatchingMedicines(QueryRequest<MedicineQuery> request) { try { using (var dbContext = new AptekaNETDbContext()) { var medicines = dbContext.Medicines.AsEnumerable().Where(p => request.Query.IsMatch(p)).ToList(); if (medicines.Any()) { var medicineDtos = medicines.Select(p => _medicineAssembler.ToDto(p)).ToList(); return new ListResponse<MedicineDto>(request.Id, medicineDtos) { Message = "Pobrano pomyślnie" }; } return new ListResponse<MedicineDto>(request.Id, new List<MedicineDto>()) { Message = "Nie ma leku spełniającego powyższe warunki" }; } } catch (Exception e) { return new ListResponse<MedicineDto>(request.Id, new List<MedicineDto>()) { Message = "Błąd" }; } }
public AptekaNetUnitOfWork() { Context = new AptekaNETDbContext(); OrderRepository = new OrderRepository(Context); EmployeeRepository = new EmployeeRepository(Context); CustomerRepository = new CustomerRepository(Context); MedicineRepository = new MedicineRepository(Context); ProductRepository = new ProductRepository(Context); PharmacyRepository = new PharmacyRepository(Context); }
public ListResponse<PharmacyDto> GetMatchingPharmacies(QueryRequest<PharmacyQuery> request) { try { using (var dbContext = new AptekaNETDbContext()) { var pharmacies = dbContext.Pharmacies.AsEnumerable().Where(p => request.Query.IsMatch(p)).ToList(); if (pharmacies.Any()) { var pharmacyDtos = pharmacies.Select(p => _pharmacyAssembler.ToDto(p)).ToList(); return new ListResponse<PharmacyDto>(request.Id, pharmacyDtos) { Message = "Pobrano pomyślnie" }; } return new ListResponse<PharmacyDto>(request.Id, new List<PharmacyDto>()) { Message = "Nie ma apteki spełniającej powyższe warunki" }; } } catch (Exception e) { return new ListResponse<PharmacyDto>(request.Id, new List<PharmacyDto>()) { Message = "Błąd" }; } }
public LoginResponse Login(LoginRequest request) { Debug.WriteLine(Directory.GetCurrentDirectory()); if (_userSignedIn) { var response = new LoginResponse(request.Id, false); response.Message = "Jesteś już zalogowany, po co drógi ras??"; return response; } try { using (var dbContext = new AptekaNETDbContext()) { var hashedPassword = Security.CalculateMD5Hash(request.Password); var user = dbContext.Customers.FirstOrDefault(c => c.Login == request.Login && c.Password == hashedPassword); //ustaw na zalogowanego if (user != null) { _userSignedIn = true; _signedCustomerId = user.Id; } return (new LoginResponse(request.Id, _userSignedIn)); } } catch (Exception e) { return new LoginResponse(request.Id, false) { Message = "Błąd - " + e.Message }; } }
public AptekaNetUnitOfWork() { context = new AptekaNETDbContext(); ordersRepository = new OrderRepository(context); employeesRepository = new EmployeeRepository(context); }
public void Initialize() { Database.SetInitializer(new DropCreateDatabaseIfModelChanges<AptekaNETDbContext>()); _aptekaNETDbContext = new AptekaNETDbContext(); _aptekaNETDbContext.Database.Initialize(true); }