// GET Update - have more and more infor so u need add s.th func, example : update money ....
public async Task <int> Update(BillRequest update)
{
var bill = _context.InforBills.Find(update.Id);
if (bill == null)
{
return(0);
}
else
{
if (!IDmotel.Contains(update.IdMotel))
{
return(0);
}
else
{
bill.ElectricBill = update.ElectricBill;
bill.IdMotel = update.IdMotel;
bill.MonthRent = update.MonthRent;
bill.ParkingFee = update.ParkingFee;
bill.RoomBill = update.ParkingFee;
bill.WaterBill = update.WaterBill;
bill.WifiBill = update.WifiBill;
_context.InforBills.Update(bill);
return(await _context.SaveChangesAsync());
}
}
}
// Get Info bill payment by id
public async Task <PagedViewModel <BillRequest> > GetByIDMotel(int value)
{
if (!IDmotel.Contains(value))
{
return(null);
}
var result = from c in _context.InforBills
where c.IdMotel == value
select c;
var data = new PagedViewModel <BillRequest>()
{
Items = result.Select(x => new BillRequest()
{
ElectricBill = x.ElectricBill,
Id = x.IdInforBill,
IdMotel = x.IdMotel,
MonthRent = x.MonthRent,
ParkingFee = x.ParkingFee,
RoomBil = x.RoomBill,
WaterBill = x.WaterBill,
WifiBill = x.WifiBill,
Payment = x.Payment,
DateCreate = x.DateCreate,
}).ToList(),
TotalRecord = await result.CountAsync(),
};
return(data);
}
/*
* id is a value of motel room and u must get id for it
*/
// POST: create a bill payment
public async Task <int> Create(BillRequest create, int id)
{
if (!IDmotel.Contains(create.IdMotel))
{
return(0);
}
if (!IDBill.Contains(create.Id))
{
var bill = new InforBill()
{
ElectricBill = create.ElectricBill,
IdInforBill = create.Id,
MonthRent = create.MonthRent,
ParkingFee = create.ParkingFee,
RoomBill = create.RoomBil,
WaterBill = create.WaterBill,
WifiBill = create.WifiBill,
IdMotel = id,
Payment = false,
DateCreate = DateTime.Now,
};
_context.InforBills.Add(bill);
return(await _context.SaveChangesAsync());
}
return(0);
}
//Update detail of Bill - IDMotel
public async Task <int> UpdateIdMotel(string id, int idmotel)
{
if (IDmotel.Contains(idmotel))
{
var result = _context.InforBills.Find(id);
if (result != null)
{
result.ElectricBill = idmotel;
_context.Update(result);
return(await _context.SaveChangesAsync());
}
}
return(0);
}
