public static PI_BA_Evaluacion GetEvaluacionById(String evalId)
{
using (var dbContext = new wPremiosInstitucionalesdbEntities())
{
try
{
return(dbContext.GetEvaluacion(evalId, null, null).FirstOrDefault());
}
catch (Exception Ex)
{
Console.WriteLine("Catched Exception: " + Ex.Message + Environment.NewLine);
return(null);
}
}
}
public static List <PI_BA_Evaluacion> GetEvaluacionesByAplicacion(String appId)
{
using (var dbContext = new wPremiosInstitucionalesdbEntities())
{
try
{
return(dbContext.GetEvaluacion(null, appId, null).ToList());
}
catch (Exception Ex)
{
Console.WriteLine("Catched Exception: " + Ex.Message + Environment.NewLine);
return(null);
}
}
}
public static PI_BA_Evaluacion GetEvaluacionByAplicacionAndJuez(String juezMail, String appId)
{
using (var dbContext = new wPremiosInstitucionalesdbEntities())
{
try
{
var juez = InformacionPersonalJuezService.GetJuezByCorreo(juezMail);
return(dbContext.GetEvaluacion(null, appId, juez.cveJuez).FirstOrDefault());
}
catch (Exception Ex)
{
Console.WriteLine("Catched Exception: " + Ex.Message + Environment.NewLine);
return(null);
}
}
}