public static List <convertdetails> GetChartData()
{
BL_AdminDashBoard objBL_AdminDashBoard = new BL_AdminDashBoard();
ML_AdminDashBoard objML_AdminDashBoard = new ML_AdminDashBoard();
DataTable dt = new DataTable();
dt = objBL_AdminDashBoard.BL_RegstraionExamProvideDashBoard(objML_AdminDashBoard);
List <convertdetails> dataList = new List <convertdetails>();
foreach (DataRow dtrow in dt.Rows)
{
convertdetails details = new convertdetails();
details.Convertname = dtrow[0].ToString();
details.Total = Convert.ToInt32(dtrow[1]);
dataList.Add(details);
}
return(dataList);
}
public static List <AudioVideo> GetChartAudioVideoCountData()
{
BL_AdminDashBoard objBL_AdminDashBoard = new BL_AdminDashBoard();
ML_AdminDashBoard objML_AdminDashBoard = new ML_AdminDashBoard();
DataTable dt = new DataTable();
dt = objBL_AdminDashBoard.BL_AudioVideoCountDashBoard(objML_AdminDashBoard);
List <AudioVideo> dataList = new List <AudioVideo>();
foreach (DataRow dtrow in dt.Rows)
{
AudioVideo details = new AudioVideo();
details.AudioVideoname = dtrow[0].ToString();
details.AudioVideoTotal = Convert.ToInt32(dtrow[1]);
dataList.Add(details);
}
return(dataList);
}
public static List <Data> GetData()
{
BL_AdminDashBoard objBL_AdminDashBoard = new BL_AdminDashBoard();
ML_AdminDashBoard objML_AdminDashBoard = new ML_AdminDashBoard();
DataTable dt = new DataTable();
dt = objBL_AdminDashBoard.BL_ExamListDashBoard(objML_AdminDashBoard);
List <Data> dataList = new List <Data>();
string cat = "";
int val = 0;
foreach (DataRow dr in dt.Rows)
{
cat = dr[0].ToString();
val = Convert.ToInt32(dr[1]);
dataList.Add(new Data(cat, val));
}
return(dataList);
}
public DataTable DL_AudioVideoCountDashBoard(ML_AdminDashBoard objML_AdminDashBoard)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_AdminDashBoard.ID) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_No_Of_Audio_Video_Dashboard", par).Tables[0]);
}
public DataTable DL_LatestRegDashBoard(ML_AdminDashBoard objML_AdminDashBoard)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_AdminDashBoard.ID) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Registration_list_Dashboard", par).Tables[0]);
}
public DataTable DL_ExamListDashBoard(ML_AdminDashBoard objML_AdminDashBoard)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_AdminDashBoard.ID) };
return(SqlHelper.ExecuteDataset(con, "FBNPC_Exams_Count_Question_Dashboard", par).Tables[0]);
}
public DataTable BL_AudioVideoCountDashBoard(ML_AdminDashBoard objML_AdminDashBoard)
{
return(objDL_AdminDashBoard.DL_AudioVideoCountDashBoard(objML_AdminDashBoard));
}
public DataTable BL_LatestRegDashBoard(ML_AdminDashBoard objML_AdminDashBoard)
{
return(objDL_AdminDashBoard.DL_LatestRegDashBoard(objML_AdminDashBoard));
}
public DataTable BL_RegstraionExamProvideDashBoard(ML_AdminDashBoard objML_AdminDashBoard)
{
return(objDL_AdminDashBoard.DL_RegistrationExamProvideDashBoard(objML_AdminDashBoard));
}
public DataTable BL_ExamListDashBoard(ML_AdminDashBoard objML_AdminDashBoard)
{
return(objDL_AdminDashBoard.DL_ExamListDashBoard(objML_AdminDashBoard));
}