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");
}
}
private void ReportViewRecentSlides_Load(object sender, EventArgs e)
{
lookupServices = new LookUpServices();
//get Speciece Specifics
dictionarySpecifics = lookupServices.fetchLookupTables("species_specifics");
dictionarySCatgerory = lookupServices.fetchLookupTables("species_category");
dictionaryStages = lookupServices.fetchLookupTables("species_stages");
dictionaryDCatgerory = lookupServices.fetchLookupTables("density_category");
ReportDocument reportDocumument = new ReportDocument();
DataGridView recentSLideDataGridView = new DataGridView();
//just getting the Form 2 instance, you can implement it in any way you choose to (e.g. make it global...)
//Slides slideFormsFromReport = this.ParentForm.MdiChildren.Any(child => child is Slides).().SingleOrDefault();
Slides slideFormsFromReport = Application.OpenForms.OfType <Slides>().FirstOrDefault();
if (slideFormsFromReport != null)
{
//MessageBox.Show("got SLides");
recentSLideDataGridView = slideFormsFromReport.getDataGridView();
//added created date as filter of todays eneter slides
String query = "SELECT TOP (500) s.id, s.bar_code, s.sequence, s.donor_id, s.cabinet_number, s.drawer_number, s.box_number, s.isDamaged, s.isReserved, s.isBorrowed, s.isActive, s.updated_date, s.created_date, s.created_by, s.updated_by, d.id AS donor_donor_id, d.donor_code, d.species_specific_id, d.species_stage_id, d.species_catgeroy_id, d.lower_density, d.average_density, d.upper_density, d.density_category_id, d.owner_id, d.acquired_date, d.country_code, d.comment, d.validation_id FROM dbo.slides AS s INNER JOIN dbo.donors AS d ON d.id = s.donor_id WHERE(d.isActive = 1) AND(s.isActive = 1) AND(s.isBorrowed = 0) ORDER BY s.created_date desc;";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection());
dataAdapter.SelectCommand.CommandText = query;
DataTable sqldatatable = new DataTable();
dataAdapter.Fill(sqldatatable);
CrystalReportRecentSlides crpt1Recent = new CrystalReportRecentSlides();
crpt1Recent.Database.Tables["recent_slide_dataset"].SetDataSource(sqldatatable);
crystalReportViewer1.ReportSource = crpt1Recent;
}
}
private void CheckOutReminderViewPort_Load(object sender, EventArgs e)
{
DueDateBorrowedCrystalReport crpt1DueDate = new DueDateBorrowedCrystalReport();
String query = "SELECT * FROM dbo.current_lending as l INNER JOIN dbo.contacts AS b ON b.id = l.borrower_id INNER JOIN dbo.slides AS s ON s.id = l.slide_id INNER JOIN dbo.donors as d on d.id = s.donor_id inner join dbo.species_category as sc on sc.id = d.species_catgeroy_id inner join dbo.species_specifics as ss on ss.id = d.species_specific_id inner join dbo.density_category as dc on dc.id = d.density_category_id where DATEDIFF(day, due_date, GETDATE()) > 0 and s.isBorrowed = 1 and isDamaged = 0 and isOutExchanged = 0 and isMissing = 0 and s.isActive = 1 ORDER BY d.donor_code,s.created_date ASC;";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection());
dataAdapter.SelectCommand.CommandText = query;
DataTable sqldatatable = new DataTable();
dataAdapter.Fill(sqldatatable);
crpt1DueDate.Database.Tables["current_lending_duedate_passed"].SetDataSource(sqldatatable);
CheckoutRemindercrystalReportViewer1.ReportSource = crpt1DueDate;
}
private void AllSlidesReportViewePort_Load(object sender, EventArgs e)
{
String query = "SELECT s.id, s.bar_code, s.sequence, s.donor_id, s.cabinet_number, s.drawer_number, s.box_number, s.isDamaged, s.isReserved, s.isBorrowed, s.isActive, s.updated_date, s.created_date, s.created_by, s.updated_by, d.id AS donor_donor_id, d.donor_code, d.species_specific_id, d.species_stage_id, d.species_catgeroy_id, d.lower_density, d.average_density, d.upper_density, d.density_category_id, d.owner_id, d.acquired_date, d.country_code, d.comment, d.validation_id FROM dbo.slides AS s INNER JOIN dbo.donors AS d ON d.id = s.donor_id ORDER BY s.created_date DESC";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection());
dataAdapter.SelectCommand.CommandText = query;
DataTable sqldatatable = new DataTable();
dataAdapter.Fill(sqldatatable);
CrystalReportAllSlides crpt1AllSlides = new CrystalReportAllSlides();
crpt1AllSlides.Database.Tables["recent_slide_dataset"].SetDataSource(sqldatatable);
crystalReportViewer1.ReportSource = crpt1AllSlides;
}
private void AllIncomingExchangeSlidesReportViewPort_Load(object sender, EventArgs e)
{
try
{
String query = "SELECT * FROM slides AS s inner join donors AS d ON d.id = s.donor_id inner join density_category as dc on dc.id = d.density_category_id inner join species_category as sc on sc.id = d.species_catgeroy_id inner join species_specifics as ss on ss.id = d.species_specific_id inner join species_stages as st on st.id = d.species_stage_id inner join borrowers as b on b.id = d.exchange_id WHERE d.isExchange = 1 ORDER BY s.id; ";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection());
dataAdapter.SelectCommand.CommandText = query;
DataTable sqldatatable = new DataTable();
dataAdapter.Fill(sqldatatable);
CrystalReportIncomingExchangeCheckout crystalReportIncomingExchangeCheckout = new CrystalReportIncomingExchangeCheckout();
crystalReportIncomingExchangeCheckout.Database.Tables["ExchangeSlidesIncomingDataTable"].SetDataSource(sqldatatable);
crystalReportViewer1.ReportSource = crystalReportIncomingExchangeCheckout;
}
catch (Exception ex)
{
logger.Error(ex, "Checkout Report generation has some expections");
}
}
private void AllGoingExchangeSlidesReportViewPort_Load(object sender, EventArgs e)
{
try
{
String query = "SELECT * from exchanges 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 borrowers as b on b.id = c.exchange_contact_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 order by exchanged_date desc;";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection());
dataAdapter.SelectCommand.CommandText = query;
DataTable sqldatatable = new DataTable();
dataAdapter.Fill(sqldatatable);
CrystalReportAllComingExchageSlides crystalReportExchangeCheckout = new CrystalReportAllComingExchageSlides();
crystalReportExchangeCheckout.Database.Tables["ExchangeCheckouReportTable"].SetDataSource(sqldatatable);
crystalReportViewer1.ReportSource = crystalReportExchangeCheckout;
}
catch (Exception ex)
{
logger.Error(ex, "Checkout Report generation has some expections");
}
}
private void PrintCurrentLendings_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'sbmsDataSet.current_lending_history' table. You can move, or remove it, as needed.
try
{
//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 isDefault=0 and b.isExchange=0;";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection());
dataAdapter.SelectCommand.CommandText = query;
DataTable sqldatatable = new DataTable();
dataAdapter.Fill(sqldatatable);
CrystalReportCurrentLendings crystalReportCurrentLending = new CrystalReportCurrentLendings();
crystalReportCurrentLending.Database.Tables["checkedout_slides_details"].SetDataSource(sqldatatable);
crystalReportViewer1.ReportSource = crystalReportCurrentLending;
}
catch (Exception ex)
{
logger.Error(ex, "All Borrowed Report generation has some expections");
}
}
