public IEnumerable<Rent> Get(Employee employee) { /*using (*/IDbConnection conn = this.Connection;//) { return conn.Query<Rent>(cSelectRentsForEmployee_SQL, new { EmployeeID = employee.EmployeeID }); } }
internal static IEnumerable<DailyGross> GetDailyGrosses(IDatabase db, Employee emp, DateTime start, DateTime end) { using (IDbConnection conn = db.Create()) { conn.Open(); var rent = conn.Query<Rent>("SELECT * FROM Rent WHERE EmployeeID = @ID", new { ID = emp.EmployeeID }).First(); return conn.Query<DailyGross>("SELECT * FROM DailyGross WHERE RentID = @RentID AND GrossTDS between @StartTDS and @EndTDS", new { RentID = rent.RentID, StartTDS = start, EndTDS = end }); } }
internal static IEnumerable<DailyGross> GetDailyGrosses(IDatabase db, Employee emp) { using (IDbConnection conn = db.Create()) { conn.Open(); var rent = conn.Query<Rent>("SELECT * FROM Rent WHERE EmployeeID = @ID", new { ID = emp.EmployeeID }).First(); return conn.Query<DailyGross>("SELECT * FROM DailyGross WHERE RentID = @RentID", new { RentID = rent.RentID}); } }
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 }); } }
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; }
public EmployeePayroll(Employee emp, DateTime start) { this.Employee = emp; _start = start; }