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