/// <summary>
/// Get all team related to user.
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
//public async Task<int> GetDefaultPointSystemId()
//{
//try
//{
// this.StartTransaction();
// string getQuery = @"SELECT TournamentPointSystemId FROM [dbo].[TournamentPointSystem] WHERE Name='Default'";
// // save the team model
// var result = await LoadDataInTransactionUsingQueryAsync<int, dynamic>(getQuery, new { Id = userId });
// this.CommitTransaction();
// return result;
//}
//catch (Exception)
//{
// this.RollbackTransaction();
// //return false; ??
// throw;
//}
//}
#region Tournament type
public async Task <IActionResult> AddTypeAsync(TournamentTypeContractModel model)
{
try
{
this.StartTransaction();
string insertQuery = @"INSERT INTO [dbo].[TournamentTypes]([Name],[Description]) VALUES (@Name,@Description)";
var rowsAffected = await this.SaveDataInTransactionUsingQueryAsync(insertQuery, model);
this.CommitTransaction();
if (rowsAffected > 0)
{
return(new OkResult());
}
else
{
return(new BadRequestResult());
}
}
catch (Exception)
{
this.RollbackTransaction();
throw;
}
}
public async Task <IActionResult> UpdateTypeAsync(TournamentTypeContractModel model)
{
try
{
this.StartTransaction();
string updateQuery = @"UPDATE [dbo].[TournamentTypes] SET Name=@Name,Description=@Description WHERE TournamentTypeId=@TournamentTypeId";
var rowsAffected = await this.SaveDataInTransactionUsingQueryAsync(updateQuery, model);
this.CommitTransaction();
if (rowsAffected > 0)
{
return(new OkResult());
}
else
{
return(new BadRequestResult());
}
}
catch (Exception)
{
this.RollbackTransaction();
throw;
}
}
public async Task <IActionResult> UpdateTypeAsync(TournamentTypeContractModel model)
{
try
{
return(await tournamentRepo.UpdateTypeAsync(model));
}
catch (Exception)
{
return(BadRequest());
}
}
