public CV_PM_ALT_SCALE GetEntity(Guid criterionID, string scales)
{
CV_PM_ALT_SCALE entity = null;
//
try
{
string sql = "select * from CV_PM_ALT_SCALE where CriterionID = @CriterionID and Scales = @Scales";
Database db = GetDatabaseInstance();
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "@CriterionID", DbType.Guid, criterionID);
db.AddInParameter(dbCommand, "@Scales", DbType.String, scales);
//
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
entity = ReadEntity(dataReader);
}
}
}
catch (Exception ex)
{
ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy);
}
//
return(entity);
}
public void Update(CV_PM_ALT_SCALE entity, bool updateAll, DbTransaction transaction)
{
throw new NotImplementedException();
}
public void Update(CV_PM_ALT_SCALE entity)
{
throw new NotImplementedException();
}
public CV_PM_ALT_SCALE Insert(CV_PM_ALT_SCALE entity, DbTransaction transaction)
{
throw new NotImplementedException();
}
public CV_PM_ALT_SCALE Insert(CV_PM_ALT_SCALE entity)
{
throw new NotImplementedException();
}
private static CV_PM_ALT_SCALE ReadEntity(IDataReader dataReader)
{
CV_PM_ALT_SCALE CV_PM_ALT_SCALEEntity = new CV_PM_ALT_SCALE();
object value;
value = dataReader["ScalePK"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.ScalePK = (Int64?)value;
}
value = dataReader["AlertID"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.AlertID = (Guid?)value;
}
value = dataReader["AlertName"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.AlertName = (String)value;
}
value = dataReader["AlertAlias"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.AlertAlias = (String)value;
}
value = dataReader["CriterionID"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.CriterionID = (Guid?)value;
}
value = dataReader["Scales"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.Scales = (String)value;
}
value = dataReader["ScaledValue"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.ScaledValue = (String)value;
}
value = dataReader["CreatedBy"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.CreatedBy = (String)value;
}
value = dataReader["CreatedOn"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.CreatedOn = (DateTime?)value;
}
value = dataReader["ModifiedBy"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.ModifiedBy = (String)value;
}
value = dataReader["ModifiedOn"];
if (value != DBNull.Value)
{
CV_PM_ALT_SCALEEntity.ModifiedOn = (DateTime?)value;
}
return(CV_PM_ALT_SCALEEntity);
}
