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(); } }