public DataTable SearchSlideById(int id) { DataTable slidesDT = new DataTable(); string strCommandText = "SELECT distinct * FROM slides WHERE id=" + id; SqlDataAdapter slidesAdapter = new SqlDataAdapter(strCommandText, DBConnectionSingltonServices.GetConnection()); SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(slidesAdapter); slidesDT.Clear(); slidesAdapter.Fill(slidesDT); // if there are records, bind to Grid view & display return(slidesDT); }
public DataFetchService() { DBConnectionSingltonServices.GetConnection(); }
public DataTable SearchSlideByNumber(int number) { DataTable checkouSlideDT = new DataTable(); string strCommandText = "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.isBorrowed = 0) and(s.isReserved = 0) and(s.isDamaged = 0) and (s.sequence like %'" + number + "'%) ORDER BY s.created_date desc"; SqlDataAdapter SlideCheckouFilterAdpter = new SqlDataAdapter(strCommandText, DBConnectionSingltonServices.GetConnection()); SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(SlideCheckouFilterAdpter); checkouSlideDT.Clear(); SlideCheckouFilterAdpter.Fill(checkouSlideDT); // if there are records, bind to Grid view & display return(checkouSlideDT); }
public LookUpServices() { DBConnectionSingltonServices.GetConnection(); }