internal static SqlDataReader IPDPatientTreatmentSheetSearch(string searchText, DateTime dateFrom, DateTime dateTo)
{
SqlDataReader r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(IPDPatientTreatmentSheet_Search))
{
AppDatabase.AddInParameter(cmd, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText));
AppDatabase.AddInParameter(cmd, "@DateFrom", SqlDbType.DateTime, AppShared.ToDbValueNullable(dateFrom));
AppDatabase.AddInParameter(cmd, "@DateTo", SqlDbType.DateTime, AppShared.ToDbValueNullable(dateTo));
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetSqlDataReader(cmd);
}
}
return(r);
}
//internal static SqlDataReader PatientSelectAll()
//{
// return GetReader(Patient_SelectAll);
//}
internal static SqlDataReader PatientSearch(string searchText, bool IsIpd, bool IsOPD, int isDischarge, DateTime dateFrom, DateTime dateTo)
{
SqlDataReader r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(Patient_Search))
{
AppDatabase.AddInParameter(cmd, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText));
AppDatabase.AddInParameter(cmd, "@IsIpd", SqlDbType.Bit, IsIpd);
AppDatabase.AddInParameter(cmd, "@IsOpd", SqlDbType.Bit, IsOPD);
AppDatabase.AddInParameter(cmd, "@IsDischarge", SqlDbType.Int, isDischarge);
AppDatabase.AddInParameter(cmd, "@DateFrom", SqlDbType.DateTime, AppShared.ToDbValueNullable(dateFrom));
AppDatabase.AddInParameter(cmd, "@DateTo", SqlDbType.DateTime, AppShared.ToDbValueNullable(dateTo));
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetSqlDataReader(cmd);
}
}
return(r);
}
internal static SqlDataReader MedicinesSearch(string SearchText)
{
return(GetReader(Medicines_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText)));
}
internal static SqlDataReader UserRoleSearch(string searchText)
{
return(GetReader(UserRole_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText)));
}
//internal static SqlDataReader PatientSelectAll()
//{
// return GetReader(Patient_SelectAll);
//}
internal static SqlDataReader PatientBillSearch(string searchText)
{
return(GetReader(PatientBill_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText)));
}
internal static SqlDataReader LabInvestigationSearch(string SearchText)
{
return(GetReader(LabInvestigation_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText)));
}
internal static SqlDataReader OPDTreatmentSearch(string SearchText)
{
return(GetReader(Treatment_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText)));
}
internal static SqlDataReader CategorySearch(string SearchText)
{
return(GetReader(Category_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText)));
}
internal static SqlDataReader ReferenceDoctorSearch(string searchText)
{
return(GetReader(ReferenceDoctor_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText)));
}
internal static SqlDataReader AssociateComplainSearch(string SearchText)
{
return(GetReader(AssociateComplain_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText)));
}