public async Task <int> SaveExecutiveForm(ExecutiveForm executiveForm)
{
using (IDbConnection conn = Connection)
{
string sQuery = "INSERT INTO ExecutiveForm(name, title, department,reviewType, sap, period, division, secTwoPercent, secTwoRating, secTwoResponsibility, secTwoSummary, teamworkRating, integRating, innovaRating, profRating, ladRating, stratRating, excellenceRating, decisionRating, pdpRating, secFiveTime, secFiveSummary, secSixSummary, revComments, employeeComments)" +
"VALUES(@name, @title, @department, @reviewType, @sap, @period, @division, @secTwoPercent, @secTwoRating, @secTwoResponsibility, @secTwoSummary, @teamworkRating, @integRating, @innovaRating, @profRating, @ladRating, @stratRating, @excellenceRating, @decisionRating, @pdpRating, @secFiveTime, @secFiveSummary, @secSixSummary, @revComments, @employeeComments)";
conn.Open();
var result = await conn.ExecuteAsync(sQuery, executiveForm);
conn.Close();
return(result);
}
}
public async Task <IActionResult> SaveNewExecutiveForm([FromBody] ExecutiveForm executiveForm)
{
var response = await _executiveFormRepository.SaveExecutiveForm(executiveForm);
return(Json(response));
}
