public static async Task <Contract> ToEntity(ContractDto contractDto, InfinityDataContext infinityDataContext)
{
if (contractDto == null)
{
return(null);
}
var entity = await infinityDataContext.Contracts.FindAsync(contractDto.Id);
if (entity == null)
{
return(new Contract
{
Id = contractDto.Id,
CustomerName = contractDto.CustomerName,
CustomerAddress = contractDto.CustomerAddress,
TotalPrice = contractDto.TotalPrice,
BrokerName = contractDto.BrokerName,
BrokerAddress = contractDto.BrokerAddress,
ContractStartDate = Utility.ConvertToUTC(contractDto.ContractStartDate),
ContractEndDate = Utility.ConvertToUTC(contractDto.ContractEndDate)
});
}
entity.CustomerName = contractDto.CustomerName;
entity.CustomerAddress = contractDto.CustomerAddress;
entity.TotalPrice = contractDto.TotalPrice;
entity.BrokerName = contractDto.BrokerName;
entity.BrokerAddress = contractDto.BrokerAddress;
entity.ContractStartDate = Utility.ConvertToUTC(contractDto.ContractStartDate);
entity.ContractEndDate = Utility.ConvertToUTC(contractDto.ContractEndDate);
return(entity);
}
public static async Task <Account> ToEntity(AccountDto accountDto, InfinityDataContext infinityDataContext)
{
if (accountDto == null)
{
return(null);
}
var entity = await infinityDataContext.Accounts.FindAsync(accountDto.Id);
if (entity == null)
{
return(new Account
{
Id = accountDto.Id,
RentAmountPaid = accountDto.RentAmountPaid,
ElectricBillPaid = accountDto.ElectricBillPaid,
WaterBillPaid = accountDto.WaterBillPaid,
Remarks = accountDto.Remarks,
MonthPaid = accountDto.MonthPaid,
PaymentDate = Utility.ConvertToUTC(accountDto.PaymentDate),
Tenant = await infinityDataContext.Tenants.FirstOrDefaultAsync(i => i.Id == accountDto.TenantId)
});
}
entity.Id = accountDto.Id;
entity.RentAmountPaid = accountDto.RentAmountPaid;
entity.ElectricBillPaid = accountDto.ElectricBillPaid;
entity.WaterBillPaid = accountDto.WaterBillPaid;
entity.Remarks = accountDto.Remarks;
entity.MonthPaid = accountDto.MonthPaid;
entity.PaymentDate = Utility.ConvertToUTC(accountDto.PaymentDate);
entity.Tenant = await infinityDataContext.Tenants.FirstOrDefaultAsync(i => i.Id == accountDto.TenantId);
return(entity);
}
public static async void ProcessWrite(InfinityDataContext infinityDataContext, int iMonat, string fileName)
{
var buffer = new StringBuilder();
var accounts = await infinityDataContext.Accounts.Where(a => a.PaymentDate.Month == iMonat && a.PaymentDate.Year == DateTime.Now.Year).OrderBy(a => a.Tenant.RentedPlace.RentedName).ToListAsync();
foreach (var account in accounts)
{
AccountDto.FormatTsqm(buffer, account);
}
buffer = AccountDto.FormatHeader().Append(buffer);
await AccountDto.WriteTextAsync(fileName, buffer.ToString());
}
public static async Task <RentedPlace> ToEntity(int id, InfinityDataContext infinityDataContext)
{
var entity = await infinityDataContext.RentedPlaces.FindAsync(id);
if (entity == null)
{
return(new RentedPlace
{
Id = entity.Id,
RentedName = entity.RentedName,
Address = entity.Address
});
}
return(entity);
}
public static async Task <TenantDto> FromEntity(int id, InfinityDataContext infinityDataContext)
{
var entity = await infinityDataContext.Tenants.FindAsync(id);
return(new TenantDto
{
Id = entity.Id,
FirstName = entity.FirstName,
LastName = entity.LastName,
DownPayment = entity.DownPayment,
Deposit = entity.Deposit,
UsedDownPayment = entity.UsedDownPayment,
UsedDeposit = entity.UsedDeposit,
Active = entity.Active,
DateInsert = Utility.ConvertToUTC(entity.DateInsert),
RentedPlacesId = entity.RentedPlace.Id,
RentedName = entity.RentedPlace.RentedName
});
}
public static async Task <Contract> ToEntity(int id, InfinityDataContext infinityDataContext)
{
var entity = await infinityDataContext.Contracts.FindAsync(id);
if (entity == null)
{
return(new Contract
{
Id = entity.Id,
CustomerName = entity.CustomerName,
CustomerAddress = entity.CustomerAddress,
TotalPrice = entity.TotalPrice,
BrokerName = entity.BrokerName,
BrokerAddress = entity.BrokerAddress,
ContractStartDate = Utility.ConvertToUTC(entity.ContractStartDate),
ContractEndDate = Utility.ConvertToUTC(entity.ContractEndDate)
});
}
return(entity);
}
public static async Task <Account> ToEntity(int id, InfinityDataContext infinityDataContext)
{
var entity = await infinityDataContext.Accounts.FindAsync(id);
if (entity == null)
{
return(new Account
{
Id = entity.Id,
RentAmountPaid = entity.RentAmountPaid,
ElectricBillPaid = entity.ElectricBillPaid,
WaterBillPaid = entity.WaterBillPaid,
Remarks = entity.Remarks,
MonthPaid = entity.MonthPaid,
PaymentDate = Utility.ConvertToUTC(entity.PaymentDate),
Tenant = await infinityDataContext.Tenants.FirstOrDefaultAsync(i => i.Id == entity.Tenant.Id)
});
}
return(entity);
}
public static async Task <AccountDto> FromEntity(int id, InfinityDataContext infinityDataContext)
{
var entity = await infinityDataContext.Accounts.FindAsync(id);
if (entity == null)
{
return(null);
}
return(new AccountDto
{
Id = entity.Id,
RentAmountPaid = entity.RentAmountPaid,
ElectricBillPaid = entity.ElectricBillPaid,
WaterBillPaid = entity.WaterBillPaid,
Remarks = entity.Remarks,
MonthPaid = entity.MonthPaid,
PaymentDate = Utility.ConvertToUTC(entity.PaymentDate),
TenantId = entity.Tenant.Id,
TenantName = entity.Tenant.FirstName
});
}
public static async Task <Tenant> ToEntity(TenantDto tenantDto, InfinityDataContext infinityDataContext)
{
if (tenantDto == null)
{
return(null);
}
var entity = await infinityDataContext.Tenants.FindAsync(tenantDto.Id);
if (entity == null)
{
return(new Tenant
{
Id = tenantDto.Id,
FirstName = tenantDto.FirstName,
LastName = tenantDto.LastName,
DownPayment = tenantDto.DownPayment,
Deposit = tenantDto.Deposit,
UsedDownPayment = tenantDto.UsedDownPayment,
UsedDeposit = tenantDto.UsedDeposit,
Active = tenantDto.Active,
DateInsert = Utility.ConvertToUTC(tenantDto.DateInsert),
RentedPlace = await infinityDataContext.RentedPlaces.FirstOrDefaultAsync(i => i.Id == tenantDto.RentedPlacesId)
});
}
entity.Id = tenantDto.Id;
entity.FirstName = tenantDto.FirstName;
entity.LastName = tenantDto.LastName;
entity.DownPayment = tenantDto.DownPayment;
entity.Deposit = tenantDto.Deposit;
entity.UsedDownPayment = tenantDto.UsedDownPayment;
entity.UsedDeposit = tenantDto.UsedDeposit;
entity.Active = tenantDto.Active;
entity.DateInsert = Utility.ConvertToUTC(tenantDto.DateInsert);
entity.RentedPlace = await infinityDataContext.RentedPlaces.FirstOrDefaultAsync(i => i.Id == tenantDto.RentedPlacesId);
return(entity);
}
public static async Task <Tenant> ToEntity(int id, InfinityDataContext infinityDataContext)
{
var entity = await infinityDataContext.Tenants.FindAsync(id);
if (entity == null)
{
return(new Tenant
{
Id = entity.Id,
FirstName = entity.FirstName,
LastName = entity.LastName,
DownPayment = entity.DownPayment,
Deposit = entity.Deposit,
UsedDownPayment = entity.UsedDownPayment,
UsedDeposit = entity.UsedDeposit,
Active = entity.Active,
DateInsert = Utility.ConvertToUTC(entity.DateInsert),
RentedPlace = await infinityDataContext.RentedPlaces.FirstOrDefaultAsync(i => i.Id == entity.RentedPlace.Id)
});
}
return(entity);
}
public TenantController(
InfinityDataContext context)
{
_context = context;
}
public RentedPlaceController(
InfinityDataContext context)
{
_context = context;
}
public static async Task <RentedPlace> ToEntity(RentedPlaceDTO rentedPlaceDto, InfinityDataContext infinityDataContext)
{
if (rentedPlaceDto == null)
{
return(null);
}
var entity = await infinityDataContext.RentedPlaces.FindAsync(rentedPlaceDto.Id);
if (entity == null)
{
return(new RentedPlace
{
Id = entity.Id,
RentedName = rentedPlaceDto.RentedName,
Address = rentedPlaceDto.Address
});
}
entity.RentedName = rentedPlaceDto.RentedName;
entity.Address = rentedPlaceDto.Address;
return(entity);
}
public AccountController(
InfinityDataContext context, IHostEnvironment env)
{
_context = context;
_env = env;
}
public CustomerContractController(
InfinityDataContext context)
{
_context = context;
}
public CsvController(InfinityDataContext context, IHostingEnvironment env)
{
_context = context;
_env = env;
}
