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 }); } }
private IEnumerable<DailyGross> LoadDailyGrosses(Employee emp, DateTime start, DateTime end) { var list = _dgrepos.Get(emp, start, end); var grosses = new List<DailyGross>(); for (var s = start; s <= end; s = s.AddDays(1)) { var gross = list.Count() > 0 ? list.Where((g) => { return g.GrossTDS.Year == s.Year && g.GrossTDS.Month == s.Month && g.GrossTDS.Day == s.Day; }).FirstOrDefault() : null; if (gross == null) { gross = new DailyGross { GrossTDS = s, Gross = 0, ModifiedTDS = DateTime.Now, ModifiedBy = "admin", Dirty = true }; } grosses.Add(gross); } return grosses; }