public ObservationSaveFinal DoneF(AuthUser authUser, ObservationSaveFinal observation) { var paramsList = new List <SqlParameter> { new SqlParameter("@CODAVALIACAO", observation.CodAvaliacao), new SqlParameter("@OBSERVERID", authUser.Chapa), new SqlParameter("@OBSERVEDID", observation.ChapaAvaliado) }; SqlParameter[] parameters = paramsList.ToArray(); Db.Database.ExecuteSqlCommand("EXECUTE [dbo].[SPU_OBSERVATION_FINALIZAR] @CODAVALIACAO, @OBSERVERID, @OBSERVEDID", parameters); return(observation); }
public ObservationSaveFinal SaveF(AuthUser authUser, ObservationSaveFinal observation) { var paramsList = new List <SqlParameter> { new SqlParameter("@CODAVALIACAO", observation.CodAvaliacao), new SqlParameter("@CHAPAAVALIADOR", observation.ChapaAvaliador), new SqlParameter("@CHAPAAVALIADO", observation.ChapaAvaliado), new SqlParameter("@A1", observation.A1 != null ? int.Parse(observation.A1) : -1), new SqlParameter("@B2", observation.B2 != null ? int.Parse(observation.B2) : -1), new SqlParameter("@C3", observation.C3 != null ? int.Parse(observation.C3) : -1), new SqlParameter("@D4", observation.D4 != null ? int.Parse(observation.D4) : -1), new SqlParameter("@E5", observation.E5 != null ? int.Parse(observation.E5) : -1), new SqlParameter("@F6", observation.F6 != null ? int.Parse(observation.F6) : -1), new SqlParameter("@G1", observation.G1 != null ? int.Parse(observation.G1) : -1), new SqlParameter("@G2", observation.G2 != null ? int.Parse(observation.G2) : -1), new SqlParameter("@G3", observation.G3 != null ? int.Parse(observation.G3) : -1), new SqlParameter("@G41", observation.G41 != null ? int.Parse(observation.G41) : -1), new SqlParameter("@G42", observation.G42 != null ? int.Parse(observation.G42) : -1), new SqlParameter("@G5", observation.G5 != null ? int.Parse(observation.G5) : -1), new SqlParameter("@G6", observation.G6 != null ? int.Parse(observation.G6) : -1), new SqlParameter("@G7", observation.G7 != null ? int.Parse(observation.G7) : -1), new SqlParameter("@H1", observation.H1 != null ? observation.H1 : ""), new SqlParameter("@H2", observation.H2 != null ? observation.H2 : ""), new SqlParameter("@H3", observation.H3 != null ? observation.H3 : ""), new SqlParameter("@H4", observation.H4 != null ? observation.H4 : ""), new SqlParameter("@H5", observation.H5 != null ? observation.H5 : ""), new SqlParameter("@H6", observation.H6 != null ? observation.H6 : ""), new SqlParameter("@H7", observation.H7 != null ? observation.H7 : ""), new SqlParameter("@H8", observation.H8 != null ? observation.H8 : ""), new SqlParameter("@Z1", observation.Z1 != null ? observation.Z1 : "") }; SqlParameter[] parameters = paramsList.ToArray(); Db.Database.ExecuteSqlCommand("EXECUTE [dbo].[SPU_OBSERVATION_FINAL_SAVE] @CODAVALIACAO,@CHAPAAVALIADOR,@CHAPAAVALIADO,@A1,@B2,@C3,@D4,@E5,@F6,@G1,@G2,@G3,@G41,@G42,@G5,@G6,@G7,@H1,@H2,@H3,@H4,@H5,@H6,@H7,@H8,@Z1", parameters); return(observation); }
public ObservationSaveFinal DoneF(AuthUser authUser, ObservationSaveFinal observation) { return(_observationService.DoneF(authUser, observation)); }
public ObservationSaveFinal SaveF(AuthUser authUser, ObservationSaveFinal observation) { return(_observationRepository.SaveF(authUser, observation)); }