public SelfEvalSave Save(SelfEvalSave obj, AuthUser authUser)
{
var sql = "UPDATE CTJ_SELFEVALUATION SET CTJEVENTS01CONFIRM = @ctjevents01confirm, CTJEVENTS02CONFIRM = @ctjevents02confirm, CTJEVENTS02ACONFIRM = @ctjevents02aconfirm, DEGREE = @degree, CERTIFICATEOFPROFICIENCY = @certificateofproficiency, DIGITALPROJECT = @digitalproject, FINALREFLECTIONA = @finalreflectiona, FINALREFLECTIONB = @finalreflectionb, FINALREFLECTIONC = @finalreflectionc, FINALREFLECTIOND = @finalreflectiond, FINALREFLECTIONE = @finalreflectione, FINALREFLECTIONF = @finalreflectionf, FINALREFLECTIONG = @finalreflectiong WHERE CHAPA = @chapa AND ANO = @ano";
List <SqlParameter> paramsList = new List <SqlParameter>();
paramsList.Add(new SqlParameter("@ano", authUser.ContextoAno));
paramsList.Add(new SqlParameter("@chapa", authUser.Chapa));
paramsList.Add(new SqlParameter("@ctjevents01confirm", obj.Ctjevents01confirm));
paramsList.Add(new SqlParameter("@ctjevents02confirm", obj.Ctjevents02confirm));
paramsList.Add(new SqlParameter("@ctjevents02aconfirm", obj.CtjEvents02AConfirm));
paramsList.Add(new SqlParameter("@degree", obj.Degree));
paramsList.Add(new SqlParameter("@certificateofproficiency", obj.CertificateOfProficiency));
paramsList.Add(new SqlParameter("@digitalproject", obj.DigitalProject ?? (object)DBNull.Value));
paramsList.Add(new SqlParameter("@finalreflectiona", obj.FinalReflectionA ?? (object)DBNull.Value));
paramsList.Add(new SqlParameter("@finalreflectionb", obj.FinalReflectionB ?? (object)DBNull.Value));
paramsList.Add(new SqlParameter("@finalreflectionc", obj.FinalReflectionC ?? (object)DBNull.Value));
paramsList.Add(new SqlParameter("@finalreflectiond", obj.FinalReflectionD ?? (object)DBNull.Value));
paramsList.Add(new SqlParameter("@finalreflectione", obj.FinalReflectionE ?? (object)DBNull.Value));
paramsList.Add(new SqlParameter("@finalreflectionf", obj.FinalReflectionF ?? (object)DBNull.Value));
paramsList.Add(new SqlParameter("@finalreflectiong", obj.FinalReflectionG ?? (object)DBNull.Value));
SqlParameter[] parameters = paramsList.ToArray();
int nRowInserted = Db.Database.ExecuteSqlCommand(sql, parameters);
return(obj);
}
public SelfEvalSave Save(SelfEvalSave obj, AuthUser authUser)
{
return(_selfEvaluationRepository.Save(obj, authUser));
}
public SelfEvalSave Save(SelfEvalSave obj, AuthUser authUser)
{
return(_selfEvaluationService.Save(obj, authUser));
}