public string GetTotalscore(DO_MyPoints objDOPoint, DA_MyPoints.MyPoint flag)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_GetPesonalPoints", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objDOPoint.UserID;
da.Fill(dt);
co.CloseConnection(conn);
return(dt.Rows[0]["totalScore"].ToString());
}
public DataTable GetDataTable(DO_MyPoints objDOPoint, DA_MyScore.MyScore flag)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_GetScorePoints", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objDOPoint.UserID;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
public static ScoreService.ScoreObject getScore(int UserID)
{
ScoreObject ret = new ScoreObject();
DA_MyScore objDAScore = new DA_MyScore();
DO_MyPoints objDOPoint = new DO_MyPoints();
objDOPoint.UserID = UserID;
DataTable dtScore = objDAScore.GetDataTable(objDOPoint, DA_MyScore.MyScore.GetScore);
if (dtScore.Rows.Count > 0)
{
double tmpAScore = Convert.ToDouble(dtScore.Rows[0]["CategoryA"]) / 0.2;
double tmpBScore = Convert.ToDouble(dtScore.Rows[0]["CategoryB"]) / 0.4;
double tmpCScore = 0.0;
double tmpDScore = 0.0;
if (dtScore.Rows[0]["CPercentileScore"] != System.DBNull.Value)
{
tmpCScore = Convert.ToDouble(dtScore.Rows[0]["CPercentileScore"]);
}
if (dtScore.Rows[0]["DPercentileScore"] != System.DBNull.Value)
{
tmpDScore = Convert.ToDouble(dtScore.Rows[0]["DPercentileScore"]);
}
ret.AScore = Convert.ToInt32(tmpAScore);
ret.BScore = Convert.ToInt32(tmpBScore);
ret.CScore = Convert.ToInt32(tmpCScore);
ret.DScore = Convert.ToInt32(tmpDScore);
ret.TotalScore = Convert.ToInt32(
(tmpAScore * 0.2) +
(tmpBScore * 0.4) +
(tmpCScore * 0.38) +
(tmpDScore * 0.02)
);
}
return(ret);
}
