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"); } }