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);
}
