internal static SqlDataReader UserSelectForAdmin(Guid ownGuid)
{
SqlDataReader r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(User_SelectForAdmin))
{
AppDatabase.AddInParameter(cmd, User.Columns.UserGuid, SqlDbType.UniqueIdentifier, ownGuid);
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetSqlDataReader(cmd);
}
}
return(r);
}
private static SqlDataReader GetReader(string storeProcName)
{
SqlDataReader r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(storeProcName))
{
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetSqlDataReader(cmd);
}
}
return(r);
}
private static SqlDataReader GetReader(string storeProcName, string paramName, SqlDbType paramType, object paramValue)
{
SqlDataReader r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(storeProcName))
{
AppDatabase.AddInParameter(cmd, paramName, paramType, paramValue);
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetSqlDataReader(cmd);
}
}
return(r);
}
internal static SqlDataReader PermssionSelect(Guid userRoleGuid, Guid entityGuid)
{
SqlDataReader dr = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(UserPermission_Select))
{
AppDatabase.AddInParameter(cmd, "@RoleGuid", SqlDbType.UniqueIdentifier, userRoleGuid);
AppDatabase.AddInParameter(cmd, "@EntityGuid", SqlDbType.UniqueIdentifier, entityGuid);
AppDatabase db = OpenDatabase();
if (db != null)
{
dr = db.GetSqlDataReader(cmd);
}
}
return(dr);
}
internal static SqlDataReader UserSelectNonDisable(bool isDisable)
{
SqlDataReader r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(User_SelectNonDisabled))
{
AppDatabase.AddInParameter(cmd, User.Columns.UserIsDisable, SqlDbType.Bit, isDisable);
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetSqlDataReader(cmd);
}
}
return(r);
}
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 UserLogin(string userName, string password)
{
SqlDataReader r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(User_Login))
{
AppDatabase.AddInParameter(cmd, User.Columns.UserLoginName, SqlDbType.NVarChar, AppShared.SafeString(userName));
AppDatabase.AddInParameter(cmd, User.Columns.UserPassword, SqlDbType.NVarChar, AppShared.SafeString(password));
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetSqlDataReader(cmd);
}
}
return(r);
}
internal static SqlDataReader ItemListQuantityWise(Guid CompanyGuid, Guid CategoryGuid)
{
//return GetReader(Item_QuantityWise, "@CompanyGuid", SqlDbType.UniqueIdentifier, CompanyGuid);
SqlDataReader r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(Item_QuantityWise))
{
AppDatabase.AddInParameter(cmd, "@CategoryGuid", SqlDbType.UniqueIdentifier, CategoryGuid);
AppDatabase.AddInParameter(cmd, "@CompanyGuid", SqlDbType.UniqueIdentifier, CompanyGuid);
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);
}
