private void LoadReport(List <RPT_DistributedKashLandEntity> list, RPT_DistributedKashLandEntity entity)
{
string ReportSource = "../RDLC/RPT_DivisionWiseDistributedKashLand.rdlc";
try
{
ReportViewer1.ClearData();
this.ReportViewer1.ReportViewer.Width = 850;
this.ReportViewer1.Visible = true;
this.ReportViewer1.ReportViewer.Reset();
string[] TableName = { "RPT_DivisionWiseDistributedKashLand" };
ReportViewer1.AddReportParameter(new ReportParameter("Month", ddlToMonth.SelectedIndex > 0 ? ddlToMonth.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("Year", ddlToYear.SelectedIndex > 0 ? ddlToYear.SelectedItem.Text : ""));
ReportViewer1.AddReportParameter(new ReportParameter("FromDate", entity.FromDate.HasValue ? entity.FromDate.Value.ToString("dd.MM.yyyy") : ""));
ReportViewer1.AddReportParameter(new ReportParameter("ToDate", entity.ToDate.HasValue ? entity.ToDate.Value.ToString("dd.MM.yyyy") : ""));
ReportViewer1.AddDsReportSource(list);
this.ReportViewer1.ShowReport(ReportSource, TableName);
this.ReportViewer1.ReportViewer.LocalReport.Refresh();
}
catch (Exception ex)
{
Error = ex.Message;
}
}
private RPT_DistributedKashLandEntity BuiltEntity(RPT_DistributedKashLandEntity entity = null)
{
try
{
if (entity == null)
{
entity = new RPT_DistributedKashLandEntity();
}
}
catch (Exception ex)
{
throw ex;
}
return(entity);
}
protected void btnShow_Click(object sender, EventArgs e)
{
this.lblException.Text = "";
this.lblResult.Text = "";
try
{
RPT_DistributedKashLandEntity entity = BuiltEntity();
entity.FromYear = ddlFromYear.SelectedIndex > 0 ? int.Parse(ddlFromYear.SelectedValue) : -99;
entity.ToYear = ddlToYear.SelectedIndex > 0 ? int.Parse(ddlToYear.SelectedValue) : -99;
entity.FromMonth = ddlFromMonth.SelectedIndex > 0 ? int.Parse(ddlFromMonth.SelectedValue) : -99;
entity.ToMonth = ddlToMonth.SelectedIndex > 0 ? int.Parse(ddlToMonth.SelectedValue) : -99;
entity.DivisionID = ddlDivision.SelectedIndex > 0 ? long.Parse(ddlDivision.SelectedValue) : -99;
entity.DistrictID = ddlDistrict.SelectedIndex > 0 ? long.Parse(ddlDistrict.SelectedValue) : -99;
DateTime FromDate = new DateTime((int)entity.FromYear, (int)entity.FromMonth, 1);
DateTime ToDate = new DateTime((int)entity.ToYear, (int)entity.ToMonth, DateTime.DaysInMonth((int)entity.ToYear, (int)entity.ToMonth));
entity.FromDate = FromDate;
entity.ToDate = ToDate;
entity.ReportType = "Upazila";
List <RPT_DistributedKashLandEntity> list = new List <RPT_DistributedKashLandEntity>();
list = Extension_ReportService.GetService().GetDistributedKashLand(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;
}
}
IList <RPT_DistributedKashLandEntity> IExtension_ReportDao.GetDistributedKashLand(RPT_DistributedKashLandEntity entity)
{
try
{
string SP = "";
if (entity.ReportType.Equals("Division"))
{
SP = "RPT_DivisionWiseDistributedKashLand";
}
if (entity.ReportType.Equals("District"))
{
SP = "RPT_DistrictWiseDistributedKashLand";
}
if (entity.ReportType.Equals("Upazila"))
{
SP = "RPT_UpazilaWiseDistributedKashLand";
}
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
if (entity.FromDate.HasValue)
{
Database.AddInParameter(cmd, "@FromDate", DbType.DateTime, entity.FromDate);
}
if (entity.ToDate.HasValue)
{
Database.AddInParameter(cmd, "@ToDate", DbType.DateTime, entity.ToDate);
}
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);
}
IList <RPT_DistributedKashLandEntity> itemList = new List <RPT_DistributedKashLandEntity>();
using (IDataReader reader = Database.ExecuteReader(cmd))
{
while (reader.Read())
{
itemList.Add(new RPT_DistributedKashLandEntity(reader, entity.ReportType));
}
}
return(itemList);
}
}
catch (Exception ex)
{
throw GetDataAccessException(ex, SourceOfException("GetAll"));
}
}
