public int countApplications() { int countProduct = -1; DataSet ds = new DataSet(); try { SqlDataReader reader = null; using (DM dbManager = new DM()) { dbManager.Command.CommandText = @"select count(id) from StudentApplications where formfilled=1 and AdmissionGranted=0"; //reader = dbManager.GetDataReader(); // dbManager.LoadDataSet(ds); countProduct = dbManager.getScopeIdentity(); } } catch (Exception exp) { } return countProduct; }
public int getTransactionID_txtRef_depostiFOrm(string transactionnumber) { int id = -1; DataSet ds = new DataSet(); try { using (DM dbManager = new DM()) { dbManager.Command.CommandText = @"SELECT ID FROM eWalletPaymentdeposit_application where TransactionNo=@tnumber "; dbManager.Command.Parameters.AddWithValue("@tnumber", transactionnumber); id = Convert.ToInt32(dbManager.getScopeIdentity()); } } catch (Exception exp) { } return id; }
public int getCounteTransactionRows_User() { int countProduct = -1; DataSet ds = new DataSet(); try { SqlDataReader reader = null; using (DM dbManager = new DM()) { dbManager.Command.CommandText = @"select count(id) from eWallet_History where userID=@userid"; dbManager.Command.Parameters.AddWithValue("@userid", Membership.GetUser().ProviderUserKey.ToString()); //reader = dbManager.GetDataReader(); // dbManager.LoadDataSet(ds); countProduct = dbManager.getScopeIdentity(); } } catch (Exception exp) { } return countProduct; }
public int getCountTableCBTSCHEDULE() { int countProduct = -1; DataSet ds = new DataSet(); try { SqlDataReader reader = null; using (DM dbManager = new DM()) { dbManager.Command.CommandText = @"select count(id) from CBT_Schedules"; countProduct = dbManager.getScopeIdentity(); } } catch (Exception exp) { } return countProduct; }
public int getCountTransactionRows_User(string ewalletNumber) { int countProduct = -1; DataSet ds = new DataSet(); try { SqlDataReader reader = null; using (DM dbManager = new DM()) { dbManager.Command.CommandText = @"select count(id) from eWallet_History where ewalletNumber=@ewalletNumber "; dbManager.Command.Parameters.AddWithValue("@ewalletNumber", ewalletNumber); //reader = dbManager.GetDataReader(); // dbManager.LoadDataSet(ds); countProduct = dbManager.getScopeIdentity(); } } catch (Exception exp) { } return countProduct; }
public int getCountTransactionRows_ALL() { int countProduct = -1; DataSet ds = new DataSet(); try { SqlDataReader reader = null; using (DM dbManager = new DM()) { dbManager.Command.CommandText = @"select count(id) from Transactionlog"; //reader = dbManager.GetDataReader(); // dbManager.LoadDataSet(ds); countProduct = dbManager.getScopeIdentity(); } } catch (Exception exp) { } return countProduct; }