private void SearchChekoutReportViewPort_Load(object sender, EventArgs e)
{
try
{
Selection selectionInstance = Application.OpenForms.OfType <Selection>().FirstOrDefault();
string list_of_ids_with_comma = "";
if (selectionInstance != null)
{
List <int> ids = selectionInstance.getSlideIDs();
ids.ForEach(delegate(int sid)
{
list_of_ids_with_comma += sid + ",";
});
list_of_ids_with_comma = list_of_ids_with_comma.Remove(list_of_ids_with_comma.Length - 1);//reove tge kaqst ,
}
//added created date as filter of todays eneter slides
String query = " SELECT * from current_lending c inner join slides as s on s.id = c.slide_id inner join donors as d on d.id = s.donor_id inner join contacts as b on b.id = c.borrower_id inner join species_specifics as ss on ss.id = d.species_specific_id inner join species_category as sc on sc.id = d.species_catgeroy_id inner join species_stages as st on st.id = d.species_stage_id inner join density_category as dc on dc.id = d.density_category_id WHERE c.isHistory = 0 and c.reason <> 'Exchange' and s.id IN (" + list_of_ids_with_comma + ")";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection());
dataAdapter.SelectCommand.CommandText = query;
DataTable sqldatatable = new DataTable();
dataAdapter.Fill(sqldatatable);
CrystalReportSearchCheckout crystalReportSearchCheckout = new CrystalReportSearchCheckout();
crystalReportSearchCheckout.Database.Tables["checkedout_slides_details"].SetDataSource(sqldatatable);
crystalReportViewer1.ReportSource = crystalReportSearchCheckout;
}
catch (Exception ex)
{
logger.Error(ex, "Checkout Report generation has some expections");
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportSearchCheckout rpt = new CrystalReportSearchCheckout();
rpt.Site = this.Site;
return(rpt);
}