public string CalcularPuntoMedio(string connstring, string Total)
{
string PuntoMedio = "";
DBHelper _oDBHelper = new DBHelper(connstring, Providers.SqlServer);
if (!string.IsNullOrEmpty(Total))
{
GradeStructureBE GradeStructure = EvaluacionDA.Instanse.GradeStructureGetByTotal(_oDBHelper, Total);
PuntoMedio = GradeStructure.Mid;
}
return(PuntoMedio);
}
public GradeStructureBE GradeStructureGetByTotal(DBHelper pDBHelper, string Total)
{
GradeStructureBE GradeStructureBE = new GradeStructureBE();
DBHelper.Parameters[] colParameters = null;
try
{
// Parámetros
colParameters = new DBHelper.Parameters[] {
new DBHelper.Parameters("@Total", Convert.ToInt32(Total) == Constantes.INT_NULO ? (object)DBNull.Value : Convert.ToInt32(Total)),
};
pDBHelper.ClearParameter();
pDBHelper.CreateDBParameters(colParameters);
using (IDataReader dataReader = pDBHelper.ExecuteReader(pDBHelper.concatOwner("GradeStructureGetByTotal"), CommandType.StoredProcedure, Utility.ConnectionState.CloseOnExit))
{
// Leyendo reader
if (dataReader.Read())
{
GradeStructureBE.IdGradeStructure = Convert.ToInt32(dataReader["IdGradeStructure"]);
GradeStructureBE.Min = dataReader["Min"].ToString();
GradeStructureBE.Mid = dataReader["Mid"].ToString();
GradeStructureBE.Max = dataReader["Max"].ToString();
GradeStructureBE.Gs = dataReader["Gs"].ToString();
}
}
return(GradeStructureBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
colParameters = null;
if (pDBHelper != null && pDBHelper.Command.Transaction == null)
{
pDBHelper.Dispose();
}
}
}
