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