public IEnumerable<DailyGross> Get(Employee employee, DateTime start, DateTime end)
{
/*using (*/IDbConnection conn = this.Connection;//)
{
Rent r = employee.EffectiveRent(start);
return conn.Query<DailyGross>(cSelectDailyGrossesForEmployee_SQL, new {
RentID = r.RentID, StartTDS = start, EndTDS = end
});
}
}
public void Update(Employee employee, DailyGross dg)
{
/*using (*/IDbConnection conn = this.Connection;//)
{
conn.Execute(cUpdateDailyGrossForEmployee_SQL, new {
DailyGrossID = dg.DailyGrossID,
RentID = employee.EffectiveRent(dg.GrossTDS).RentID,
Gross = dg.Gross,
GrossTDS = dg.GrossTDS,
ModifiedBy = dg.ModifiedBy,
ModifiedTDS = dg.ModifiedTDS
});
}
}