public async Task <HttpResponseMessage> GetSupplierCountryMappingByCode(string CountryCode, string SupplierCode)
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <CountryMapping>("CountryMapping");
FilterDefinition <CountryMapping> filter;
filter = Builders <CountryMapping> .Filter.Empty;
filter = filter & Builders <CountryMapping> .Filter.Eq(x => x.CountryCode, CountryCode.Trim().ToUpper());
filter = filter & Builders <CountryMapping> .Filter.Eq(x => x.SupplierCode, SupplierCode.Trim().ToUpper());
var searchResult = await collection.Find(filter)
.Project(x => new CountryMapping_RS
{
CountryName = x.CountryName,
CountryCode = x.CountryCode,
SupplierName = x.SupplierName,
SupplierCode = x.SupplierCode,
SupplierCountryCode = x.SupplierCountryCode,
SupplierCountryName = x.SupplierCountryName,
MapId = x.MapId
})
.ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResult);
return(response);
}
private Task LoadCache()
{
foreach (var guild in _discord.Guilds)
{
var serverDataManager = ServerDataManager.AddServer(guild.Id);
var database = new MongoDBHandler(guild.Id.ToString());
var userDataList = database.GetAllDocumentsFromTable <UserDataModel>("UserData");
foreach (var userData in userDataList)
{
serverDataManager.SetUserData(Convert.ToUInt64(userData.UserId), userData);
}
var shopRoles = database.GetAllDocumentsFromTable <ShopRoleModel>("ShopRoles");
foreach (var shopRole in shopRoles)
{
serverDataManager.AddShopRole(shopRole.GetRoleId(), shopRole);
}
var serverSettings = database.GetAllDocumentsFromTable <ServerSettingsModel>("ServerSettings");
foreach (var serverSetting in serverSettings)
{
serverDataManager.AddServerSettings(serverSetting.Id, serverSetting);
}
}
return(Task.CompletedTask);
}
public async Task <HttpResponseMessage> updateHolidayMapping(HolidayModel HolidayModel)
{
_database = MongoDBHandler.mDatabase();
IMongoCollection <HolidayModel> collectionHolidayModelMapping = _database.GetCollection <HolidayModel>("HolidayMapping");
if (HolidayModel != null)
{
FilterDefinition <HolidayModel> filter;
filter = Builders <HolidayModel> .Filter.Empty;
var nakshatraHolidayId = HolidayModel.NakshatraHolidayId.ToString().ToUpper();
filter = filter & Builders <HolidayModel> .Filter.Eq(x => x.NakshatraHolidayId, nakshatraHolidayId);
var searchResult = await collectionHolidayModelMapping.Find(filter).FirstOrDefaultAsync();
// Update this record.
if (searchResult != null)
{
searchResult = HolidayModel;
var filter1 = Builders <HolidayModel> .Filter.Eq(c => c.NakshatraHolidayId, HolidayModel.NakshatraHolidayId);
collectionHolidayModelMapping.ReplaceOne(filter, HolidayModel, new UpdateOptions {
IsUpsert = true
});
}
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResult);
return(response);
}
return(null);
}
public StockMongoDbRepository(ILogger <StockMongoDbRepository> logger, IStockstoreDatabaseSettings settings)
{
_mongoDBHandler = new MongoDBHandler(settings);
_logger = logger;
_stocks = _mongoDBHandler.GetDataBase().GetCollection <Stock>(settings.StockCollectionName);
}
public async Task <HttpResponseMessage> GetListOfSupplierProductCodes(string SystemCityCode, string SupplierCode)
{
_database = MongoDBHandler.mDatabase();
IMongoCollection <ProductMapping> collectionProductMapping = _database.GetCollection <ProductMapping>("ProductMapping");
FilterDefinition <ProductMapping> filter;
filter = Builders <ProductMapping> .Filter.Empty;
filter = filter & Builders <ProductMapping> .Filter.Eq(x => x.SystemCityCode, SystemCityCode.Trim().ToUpper());
filter = filter & Builders <ProductMapping> .Filter.Eq(x => x.SupplierCode, SupplierCode.Trim().ToUpper());
var searchResult = await collectionProductMapping.Find(filter)
.Project(x => new
{
x.SupplierProductCode
})
.ToListAsync();
var searchResultArray = searchResult.Select(x => x.SupplierProductCode).Distinct().ToArray();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResultArray);
return(response);
}
public async Task <HttpResponseMessage> GetLocationMappingBySupplierCode(string SupplierCode)
{
try
{
List <SupplierZoneMaster> zoneMappingSearchResponses = new List <SupplierZoneMaster>();
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <SupplierZoneMaster>("SupplierZoneMaster");
FilterDefinition <SupplierZoneMaster> filterForZone;
filterForZone = Builders <SupplierZoneMaster> .Filter.Empty;
if (!string.IsNullOrWhiteSpace(SupplierCode))
{
filterForZone = filterForZone & Builders <SupplierZoneMaster> .Filter.Eq(b => b.Supplier_code, SupplierCode);
}
var result = await collection.Find(filterForZone).ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, result);
return(response);
}
catch (Exception ex)
{
NLogHelper.Nlogger_LogError.LogError(ex, this.GetType().FullName, Request.GetActionDescriptor().ActionName, Request.RequestUri.PathAndQuery);
HttpResponseMessage response = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Server Error. Contact Admin. Error Date : " + DateTime.Now.ToString());
return(response);
}
}
public async Task <HttpResponseMessage> GetProductDetailsBy_SuppName_SupHtlId_Format(string spname, string id, string format)
{
_database = MongoDBHandler.mDatabase();
var accomodationsList = _database.GetCollection <HotelsHotel>("Accommodations");
var productMappingList = _database.GetCollection <ProductMapping>("ProductMapping");
//FilterDefinition<HotelsHotel> filterAcco;
//FilterDefinition<ProductMapping> filterPM;
var idList = id.Split(',');
XDocument doc = new XDocument();
doc.Add(new XElement("Hotels"));
Hotels _Hotels = new Hotels();
List <HotelsHotel> _HotelsHotel = new List <HotelsHotel>();
foreach (var hotelId in idList)
{
var searchResultPM = await productMappingList.Find(x => (x.SupplierCode.ToLower() == spname.ToLower() && x.SupplierProductCode.ToLower() == hotelId.ToLower())).ToListAsync();
foreach (var resultPM in searchResultPM)
{
var searchResultAcco = await accomodationsList.Find(x => (x.HotelId.ToLower() == resultPM.SystemProductCode.ToLower())).ToListAsync();
foreach (var hotel in searchResultAcco)
{
hotel.SupplierHotelID = hotelId;
_HotelsHotel.Add(hotel);
}
}
}
_Hotels.Hotel = _HotelsHotel;
HttpResponseMessage response = new HttpResponseMessage();
if (format.ToLower() == "xml")
{
StringWriter sw = new StringWriter();
XmlTextWriter tw = null;
XmlSerializer serializer = new XmlSerializer(_Hotels.GetType());
tw = new XmlTextWriter(sw);
serializer.Serialize(tw, _Hotels);
sw.Close();
if (tw != null)
{
tw.Close();
}
response.Content = new StringContent(sw.ToString(), Encoding.UTF8, "application/xml");
response.StatusCode = HttpStatusCode.OK;
}
else if (format.ToLower() == "json")
{
response = Request.CreateResponse(HttpStatusCode.OK, _Hotels, "application/json");
}
response.StatusCode = HttpStatusCode.OK;
return(response);
}
public async Task <HttpResponseMessage> GetProductDetailsBy_SuppName_SupCityName(string spname, string city)
{
_database = MongoDBHandler.mDatabase();
var accomodationsList = _database.GetCollection <HotelsHotel>("Accommodations");
var productMappingList = _database.GetCollection <ProductMapping>("ProductMapping");
var idList = await productMappingList.Find(x => (x.SupplierCode.ToLower() == spname.ToLower() && x.SupplierCityName.ToLower() == city.ToLower())).ToListAsync();
XDocument doc = new XDocument();
doc.Add(new XElement("Hotels"));
Hotels _Hotels = new Hotels();
List <HotelsHotel> _HotelsHotel = new List <HotelsHotel>();
foreach (var hotelId in idList)
{
var searchResultAcco = await accomodationsList.Find(x => (x.HotelId.ToLower() == hotelId.SystemProductCode.ToLower())).ToListAsync();
foreach (var hotel in searchResultAcco)
{
hotel.SupplierHotelID = hotelId.SupplierProductCode;
_HotelsHotel.Add(hotel);
}
}
_Hotels.Hotel = _HotelsHotel;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, _Hotels);
return(response);
}
public async Task <HttpResponseMessage> GetAccommodationByCountryCode(string CountryCode)
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <AccommodationMaster>("AccommodationMaster");
var result = await collection.Find(c => c.CountryCode == CountryCode.Trim().ToUpper() && c.TLGXAccoId != null)
.Project(u =>
new AccommodationMasterGIATARS
{
HotelID = u.TLGXAccoId,
HotelName = u.HotelName,
HotelType = u.ProductCategorySubType,
HotelStarRating = u.HotelStarRating,
AddressStreet = concate(new List <string> {
u.StreetName, u.Street3, u.Street4, u.Street5
}),
PostalCode = u.PostalCode,
GIATA_ID = "",
CityName = u.CityName,
TelephoneNumber = u.Telephone,
FaxNumber = u.Fax,
URL = u.WebSiteURL,
EmailAddress = u.Email,
Latitude = u.Latitude,
Longitude = u.Longitude,
CodeStatus = u.CodeStatus,
AddressSuburb = u.SuburbDowntown
}
)
.SortBy(s => s.TLGXAccoId).ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, result);
return(response);
}
public async Task <HttpResponseMessage> GetContinentByContinentCode(string ContinentCode)
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <Country>("CountryMaster");
var result = await collection.Find(c => c.ContinentCode == ContinentCode.Trim().ToUpper()).SortBy(s => s.CountryName).ToListAsync();
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public async Task <HttpResponseMessage> GetAllContries()
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <Country>("CountryMaster");
var result = await collection.Find(bson => true).SortBy(s => s.CountryName).ToListAsync();
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
private async void button3_Click(object sender, EventArgs e)
{
//var strData = File.ReadAllText(@"D:\wamp\tmp\3.txt");
//var data = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Word>>(strData);
//var wordsWithOccurences = await MongoDBHandler.GetWordCollection();
var wordsWithOccurences = _intermediateWordContainer;
var articles = await MySQLHandler.GetAllArticlesAsync();
//articles.Reverse();
//articles = articles.Take(110).ToList();
// take top 1000 words
var wordsToProcess = wordsWithOccurences.Take(1000).ToList();
// get occurence of each word by individual article
var articleWordOccurenceList = new List <ArticleWordOccurence>();
int counter = 0;
await MongoDBHandler.ClearArticleWordOccurences();
var thread = new Thread(async() =>
{
foreach (var article in articles)
{
foreach (var word in wordsToProcess)
{
var count = GeneralHandlers.CountStringOccurrences(article.Text, word.WordName);
articleWordOccurenceList.Add(new ArticleWordOccurence
{
ArticleId = article.Id,
Word = word.WordName,
Occurence = count
});
}
if (counter > 1000)
{
counter = 0;
await MongoDBHandler.InsertArticleWordOccurences(articleWordOccurenceList);
articleWordOccurenceList.Clear();
}
counter++;
}
await MongoDBHandler.InsertArticleWordOccurences(articleWordOccurenceList);
});
thread.Start();
}
public async Task <HttpResponseMessage> GetLocationMappingByCode(string ZoneCode, string SupplierCode)
{
try
{
List <ZoneMappingSearchResponse> zoneMappingSearchResponses = new List <ZoneMappingSearchResponse>();
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <ZoneMaster>("ZoneMaster");
FilterDefinition <ZoneMaster> filterForZone;
filterForZone = Builders <ZoneMaster> .Filter.Empty;
if (!string.IsNullOrWhiteSpace(ZoneCode))
{
filterForZone = filterForZone & Builders <ZoneMaster> .Filter.Eq(b => b.Zone_Code, ZoneCode);
}
var zoneMasters = await collection.Find(filterForZone).ToListAsync();
if (!string.IsNullOrWhiteSpace(SupplierCode))
{
zoneMasters.ForEach(a => a.Zone_LocationMapping.RemoveAll(d => !(d.Supplier_code == SupplierCode)));
}
foreach (ZoneMaster zm in zoneMasters)
{
ZoneMappingSearchResponse zoneMappingSearchResponse = new ZoneMappingSearchResponse();
zoneMappingSearchResponse.ZoneCodes = zm.Zone_Code;
List <string> SupplierCodes = zm.Zone_LocationMapping.Select(x => x.Supplier_code).Distinct().ToList();
List <Zone_Supplier> zone_Suppliers = new List <Zone_Supplier>();
foreach (string SupCode in SupplierCodes)
{
Zone_Supplier zone_Sup = new Zone_Supplier();
zone_Sup.SupplierCode = SupCode;
List <Zone_LocationMapping> zone_LocationMappings = zm.Zone_LocationMapping.Where(x => x.Supplier_code == SupCode).ToList();
List <ZoneSupplierLocation> ZoneSupplierLocationList = zone_LocationMappings.ConvertAll(x => new ZoneSupplierLocation
{
Name = x.Name ?? string.Empty,
Code = x.Code ?? string.Empty,
Distance = x.Distance,
Type = x.ZoneType ?? string.Empty,
SubType = x.ZoneSubType ?? string.Empty,
Latitude = x.Latitude,
Longitude = x.Longitude,
FullAddress = x.FullAdress
});
zone_Sup.MappingLocations = ZoneSupplierLocationList;
zone_Suppliers.Add(zone_Sup);
}
zoneMappingSearchResponse.SupplierCodes = zone_Suppliers;
zoneMappingSearchResponses.Add(zoneMappingSearchResponse);
}
return(zoneMappingSearchResponses.Count > 0 ? Request.CreateResponse(HttpStatusCode.OK, zoneMappingSearchResponses) : Request.CreateResponse(HttpStatusCode.BadRequest, "Data Not Available for request"));
}
catch (Exception ex)
{
NLogHelper.Nlogger_LogError.LogError(ex, this.GetType().FullName, Request.GetActionDescriptor().ActionName, Request.RequestUri.PathAndQuery);
HttpResponseMessage response = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Server Error. Contact Admin. Error Date : " + DateTime.Now.ToString());
return(response);
}
}
public async Task <HttpResponseMessage> GetAllPorts()
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <Port>("PortMaster");
var result = await collection.Find(c => c.oag_inactive_indicator != "I").SortBy(s => s.oag_port_name).ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, result);
return(response);
}
public async Task <HttpResponseMessage> GetAllStates()
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <State>("StateMaster");
var result = await collection.Find(c => true).SortBy(s => s.StateName).ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, result);
return(response);
}
public async Task <HttpResponseMessage> GetPortByCountryCode(string CountryCode)
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <Port>("PortMaster");
var result = await collection.Find(c => c.oag_inactive_indicator != "I" && c.oag_country_code.ToUpper() == CountryCode.Trim().ToUpper()).SortBy(s => s.oag_port_name).ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, result);
return(response);
}
public async Task <HttpResponseMessage> GetSupplierByName(string Name)
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <Supplier>("Supplier");
var result = await collection.Find(s => s.SupplierName == Name.Trim().ToUpper()).SortBy(s => s.SupplierCode).ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, result);
return(response);
}
public async Task <HttpResponseMessage> GetZoneTypeMaster()
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <ZoneTypeMaster>("ZoneTypeMaster");
var result = await collection.Find(bson => true).SortBy(s => s.Zone_Type).ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, result);
return(response);
}
public TestDataGeneratorController(ICaseReportsEventHandler caseReportsEventHandler,
IHealthRisksEventHandler healthRisksEventHandler,
IDataCollectorsEventHandler dataCollectorsEventHandler,
MongoDBHandler mongoDbHandler)
{
_caseReportsEventHandler = caseReportsEventHandler;
_healthRisksEventHandler = healthRisksEventHandler;
_dataCollectorsEventHandler = dataCollectorsEventHandler;
_mongoDbHandler = mongoDbHandler;
}
public async Task <HttpResponseMessage> GetActivityMasters()
{
_database = MongoDBHandler.mDatabase();
IMongoCollection <ActivityMasters> collectionActivity = _database.GetCollection <ActivityMasters>("ActivityMasters");
var searchResult = await collectionActivity.Find(s => true).SortBy(s => s.Type).ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResult);
return(response);
}
public async Task <HttpResponseMessage> GetSystemProductMappingByCode(string SupplierProductCode, string SupplierCode)
{
_database = MongoDBHandler.mDatabase();
IMongoCollection <ProductMapping> collectionProductMapping = _database.GetCollection <ProductMapping>("ProductMapping");
FilterDefinition <ProductMapping> filter;
filter = Builders <ProductMapping> .Filter.Empty;
filter = filter & Builders <ProductMapping> .Filter.Eq(x => x.SupplierProductCode, SupplierProductCode.Trim().ToUpper());
filter = filter & Builders <ProductMapping> .Filter.Eq(x => x.SupplierCode, SupplierCode.Trim().ToUpper());
filter = filter & Builders <ProductMapping> .Filter.Or(Builders <ProductMapping> .Filter.Eq(x => x.MappingStatus, "MAPPED"), Builders <ProductMapping> .Filter.Eq(x => x.MappingStatus, "AUTOMAPPED"));
//var searchResult = await collectionProductMapping.Find(filter)
// .Project(x => new SystemProductMapping_RS
// {
// SupplierCode = x.SupplierCode,
// MapId = x.MapId,
// SupplierProductCode = x.SupplierProductCode,
// SystemProductCode = x.SystemProductCode,
// TlgxMdmHotelId = x.TlgxMdmHotelId
// })
// .ToListAsync();
var searchResult = await collectionProductMapping.Find(filter)
.Project(x => new CompleteProductMapping_RS
{
SupplierCode = x.SupplierCode,
MapId = x.MapId,
SupplierProductCode = x.SupplierProductCode,
SystemProductCode = x.SystemProductCode,
TlgxMdmHotelId = x.TlgxMdmHotelId,
SupplierCityCode = x.SupplierCityCode,
SupplierCityName = x.SupplierCityName,
SupplierCountryCode = x.SupplierCountryCode,
SupplierCountryName = x.SupplierCountryName,
SupplierProductName = x.SupplierProductName,
SystemCityCode = x.SystemCityCode,
SystemCityName = x.SystemCityName,
SystemCountryCode = x.SystemCountryCode,
SystemCountryName = x.SystemCountryName,
SystemProductName = x.SystemProductName,
SystemProductType = x.SystemProductType
})
.ToListAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResult);
return(response);
}
public async Task <HttpResponseMessage> GetVisaDetailByCountryCode(string CountryCode)
{
_database = MongoDBHandler.mDatabase();
IMongoCollection <DistributionWebApi.Models.VisaDefinition> collectionVisa = _database.GetCollection <DistributionWebApi.Models.VisaDefinition>("VisaMapping");
var filter = Builders <DistributionWebApi.Models.VisaDefinition> .Filter.ElemMatch(x => x.VisaDetail, x => x.CountryCode.ToLower() == CountryCode.ToLower());
var searchResult = await collectionVisa.Find(filter).FirstOrDefaultAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResult);
return(response);
}
public List <CreditCard> GetAllCards()
{
var handler = new MongoDBHandler();
var retriever = new AXRertrieveCreditCards();
var cards = retriever.GetAllPaidByUsCreditCards();
foreach (var card in cards) //Check if image exists in DB.
{
card.ImageExist = handler.IsImageExist(card.ComputeHashForImage());
}
return(cards);
}
public async Task <HttpResponseMessage> GetProductByEzeegoId(string id)
{
_database = MongoDBHandler.mDatabase();
var collection = _database.GetCollection <HotelsHotel>("Accommodations");
var result = await collection.Find(c => c.HotelId == id).ToListAsync();
var hotels = new Hotels();
hotels.Hotel = result;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, hotels);
return(response);
}
public async Task <HttpResponseMessage> GetActivityDetailsByCode(int Code)
{
_database = MongoDBHandler.mDatabase();
IMongoCollection <ActivityDefinition> collectionActivity = _database.GetCollection <ActivityDefinition>("ActivityDefinitions");
FilterDefinition <ActivityDefinition> filter;
filter = Builders <ActivityDefinition> .Filter.Empty;
filter = filter & Builders <ActivityDefinition> .Filter.Eq(x => x.SystemActivityCode, Code);
var searchResult = await collectionActivity.Find(filter).FirstOrDefaultAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResult);
return(response);
}
public async Task <HttpResponseMessage> GetHolidayByNakshatraHolidayId(string NakshtraHolidayid)
{
_database = MongoDBHandler.mDatabase();
IMongoCollection <HolidayModel> collectionHolidayModelMapping = _database.GetCollection <HolidayModel>("HolidayMapping");
FilterDefinition <HolidayModel> filter;
filter = Builders <HolidayModel> .Filter.Empty;
//NakshtraHolidayid = NakshtraHolidayid.ToUpper();
filter = filter & Builders <HolidayModel> .Filter.Eq(x => x.NakshatraHolidayId, NakshtraHolidayid.TrimEnd().TrimStart());
var searchResult = await collectionHolidayModelMapping.Find(filter).FirstOrDefaultAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResult);
return(response);
}
public async Task <HttpResponseMessage> GetActivityDetailsBySupplierAndProductCode(string SupplierCode, string ProductCode)
{
_database = MongoDBHandler.mDatabase();
IMongoCollection <ActivityDefinition> collectionActivity = _database.GetCollection <ActivityDefinition>("ActivityDefinitions");
FilterDefinition <ActivityDefinition> filter;
filter = Builders <ActivityDefinition> .Filter.Empty;
filter = filter & Builders <ActivityDefinition> .Filter.Eq(x => x.SupplierCompanyCode, SupplierCode.Trim().ToLower());
filter = filter & Builders <ActivityDefinition> .Filter.Eq(x => x.SupplierProductCode, ProductCode.Trim().ToUpper());
var searchResult = await collectionActivity.Find(filter).FirstOrDefaultAsync();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, searchResult);
return(response);
}
/// <summary>
/// Gets the warnings of a certain user by page (maximum of 5 logs per page).
/// </summary>
/// <param name="context">Gives the context needed to execute the command.</param>
/// <param name="mentionedUser">Gives the user of whom the warnings need to be checked.</param>
/// <param name="page">Gives the page the user wants to view.</param>
public async Task GetWarnings(SocketCommandContext context, SocketGuildUser mentionedUser, int page)
{
var mongoDbHandler = new MongoDBHandler(context.Guild.Id.ToString());
var userLog =
mongoDbHandler.LoadRecordByField <UserLogsModel>("Logs", "_id", Convert.ToInt64(mentionedUser.Id));
if (userLog == null)
{
await context.Channel.SendMessageAsync("This user has no logs!");
return;
}
var builder = new EmbedBuilder();
builder.WithAuthor(mentionedUser.Username, mentionedUser.GetAvatarUrl());
builder.WithColor(255, 183, 229);
var actions = userLog.Actions;
//Calculates the amount of possible pages
var maxPages = Math.Ceiling(Convert.ToDouble(actions.Count) / 5) - 1;
//Checks if the current given page is possible to reach
page = page > maxPages ? (int)maxPages : page;
//Loops the logs of the given pages
for (var i = page * 5; i < page * 5 + 5; i++)
{
if (actions.Count > i)
{
builder.AddField("Case: [" + i + "] - " + actions[i].GetActionType(), actions[i].GetReason());
continue;
}
break;
}
builder.WithFooter("Page " + (page + 1) + "/" + (maxPages + 1));
await context.Channel.SendMessageAsync("", false, builder.Build());
}
public BeerCreatedReceicer(StockRepository stockRepository, IStockstoreDatabaseSettings settings, ILogger <BeerCreatedReceicer> logger)
{
_mongoDBHandler = new MongoDBHandler(settings);
_stockRepository = stockRepository;
_rabbitMqHost = Environment.GetEnvironmentVariable("RABBITMQ_HOST");
_rabbitMqPort = Int32.Parse(Environment.GetEnvironmentVariable("RABBITMQ_PORT"));
var rbUserName = Environment.GetEnvironmentVariable("RABBITMQ_USERNAME");
var rbPassword = Environment.GetEnvironmentVariable("RABBITMQ_PASSWORD");
_logger = logger;
_connectionFactory = new ConnectionFactory()
{
HostName = _rabbitMqHost,
Port = _rabbitMqPort,
UserName = rbUserName,
Password = rbPassword
};
InitializeRabbitMqListener();
}
private async void button3_Click(object sender, EventArgs e)
{
var MediaManagerDataJSON = File.ReadAllText(@"D:\wamp\tmp\media_manager_posts.json");
var PublishedPostsDataJSON = File.ReadAllText(@"D:\wamp\tmp\published_posts_graphAPI.json");
var MediaManagerData = Newtonsoft.Json.JsonConvert.DeserializeObject <List <MediaManagerPostModels.Datum> >(MediaManagerDataJSON);
var PublishedPostsData = Newtonsoft.Json.JsonConvert.DeserializeObject <List <PublishedPostsGraphModels.Datum> >(PublishedPostsDataJSON);
// match each article from media manager list with a data_link from published posts list.
foreach (var article in MediaManagerData)
{
// PublishedPosts data list contains IDs with prefix, so split them first and get the actual id
var ppEntry = PublishedPostsData.FirstOrDefault(a => a.id.Split('_')[1].Equals(article.id));
if (ppEntry != null && ppEntry.attachments != null)
{
article.data_link = ppEntry.attachments.data[0].unshimmed_url;
}
}
await MongoDBHandler.InsertFbGraphArticles(MediaManagerData);
}
