private List <MetricRating> ConvertToModel(DataSet dsMetricRating)
{
try
{
List <MetricRating> metricRatings = new List <MetricRating>();
if (dsMetricRating != null)
{
if (dsMetricRating.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsMetricRating.Tables[0].Rows.Count; i++)
{
MetricRating metricRating = new MetricRating();
metricRating.RatingType = new RatingType();
metricRating.Period = new Period();
metricRating.Metrics = new Model.Model.Metrics();
metricRating.Rating = new Rating();
metricRating.Metrics.Id = dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_METRIC_ID] == DBNull.Value ? 0 : Convert.ToInt64(dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_METRIC_ID]);
metricRating.Rating.Id = dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_RATING_ID] == DBNull.Value ? (byte)0 : Convert.ToByte(dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_RATING_ID]);
metricRating.From = dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_FROM] == DBNull.Value ? 0 : Convert.ToDecimal(dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_FROM]);
metricRating.To = dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_TO] == DBNull.Value ? 0 : Convert.ToDecimal(dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_TO]);
metricRating.RatingType.Id = dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_RATING_TYPE_ID] == DBNull.Value ? (byte)0 : Convert.ToByte(dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_RATING_TYPE_ID]);
metricRating.Period.Id = dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_PERIOD_ID] == DBNull.Value ? 0 : Convert.ToInt32(dsMetricRating.Tables[0].Rows[i][metricRatingDb.FIELD_PERIOD_ID]);
metricRatings.Add(metricRating);
}
}
}
return(metricRatings);
}
catch (Exception)
{
throw;
}
}
private List <MetricRating> GetMetricRating(long metricId, int metricPerspectiveId, int companyDepartmentJobRoleId, int periodId)
{
try
{
//get metric ratings
List <MetricRating> metricRatings = new List <MetricRating>();
//DataSet dsRating = metricDb.SelectMetricRatingByMetricPerspectiveIDAndCompanyDepartmentJobRoleID(metricId, metricPerspectiveId, companyDepartmentJobRoleId);
DataSet dsRating = metricDb.SelectMetricRatingByMetricPerspectiveIDAndCompanyDepartmentJobRoleIDAndPeriodID(metricId, metricPerspectiveId, companyDepartmentJobRoleId, periodId);
if (dsRating != null)
{
if (dsRating.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < dsRating.Tables[0].Rows.Count; j++)
{
MetricRating metricRating = new MetricRating();
metricRating.Metrics = new Model.Model.Metrics();
metricRating.Rating = new Rating();
metricRating.Metrics.Id = Convert.ToInt32(dsRating.Tables[0].Rows[j][metricDb.FIELD_METRIC_ID]);
metricRating.Rating.Id = Convert.ToByte(dsRating.Tables[0].Rows[j]["Rating_ID"]);
metricRating.From = Convert.ToDecimal(dsRating.Tables[0].Rows[j]["From"]);
metricRating.To = Convert.ToDecimal(dsRating.Tables[0].Rows[j]["To"]);
metricRatings.Add(metricRating);
}
}
}
return(metricRatings);
}
catch (Exception ex)
{
throw ex;
}
}
