public ActionResult StudentFeeFollowUpReport()
{
BLLStudentReports objBLLStudentReports = new BLLStudentReports();
ViewBag.dpReports = objBLLStudentReports.GetReportListDropdown(Convert.ToDouble(Session[DALVariables.SchoolAccountId]), 1);
getdropdownData();
return(View());
}
private DataTable getStudentListTable(bool isStdId, bool isCompCode, bool isStudentName, bool isDOB)
{
DataTable atable = new DataTable();
BLLStudentReports objBLLStudentReports = new BLLStudentReports();
atable = objBLLStudentReports.GetStudentListForDynamicParameterTable(isStdId, isCompCode, isStudentName, isDOB);
return(atable);
}
private List <ModelStudentDynamicReport> getStudentList()
{
List <ModelStudentDynamicReport> lstModelStudentDynamicReport = new List <ModelStudentDynamicReport>();
BLLStudentReports objBLLStudentReports = new BLLStudentReports();
lstModelStudentDynamicReport = objBLLStudentReports.GetStudentListForDynamicParameter(true, true, true, true);
return(lstModelStudentDynamicReport);
}
private List <ModelStudent> getStudentInfoBySearch()
{
BLLStudentReports objBLLStudentReports = new BLLStudentReports();
List <ModelStudent> lstModelStudent = new List <ModelStudent>();
//Testing
//string SearchCriteria = "Students.ClassId = 1 AND Students.SectionId = 1";
lstModelStudent = objBLLStudentReports.GetStudentListForReport(SearchCriteriaParam, CampusId, Convert.ToInt32(Session[iDAS.DAL.DALVariables.SchoolAccountId].ToString()));
return(lstModelStudent);
}
private List <ModelStudentFeeFollowUpMonthCountReport> getStudentFeeFollowUpReportData()
{
BLLStudentReports objBLLStudentReports = new BLLStudentReports();
List <ModelStudentFeeFollowUpMonthCountReport> lstFollowUpMonthCountReport = new List <ModelStudentFeeFollowUpMonthCountReport>();
//Testing
//string SearchCriteria = "Students.ClassId = 1 AND Students.SectionId = 1";
lstFollowUpMonthCountReport = objBLLStudentReports.GetFeeFollowUpMonthCountForReportBySchoolId(SearchCriteriaParam, UnPaidMonths, CampusId, Convert.ToInt32(Session[iDAS.DAL.DALVariables.SchoolAccountId].ToString()));
return(lstFollowUpMonthCountReport);
}
private List <ModelBankFeeChallanReport> getStudentUnpaidFeeInfoBySearch()
{
BLLStudentReports objBLLStudentReports = new BLLStudentReports();
List <ModelBankFeeChallanReport> lstModelBankFeeChallanReportt = new List <ModelBankFeeChallanReport>();
//Testing
//string SearchCriteria = "Students.ClassId = 1 AND Students.SectionId = 1";
lstModelBankFeeChallanReportt = objBLLStudentReports.GetFeeFollowUpStudentListForReport(SearchCriteriaParam, UnPaidMonths, CampusId, Convert.ToInt32(Session[iDAS.DAL.DALVariables.SchoolAccountId].ToString()));
return(lstModelBankFeeChallanReportt);
}
public ActionResult StudentFeeFollowUpReport(string dropDownClass, string dropDownSection, string dropDownReportTypeId, string dropDownCampusTypeId, string strReportTitle)
{
BLLStudentReports objBLLStudentReports = new BLLStudentReports();
ViewBag.dpReports = objBLLStudentReports.GetReportListDropdown(Convert.ToDouble(Session[DALVariables.SchoolAccountId]), 1);
getdropdownData();
StringBuilder strSearchCriteria = new StringBuilder();
string searchCriteria = "";
//If Selected Class Is Empty
if (!string.IsNullOrEmpty(dropDownCampusTypeId.Trim()))
{
int _selectedCampusTypeId = Convert.ToInt32(dropDownCampusTypeId.Trim());
if (_selectedCampusTypeId <= 0)
{
return(Json(new { code = 1, css = "error", message = "Error occured ! Campus Type not selected" }));
}
}
//If Selected Class Is Empty
if (!string.IsNullOrEmpty(dropDownClass.Trim()))
{
int _selectedClass = Convert.ToInt32(dropDownClass.Trim());
if (_selectedClass <= 0)
{
return(Json(new { code = 1, css = "error", message = "Error occured ! Class not selected" }));
}
}
//If Report Type Is Empty
if (!string.IsNullOrEmpty(dropDownReportTypeId.Trim()))
{
int _selectedClass = Convert.ToInt32(dropDownReportTypeId.Trim());
if (_selectedClass <= 0)
{
return(Json(new { code = 1, css = "error", message = "Error occured ! Report not selected" }));
}
}
//If Selected Class Is Not Empty
if ((!string.IsNullOrEmpty(dropDownClass.Trim())))
{
int _selectedClass = Convert.ToInt32(dropDownClass.Trim());
if (_selectedClass > 0)
{
strSearchCriteria.Append(" Students.ClassId = " + _selectedClass + " AND ");
}
}
//If Class Section Is Not Empty
if ((!string.IsNullOrEmpty(dropDownSection.Trim())))
{
int _selectedSection = Convert.ToInt32(dropDownSection.Trim());
if (_selectedSection > 0)
{
strSearchCriteria.Append(" Students.SectionId = " + _selectedSection + " AND ");
}
}
//strSearchCriteria.Append(" ServiceTypeCategoryId = " + CategoryId + " AND ");
//If Filter Expression Is Not Null Or Empty
if ((!string.IsNullOrEmpty(strSearchCriteria.ToString())))
{
//Set Filter Expression
searchCriteria = strSearchCriteria.ToString().Remove(strSearchCriteria.ToString().Length - 4, 4);
//User Log
DALUtility.InsertUserLog("Generate Bulk Fee Voucher. Search Criteria - " + searchCriteria, "Student/Search", Convert.ToInt32(Session[DALVariables.UserAccountId].ToString()));
}
else
{
//User Log
DALUtility.InsertUserLog("Generate Bulk Fee Voucher. Search Criteria - Nothing", "Student/Search", Convert.ToInt32(Session[DALVariables.UserAccountId].ToString()));
}
try
{
string reportURL = "../../ASPXReport/StudentFeeReport.aspx?Report=" + HttpUtility.UrlEncode(EncryptDecrypt.Encrypt(dropDownReportTypeId)) + "&CampId=" + HttpUtility.UrlEncode(EncryptDecrypt.Encrypt(dropDownCampusTypeId)) + "&Title=" + HttpUtility.UrlEncode(EncryptDecrypt.Encrypt(strReportTitle)) + "&Search=" + HttpUtility.UrlEncode(EncryptDecrypt.Encrypt(searchCriteria));
return(Json(new { code = 3, css = "success", message = "Message ! Reridecting report URL", linkUrl = reportURL }));
}
catch (Exception ex)
{
DALUtility.ErrorLog(ex.Message, "GenerateBulkFeeVouchers, StudentFee");
}
return(View());
}
