//Get Report List Dropdown public static List <SelectListItem> GetReportListDropdown(double SchoolAccountId, int ReportCategory) { List <SelectListItem> lstReports = new List <SelectListItem>(); try { lstReports.Add(new SelectListItem { Text = "--- Select Report Type --- ", Value = "0" }); DataTable tblReportsList = new DataTable(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@SchoolAccountId", SchoolAccountId); param[1] = new SqlParameter("@ReportCategory", ReportCategory); tblReportsList = DALCommon.GetDataUsingDataTable("[sp_GetReportInfoBySchoolId]", param); if (tblReportsList.Rows.Count > 0) { foreach (DataRow aClass in tblReportsList.Rows) { lstReports.Add(new SelectListItem { Text = Convert.ToString(aClass["ReportName"]), Value = Convert.ToString(aClass["ReportId"]) }); } } } catch (Exception ex) { DALUtility.ErrorLog(ex.Message, "GetReportListDropdown, DALCommonFormData"); } return(lstReports); }
public static List <SelectListItem> GetClassSectionDropdown(decimal SchoolAccountId) { List <SelectListItem> lstClassSection = new List <SelectListItem>(); try { lstClassSection.Add(new SelectListItem { Text = "--- Select Class Section--- ", Value = "0" }); DataTable tblClassList = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@SchoolAccountId", SchoolAccountId); tblClassList = DALCommon.GetDataUsingDataTable("[sp_Admin_GetClassSectionDropdownListBySchoolId]", param); if (tblClassList.Rows.Count > 0) { foreach (DataRow aClass in tblClassList.Rows) { lstClassSection.Add(new SelectListItem { Text = Convert.ToString(aClass["SectionName"]), Value = Convert.ToString(aClass["SectionId"]) }); } } } catch (Exception ex) { DALUtility.ErrorLog(ex.Message, "GetClassSectionDropdown, DALCommonFormData"); } return(lstClassSection); }
//Get Repor Info Data Table public static ModelReportInfo GetReportInfoModel(int ReportId) { ModelReportInfo objModelReportInfo = new ModelReportInfo(); try { DataTable tblReportsList = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ReportId", ReportId); tblReportsList = DALCommon.GetDataUsingDataTable("[sp_Admin_GetReportInfoByReportId]", param); if (tblReportsList.Rows.Count > 0) { objModelReportInfo.ReportFilePathName = Convert.ToString(tblReportsList.Rows[0]["ReportFilePathName"]); objModelReportInfo.SchoolAddressForReport = Convert.ToString(tblReportsList.Rows[0]["SchoolAddressForReport"]); objModelReportInfo.SchoolTitleForReport = Convert.ToString(tblReportsList.Rows[0]["SchoolTitleForReport"]); } } catch (Exception ex) { DALUtility.ErrorLog(ex.Message, "GetReportListDropdown, DALCommonFormData"); } return(objModelReportInfo); }
//Get Repor Info Data Table public static DataTable GetReportInfoDataTable(int ReportId) { DataTable tblDataTable = new DataTable(); try { DataTable tblReportsList = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ReportId", ReportId); tblReportsList = DALCommon.GetDataUsingDataTable("[sp_Admin_GetReportInfoByReportId]", param); return(tblDataTable); } catch (Exception ex) { DALUtility.ErrorLog(ex.Message, "GetReportListDropdown, DALCommonFormData"); } return(tblDataTable); }
//Get Repor Info Data Table public static string GetReportFileNamePath(int ReportId) { string reportFileName = ""; try { DataTable tblReportsList = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ReportId", ReportId); tblReportsList = DALCommon.GetDataUsingDataTable("[sp_Admin_GetReportInfoByReportId]", param); if (tblReportsList.Rows.Count > 0) { reportFileName = Convert.ToString(tblReportsList.Rows[0]["ReportFilePathName"]); } } catch (Exception ex) { DALUtility.ErrorLog(ex.Message, "GetReportListDropdown, DALCommonFormData"); } return(reportFileName); }