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