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