public int Add(int idClient, int idAward)
{
if (GetAll() == null)
{
FakeDaoClientAward = new Dictionary <int, ClientAward>();
}
using (StreamWriter fileJson = new StreamWriter(_path, false))
{
var award = new ClientAward
{
IdClient = idClient,
IdAchievement = idAward
};
if (FakeDaoClientAward.Any())
{
award.Id = FakeDaoClientAward.Select(x => x.Key).Max();
_id = ++award.Id;
}
FakeDaoClientAward.Add(_id, award);
var json = JsonConvert.SerializeObject(FakeDaoClientAward);
fileJson.WriteLine(json);
return(_id++);
}
}
public ClientAward Update(ClientAward clientAward)
{
if (GetAll() == null)
{
return(null);
}
var item = GetById(clientAward.Id);
using (StreamWriter fileJson = new StreamWriter(_path, false))
{
if (!FakeDaoClientAward.Any())
{
return(null);
}
if (item == null)
{
return(null);
}
FakeDaoClientAward[clientAward.Id] = clientAward;
var json = JsonConvert.SerializeObject(FakeDaoClientAward);
fileJson.WriteLine(json);
return(item);
}
}
public ClientAward Update(ClientAward clientAward)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "[dbo].[Sp_UpdateClientAward]";
SqlParameter ParameterId = new SqlParameter
{
DbType = DbType.Int32,
ParameterName = "@Id",
Value = clientAward.Id,
Direction = ParameterDirection.Input
};
command.Parameters.Add(ParameterId);
SqlParameter ParameterIdClient = new SqlParameter
{
DbType = DbType.Int32,
ParameterName = "@IdClient",
Value = clientAward.IdClient,
Direction = ParameterDirection.Input
};
command.Parameters.Add(ParameterIdClient);
SqlParameter ParameterIdAward = new SqlParameter
{
DbType = DbType.Int32,
ParameterName = "@IdAward",
Value = clientAward.IdAchievement,
Direction = ParameterDirection.Input
};
command.Parameters.Add(ParameterIdAward);
connection.Open();
command.ExecuteNonQuery();
//Бред какой то
return(clientAward);
}
}
public ClientAward Update(ClientAward clientAward)
{
return(_clientAwardDao.Update(clientAward));
}