public override bool IsValidBankName(int BankID, string Name)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((bool)adapter.SP_IsValidBankName(BankID, Name));
     }
 }
 public override int Import(int tableID, int modifierUserID, byte[] b)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((int)adapter.SP_Import(tableID, modifierUserID, b.GetXmlData()));
     }
 }
 public override int AddOrEditBank(int BankID, string Name, string BankCode, int Status, int ModifiedUserID, DateTime ModifiedDate, int ApproverUserID, int Action)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((int)adapter.SP_AddOrEditBank(BankID, Name, BankCode, Status, ModifiedUserID, ModifiedDate, ApproverUserID, Action));
     }
 }
 public override int AddOrEditGeneric(int genericID, string name, int status, int modifiedUserID, DateTime modifiedDate, int approverUserID, int action)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((int)adapter.SP_AddOrEditGeneric(genericID, name, status, modifiedUserID, modifiedDate, approverUserID, action));
     }
 }
 public override bool IsValidPaymentMethodName(int paymentMethodID, string name)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((bool)adapter.SP_IsValidPaymentMethodName(paymentMethodID, name));
     }
 }
 public override bool IsValidUnitMeasureName(string unitMeasureCode, string name)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((bool)adapter.SP_IsValidUnitMeasureName(unitMeasureCode, name));
     }
 }
 public override int AddOrEditCurrencyRate(int currencyRateID, string currencyCode, DateTime startDate, DateTime endDate, decimal averageRate, int Events, int status, int modifiedUserID, DateTime modifiedDate, int approverUserID, int action)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((int)adapter.SP_AddOrEditCurrencyRate(currencyRateID, currencyCode, startDate, endDate, averageRate, Events, status, modifiedUserID, modifiedDate, approverUserID, action));
     }
 }
 public override bool IsValidMedicamentSubcategoryName(int medicamentSubcategoryID, int medicamentCategoryID, string name)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((bool)adapter.SP_IsValidMedicamentSubcategoryName(medicamentSubcategoryID, medicamentCategoryID, name));
     }
 }
 public override bool IsValidCurrencyRateDate(int currencyRateID, string currencyCode, DateTime date)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((bool)adapter.SP_IsValidCurrencyRateDate(currencyRateID, currencyCode, date));
     }
 }
示例#10
0
 public override int AddOrEditCurrency(string currencyCodeOld, string currencyCodeNew, string name, string coin, decimal averageRate, int position, int status, int modifiedUserID, DateTime modifiedDate, int approverUserID, int action)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((int)adapter.SP_AddOrEditCurrency(currencyCodeOld, currencyCodeNew, name, coin, averageRate, position, status, modifiedUserID, modifiedDate, approverUserID, action));
     }
 }
示例#11
0
 public override bool IsValidCurrencyCode(string currencyCodeOld, string currencyCodeNew)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((bool)adapter.SP_IsValidCurrencyCode(currencyCodeOld, currencyCodeNew));
     }
 }
示例#12
0
 public override bool IsValidCountryName(string countryCodeOld, string name)
 {
     using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
     {
         return((bool)adapter.SP_IsValidCountryName(countryCodeOld, name));
     }
 }
示例#13
0
        public override int ActionRecord(int tableID, int paramInt1, string paramString1, DateTime paramDateTime1, Guid paramGuid1, int paramInt2, string paramString2, DateTime paramDateTime2, Guid paramGuid2, int action, int modifiedUserID, bool isOnline)
        {
            var connectionString = (isOnline ? ConfigurationManagerEx.ConnectionString : ConfigurationManagerEx.OfflineConnectionString);
            var commandTimeout   = (isOnline ? ConfigurationManagerEx.CommandTimeout : ConfigurationManagerEx.OfflineCommandTimeout);

            using (var adapter = DictionaryQueriesAdapter.CreateInstance(connectionString, commandTimeout))
            {
                return((int)adapter.SP_ActionRecord(tableID, paramInt1, paramString1, paramDateTime1, paramGuid1, paramInt2, paramString2, paramDateTime2, paramGuid2, action, modifiedUserID));
            }
        }
示例#14
0
        public override decimal GetCurrencyRate(string currencyCode, DateTime date, bool isOnline)
        {
            var connectionString = (isOnline ? ConfigurationManagerEx.ConnectionString : ConfigurationManagerEx.OfflineConnectionString);
            var commandTimeout   = (isOnline ? ConfigurationManagerEx.CommandTimeout : ConfigurationManagerEx.OfflineCommandTimeout);

            using (var adapter = DictionaryQueriesAdapter.CreateInstance(connectionString, commandTimeout))
            {
                return((decimal)adapter.SP_GetRate(currencyCode, date));
            }
        }