public async Task <OperationResult> Insert(HouseObject obj, HousingLayout layout)
{
OperationResult result = new();
var(objKeys, objValues) = GetArray <HouseObject>(obj);
var(layoutKeys, layoutValues) = GetArray <HousingLayout>(layout);
string houseObjectQuery = $"Insert Into HouseObjects ({string.Join(",", objKeys)}) Values ({string.Join(",", objValues)})";
string housingLayoutQuery = $"Insert Into HousingLayouts ({string.Join(",", layoutKeys)}) Values ({string.Join(",", layoutValues)})";
_conn.Open();
using (var _tran = _conn.BeginTransaction())
{
try
{
await _conn.ExecuteAsync(houseObjectQuery);
await _conn.ExecuteAsync(housingLayoutQuery);
result.IsSuccessful = true;
_tran.Commit();
}
catch (Exception ex)
{
await _tran.RollbackAsync();
result.IsSuccessful = false;
result.Exception = ex;
}
}
return(result);
}
public async Task <OperationResult> Update(HouseObject obj, HousingLayout layout)
{
OperationResult result = new();
var(objKeys, objValues) = GetArray <HouseObject>(obj);
var(layoutKeys, layoutValues) = GetArray <HousingLayout>(layout);
var objStrings = string.Empty;
var layoutStrings = string.Empty;
for (int i = 0; i < objKeys.Length; i++)
{
if (objValues[i] != null)
{
objStrings += $"{objKeys[i]}=${objValues[i]}";
}
}
for (int i = 0; i < layoutKeys.Length; i++)
{
if (layoutValues[i] != null)
{
layoutStrings += $"{layoutKeys[i]}=${layoutValues[i]}";
}
}
string houseObjectQuery = $"Update HouseObjects Set({objStrings}) Where HouseObjectId={obj.HouseObjectId}";
string housingLayoutQuery = $"Update HousingLayouts Set({layoutStrings}) Where HousingLayoutId={layout.HousingLayoutId}";
using (var _tran = _conn.BeginTransaction())
{
try
{
await _conn.ExecuteAsync(houseObjectQuery);
await _conn.ExecuteAsync(housingLayoutQuery);
result.IsSuccessful = true;
_tran.Commit();
}
catch (Exception ex)
{
await _tran.RollbackAsync();
result.IsSuccessful = false;
result.Exception = ex;
}
}
return(result);
}
public Task <OperationResult> CreateHouseObjects(HouseObjectCreateViewModel obj)
{
var housingLayoutId = Guid.NewGuid();
var houseObj = new HouseObject
{
HouseObjectId = Guid.NewGuid(),
HousingLayoutId = housingLayoutId,
DealDate = obj.DealDate,
Address = obj.Address,
HouseAge = obj.HouseAge,
County = obj.County,
IsParkingSpace = obj.IsParkingSpace,
ParkingSpacePrice = obj.ParkingSpacePrice,
ParkingSpaceSqureFeet = obj.ParkingSpaceSqureFeet,
Region = obj.Region,
Remark = obj.Remark,
Source = obj.Source,
SquareFeet = obj.SquareFeet,
SquareFeetUnitPrice = obj.SquareFeetUnitPrice,
TotalFloor = obj.TotalFloor,
TotalPrice = obj.TotalPrice,
Type = obj.Type,
ImgUrl = obj.ImgUrl,
Floor = obj.Floor,
CreateTime = DateTime.UtcNow.AddHours(8),
EditeTime = DateTime.UtcNow.AddHours(8),
CreateUser = "******",
EditeUser = "******",
};
var housingLayout = new HousingLayout
{
HousingLayoutId = housingLayoutId,
Bathroom = obj.Bathroom,
LivingRoom = obj.LivingRoom,
Room = obj.Room,
EditeTime = DateTime.UtcNow.AddHours(8),
CreateTime = DateTime.UtcNow.AddHours(8),
CreateUser = "******",
EditeUser = "******"
};
var result = _repo.Insert(houseObj, housingLayout);
return(result);
}
