public bool Update(CounterSquad counterSquadToUpdate, string id)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
var sql = @"UPDATE [dbo].[CounterSquad]
SET [Id] = @newId
,[Name] = @name
,[Type] = @type
,[LeaderName] = @leaderName
,[Toon2Name] = @toon2Name
,[Toon3Name] = @toon3Name
,[Toon4Name] = @toon4Name
,[Toon5Name] = @toon5Name
,[Subs] = @subs
,[Description] = @description
,[CounterStrategy] = @counterStrategy
,[IsLeaderRequired] = @isLeaderRequired
,[IsToon2Required] = @isToon2Required
,[IsToon3Required] = @isToon3Required
,[IsToon4Required] = @isToon4Required
,[IsToon5Required] = @isToon5Required
WHERE [Id] = @id";
var parameters = new
{
id,
newId = counterSquadToUpdate.Id,
name = counterSquadToUpdate.Name,
type = counterSquadToUpdate.Type,
leaderName = counterSquadToUpdate.LeaderName,
toon2Name = counterSquadToUpdate.Toon2Name,
toon3Name = counterSquadToUpdate.Toon3Name,
toon4Name = counterSquadToUpdate.Toon4Name,
toon5Name = counterSquadToUpdate.Toon5Name,
subs = counterSquadToUpdate.Subs,
description = counterSquadToUpdate.Description,
counterStrategy = counterSquadToUpdate.CounterStrategy,
isLeaderRequired = counterSquadToUpdate.IsLeaderRequired,
isToon2Required = counterSquadToUpdate.IsToon2Required,
isToon3Required = counterSquadToUpdate.IsToon3Required,
isToon4Required = counterSquadToUpdate.IsToon4Required,
isToon5Required = counterSquadToUpdate.IsToon5Required
};
return(connection.Execute(sql, parameters) == 1);
}
}
public bool Create(CounterSquad newCounterSquad)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
var addCounterSquad = @"INSERT INTO [dbo].[CounterSquad]
([Id]
,[Name]
,[Type]
,[LeaderName]
,[Toon2Name]
,[Toon3Name]
,[Toon4Name]
,[Toon5Name]
,[Subs]
,[Description]
,[CounterStrategy]
,[IsLeaderRequired]
,[IsToon2Required]
,[IsToon3Required]
,[IsToon4Required]
,[IsToon5Required])
VALUES
(@id
,@name
,@type
,@leaderName
,@toon2Name
,@toon3Name
,@toon4Name
,@toon5Name
,@subs
,@description
,@counterStrategy
,@isLeaderRequired
,@isToon2Required
,@isToon3Required
,@isToon4Required
,@isToon5Required)";
var parameters = new
{
id = newCounterSquad.Id,
name = newCounterSquad.Name,
type = newCounterSquad.Type,
leaderName = newCounterSquad.LeaderName,
toon2Name = newCounterSquad.Toon2Name,
toon3Name = newCounterSquad.Toon3Name,
toon4Name = newCounterSquad.Toon4Name,
toon5Name = newCounterSquad.Toon5Name,
subs = newCounterSquad.Subs,
description = newCounterSquad.Description,
counterStrategy = newCounterSquad.CounterStrategy,
isLeaderRequired = newCounterSquad.IsLeaderRequired,
isToon2Required = newCounterSquad.IsToon2Required,
isToon3Required = newCounterSquad.IsToon3Required,
isToon4Required = newCounterSquad.IsToon4Required,
isToon5Required = newCounterSquad.IsToon5Required
};
var rowsAffected = connection.Execute(addCounterSquad, parameters);
return(rowsAffected == 1);
}
}
public bool PutCounterSquad(CounterSquad counterSquad, string counterSquadId)
{
return(_repo.Update(counterSquad, counterSquadId));
}
public bool PostCounterSquad(CounterSquad counterSquad)
{
return(_repo.Create(counterSquad));
}
