public void CreateRentalSummary(RentalSummary summary) { string query = String.Format("INSERT INTO tblrentalsummary (rentalid,total) values ('{0}','{1}')", summary.RentalId, summary.Total); qryObjectMapper.Map<RentalSummary>(query); }
public void UpdateRentalSummary(RentalSummary summary) { string query = String.Format("UPDATE tblrentalsummary set totaldenda ='{0}', total = '{1}' where rentalid = '{2}'", summary.TotalDenda, summary.Total, summary.RentalId); qryObjectMapper.Map<RentalSummary>(query); }
private decimal CreateRentalSummary(Rental rent) { decimal subtotal = 0; foreach (RentalItem itm in rent.Items) { subtotal += itm.Total; } RentalSummary summary = new RentalSummary() { RentalId = rent.RentalId, Total = subtotal }; Penyewaan.CreateRentalSummary(summary); return subtotal; }