private void LoadReport(List <RPT_OrganizationDataEntity> list, RPT_OrganizationDataEntity entity)
{
string ReportSource = "../RDLC/RPT_UnionWiseFisherFolkFamilyCoparativesInitiativesByRange.rdlc";
try
{
ReportViewer1.ClearData();
this.ReportViewer1.ReportViewer.Width = 850;
this.ReportViewer1.Visible = true;
this.ReportViewer1.ReportViewer.Reset();
string[] TableName = { "RPT_OrganizationData" };
ReportViewer1.AddReportParameter(new ReportParameter("FromYear", ddlFromYear.SelectedIndex > 0 ? ddlFromYear.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("ToYear", ddlToYear.SelectedIndex > 0 ? ddlToYear.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("Division", ddlDivision.SelectedIndex > 0 ? "Division: " + ddlDivision.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("District", ddlDistrict.SelectedIndex > 0 ? "District/Zilla: " + ddlDistrict.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("Upazila", ddlUpazilla.SelectedIndex > 0 ? "Upazila/Thana: " + ddlUpazilla.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("Union", ddlUnion.SelectedIndex > 0 ? "Union: " + ddlUnion.SelectedItem.Text : ""));
ReportViewer1.AddDsReportSource(list);
this.ReportViewer1.ShowReport(ReportSource, TableName);
this.ReportViewer1.ReportViewer.LocalReport.Refresh();
}
catch (Exception ex)
{
Error = ex.Message;
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
this.lblException.Text = "";
this.lblResult.Text = "";
try
{
RPT_OrganizationDataEntity entity = BuiltEntity();
entity.FromYear = ddlFromYear.SelectedIndex > 0 ? long.Parse(ddlFromYear.SelectedValue) : -99;
entity.ToYear = ddlToYear.SelectedIndex > 0 ? long.Parse(ddlToYear.SelectedValue) : -99;
entity.DivisionID = ddlDivision.SelectedIndex > 0 ? long.Parse(ddlDivision.SelectedValue) : (long?)null;
entity.DistrictID = ddlDistrict.SelectedIndex > 0 ? long.Parse(ddlDistrict.SelectedValue) : (long?)null;
entity.UpazilaID = ddlUpazilla.SelectedIndex > 0 ? long.Parse(ddlUpazilla.SelectedValue) : (long?)null;
entity.UnionID = ddlUnion.SelectedIndex > 0 ? long.Parse(ddlUnion.SelectedValue) : (long?)null;
entity.ReportType = "FisherFolkFamilyCoparativesInitiatives";
List <RPT_OrganizationDataEntity> list = new List <RPT_OrganizationDataEntity>();
list = Extension_ReportService.GetService().GetOrganizationData(entity).ToList();
if (list.Count > 0 && list.Count > 0)
{
LoadReport(list, entity);
}
else
{
Error = "No record is found !";
ClearReportView();
}
}
catch (Exception ex)
{
Error = ex.Message;
}
}
private void LoadReport(List <RPT_OrganizationDataEntity> list, RPT_OrganizationDataEntity entity)
{
string ReportSource = "../RDLC/RPT_UnionWiseStatusOfAffectedForConvertAgriLandToCommercialLand.rdlc";
try
{
ReportViewer1.ClearData();
this.ReportViewer1.ReportViewer.Width = 850;
this.ReportViewer1.Visible = true;
this.ReportViewer1.ReportViewer.Reset();
string[] TableName = { "RPT_OrganizationData" };
ReportViewer1.AddReportParameter(new ReportParameter("Year", ddlYear.SelectedIndex > 0 ? ddlYear.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("Division", ddlDivision.SelectedIndex > 0 ? "Division: " + ddlDivision.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("District", ddlDistrict.SelectedIndex > 0 ? "District/Zilla: " + ddlDistrict.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("Upazila", ddlUpazilla.SelectedIndex > 0 ? "Upazila/Thana: " + ddlUpazilla.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("Union", ddlUnion.SelectedIndex > 0 ? "Union: " + ddlUnion.SelectedItem.Text : ""));
ReportViewer1.AddDsReportSource(list);
this.ReportViewer1.ShowReport(ReportSource, TableName);
this.ReportViewer1.ReportViewer.LocalReport.Refresh();
}
catch (Exception ex)
{
Error = ex.Message;
}
}
private RPT_OrganizationDataEntity BuiltEntity(RPT_OrganizationDataEntity entity = null)
{
try
{
if (entity == null)
{
entity = new RPT_OrganizationDataEntity();
}
}
catch (Exception ex)
{
throw ex;
}
return(entity);
}
IList <RPT_OrganizationDataEntity> IExtension_ReportDao.GetOrganizationData(RPT_OrganizationDataEntity entity)
{
try
{
string SP = "";
if (entity.ReportType.Equals("FisherFolkFamilyCoparativesInitiatives"))
{
SP = "RPT_UnionWiseFisherFolkFamilyCoparativesInitiatives";
}
if (entity.ReportType.Equals("KhasLand"))
{
SP = "RPT_UnionWiseKhasLand";
}
if (entity.ReportType.Equals("KhasLandAsPerResearchStudyAssumption"))
{
SP = "RPT_UnionWiseKhasLandAsPerResearchStudyAssumption";
}
if (entity.ReportType.Equals("LandlessFamily"))
{
SP = "RPT_UnionWiseLandlessFamily";
}
if (entity.ReportType.Equals("LandlessFamilyInitiativesAsPerResearchStudyAssumption"))
{
SP = "RPT_UnionWiseLandlessFamilyInitiativesAsPerResearchStudyAssumption";
}
if (entity.ReportType.Equals("StatusOfAffectedForConvertAgriLandToCommercialLand"))
{
SP = "RPT_UnionWiseStatusOfAffectedForConvertAgriLandToCommercialLand";
}
if (entity.ReportType.Equals("StatusOfLandUse"))
{
SP = "RPT_UnionWiseStatusOfLandUse";
}
if (entity.ReportType.Equals("WaterBody"))
{
SP = "RPT_UnionWiseWaterBody";
}
if (entity.ReportType.Equals("WaterBodyAsPerResearchStudyAssumption"))
{
SP = "RPT_UnionWiseWaterBodyAsPerResearchStudyAssumption";
}
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
if (entity.FromYear.HasValue)
{
Database.AddInParameter(cmd, "@FromYear", DbType.Int64, entity.FromYear);
}
if (entity.ToYear.HasValue)
{
Database.AddInParameter(cmd, "@ToYear", DbType.Int64, entity.ToYear);
}
if (entity.DivisionID.HasValue)
{
Database.AddInParameter(cmd, "@DivisionID", DbType.Int64, entity.DivisionID);
}
if (entity.DistrictID.HasValue)
{
Database.AddInParameter(cmd, "@DistrictID", DbType.Int64, entity.DistrictID);
}
if (entity.UpazilaID.HasValue)
{
Database.AddInParameter(cmd, "@UpazilaID", DbType.Int64, entity.UpazilaID);
}
if (entity.UnionID.HasValue)
{
Database.AddInParameter(cmd, "@UnionID", DbType.Int64, entity.UnionID);
}
IList <RPT_OrganizationDataEntity> itemList = new List <RPT_OrganizationDataEntity>();
using (IDataReader reader = Database.ExecuteReader(cmd))
{
while (reader.Read())
{
itemList.Add(new RPT_OrganizationDataEntity(reader, entity.ReportType));
}
}
return(itemList);
}
}
catch (Exception ex)
{
throw GetDataAccessException(ex, SourceOfException("GetAll"));
}
}
