public async Task <Guid> Exist(ServiceBillDTO dto)
{
using (MUEContext db = new MUEContext())
{
var ServiceBill = await db.ServiceBills
.Where(sb => sb.FlatId == dto.FlatId && sb.PeriodId == dto.PeriodId && sb.TypeOfServiceId == dto.TypeOfServiceId).FirstOrDefaultAsync();
if (ServiceBill == null)
{
return(Guid.Empty);
}
else
{
return(ServiceBill.ServiceBillId);
}
}
}
public async Task Create(ServiceBillDTO dto)
{
Guid id = Guid.NewGuid();
var ReCreate = await Exist(dto);
if (ReCreate != Guid.Empty)
{
await Delete(ReCreate);
}
using (MUEContext db = new MUEContext())
{
ServiceBill serviceBill = new ServiceBill {
ServiceBillId = id,
Status = 0,
FlatId = dto.FlatId,
PeriodId = dto.PeriodId,
TypeOfServiceId = dto.TypeOfServiceId,
Summ = dto.Summ
};
db.ServiceBills.Add(serviceBill);
await db.SaveChangesAsync();
}
}
