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));
}
}
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));
}
}
public override bool IsValidCurrencyCode(string currencyCodeOld, string currencyCodeNew)
{
using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
{
return((bool)adapter.SP_IsValidCurrencyCode(currencyCodeOld, currencyCodeNew));
}
}
public override bool IsValidCountryName(string countryCodeOld, string name)
{
using (var adapter = DictionaryQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
{
return((bool)adapter.SP_IsValidCountryName(countryCodeOld, name));
}
}
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));
}
}
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));
}
}
