public void SubmitNewTimeSheet(Timesheet timesheet) { using (var cn = new SqlConnection(Settings.ConnectionString)) { var p = new DynamicParameters(); p.Add("dateOfSheet", timesheet.DateOfTimesheet); p.Add("totalHrsThatDay", timesheet.TotalHoursByDay); p.Add("empId", timesheet.EmpId); cn.Query("SubmitNewTimeSheet", p, commandType: CommandType.StoredProcedure); } }
public void SubmitNewTimeSheet() { var repo = new TimeTrackerRepository(); var timesheet = new Timesheet() { DateOfTimesheet = new DateTime(1989, 02, 01), EmpId = 1, TotalHoursByDay = 2 }; repo.SubmitNewTimeSheet(timesheet); List<Timesheet> listOfSheets = repo.GetAllTimeSheets(1); Assert.AreEqual(8, listOfSheets.Count); }
public void Delete(Timesheet toDelete) { var currentList = GetAll(); currentList.RemoveAll( c => c.EmployeeId == toDelete.EmployeeId && c.DateWorked == toDelete.DateWorked && c.HoursWorked == toDelete.HoursWorked); using (var writer = File.CreateText(_filepath)) { foreach (var c in currentList) { writer.WriteLine("{0}^{1}^{2}^{3}", c.TimeSheetId, c.EmployeeId, c.HoursWorked, c.DateWorked.ToString("d")); } } }
public void SubmitTimeSheetTest() { TimeTrackerOperations ops = new TimeTrackerOperations(); var timesheet = new Timesheet() { DateOfTimesheet = new DateTime(1989, 07, 01), EmpId = 1, TotalHoursByDay = 12 }; ops.SubmitTimeSheet(timesheet); var repo = new TimeTrackerRepository(); List<Timesheet> listOfSheets = repo.GetAllTimeSheets(1); Assert.AreEqual(6, listOfSheets.Count); }
public List<Timesheet> GetAll() { var reader = File.ReadAllLines(_filepath); var list = new List<Timesheet>(); for (int i = 0; i < reader.Length; i++) { if (reader.Length > 0) { var columns = reader[i].Split('^'); var timesheet = new Timesheet(); timesheet.TimeSheetId = Int32.Parse(columns[0]); timesheet.EmployeeId = Int32.Parse(columns[1]); timesheet.HoursWorked = Decimal.Parse(columns[2]); timesheet.DateWorked = DateTime.Parse(columns[3]); list.Add(timesheet); } } return list; }
public void Add(Timesheet newTimesheet) { var currentList = GetAll(); if (currentList.Any()) { newTimesheet.TimeSheetId = currentList.Max(c => c.TimeSheetId) + 1; } else { newTimesheet.TimeSheetId = 1; } currentList.Add(newTimesheet); using (var writer = File.CreateText(_filepath)) { foreach (var c in currentList) { writer.WriteLine("{0}^{1}^{2}^{3}", c.TimeSheetId, c.EmployeeId, c.HoursWorked, c.DateWorked.ToString("d")); } } }
public void SubmitTimeSheet(Timesheet timesheet) { TimeTrackerRepository repo = new TimeTrackerRepository(); repo.SubmitNewTimeSheet(timesheet); }