public void ShouldReturnQueryForAddingEmployeeMetric()
{
string expected = "INSERT INTO public.ett_hours_source (employee_number_fk, hours, code, the_date) VALUES('b003223', 8, 'Work', '10/03/2020');";
HoursSourceRow obj = new HoursSourceRow {
EmployeeNumber = "b003223", Code = "Work", Date = new DateTime(2020, 10, 3), Hours = 8.0
};
string actual = QueryGenerator.AddHourRow(obj);
Assert.Equal(expected, actual);
}
public static string AddHourRow(HoursSourceRow obj)
{
return($"INSERT INTO public.ett_hours_source (employee_number_fk, hours, code, the_date) VALUES('{obj.EmployeeNumber}', {obj.Hours}, '{obj.Code}', '{obj.Date.ToString("MM/dd/yyyy")}');");
}
