/* private void ValidateOwership(OwnershipDTO ownership)
* {
* throw new NotImplementedException();
* }*/
public async Task AddTenancyAsync(TenancyDTO tenancy)
{
var gateway = _gatewayFactory.CreateTenancyTableGateway();
/*ValidateTenancy(tenancy);*/
var id = await gateway.InsertTenancyAsync(tenancy);
tenancy.TenancyId = id;
}
public async Task <int> CreateTenancyAsync(int unitId, string personName, DateTime from, DateTime?to, int numberOfPeople)
{
var tenantDto = new TenancyDTO {
UserName = personName, UnitId = unitId, From = from, To = to, NumberOfPeople = numberOfPeople
};
await _buildingManager.AddTenancyAsync(tenantDto).ConfigureAwait(false);
return(tenantDto.TenancyId);
}
public static TenancyDTO ToDTO(this ChangeTenantRequest tenant)
{
TenancyDTO dto = new TenancyDTO
{
PersonId = tenant.PersonId,
UserName = tenant.PersonName,
From = tenant.From,
To = tenant.To,
UnitId = tenant.UnitId,
NumberOfPeople = tenant.NumberOfPeople
};
return(dto);
}
public async Task UpdateTenancyAsync(DateTime oldFrom, TenancyDTO tenancy)
{
using (var connection = new SqlConnection(_connectionString))
{
using (var cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[SpUpdateTenancy]";
cmd.Parameters.AddWithValue("@oldFrom", oldFrom);
cmd.Parameters.AddWithValue("@unitId", tenancy.UnitId);
cmd.Parameters.AddWithValue("@username", tenancy.UserName);
cmd.Parameters.AddWithValue("@from", tenancy.From);
cmd.Parameters.AddWithValue("@to", tenancy.To);
cmd.Parameters.AddWithValue("@numberOfPeople", tenancy.NumberOfPeople);
cmd.Connection = connection;
cmd.Connection.Open();
await cmd.ExecuteNonQueryAsync();
}
}
}
public async Task <int> InsertTenancyAsync(TenancyDTO tenancy)
{
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", tenancy.UserName);
cmd.Connection = connection;
var result = await cmd.ExecuteScalarAsync();
if (result == null)
{
throw new ArgumentException("Username Not Exist");
}
tenancy.PersonId = Convert.ToInt32(result);
}
using (var cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[SpTenancyCreate]";
cmd.Parameters.AddWithValue("@unitId", tenancy.UnitId);
cmd.Parameters.AddWithValue("@personId", tenancy.PersonId);
cmd.Parameters.AddWithValue("@from", tenancy.From);
cmd.Parameters.AddWithValue("@to", tenancy.To);
cmd.Parameters.AddWithValue("@numberOfPeople", tenancy.NumberOfPeople);
cmd.Connection = connection;
var result = await cmd.ExecuteScalarAsync();
id = Convert.ToInt32(result);
}
}
return(id);
}
/* private void ValidateTenancy(TenancyDTO tenancy)
* {
* throw new NotImplementedException();
* }*/
public async Task UpdateTenancyAsync(DateTime oldFrom, TenancyDTO tenancy)
{
var gateway = _gatewayFactory.CreateTenancyTableGateway();
await gateway.UpdateTenancyAsync(oldFrom, tenancy);
}
