public async Task AddOwnershipAsync(OwnershipDTO ownership)
{
var gateway = _gatewayFactory.CreateOwnershipTableGateway();
/*ValidateOwership(ownership);*/
var id = await gateway.InsertOwnershipAsync(ownership).ConfigureAwait(false);
ownership.Id = id;
}
public async Task <int> CreateOwnershipAsync(int unitId, string personName, DateTime from, DateTime?to)
{
var ownerDto = new OwnershipDTO {
UserName = personName, UnitId = unitId, From = from, To = to
};
await _buildingManager.AddOwnershipAsync(ownerDto);
return(ownerDto.Id);
}
public static OwnershipDTO ToDTO(this ChangeOwnerRequest owner)
{
OwnershipDTO dto = new OwnershipDTO
{
UserName = owner.PersonName,
PersonId = owner.PersonId,
From = owner.From,
To = owner.To,
UnitId = owner.UnitId
};
return(dto);
}
public async Task UpdateOwnershipAsync(DateTime oldFrom, OwnershipDTO ownership)
{
using (var connection = new SqlConnection(_connectionString))
{
using (var cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[SpUpdateOwnership]";
cmd.Parameters.AddWithValue("@oldFrom", oldFrom);
cmd.Parameters.AddWithValue("@unitId", ownership.UnitId);
cmd.Parameters.AddWithValue("@username", ownership.UserName);
cmd.Parameters.AddWithValue("@from", ownership.From);
cmd.Parameters.AddWithValue("@to", ownership.To);
cmd.Connection = connection;
cmd.Connection.Open();
await cmd.ExecuteNonQueryAsync();
}
}
}
public async Task <int> InsertOwnershipAsync(OwnershipDTO ownership)
{
int id = 0;
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
using (var cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[SpGetUserIdByUserName]";
cmd.Parameters.AddWithValue("@userName", ownership.UserName);
cmd.Connection = connection;
var result = await cmd.ExecuteScalarAsync();
if (result == null)
{
throw new ArgumentException("Username Not Exist");
}
ownership.PersonId = Convert.ToInt32(result);
}
using (var cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[SpOwnershipCreate]";
cmd.Parameters.AddWithValue("@unitId", ownership.UnitId);
cmd.Parameters.AddWithValue("@personId", ownership.PersonId);
cmd.Parameters.AddWithValue("@from", ownership.From);
cmd.Parameters.AddWithValue("@to", ownership.To);
cmd.Connection = connection;
var result = await cmd.ExecuteScalarAsync();
id = Convert.ToInt32(result);
}
}
return(id);
}
public async Task UpdateOwnershipAsync(DateTime oldFrom, OwnershipDTO ownershipDTO)
{
var gateway = _gatewayFactory.CreateOwnershipTableGateway();
await gateway.UpdateOwnershipAsync(oldFrom, ownershipDTO);
}
