public SapUnitOfWork(SapContextOptions options)
{
//this.InjectInstanceOf(typeof(IRepository), sapSqlDbContext, diApiContext);
//this.InjectInstanceOf(typeof(IRepository), sapSqlDbContext, diApiContext, options.SqlServerConnection, new DemoItemPropertiesRepository());
var productPropertiesRepository = new DemoProductPropertiesRepository();
_options = options;
_extrasDbContext = new RalDbContext(options.ExtrasServerOptions);
_diApiContext = new SapDiApiContext(options.DiApiServerConnection, CurrentProvider.GetService <ILogger <SapDiApiContext> >());
_sapSqlDbContext = new SapSqlDbContext(options.SapSqlServerOptions);
BusinessPartners = new SapBusinessPartnerRepository(_sapSqlDbContext, _diApiContext);
Salesmen = new SapSalesmanRepository(_sapSqlDbContext, _diApiContext);
Employees = new SapEmployeeRepository(_sapSqlDbContext, _diApiContext);
Company = new SapCompanyRepository(_sapSqlDbContext, _diApiContext);
Quotations = new SapDocumentRepository <QuotationEntity, QuotationHeaderEntity>(_sapSqlDbContext, _diApiContext, productPropertiesRepository);
Orders = new SapDocumentRepository <OrderEntity, OrderHeaderEntity>(_sapSqlDbContext, _diApiContext, productPropertiesRepository);
DeliveryNotes = new SapDocumentRepository <DeliveryNoteEntity, DeliveryNoteHeaderEntity>(_sapSqlDbContext, _diApiContext, productPropertiesRepository);
Invoices = new SapDocumentRepository <InvoiceEntity, InvoiceHeaderEntity>(_sapSqlDbContext, _diApiContext, productPropertiesRepository);
CreditNotes = new SapDocumentRepository <CreditNoteEntity, CreditNoteHeaderEntity>(_sapSqlDbContext, _diApiContext, productPropertiesRepository);
DownPaymentRequests = new SapDocumentRepository <DownPaymentRequest, DownPaymentRequestHeader>(_sapSqlDbContext, _diApiContext, productPropertiesRepository);
ProductGroups = new SapProductGroupRepository(_sapSqlDbContext, _diApiContext);
Products = new SapProductRepository(_sapSqlDbContext, _diApiContext);
RefreshTokens = new AuthenticationRepository(_extrasDbContext);
UserLocations = new UserLocationRepository(_extrasDbContext);
LeadUsersData = new LeadUserDataRepository(_extrasDbContext);
EmployeeTimeClocks = new EmployeeTimeClockRepository(_extrasDbContext);
_activities = new Lazy <IActivityRepository>(new SapActivityRepository(_sapSqlDbContext, _diApiContext, _extrasDbContext, options));
_attachments = new Lazy <IAttachmentRepository>(new SapAttachmentRepository(_sapSqlDbContext, _diApiContext));
_identityUsers = new Lazy <IIdentityRepository>(new IdentityUserRepository(_extrasDbContext));
}
public void DeleteLocation(int userId, int locationId)
{
using (UserLocationRepository repo = new UserLocationRepository())
{
repo.Delete(userId, locationId);
}
}
public void DeleteUserLocation(int id)
{
//unitOfWork.StartTransaction();
UserLocationRepository repo = new UserLocationRepository(unitOfWork);
//UserLocationModel userLocationModel = new UserLocationModel();
UserLocation userLocation = new UserLocation();
repo.Delete(x=>x.UserLocationId==id);
//unitOfWork.Commit();
}
public List<UserLocationModel> FindLocationListById(string id)
{
//unitOfWork.StartTransaction();
List<UserLocationModel> locationModelList = new List<UserLocationModel>();
UserLocationRepository repo = new UserLocationRepository(unitOfWork);
List<UserLocation> userLocation = new List<UserLocation>();
userLocation = repo.GetAll(x => x.UserId == id).ToList();
//unitOfWork.Commit();
AutoMapper.Mapper.Map(userLocation, locationModelList);
return locationModelList;
}
public UserLocationModel FindLocationByUserAndCityId(string userId,int cityId)
{
//unitOfWork.StartTransaction();
UserLocationModel locationModel = new UserLocationModel();
UserLocationRepository repo = new UserLocationRepository(unitOfWork);
UserLocation userLocation = new UserLocation();
userLocation = repo.GetAll(x => x.UserId == userId && x.CityId==cityId).FirstOrDefault();
//unitOfWork.Commit();
AutoMapper.Mapper.Map(userLocation, locationModel);
return locationModel;
}
public bool CheckExistance(string userId)
{
//unitOfWork.StartTransaction();
UserLocationRepository repo = new UserLocationRepository(unitOfWork);
UserLocation userLocation = new UserLocation();
userLocation = repo.GetAll(x => x.UserId == userId).FirstOrDefault();
//unitOfWork.Commit();
if (userLocation !=null)
{
return true;
}
else
{
return false;
}
}
public static IPockyBot CreatePockyBot(PockyBotSettings settings, IChatHelper chatHelper, IResultsUploader resultsUploader, ILoggerFactory loggerFactory)
{
var wrappedSettings = new OptionsWrapper <PockyBotSettings>(settings);
var dbContext = DatabaseContextBuilder.BuildDatabaseContext(settings.DatabaseConnectionString);
var pockyUserRepository = new PockyUserRepository(dbContext);
var configRepository = new ConfigRepository(dbContext);
var pegRepository = new PegRepository(dbContext);
var locationRepository = new LocationRepository(dbContext);
var userLocationRepository = new UserLocationRepository(dbContext);
var triggerResponseTester = new TriggerResponseTester(wrappedSettings, pockyUserRepository);
var pegRequestValidator = new PegRequestValidator(wrappedSettings, configRepository);
var pegHelper = new PegHelper(configRepository);
var pegGiver = new PegGiver(pegRepository, chatHelper);
var directResultsMessageSender = new DirectResultsMessageSender(chatHelper.Messages);
var pegResultsHelper = new PegResultsHelper(configRepository, pegHelper);
var userLocationGetter = new UserLocationGetter(pockyUserRepository);
var userLocationSetter =
new UserLocationSetter(pockyUserRepository, locationRepository, userLocationRepository, chatHelper);
var userLocationDeleter = new UserLocationDeleter(userLocationRepository);
var resultsFileGenerator = new ResultsFileGenerator(pegResultsHelper, loggerFactory.CreateLogger <ResultsFileGenerator>(), resultsUploader);
var usernameUpdater = new UsernameUpdater(chatHelper.People, pockyUserRepository);
var triggers = new List <ITrigger>
{
new Ping(),
new Help(pockyUserRepository, wrappedSettings, configRepository),
new Welcome(wrappedSettings, configRepository),
new Peg(pegRequestValidator, pockyUserRepository, pegHelper, configRepository, chatHelper, pegGiver, loggerFactory.CreateLogger <Peg>()),
new Status(pockyUserRepository, configRepository, pegHelper, loggerFactory.CreateLogger <Status>()),
new Results(pockyUserRepository, pegResultsHelper, resultsFileGenerator, loggerFactory.CreateLogger <Results>()),
new Finish(pockyUserRepository, pegResultsHelper, directResultsMessageSender, resultsFileGenerator, loggerFactory.CreateLogger <Finish>(), usernameUpdater),
new Reset(pegRepository, loggerFactory.CreateLogger <Reset>()),
new Keywords(configRepository),
new Rotation(configRepository),
new LocationConfig(locationRepository, pockyUserRepository),
new UserLocation(pockyUserRepository, userLocationGetter, userLocationSetter, userLocationDeleter),
new NumberConfig(configRepository),
new StringConfig(configRepository),
new RoleConfig(pockyUserRepository, chatHelper),
new RemoveUser(pockyUserRepository, loggerFactory.CreateLogger <RemoveUser>()),
new LocationWeight(configRepository, locationRepository),
new Default(wrappedSettings)
};
return(new PockyBot(triggers, triggerResponseTester, chatHelper, loggerFactory.CreateLogger <PockyBot>()));
}
public async Task TestThat_GetUserLocation_When_DataReaderReturnsItems_Returns_NotNullLocation()
{
// Arrange
var dataReaderMock = new Mock <IUserLocationDataReader>();
dataReaderMock
.Setup(x => x.ReadUserLocation())
.ReturnsAsync(MockObjects.UserLocation1);
var userLocationRepository = new UserLocationRepository(dataReaderMock.Object);
// Act
var location = await userLocationRepository.GetUserLocation();
// Assert
Assert.NotNull(location);
}
public async Task TestThat_GetUserLocation_When_DataReaderThrowsDataProviderException_Throws_DataProviderExceptionWithExpectedMessage()
{
// Arrange
var dataReaderMock = new Mock <IUserLocationDataReader>();
dataReaderMock
.Setup(x => x.ReadUserLocation())
.Throws(new DataProviderException(MockValues.UserLocationDataProviderExceptionMessage));
var userLocationRepository = new UserLocationRepository(dataReaderMock.Object);
// Act
async Task Act() => await userLocationRepository.GetUserLocation();
// Assert
var exception = await Assert.ThrowsAsync <DataProviderException>(Act);
Assert.Equal(MockValues.UserLocationDataProviderExceptionMessage, exception.Message);
}
public async Task TestThat_GetUserLocation_When_DataReaderReturnsItems_Returns_LocationWithExpectedValues()
{
// Arrange
var mockLocation = MockObjects.UserLocation1;
var dataReaderMock = new Mock <IUserLocationDataReader>();
dataReaderMock
.Setup(x => x.ReadUserLocation())
.ReturnsAsync(mockLocation);
var userLocationRepository = new UserLocationRepository(dataReaderMock.Object);
// Act
var location = await userLocationRepository.GetUserLocation();
// Assert
Assert.Equal(mockLocation.X, location.X);
Assert.Equal(mockLocation.Y, location.Y);
Assert.Equal(mockLocation.Tag, location.Tag);
}
// private DbContextOptions<RalDbContext> _options;
public RalUnitOfWork(RalDbContext dbContext)
{
_dbContext = dbContext;
BusinessPartners = new BusinessPartnerRepository(dbContext);
Company = new CompanyRepository(dbContext);
Employees = new EmployeesRepository(dbContext);
Quotations = new DocumentRepository <QuotationEntity, QuotationHeaderEntity>(dbContext);
Orders = new DocumentRepository <OrderEntity, OrderHeaderEntity>(dbContext);
DeliveryNotes = new DocumentRepository <DeliveryNoteEntity, DeliveryNoteHeaderEntity>(dbContext);
Invoices = new DocumentRepository <InvoiceEntity, InvoiceHeaderEntity>(dbContext);
CreditNotes = new DocumentRepository <CreditNoteEntity, CreditNoteHeaderEntity>(dbContext);
DownPaymentRequests = new DocumentRepository <DownPaymentRequest, DownPaymentRequestHeader>(dbContext);
Salesmen = new SalesmanRepository(dbContext);
ProductGroups = new ProductGroupRepository(dbContext);
Products = new ProductRepository(dbContext);
RefreshTokens = new AuthenticationRepository(dbContext);
IdentityUsers = new IdentityUserRepository(dbContext);
UserLocations = new UserLocationRepository(dbContext);
LeadUsersData = new LeadUserDataRepository(dbContext);
EmployeeTimeClocks = new EmployeeTimeClockRepository(dbContext);
Activities = new ActivityRepository(dbContext);
Attachments = new AttachmentRepository(dbContext);
}
public UserLocationsController()
{
_userLocationRepository = new UserLocationRepository();
}
public async Task <List <UserLocationModel> > GetAllUserLocations(int userId)
{
var userLocationRepository = new UserLocationRepository();
return(await userLocationRepository.GetAllUserLocations(userId));
}
public UserLocationModel UpadteUserLocation(UserLocationModel model)
{
//unitOfWork.StartTransaction();
UserLocationRepository repo = new UserLocationRepository(unitOfWork);
UserLocation userLocation = new UserLocation();
userLocation = repo.GetAll().Where(x => x.UserLocationId == model.UserLocationId).FirstOrDefault();
AutoMapper.Mapper.Map(model, userLocation);
repo.Update(userLocation);
//unitOfWork.Commit();
AutoMapper.Mapper.Map(userLocation, model);
return model;
}
public UserLocationModel InsertUserLocation(UserLocationModel locationModel)
{
//unitOfWork.StartTransaction();
UserLocationRepository repo = new UserLocationRepository(unitOfWork);
//UserLocationModel userLocationModel = new UserLocationModel();
UserLocation userLocation = new UserLocation();
AutoMapper.Mapper.Map(locationModel, userLocation);
userLocation = repo.Insert(userLocation);
//unitOfWork.Commit();
AutoMapper.Mapper.Map(userLocation, locationModel);
return locationModel;
}
