public static string UpdateEmployeeMetric(EmployeeMetricRow obj)
{
string result = "";
result += "UPDATE public.ett_employee_metrics SET ";
result += $"target_billable_hours={obj.TargetBillableHours}, current_billable_hours={obj.CurrentBillableHours}, target_training_hours={obj.CurrentBillableHours}, current_training_hours={obj.CurrentTrainingHours}, total_yearly_pto={obj.YearlyAccruablePTO}, overflow_pto={obj.OverflowedPTO}, used_pto={obj.UsedPTO} ";
result += $"WHERE employee_number_fk = '{obj.EmployeeNumber}' AND the_year = {obj.Date.Year};";
return(result);
}
public static string AddEmployeeMetric(EmployeeMetricRow obj)
{
string result = "";
result += "INSERT INTO public.ett_employee_metrics ";
result += "(employee_number_fk, target_billable_hours, current_billable_hours, target_training_hours, current_training_hours, total_yearly_pto, overflow_pto, used_pto, the_year) ";
result += $"VALUES('{obj.EmployeeNumber}', {obj.TargetBillableHours}, {obj.CurrentBillableHours}, {obj.TargetTrainingHours}, {obj.CurrentTrainingHours}, {obj.YearlyAccruablePTO}, {obj.OverflowedPTO}, {obj.UsedPTO}, {obj.Date.Year});";
return(result);
}
