public object GetLeaderBoardDetails(LeaderBoard_Input Obj)
{
dynamic TBLeaderBoardResult;
List <object> LeaderBoardResult = new List <object>();
try
{
DataSet ds_details = LeaderBoard.getLeaderBoardDetails(Obj);
List <LeaderBoard_clubList> Result = GlobalFuns.DataTableToList <LeaderBoard_clubList>(ds_details.Tables[1]);
string TotalProjectsstr = "0";
string ProjectCoststr = "0";
string BeneficiaryCountstr = "0";
string ManHoursCountstr = "0";
string RotariansCountstr = "0";
string MembersCountstr = "0";
string TRFCountstr = "0";
if (ds_details.Tables[0].Rows.Count > 0)
{
string[] commandArgs = ds_details.Tables[0].Rows[0]["ClubsDetails"].ToString().Split(new char[] { '|' });
TotalProjectsstr = commandArgs[0].ToString();
ProjectCoststr = commandArgs[1].ToString();
BeneficiaryCountstr = commandArgs[2].ToString();
ManHoursCountstr = commandArgs[3].ToString();
RotariansCountstr = commandArgs[4].ToString();
MembersCountstr = commandArgs[5].ToString();
TRFCountstr = commandArgs[6].ToString();
}
for (int i = 0; i < Result.Count; i++)
{
LeaderBoardResult.Add(new { LeaderBoardResult = Result[i] });
}
if (LeaderBoardResult != null)
{
TBLeaderBoardResult = new { status = "0", message = "success", TotalProjects = TotalProjectsstr, ProjectCost = ProjectCoststr, BeneficiaryCount = BeneficiaryCountstr, ManHoursCount = ManHoursCountstr, RotariansCount = RotariansCountstr, MembersCount = MembersCountstr, TRFCount = TRFCountstr, LeaderBoardResult };
}
else
{
TBLeaderBoardResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBLeaderBoardResult = new { status = "1", message = "failed" };
}
return(new { TBLeaderBoardResult });
}
public static DataSet getLeaderBoardDetails(LeaderBoard_Input Obj)
{
try
{
MySqlParameter[] param = new MySqlParameter[3];
param[0] = new MySqlParameter("?p_GroupID", Obj.GroupID);
param[1] = new MySqlParameter("?p_RowYear", Obj.RowYear);
param[2] = new MySqlParameter("?p_ProfileID", Obj.ProfileID);
DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "API_GetLeaderBoarClubDetails", param);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
