public async Task Load(string rootFolder)
{
var createTables = false;
if (!_databaseFile.Exists)
{
SQLiteConnection.CreateFile(_databaseFile.FullName);
createTables = true;
}
var dataProvider = new IDataProvider[] {Images, Artists, Albums, Tracks, Playlists};
_connection = new SQLiteConnection($"Data Source={_databaseFile.FullName};Version=3;");
await _connection.OpenAsync();
if(createTables)
foreach (var provider in dataProvider)
await provider.CreateTables(_connection);
foreach (var data in dataProvider)
await data.Load(_connection);
var userDataFileInfo = new FileInfo(Path.Combine(rootFolder, UserDataFilename));
if (userDataFileInfo.Exists)
await UserData.LoadFromFile(userDataFileInfo.FullName);
LoadSettings();
}
public Sample(string fileName, string fullPath, IDataProvider dataProvider)
{
_fileName = fileName;
FullPath = fullPath;
_dataProvider = dataProvider;
dataProviderTypeId = dataProvider.TypeId;
}
public SimplestsTable(IDataProvider provider):base("Simplests",provider){
ClassName = "Simplest";
SchemaName = "dbo";
Columns.Add(new DatabaseColumn("Id", this)
{
IsPrimaryKey = true,
DataType = DbType.Int64,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0
});
Columns.Add(new DatabaseColumn("Value", this)
{
IsPrimaryKey = false,
DataType = DbType.Int64,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0
});
}
public HomeController()
{
var dbFactory = new SqLiteConnectionFactory();
DataProvider = new DataProvider(dbFactory);
DataService = new BookStorageService(DataProvider);
DataService.InitSqDb();
}
public AUSaleService(
IRepository<AULotRecord> lotRepo,
IConsignorService consignorService,
IAuthenticationService authenticationService,
IRepository<AUConsignmentLotRecord> consignmentlotRepo,
IRepository<AUCountryLotRecord> countrylotRepo,
IRepository<AUStateProvinceLotRecord> stateprovincelotRepo,
IRepository<AULotLotRecord> lotlotRepo,
IRepository<AUSaleRecord> saleRepo,
IProductService productService,
IDataProvider dataProvider,
IDbContext dbContext,
ICategoryService categoryService
)
{
this._lotRepo = lotRepo;
this._consignorService = consignorService;
this._authenticationService = authenticationService;
this._consignmentlotRepo = consignmentlotRepo;
this._countrylotRepo = countrylotRepo;
this._stateprovincelotRepo = stateprovincelotRepo;
this._lotlotRepo = lotlotRepo;
this._saleRepo = saleRepo;
this._productService = productService;
this._dataProvider = dataProvider;
this._dbContext = dbContext;
this._categoryService = categoryService;
}
private void SubmitCheck( IDataProvider provider )
{
int accountId = int.Parse( ddlAccount.SelectedValue );
IAccount account = provider.GetAccount( accountId );
if( account == null )
throw new ApplicationException( "Account " + accountId + " not found in data storage." );
IAccount expenseAccount = provider.GetAccount( 2 );
if( expenseAccount == null )
throw new ApplicationException( "Expense account not found in data storage." );
this.trans = provider.NewTransaction();
trans.Amount = Convert.ToDecimal( txtAmount.Text );
trans.TransactionDate = DateTime.Parse( txtDate.Text );
trans.Payee = txtPayee.Text;
if( txtMemo.Text.Length > 0 ) trans.Memo = txtMemo.Text;
trans.IsEstimated = chkEstimated.Checked;
ILineItem credit = trans.NewLineItem();
credit.SetAccount( account );
credit.Amount = trans.Amount;
credit.Category = null;
credit.Memo = trans.Memo;
if( txtNumber.Text.Length > 0 ) credit.Number = txtNumber.Text;
credit.TransactionType = TransactionType.Credit;
credit.IsTaxRelated = this.chkDeductible.Checked;
ILineItem debit = trans.NewLineItem();
debit.SetAccount( expenseAccount );
debit.Amount = credit.Amount;
debit.Category = txtCategory.Text;
debit.TransactionType = TransactionType.Debit;
debit.IsTaxRelated = this.chkDeductible.Checked;
}
public VotingControllerBuilder()
{
conferenceLoader = Substitute.For<IConferenceLoader>();
dataProvider = Substitute.For<IDataProvider>();
dnsLookup = Substitute.For<IDnsLookup>();
chartDataConverter = Substitute.For<IChartDataConverter>();
}
private static void Initialize()
{
if (_provider == null)
{
lock (_lock)
{
if (_provider == null)
{
//SqlCeProviderController.Register();
GalleryServerPro.Configuration.DataProvider dataProviderConfig = GalleryServerPro.Configuration.ConfigManager.GetGalleryServerProConfigSection().DataProvider;
if (dataProviderConfig.DefaultProvider == null || dataProviderConfig.Providers == null || dataProviderConfig.Providers.Count < 1)
throw new ProviderException("You must specify a valid default Gallery Server data provider.");
//Instantiate the providers
_providerCollection = new DataProviderCollection();
System.Web.Configuration.ProvidersHelper.InstantiateProviders(dataProviderConfig.Providers, _providerCollection, typeof(DataProvider));
//providerCollection.SetReadOnly();
_provider = _providerCollection[dataProviderConfig.DefaultProvider];
if (_provider == null)
{
string source = (dataProviderConfig.ElementInformation.Properties["defaultProvider"] != null ? dataProviderConfig.ElementInformation.Properties["defaultProvider"].Source : String.Empty);
int lineNumber = (dataProviderConfig.ElementInformation.Properties["defaultProvider"] != null ? dataProviderConfig.ElementInformation.Properties["defaultProvider"].LineNumber : 0);
throw new ConfigurationErrorsException("You must specify a default Gallery Server data provider.", source, lineNumber);
}
}
}
}
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="dataProvider">Data provider</param>
/// <param name="dbContext">Database Context</param>
/// <param name="commonSettings">Common settings</param>
public FulltextService(IDataProvider dataProvider, IDbContext dbContext,
CommonSettings commonSettings)
{
this._dataProvider = dataProvider;
this._dbContext = dbContext;
this._commonSettings = commonSettings;
}
public AddTaskViewModel(IDataProvider batchService, string jobId)
{
this.batchService = batchService;
this.IsBusy = false;
this.JobId = jobId;
}
public void HandlesDegenerateCaseWithMoreThanOneProviderButOneIsEmpty()
{
DataBinding[][] bindingsPerProvider = new DataBinding[][] {
new DataBinding[] { new DataBinding(0, null) },
new DataBinding[] { new DataBinding(0, null) },
};
IDataProvider[] providers = new IDataProvider[] {
Mocks.StrictMock<IDataProvider>(),
Mocks.StrictMock<IDataProvider>()
};
IDataItem[][] itemsPerProvider = new IDataItem[][] {
new IDataItem[] {
new ScalarDataItem<int>(1, null, true),
new ScalarDataItem<int>(2, null, false)
},
new IDataItem[0]
};
using (Mocks.Record())
{
SetupResult.For(providers[0].GetItems(bindingsPerProvider[0], true)).Return(itemsPerProvider[0]);
SetupResult.For(providers[1].GetItems(bindingsPerProvider[1], true)).Return(itemsPerProvider[1]);
}
using (Mocks.Playback())
{
List<IList<IDataItem>> items = new List<IList<IDataItem>>(PairwiseJoinStrategy.Instance.Join(providers, bindingsPerProvider, true));
Assert.Count(0, items);
}
}
public MushroomRule(IDataProvider dataProvider, int generacion, char classValue)
{
DataProvider = dataProvider;
Generation = generacion;
ClassValue = classValue;
solution = null;
}
public void HandlesDegenerateCaseWithOneProvider()
{
DataBinding[] bindings = new DataBinding[] {
new DataBinding(0, null)
};
IDataProvider[] providers = new IDataProvider[] {
Mocks.StrictMock<IDataProvider>()
};
using (Mocks.Record())
{
Expect.Call(providers[0].GetItems(bindings, true)).Return(new IDataItem[] {
new ScalarDataItem<int>(1, null, true),
new ScalarDataItem<int>(2, null, false),
new ScalarDataItem<int>(3, null, true)
});
}
using (Mocks.Playback())
{
List<IDataItem> items = new List<IDataItem>(IntersectionMergeStrategy.Instance.Merge(providers, bindings, true));
Assert.Count(3, items);
Assert.AreEqual(1, items[0].GetValue(bindings[0]));
Assert.IsTrue(items[0].IsDynamic);
Assert.AreEqual(2, items[1].GetValue(bindings[0]));
Assert.IsFalse(items[1].IsDynamic);
Assert.AreEqual(3, items[2].GetValue(bindings[0]));
Assert.IsTrue(items[2].IsDynamic);
}
}
public VotingController(IConferenceLoader conferenceLoader, IDataProvider dataProvider, IDnsLookup dnsLookup, IChartDataConverter chartDataConverter)
{
if (conferenceLoader == null)
{
throw new ArgumentNullException("conferenceLoader");
}
if (dataProvider == null)
{
throw new ArgumentNullException("dataProvider");
}
if (dnsLookup == null)
{
throw new ArgumentNullException("dnsLookup");
}
if (chartDataConverter == null)
{
throw new ArgumentNullException("chartDataConverter");
}
this.conferenceLoader = conferenceLoader;
this.dataProvider = dataProvider;
this.dnsLookup = dnsLookup;
this.chartDataConverter = chartDataConverter;
}
void Initialize() {
this.dataProvider = DataSource.GetDataProvider();
this.range = this.currentRange = DateTimeUtils.GetOneYearRange();
ucSales.Diagram.AxisY.Visibility = Utils.DefaultBoolean.False;
ucSales.Diagram.AxisX.Visibility = Utils.DefaultBoolean.False;
ucUnits.Diagram.AxisY.Visibility = Utils.DefaultBoolean.False;
ucUnits.Diagram.AxisX.Visibility = Utils.DefaultBoolean.False;
ucUnits.Diagram.Margins.All = 0;
ucUnits.Diagram.Rotated = true;
ucUnits.chart.Legend.AlignmentVertical = LegendAlignmentVertical.Top;
ucUnits.chart.Legend.AlignmentHorizontal = LegendAlignmentHorizontal.RightOutside;
ucUnits.chart.Legend.Border.Visibility = Utils.DefaultBoolean.False;
ucUnits.chart.Legend.Margins.Right = 0;
ucUnits.chart.Legend.MarkerSize = new System.Drawing.Size(18, 18);
ucUnits.chart.Legend.MarkerVisible = true;
ucUnits.chart.Legend.TextOffset = 8;
ucUnits.chart.Legend.VerticalIndent = 4;
ucUnits.chart.Legend.Visibility = Utils.DefaultBoolean.True;
ucUnits.chart.Series[0].LegendTextPattern = "{A}";
ucSales.Diagram.Margins.All = 0;
Palette palette = ChartUtils.GeneratePalette();
this.rangeControlClient = new RangeControlSalesClient(palette[3].Color);
this.rangeControlClient.YearMonth = true;
rangeControl.Client = this.rangeControlClient;
IEnumerable<SalesGroup> sales = dataProvider.GetSales(range.Start, range.End, GroupingPeriod.Day);
this.rangeControlClient.UpdateData(sales);
}
protected QueryConditional(Type[] dbtypes, Expression expr, IDataProvider dataProvider)
{
LoadObjects(dbtypes);
DataProvider = dataProvider;
string conditional = TranslateExtendtion.TranslateConditional(expr, DataProvider);
this.strConditional = new StringBuilder(conditional);
}
public Database(IDataProvider provider, string connectionString)
{
Timeout = -1;
Provider = provider;
ConnectionString = connectionString;
LogDatabaseProviderName(provider.ToString());
}
public SimpleRepositoryTests(IDataProvider provider)
{
_provider = provider;
_repo = new SimpleRepository(_provider, SimpleRepositoryOptions.RunMigrations);
try
{
var qry = new CodingHorror(_provider, "DROP TABLE Shwerkos").Execute();
}
catch { }
try
{
new CodingHorror(_provider, "DROP TABLE DummyForDeletes").Execute();
}
catch { }
try
{
new CodingHorror(_provider, "DROP TABLE Shwerko2s").Execute();
}
catch { }
try
{
new CodingHorror(_provider, "DROP TABLE NonAutoIncrementingIdWithDefaultSettings").Execute();
}
catch { }
}
protected override void OnStartup(StartupEventArgs e)
{
base.OnStartup(e);
try
{
Assembly a = Assembly.LoadFrom(Console.Properties.Settings.Default.DataProviderLibrary);
ProviderType = a.GetType(Console.Properties.Settings.Default.DataProviderClass);
Provider = (IDataProvider)Activator.CreateInstance(ProviderType);
}
catch (Exception ex)
{
string m = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
Message(
"Fehler beim Aufstarten des konfigurierten Datenproviders: " +
m +
"\nDie Anwendung wird nun beendet.",
MessageType.Error);
Shutdown(1);
return;
}
MainView = new MainViewModel();
MainView.ShowPage(new SplashViewModel());
Task t = new Task(new Action<object>(Provider.Startup), null);
t.Start();
Task.WaitAny(new Task[] { t });
this.MainWindow = MainView.GetWindow();
MainView.SetDefaultView(typeof(OverViewModel));
MainView.ShowPage(new OverViewModel());
}
public void Subscribe(IDataProvider provider, InstrumentList instruments)
{
if (provider.Status != ProviderStatus.Connected)
{
provider.Connect();
}
InstrumentList instrumentList = new InstrumentList();
for (int i = 0; i < instruments.Count; i++)
{
Instrument byIndex = instruments.GetByIndex(i);
if (!this.subscriptions.ContainsKey((int)provider.Id))
{
this.subscriptions[(int)provider.Id] = new Dictionary<Instrument, int>();
}
if (!this.subscriptions[(int)provider.Id].ContainsKey(byIndex) || this.subscriptions[(int)provider.Id][byIndex] == 0)
{
this.subscriptions[(int)provider.Id][byIndex] = 0;
instrumentList.Add(byIndex);
}
Dictionary<Instrument, int> dictionary;
Instrument key;
(dictionary = this.subscriptions[(int)provider.Id])[key = byIndex] = dictionary[key] + 1;
}
if (instrumentList.Count > 0)
{
provider.Subscribe(instrumentList);
}
}
public void Subscribe(IDataProvider provider, Instrument instrument)
{
if (provider.Status != ProviderStatus.Connected)
{
provider.Connect();
}
Dictionary<Instrument, int> dictionary = null;
if (!this.subscriptions.TryGetValue((int)provider.Id, out dictionary))
{
dictionary = new Dictionary<Instrument, int>();
this.subscriptions[(int)provider.Id] = dictionary;
}
int num = 0;
bool flag = false;
if (!dictionary.TryGetValue(instrument, out num))
{
flag = true;
num = 1;
}
else
{
if (num == 0)
{
flag = true;
}
num++;
}
dictionary[instrument] = num;
if (flag)
{
provider.Subscribe(instrument);
}
}
public ArticleStructs(IDataProvider provider)
: base("Article",provider)
{
ClassName = "Article";
SchemaName = "dbo";
Columns.Add(new DatabaseColumn("Id", this)
{
IsPrimaryKey = true,
DataType = DbType.Int64,
IsNullable = false,
AutoIncrement = true,
IsForeignKey = true,
MaxLength = 0,
PropertyName = "Id"
});
Columns.Add(new DatabaseColumn("ArticleName", this)
{
IsPrimaryKey = false,
DataType = DbType.String,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 255,
PropertyName = "ArticleName"
});
}
/// <summary>
/// Initializes a new instance of the <see cref="ScanManager"/> class.
/// </summary>
/// <param name="storageProvider">
/// The storage provider to use.
/// </param>
/// <param name="dataProvider">
/// The data provider to use.
/// </param>
internal ScanManager(IStorageProvider storageProvider, IDataProvider dataProvider)
{
this.storageProvider = storageProvider;
this.dataProvider = dataProvider;
this.settings = Settings.LoadSettings(storageProvider);
this.tvShows = TvShow.GetTvShows(storageProvider).ToList();
}
public BaseServices()
{
DataProvider = DependencyResolver.Current.GetService<IDataProvider>();
LikesService = DependencyResolver.Current.GetService<ILikesService>();
ServiceCache = CacheProvider.Current.GetCache();
DefaultExpirationTime = new TimeSpan(0, 20, 0);
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="logRepository">Log repository</param>
/// <param name="webHelper">Web helper</param>>
/// <param name="dbContext">DB context</param>>
/// <param name="dataProvider">WeData provider</param>
/// <param name="commonSettings">Common settings</param>
public DefaultLogger(IRepository<Log> logRepository, IWebHelper webHelper, IDbContext dbContext, IDataProvider dataProvider)
{
this._logRepository = logRepository;
this._webHelper = webHelper;
this._dbContext = dbContext;
this._dataProvider = dataProvider;
}
public CommandsTable(IDataProvider provider)
: base("Commands",provider)
{
ClassName = "Command";
SchemaName = "";
Columns.Add(new DatabaseColumn("CommandName", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 2147483647
});
Columns.Add(new DatabaseColumn("File", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 2147483647
});
}
/// <summary>
/// Creates a new Parser instance
/// </summary>
/// <param name="dataProvider">The provider of the screen data</param>
public Parser(IDataProvider dataProvider, ILocatorFinder locatorFinder = null, INameFinder nameFinder = null, params ITool[] tools)
{
this.dataProvider = dataProvider;
this.locatorFinder = locatorFinder;
this.nameFinder = nameFinder;
this.tools = tools;
}
private void RegisterDataProvider(IDataProvider provider)
{
if (provider == null)
{
throw new ArgumentNullException("provider");
}
Type type = provider.GetType();
List<MethodInfo> methods = type.GetMethods()
.Where(IsEvaluator)
.ToList();
foreach (MethodInfo method in methods)
{
string key = GetArgumentName(method);
Func<double> evaluator = CreateEvaluator(method, provider);
if (_evaluators.ContainsKey(key))
{
throw new InvalidOperationException(String.Format("Formula argument duplicate {0}", key));
}
_evaluators[key] = evaluator;
}
}
public TemplateCrawlResult Run(IDataProvider provider)
{
if (_phases.Count == 0)
{
String msg = "No phases configured for this template, aborting";
throw new InvalidOperationException(msg);
}
Context.ParameterProvider = provider;
RunInternal();
TemplateCrawlResult result = new TemplateCrawlResult();
result.JsonResult = _context.JsonResult;
result.Succeed = true;
// 如果存在Gecko浏览器则将它释放
if (UseBrowser)
{
GeckoWebBrowser browser = (GeckoWebBrowser)Context.GetService(typeof(GeckoWebBrowser));
if (browser != null)
{
browser.Dispose();
}
}
return result;
}
public SocketWriter(IDataProvider Idp, Socket s)
{
SocketForClient = s;
this.ns = new NetworkStream(s);
this.Idp = Idp;
Idp.DataChanged += new EventHandler(Idp_DataChanged);
}
public MainViewModel(IDataProvider dataProvider, IEventAggregator eventAggregator, IAuthenticationService authenticationService)
{
_dataProvider = dataProvider;
_eventAggregator = eventAggregator;
_authenticationService = authenticationService;
}
public NorthwindDB(string connectionString, string providerName)
{
DataProvider = ProviderFactory.GetProvider(connectionString, providerName);
Init();
}
public NorthwindDB()
{
DataProvider = ProviderFactory.GetProvider("Northwind");
Init();
}
public STOCK_SHOP00Structs(IDataProvider provider) : base("STOCK_SHOP00", provider)
{
ClassName = "STOCK_SHOP00";
SchemaName = "dbo";
Columns.Add(new DatabaseColumn("Id", this)
{
IsPrimaryKey = false,
DataType = DbType.Int32,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0,
PropertyName = "Id"
});
Columns.Add(new DatabaseColumn("SHOP_ID", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 10,
PropertyName = "SHOP_ID"
});
Columns.Add(new DatabaseColumn("SHOP_NAME1", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 40,
PropertyName = "SHOP_NAME1"
});
Columns.Add(new DatabaseColumn("STOCK_ID", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 10,
PropertyName = "STOCK_ID"
});
Columns.Add(new DatabaseColumn("STOCK_NAME", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 30,
PropertyName = "STOCK_NAME"
});
Columns.Add(new DatabaseColumn("IsDefBill", this)
{
IsPrimaryKey = false,
DataType = DbType.Byte,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0,
PropertyName = "IsDefBill"
});
Columns.Add(new DatabaseColumn("IsBool", this)
{
IsPrimaryKey = false,
DataType = DbType.Byte,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0,
PropertyName = "IsBool"
});
Columns.Add(new DatabaseColumn("Memo", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 40,
PropertyName = "Memo"
});
Columns.Add(new DatabaseColumn("CRT_DATETIME", this)
{
IsPrimaryKey = false,
DataType = DbType.DateTime,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0,
PropertyName = "CRT_DATETIME"
});
Columns.Add(new DatabaseColumn("CRT_USER_ID", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 10,
PropertyName = "CRT_USER_ID"
});
Columns.Add(new DatabaseColumn("MOD_DATETIME", this)
{
IsPrimaryKey = false,
DataType = DbType.DateTime,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0,
PropertyName = "MOD_DATETIME"
});
Columns.Add(new DatabaseColumn("MOD_USER_ID", this)
{
IsPrimaryKey = false,
DataType = DbType.AnsiString,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 10,
PropertyName = "MOD_USER_ID"
});
Columns.Add(new DatabaseColumn("LAST_UPDATE", this)
{
IsPrimaryKey = false,
DataType = DbType.DateTime,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0,
PropertyName = "LAST_UPDATE"
});
}
public NorthwindDataContextFactory(IDataProvider dataProvider, string connectionString)
{
this.dataProvider = dataProvider;
this.connectionString = connectionString;
}
public ChiTietHDNService(IRepository <ChiTietHDN> repos, IDataProvider data, IDbContext db)
{
this.repos = repos;
this.data = data;
this.db = db;
}
/// <summary>
/// <see cref="ISequencer.NewPoller{T}(IDataProvider{T}, ISequence[])"/>.
/// </summary>
public EventPoller <T> NewPoller <T>(IDataProvider <T> provider, params ISequence[] gatingSequences)
{
return(EventPoller.Create(provider, this, new Sequence(), _cursor, gatingSequences));
}
private void bntSearchDate_Click(object sender, EventArgs e)
{
/**
* the vaues of comboBox cmbCondition
* 0 = equal
* 1 = greater
* 2 = greater and equal
* 3 = less than
* 4 = less and equal
*/
txtBeginDateFilter_TextChanged(null, null);
string dateStr = txtBeginDateFilter.Text;
string condition = "";
string fld;
fld = ViewInsuranceInfoData.endDate_FIELD;
if (cmbCondition.SelectedIndex < 0)
{
MessageBox.Show("شرط تاریخ تعیین نشده است");
return;
}
if (!CheckDate.checkDate(dateStr))
{
MessageBox.Show("تاریخ معتبر نیست");
return;
}
DateTime date = RMX_TOOLS.date.DateXFormer.persianToGreGorian(dateStr);
IDataProvider dp = Config.provider;
switch (cmbCondition.SelectedIndex)
{
case 0:
if (rBtnHaveDid.Checked)
{
condition = dp.getBetweenDate(fld, date, date, null);
}
else if (rBtnOP.Checked)
{
condition = dp.getBetweenDate(fld, date, date, ViewInsuranceInfoData.DAYSBEFOREXP_FIELD);
}
break;
case 1:
if (rBtnHaveDid.Checked)
{
condition = fld + ">" + dp.getAsSqlDate(date.ToShortDateString(), RMX_TOOLS.date.DateConstants.END_OF_DAY);
}
else if (rBtnOP.Checked)
{
condition = fld + ">" + dp.getAsSqlDate(date.ToShortDateString(),
RMX_TOOLS.date.DateConstants.END_OF_DAY) + " + " + ViewInsuranceInfoData.DAYSBEFOREXP_FIELD;
}
break;
case 2:
if (rBtnHaveDid.Checked)
{
condition = fld + " >= " + dp.getAsSqlDate(date.ToShortDateString(), RMX_TOOLS.date.DateConstants.BEGIN_OF_DAY);
}
else if (rBtnOP.Checked)
{
condition = fld + " >= " + dp.getAsSqlDate(date.ToShortDateString(),
RMX_TOOLS.date.DateConstants.BEGIN_OF_DAY) + " + " + ViewInsuranceInfoData.DAYSBEFOREXP_FIELD;
}
break;
case 3:
if (rBtnHaveDid.Checked)
{
condition = fld + " < " + dp.getAsSqlDate(date.ToShortDateString(), RMX_TOOLS.date.DateConstants.BEGIN_OF_DAY);
}
else if (rBtnOP.Checked)
{
condition = fld + " < " + dp.getAsSqlDate(date.ToShortDateString(),
RMX_TOOLS.date.DateConstants.BEGIN_OF_DAY) + " + " + ViewInsuranceInfoData.DAYSBEFOREXP_FIELD;
}
break;
case 4:
if (rBtnHaveDid.Checked)
{
condition = fld + " < " + dp.getAsSqlDate(date.ToShortDateString(), RMX_TOOLS.date.DateConstants.END_OF_DAY);
}
else if (rBtnOP.Checked)
{
condition = fld + " < " + dp.getAsSqlDate(date.ToShortDateString(),
RMX_TOOLS.date.DateConstants.END_OF_DAY) + " + " + ViewInsuranceInfoData.DAYSBEFOREXP_FIELD;
}
break;
}
// int v = (cbxHaveDid2.Checked ? 1 : 0);
// condition += " and " + ViewInsuranceInfoData.haveDid_FIELD + "=" + v + " ";
_condition = condition;
string cancel = "";// " and(cancel is null or cancel = 0)";
fillGrid(_condition + cancel);
}
public Detalle_de_Persona_MoralService(IDataProvider dataProvider, IDbContext dbContext, IRepository <Spartane.Core.Domain.Detalle_de_Persona_Moral.Detalle_de_Persona_Moral> Detalle_de_Persona_MoralRepository)
{
this._dataProvider = dataProvider;
this._dbContext = dbContext;
this._Detalle_de_Persona_MoralRepository = Detalle_de_Persona_MoralRepository;
}
public Spartan_Format_TypeService(IDataProvider dataProvider, IDbContext dbContext, IRepository <Spartane.Core.Classes.Spartan_Format_Type.Spartan_Format_Type> Spartan_Format_TypeRepository)
{
this._dataProvider = dataProvider;
this._dbContext = dbContext;
this._Spartan_Format_TypeRepository = Spartan_Format_TypeRepository;
}
public Tipo_de_PlantioService(IDataProvider dataProvider, IDbContext dbContext, IRepository <Spartane.Core.Domain.Tipo_de_Plantio.Tipo_de_Plantio> Tipo_de_PlantioRepository)
{
this._dataProvider = dataProvider;
this._dbContext = dbContext;
this._Tipo_de_PlantioRepository = Tipo_de_PlantioRepository;
}
public LogController(IDataProvider dataProvider)
{
_logsDataProvider = new LogsDataProvider(dataProvider);;
}
public RemoveVehicleHandler(IDataProvider dataProvider)
{
this.dataProvider = dataProvider;
}
public BackendResponseDataProvider()
{
dataProvider = new BackendDataProvider();
}
public ShortLinkService(IConfiguration configuration, IDataProvider dataProvider, IHashids hashids)
{
_configuration = configuration;
_dataProvider = dataProvider;
_hashids = hashids;
}
public LazyElementEnumerable(IdEnumerable <TId> ids, IDataProvider <TId, TConstraint> dataProvider)
{
IDs = ids;
this.dataProvider = dataProvider;
}
public Median(IDataProvider DataProvider)
{
this.DataProvider = DataProvider;
}
public DBResourceReader(CultureInfo culture, IDataProvider dataProvider)
{
this.culture = culture;
this.dataProvider = dataProvider;
}
public DataInsertController()
{
_IDataProvider = new DataProvider();
}
public TrialVersionRepository(IDataProvider dataProvider)
: base(dataProvider)
{
}
public Distrito_JudicialService(IDataProvider dataProvider, IDbContext dbContext, IRepository <Spartane.Core.Domain.Distrito_Judicial.Distrito_Judicial> Distrito_JudicialRepository)
{
this._dataProvider = dataProvider;
this._dbContext = dbContext;
this._Distrito_JudicialRepository = Distrito_JudicialRepository;
}
public SchemaParser(IDataProvider provider)
{
_provider = provider ?? throw new ArgumentNullException(nameof(provider));
}
public ChallengeDay7(AmplifierArrayFactory factory, IDataProvider <string> provider)
{
_factory = factory;
_provider = provider;
}
public ProductOrderManager(IDataProvider <ProductOrder> provider) : base(provider)
{
}
public HomeController(IDataProvider dataProvider)
{
_dataProvider = dataProvider;
}
public Medida_de_ProteccionService(IDataProvider dataProvider, IDbContext dbContext, IRepository <Spartane.Core.Domain.Medida_de_Proteccion.Medida_de_Proteccion> Medida_de_ProteccionRepository)
{
this._dataProvider = dataProvider;
this._dbContext = dbContext;
this._Medida_de_ProteccionRepository = Medida_de_ProteccionRepository;
}
public MyViewModel(IDataProvider provider)
{
_provider = provider ?? (some default provider);
public static void ResetDbProvider()
{
_instance = null;
}
public SustanciasService(IDataProvider dataProvider, IDbContext dbContext, IRepository <Spartane.Core.Classes.Sustancias.Sustancias> SustanciasRepository)
{
this._dataProvider = dataProvider;
this._dbContext = dbContext;
this._SustanciasRepository = SustanciasRepository;
}
public ASearchStrategy(IDataProvider dataProvider)
{
_dataProvider = dataProvider;
}
