public object Any(User request)
{
TableRepository tableRepository = new TableRepository();
var userQuery = tableRepository.GetTable(Tables.Users).CreateQuery<UserEntry>();
string username = request.Username;
username = TableEntityHelper.RemoveDiacritics(username);
username = TableEntityHelper.ToAzureKeyString(username);
var user = (from k in userQuery
where k.RowKey == username
select k).FirstOrDefault();
if (user == null)
return HttpError.NotFound(username + " do not exist");
var badges = tableRepository.Get<UserBadgeEntry>(Tables.UserBadges, user.GetUserId().ToString());
// "No similar question found... yet !"
return new UserResponse
{
Created = user.CreatedDate,
Badges = badges.Select(k => new BadgeResponse
{
Name = k.GetName(),
Awarded = k.Awarded,
}).ToArray()
};
}
public override int Add()
{
TElementType element = NewElement();
TableRepository.Add(element);
Items.Add(element);
return(element.Id);
}
public void NotificationNull()
{
//Arrange | Act
var repository = new TableRepository(GetPostgreSettings, null);
//Assert
Assert.NotNull(repository);
}
public void does_build_merge_for_table_with_no_schema_defined()
{
var tableRepository = new TableRepository(Path.Combine(Directories.GetSampleSolution(), @"NestedProjects\Nested\bin\Debug\Nested.dacpac"));
var mergeRepository = new MergeStatementRepository(tableRepository, Path.Combine(Directories.GetSampleSolution(), @"NestedProjects\Nested\ABC\DEF\Script.PostDeploy.sql"));
var merge = mergeRepository.Get().FirstOrDefault(p => p.Name.Value == "NoSchema");
Assert.IsNotNull(merge);
}
public TableBusinessModel()
{
_playerBusinessModel = new PlayerBusinessModel();
_tableRepository = new TableRepository(new SessionBusinessModel());
EventAggregator.Resolve <PlayerJoinedTable>().Subscribe(PlayerJoinedTableEvent);
EventAggregator.Resolve <PlayerLeftTable>().Subscribe(PlayerLeftTableEvent);
}
public ActionResult GetSingle()
{
// Создайте объект операции извлечения, который принимает объект сущности, производный от TableEntity. Первый параметр — ключ раздела partitionKey, а второй — ключ строки rowKey. Используя класс CustomerEntity и данные, представленные в разделе Добавление пакета сущностей в таблицу, следующий фрагмент кода направляет запрос к таблице на получение сущности CustomerEntity, свойство partitionKey которой имеет значение Smith, а свойство rowKey — значение Ben
string c = _configuration.GetConnectionString("start1storage_AzureStorageConnectionString");
CustomerEntity customer = TableRepository.ReadCustomer(c, _tableName, "Smith", "Ben");
return(View(customer));
}
public ActionResult DeleteEntity()
{
string c = _configuration.GetConnectionString("start1storage_AzureStorageConnectionString");
ViewBag.TableName = _tableName;
ViewBag.Result = TableRepository.DeleteCustomer(c, _tableName, "Smith", "Ben");
return(View());
}
public AttributedDocumentRepository(CloudStorageAccount storageAccount, IDocumentSerializer?serializer = default)
: base(storageAccount,
TableRepository.GetDefaultTableName <T>(),
PartitionKeyAttribute.CreateCompiledAccessor <T>(),
RowKeyAttribute.CreateCompiledAccessor <T>(),
serializer ?? DocumentSerializer.Default)
{
}
public ActionResult Index(Table tab)
{
if (ModelState.IsValid)
{
TableRepository.AddPerson(tab);
}
return(View());
}
public void Delete(int id)
{
var tr = new TableRepository(_context);
var table = tr.GetTableById(id);
var tm = new TableModification(_context);
tm.DeleteTable(table);
}
public void IsExistNoteById_Test()
{
var repo = new TableRepository();
var r = repo.IsExistNoteById(1);
Assert.AreEqual(true, r); // 현재 시점에서는 통과
}
public void does_not_build_merge_for_table_with_no_inline_table()
{
var tableRepository = new TableRepository(GetPath());
var mergeRepository = new MergeStatementRepository(tableRepository, Path.Combine(Directories.GetSampleSolution(), @"NestedProjects\Nested\ABC\DEF\Script.PostDeploy.sql"));
var merge = mergeRepository.Get().FirstOrDefault(p => p.Name.Value == "NoInlineTable");
Assert.IsNull(merge);
}
public override TElementType Add(params object[] values)
{
TElementType element = NewElement(values);
TableRepository.Add(element);
Items.Add(element);
return(element);
}
public void CreateForQuestion(TableRepository tableRepository, Guid userId, Guid questionId)
{
UserBadgeEntry badge = new UserBadgeEntry(userId, Name)
{
QuestionId = questionId,
};
tableRepository.InsertOrMerge(badge, Tables.UserBadges);
}
private async Task <Option <Table, Error> > CheckIfNumberIsNotTaken(AddTable command)
{
var table = await TableRepository
.GetByNumber(command.Number);
return(table
.SomeWhen(t => !t.HasValue, Error.Conflict($"Table number '{command.Number}' is already taken."))
.Map(_ => Mapper.Map <Table>(command)));
}
public UnitOfWork(CoffeeShopContext context)
{
_context = context;
Table = new TableRepository(_context);
User = new UserRepository(_context);
Category = new CategoryRepository(_context);
Foods = new FoodsRepository(_context);
Images = new ImageRepository(_context);
}
public void CreateForQuestion(TableRepository tableRepository, Guid userId, Guid questionId)
{
UserBadgeEntry badge = new UserBadgeEntry(userId, Name)
{
QuestionId = questionId,
};
tableRepository.InsertOrMerge(badge, Tables.UserBadges);
}
public DataMonitorView()
{
InitializeComponent();
_tableRepository = new TableRepository(AppContext.Instance);
_dataRepository = new DataRepository(AppContext.Instance);
InitData();
}
public void CreateIfNotExist(TableRepository tableRepository, Guid userId)
{
UserBadgeEntry badge = tableRepository.Get<UserBadgeEntry>(Tables.UserBadges, userId, Name);
if (badge == null)
{
badge = new UserBadgeEntry(userId, Name);
tableRepository.InsertOrMerge(badge, Tables.UserBadges);
}
}
public OrderViewModel(MainViewModel mainViewModel)
{
CurrentViewModel = new GroupItemsViewModel(this);
_mainViewModel = mainViewModel;
_orderDetailRepository = new OrderDetailRepository(_connectionString);
_orderRepository = new OrderRepository(_connectionString);
_tableRepository = new TableRepository(_connectionString);
_billRepositary = new BillRepository(_connectionString);
}
public void LoadAllTables()
{
TableRepository.LoadSingleFile(@"..\..\..\Tables\treasure table.json", new JSONLoader());
TableRepository.LoadSingleFile(@"..\..\..\Tables\magic base.json", new JSONLoader());
TableRepository.LoadAllMatchingStringFromDirectory(@"..\..\..\Tables", @"*special abilities*", new JSONLoader());
var baseTable = TableRepository.GetTableFromString("treasure table");
TableRepository.GetTableFromString("armor special abilities").Accept(new PrintEntireTreeVisitor());
TableRepository.GetTableFromString("shield special abilities").Accept(new PrintEntireTreeVisitor());
}
public Table(int wareId)
{
ITableRepository tr = new TableRepository();
Table tableToLoad = tr.LoadTable(wareId);
WareId = tableToLoad.WareId;
Length = tableToLoad.Length;
Width = tableToLoad.Width;
Quantity = 1;
}
private void Add_Table_Click(object sender, RoutedEventArgs e)
{
Table table = new Table()
{
TableInfo = TableInfoBox.Text
};
ITableRepository repository = new TableRepository();
repository.CreateTable(table);
}
private UserCard CreateUserCard(TableRepository tableRepository, Guid creatorId)
{
UserEntry user = tableRepository.Get <UserEntry>(Tables.Users, creatorId.ToString())?.FirstOrDefault();
return(new UserCard
{
Id = creatorId,
Username = user?.UserName
});
}
public void LoadTables()
{
TableRepository.LoadSingleFile(@"..\..\..\Tables\treasure table.json", new JSONLoader());
TableRepository.LoadSingleFile(@"..\..\..\Tables\magic base.json", new JSONLoader());
TableRepository.LoadAllMatchingStringFromDirectory(@"..\..\..\Tables", @"*special abilities*", new JSONLoader());
var baseTable = TableRepository.GetTableFromString("treasure table");
Assert.IsNotNull(baseTable);
}
public void sets_merge_options_to_show_missing_delete_clause()
{
var tableRepository = new TableRepository(GetPath());
var mergeRepository = new MergeStatementRepository(tableRepository, Path.Combine(Directories.GetSampleSolution(), @"NestedProjects\Nested\ABC\DEF\Script.PostDeploy.sql"));
var merge = mergeRepository.Get().FirstOrDefault(p => p.Name.Value == "NoDelete");
Assert.IsFalse(merge.Option.HasDelete);
Assert.IsTrue(merge.Option.HasInsert);
Assert.IsTrue(merge.Option.HasUpdate);
}
public override void Delete(int id)
{
TElementType element = Items.Find(e => e.Id == id);
if (element != null)
{
Items.Remove(element);
}
TableRepository.Remove(id);
}
public void CreateIfNotExist(TableRepository tableRepository, Guid userId)
{
UserBadgeEntry badge = tableRepository.Get <UserBadgeEntry>(Tables.UserBadges, userId, Name);
if (badge == null)
{
badge = new UserBadgeEntry(userId, Name);
tableRepository.InsertOrMerge(badge, Tables.UserBadges);
}
}
public ActionResult TruncateTable(TableModel model)
{
if (model.PostedTable != null && model.PostedTable.Name.Any())
{
var names = string.Join(",", model.PostedTable.Name.Select(c => c.Trim()));
TableRepository.Truncate(names);
ViewBag.Message = "Truncate thành công";
}
return(TruncateTable());
}
public override async Task <IEnumerable <TicketsPool> > Handle(GetEventsQuery request, CancellationToken cancellationToken)
{
var repo = new TableRepository <TicketsPool>(); //use ioc
var allEvents = await repo.GetAll();
var events = allEvents.OrderBy(ev => ev.EventName);
return(events);
}
private void FirstStart()
{
ModelContainer cont = new ModelContainer();
BranchRepository branchRepository = new BranchRepository(cont);
CategoryRepository categoryRepository = new CategoryRepository(cont);
CompanyOwnerRepository companyOwnerRepository = new CompanyOwnerRepository(cont);
PersonRepository personRepository = new PersonRepository(cont);
PositionRepository positionRepository = new PositionRepository(cont);
RoomRepository roomRepository = new RoomRepository(cont);
TableRepository tableRepository = new TableRepository(cont);
ClientRepository clientRepository = new ClientRepository(cont);
if (positionRepository.Positions().Count() == 0)
{
positionRepository.AddPosition("Суперпользователь", true, true, true, true, true, true);
}
CompanyOwner co = new CompanyOwner();
if (personRepository.Persones().Count() == 0)
{
co = companyOwnerRepository.AddCompanyOwner("Суперпользователь", "", "", "", "", "super", "super".GetHashCode().ToString(), "", "", "",
positionRepository.GetPositionByName("Суперпользователь"));
}
Branch b = new Branch();
if (branchRepository.Branches().Count() == 0)
{
b = branchRepository.AddBranch("", "", DateTime.Now, DateTime.Now, "", "", "", "", "", co, null);
}
Room r = new Room();
if (roomRepository.Rooms().Count() == 0)
{
r = roomRepository.AddRoom("", b);
}
if (categoryRepository.Categotyes().Count() == 0)
{
categoryRepository.AddCategory("");
}
if (tableRepository.Tables().Count() == 0)
{
tableRepository.AddTable(1, "", r);
}
if (clientRepository.Clients().Count() == 0)
{
clientRepository.AddClient("Клиент", "", "", "", "", "", "", "", "", "", "", "");
}
}
public void Get_All_Photos_Count()
{
var tableRepository = new TableRepository();
var blobRepository = new BlobRepository();
var visionService = new VisionService();
var photoService = new PhotoService(tableRepository, blobRepository, visionService);
var photos = photoService.GetAll();
Assert.IsTrue(photos.Count > 0);
}
private void btnGetTables_Click(object sender, EventArgs e)
{
var tables = TableRepository.GetTables("MordorEV").ToList();
clbTableList.Items.Clear();
foreach (var table in tables)
{
clbTableList.Items.Add(table, CheckState.Unchecked);
}
}
public object Any(Ask request)
{
AskResponse response = new AskResponse();
response.Result = ErrorCode.OK;
Guid creatorId = UserSession.GetUserId();
DateTime dateTime = DateTime.UtcNow;
QuestionEntry questionEntry = new QuestionEntry(creatorId, Guid.NewGuid())
{
Title = request.Title,
Detail = request.Detail,
Creation = dateTime,
Modification = dateTime,
Tags = string.Join(",", request.Tags).ToLowerInvariant()
};
TableRepository tableRepository = new TableRepository();
tableRepository.InsertOrReplace(questionEntry, Tables.Questions);
IndexHelper.CreateIndex(questionEntry.GetId(), request.Title + " " + questionEntry.Tags, Tables.Questions);
return response;
}
public object Any(Vote request)
{
Guid userId = UserSession.GetUserId();
VoteResponse response = new VoteResponse
{
Result = ErrorCode.OK,
};
TableRepository tableRepository = new TableRepository();
UserQuestionEntry userQuestionEntry = tableRepository.Get<UserQuestionEntry>(Tables.UserQuestion, request.QuestionId, userId);
// Création d'un nouveau vote
if (userQuestionEntry == null)
{
DateTime dateTime = DateTime.UtcNow;
userQuestionEntry = new UserQuestionEntry(request.QuestionId, userId)
{
Creation = dateTime,
Modification = dateTime
};
}
else
{
userQuestionEntry.Modification = DateTime.UtcNow;
}
Guid target = request.VoteTarget == VoteTarget.Question ? request.QuestionId : request.OwnerId;
HashSet<string> votesUp = new HashSet<string>(userQuestionEntry.VotesUp?.Split('|') ?? new string[] { });
HashSet<string> votesDown = new HashSet<string>(userQuestionEntry.VotesDown?.Split('|') ?? new string[] { });
VoteKind oldValue = VoteKind.None;
if (votesUp.Contains(target.ToString()))
oldValue = VoteKind.Up;
else if (votesDown.Contains(target.ToString()))
oldValue = VoteKind.Down;
response.VoteKind = request.VoteKind;
votesUp.Remove(target.ToString());
votesDown.Remove(target.ToString());
if (response.VoteKind == oldValue) response.VoteKind = VoteKind.None;
else
{
switch (response.VoteKind)
{
case VoteKind.Up:
votesUp.Add(target.ToString());
break;
case VoteKind.Down:
votesDown.Add(target.ToString());
break;
}
}
userQuestionEntry.VotesUp = votesUp.Join("|");
userQuestionEntry.VotesDown = votesDown.Join("|");
if (request.VoteTarget == VoteTarget.Answer)
{
AnswerEntry answerEntry = tableRepository.Get<AnswerEntry>(Tables.Answers, request.QuestionId, request.OwnerId);
answerEntry.Votes -= (int)oldValue;
answerEntry.Votes += (int)response.VoteKind;
tableRepository.InsertOrMerge(answerEntry, Tables.Answers);
response.VoteValue = answerEntry.Votes;
// badges
if (response.VoteKind == VoteKind.Up)
{
switch (answerEntry.Votes)
{
case 1: AllBadges.Approved.CreateIfNotExist(tableRepository, answerEntry.GetAnswerOwnerId()); break;
case 10: AllBadges.NiceAnswer.CreateForQuestion(tableRepository, answerEntry.GetAnswerOwnerId(), request.QuestionId); break;
case 25: AllBadges.GoodAnswer.CreateForQuestion(tableRepository, answerEntry.GetAnswerOwnerId(), request.QuestionId); break;
case 100: AllBadges.GreatAnswer.CreateForQuestion(tableRepository, answerEntry.GetAnswerOwnerId(), request.QuestionId); break;
}
}
}
else
{
QuestionEntry questionEntry = tableRepository.Get<QuestionEntry>(Tables.Questions, request.OwnerId, request.QuestionId);
questionEntry.Votes -= (int)oldValue;
questionEntry.Votes += (int)response.VoteKind;
tableRepository.InsertOrMerge(questionEntry, Tables.Questions);
response.VoteValue = questionEntry.Votes;
// badges
if (response.VoteKind == VoteKind.Up)
{
switch (questionEntry.Votes)
{
case 1: AllBadges.Padawan.CreateIfNotExist(tableRepository, questionEntry.GetOwnerId()); break;
case 10: AllBadges.NiceQuestion.CreateForQuestion(tableRepository, questionEntry.GetOwnerId(), request.QuestionId); break;
case 25: AllBadges.GoodQuestion.CreateForQuestion(tableRepository, questionEntry.GetOwnerId(), request.QuestionId); break;
case 100: AllBadges.GreatQuestion.CreateForQuestion(tableRepository, questionEntry.GetOwnerId(), request.QuestionId); break;
}
}
}
// insert le vote
tableRepository.InsertOrReplace(userQuestionEntry, Tables.UserQuestion);
// badges
if (response.VoteKind == VoteKind.Up)
AllBadges.Supporter.CreateIfNotExist(tableRepository, userId);
else if (response.VoteKind == VoteKind.Down)
AllBadges.Critic.CreateIfNotExist(tableRepository, userId);
return response;
}
public object Any(Love request)
{
Guid userId = UserSession.GetUserId();
LoveResponse response = new LoveResponse
{
Result = ErrorCode.OK,
};
TableRepository tableRepository = new TableRepository();
UserQuestionEntry userQuestionEntry = tableRepository.Get<UserQuestionEntry>(Tables.UserQuestion, request.QuestionId, userId);
// Création d'un nouveau vote
if (userQuestionEntry == null)
{
DateTime dateTime = DateTime.UtcNow;
userQuestionEntry = new UserQuestionEntry(request.QuestionId, userId)
{
Creation = dateTime,
Modification = dateTime
};
}
else
{
userQuestionEntry.Modification = DateTime.UtcNow;
}
userQuestionEntry.Love = !userQuestionEntry.Love;
// insert le vote
tableRepository.InsertOrReplace(userQuestionEntry, Tables.UserQuestion);
return response;
}
private UserCard CreateUserCard(TableRepository tableRepository, Guid creatorId)
{
UserEntry user = tableRepository.Get<UserEntry>(Tables.Users, creatorId.ToString())?.FirstOrDefault();
return new UserCard
{
Id = creatorId,
Username = user?.UserName
};
}
public object Any(Answers request)
{
TableRepository tableRepository = new TableRepository();
CloudTable questionTable = tableRepository.GetTable(Tables.Questions);
Guid questionId = Guid.Parse(request.Id);
TableQuery<QuestionEntry> questionQuery = questionTable.CreateQuery<QuestionEntry>();
QuestionEntry questionEntry = (from k in questionQuery
where k.RowKey == questionId.ToString()
select k).SingleOrDefault();
if (questionEntry == null)
throw HttpError.NotFound("Such question do not exist");
questionEntry.Views++;
tableRepository.InsertOrMerge(questionEntry, Tables.Questions);
CloudTable answerTable = tableRepository.GetTable(Tables.Answers);
TableQuery<AnswerEntry> answerQuery = answerTable.CreateQuery<AnswerEntry>();
AnswerEntry[] answerEntries = (from k in answerQuery
where k.PartitionKey == questionId.ToString()
select k).ToArray();
UserQuestionEntry userQuestionEntry = UserSession.IsAuthenticated
? tableRepository.Get<UserQuestionEntry>(Tables.UserQuestion, questionId, UserSession.GetUserId())
: null;
HashSet<string> votesUp = new HashSet<string>(userQuestionEntry?.VotesUp?.Split('|') ?? new string[] { });
HashSet<string> votesDown = new HashSet<string>(userQuestionEntry?.VotesDown?.Split('|') ?? new string[] { });
Func<Guid, VoteKind> getVoteKind = ownerId =>
{
if (votesUp.Contains(ownerId.ToString()))
return VoteKind.Up;
if (votesDown.Contains(ownerId.ToString()))
return VoteKind.Down;
return VoteKind.None;
};
AnswersResponse answersResponse = new AnswersResponse
{
Id = questionEntry.GetId(),
Creation = questionEntry.Creation,
Owner = CreateUserCard(tableRepository, questionEntry.GetOwnerId()),
Detail = questionEntry.Detail,
Tags = questionEntry.Tags.SplitAndTrimOn(new char[] { ',' }),
Title = questionEntry.Title,
Views = questionEntry.Views,
Votes = questionEntry.Votes,
SelectedAnswer = questionEntry.SelectedAnswer,
Answers = answerEntries.Select(k => new AnswerResult
{
Owner = CreateUserCard(tableRepository, k.GetAnswerOwnerId()),
Creation = k.Creation,
Content = k.Content,
Votes = k.Votes,
VoteKind = getVoteKind(k.GetAnswerOwnerId())
}).ToArray()
};
// quest user vote for this question
answersResponse.VoteKind = getVoteKind(questionId);
answersResponse.Love = userQuestionEntry?.Love ?? false;
return answersResponse;
}
public object Any(Answer request)
{
Guid userId = UserSession.GetUserId();
TableRepository tableRepository = new TableRepository();
// create answers
AnswerEntry answerEntry = tableRepository.Get<AnswerEntry>(Tables.Answers, request.QuestionId, userId);
if (answerEntry == null)
{
DateTime dateTime = DateTime.UtcNow;
answerEntry = new AnswerEntry(request.QuestionId, userId)
{
Content = request.Content,
Creation = dateTime,
Modification = dateTime,
Votes = 0
};
// update the answers count
QuestionEntry questionEntry = tableRepository.Get<QuestionEntry>(Tables.Questions, request.QuestionOwnerId, request.QuestionId);
if (questionEntry != null)
{
questionEntry.Answers++;
tableRepository.InsertOrMerge(questionEntry, Tables.Questions);
}
}
else
{
// perform an edit
answerEntry.Content = request.Content;
answerEntry.Modification = DateTime.UtcNow;
}
tableRepository.InsertOrMerge(answerEntry, Tables.Answers);
AnswerResponse response = new AnswerResponse
{
Result = ErrorCode.OK
};
return response;
}
public Table GetTable(int id)
{
TableRepository tableRepository = new TableRepository();
return tableRepository.Get(id);
}
public object Any(Top request)
{
TableRepository tableRepository = new TableRepository();
var questions = tableRepository.GetTable(Tables.Questions).CreateQuery<QuestionEntry>().ToArray().Take(10);
// "No similar question found... yet !"
return new TopResponse
{
Questions = questions.Select(k => new TopQuestionResponse
{
Id = k.GetId(),
Title = k.Title,
Votes = k.Votes,
Answers = k.Answers,
Views = k.Views
}).ToArray()
};
}
public TablesController()
{
var db = new CartSysContext();
repo = new TableRepository(db);
tableService = new TableService(repo);
}
