protected internal override void Loading()
{
txtFilterText.SourceControl = _filterGrid;
while (true)
{
if (processType == ProcessType.EntityInsert)
{
oldEntity = new Filter();
Id = processType.CreateId(oldEntity);
txtCode.Text = ((FilterBll)bll).NewCodeCreate(x => x.CardType == _filterCardType);
}
else
{
oldEntity = ((FilterBll)bll).Single(FilterFunctions.Filter <Filter>(Id));
if (oldEntity == null)
{
processType = ProcessType.EntityInsert;
continue;
}
ControlObjectConnection();
}
break;
}
}
protected internal override void Yukle()
{
txtFiltreMetni.SourceControl = _filtreGrid;
while (true)
{
if (BaseIslemTuru == IslemTuru.EntityInsert)
{
oldEntity = new Filtre();
id = BaseIslemTuru.IdOlustur(oldEntity);
txtKod.Text = ((FiltreBLL)bll).YeniKodVer(x => x.KartTuru == _filtreKartTuru);
}
else
{
oldEntity = ((FiltreBLL)bll).Single(FilterFunctions.Filter <Filtre>(id));
if (oldEntity == null)
{
BaseIslemTuru = IslemTuru.EntityInsert;
continue;
}
NesneyiKontrollereBagla();
}
break;
}
}
private FilterFunctions GetDefaultFilterFunctions(Method method)
{
if (method == null)
{
return(DefaultFilterFunctions);
}
FilterFunctions defaultValue = GetDefaultFilterFunctions(method.Entity);
return(method.GetAttributeValue("defaultFilterFunctions", NamespaceUri, defaultValue));
}
private FilterFunctions GetDefaultFilterFunctions(Entity entity)
{
if (entity == null)
{
return(DefaultFilterFunctions);
}
FilterFunctions defaultValue = GetDefaultFilterFunctions(entity.Project);
return(entity.GetAttributeValue("defaultFilterFunctions", NamespaceUri, defaultValue));
}
public void SearchDirectly()
{
Assert.That(FilterFunctions.SearchDirectly("строка", "строка"));
Assert.That(FilterFunctions.SearchDirectly("стРОка", "СТроКА"));
Assert.That(FilterFunctions.SearchDirectly("строка", "строк"), Is.False);
Assert.That(FilterFunctions.SearchDirectly("строка число", "строка число"));
Assert.That(FilterFunctions.SearchDirectly("строка число", "строка,число"));
Assert.That(FilterFunctions.SearchDirectly("строка,число", "строка число"));
Assert.That(FilterFunctions.SearchDirectly("строка число", "строка числ"), Is.False);
Assert.That(FilterFunctions.SearchDirectly("строка число", "строка за число"), Is.False);
}
private FilterFunctions GetFilterFunctions(MethodParameter parameter)
{
if (parameter == null)
{
return(DefaultFilterFunctions);
}
FilterFunctions defaultValue = GetDefaultFilterFunctions(parameter.Method);
return(parameter.GetAttributeValue("filterFunctions", NamespaceUri, defaultValue));
}
private FilterFunctions GetFilterFunction(EnumerationValue enumValue)
{
FilterFunctions op = enumValue.GetAttributeValue("filterFunction", NamespaceUri, FilterFunctions.None);
if (op == FilterFunctions.None)
{
op = ConvertUtilities.ChangeType(enumValue.Name, FilterFunctions.None);
}
return(op);
}
public override void Yukle()
{
OldEntity = BaseIslemTuru == IslemTuru.EntityInsert
? new Donem()
: ((DonemBll)Bll).Single(FilterFunctions.Filter <Donem>(Id));
NesneyiKontrollereBagla();
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(OldEntity);
txtKod.Text = ((DonemBll)Bll).YeniKodVer();
txtDonemAdi.Focus();
}
protected internal override void Loading()
{
oldEntity = processType == ProcessType.EntityInsert
? new Country()
: ((CountryBll)bll).Single(FilterFunctions.Filter <Country>(Id));
ControlObjectConnection();
if (processType != ProcessType.EntityInsert)
{
return;
}
Id = processType.CreateId(oldEntity);
txtCode.Text = ((CountryBll)bll).NewCodeCreate();
txtCountryName.Focus();
}
public override void Yukle()
{
OldEntity = BaseIslemTuru == IslemTuru.EntityInsert
? new Kurum()
: ((KurumBll)Bll).Single(FilterFunctions.Filter <Kurum>(Id));
NesneyiKontrollereBagla();
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(OldEntity);
txtKod.Text = "Yeni_Kurum";
txtKod.Enabled = true;
}
public override void Yukle()
{
OldEntity = BaseIslemTuru == IslemTuru.EntityInsert
? new KullaniciS()
: ((KullaniciBll)Bll).Single(FilterFunctions.Filter <Kullanici>(Id));
NesneyiKontrollereBagla();
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(OldEntity);
txtKullaniciAdi.Text = "Yeni Kullanıcı";
btnSifreSifirla.Enabled = false;
}
public void Search()
{
Assert.That(FilterFunctions.Search("строка", "строка"));
Assert.That(FilterFunctions.Search("стРОка", "СТроКА"));
Assert.That(FilterFunctions.Search("строка", "строкд"), Is.False);
Assert.That(FilterFunctions.Search("строка", "строк"));
Assert.That(FilterFunctions.Search("одна строка", "строка"));
Assert.That(FilterFunctions.Search("одна строка", "за строка"));
Assert.That(FilterFunctions.Search("одна строка", "за"), Is.False);
Assert.That(FilterFunctions.Search("одна строка", "одн*"));
Assert.That(FilterFunctions.Search("одна строка", "одн* строк"));
Assert.That(FilterFunctions.Search("одна строка", "одн* строк"));
Assert.That(FilterFunctions.Search("одна строка", "/одна, строк"));
Assert.That(FilterFunctions.Search("одна строка", "одна,строк"));
Assert.That(FilterFunctions.Search("одна строка", "одна.строк"), Is.False);
}
private bool IsSupported(FilterFunctions op, Procedure procedure, Parameter parameter)
{
if (op == FilterFunctions.None)
{
return(false);
}
var fullTextFunctions = new[] {
FilterFunctions.FullTextContains,
FilterFunctions.NotFullTextContains,
FilterFunctions.FreeText,
FilterFunctions.NotFreeText
};
var likeFunctions = new[] {
FilterFunctions.StartsWith,
FilterFunctions.EndsWith,
FilterFunctions.Contains,
FilterFunctions.NotContains
};
var parameterFunctions = GetFilterFunctions(parameter);
if ((parameterFunctions & op) != op)
{
return(false);
}
if (fullTextFunctions.Contains(op))
{
if (!IsFullTextCompatible(parameter.DbType))
{
return(false);
}
}
if (op == FilterFunctions.StartsWith || op == FilterFunctions.EndsWith || op == FilterFunctions.Contains || op == FilterFunctions.NotContains)
{
if (!IsLikeCompatible(parameter.DbType))
{
return(false);
}
}
return(true);
}
private void FilterRoms(Filter filter = null)
{
if (updating)
{
return;
}
FilteredRoms.Clear();
//DateTime begin = DateTime.Now;
if (filter == null)
{
filter = new Filter();
filter.text = textBoxFilter.Text;
filter.platform = comboBoxPlatform.Text;
filter.label = comboBoxLabels.Text;
filter.genre = comboBoxGenre.Text;
filter.publisher = comboBoxPublisher.Text;
filter.developer = comboBoxDeveloper.Text;
filter.year = comboBoxYearReleased.Text;
filter.status = comboBoxStatus.Text;
filter.favorite = checkBoxFavorite.Checked;
filter.text = filter.text.ToLower();
filter.textType = comboBoxFilter.Text;
filter.arcade = checkBoxArcade.Checked;
filter.console = checkBoxConsole.Checked;
filter.handheld = checkBoxHandheld.Checked;
filter.cd = checkBoxCD.Checked;
filter.romfile = dataGridView.SelectedRows.Count == 0 ? "" : ((Rom)dataGridView.SelectedRows[0].Tag).Name;
filter.romplatform = dataGridView.SelectedRows.Count == 0 ? "" : ((Rom)dataGridView.SelectedRows[0].Tag).Platform.Name;
}
dataGridView.SuspendLayout();
Thread.BeginCriticalRegion();
FilteredRoms = FilterFunctions.FilterRoms(filter);
Thread.EndCriticalRegion();
dataGridView.ResumeLayout();
//DateTime end = DateTime.Now;
AddRomsToGrid(FilteredRoms);
//FormCustomMessage.Show((end - begin).ToString());
}
protected override void Listele()
{
Tablo.GridControl.DataSource = ((SubeBll)bll).List(FilterFunctions.Filter <Sube>(aktifKartlariGoster));
var list = ((SubeBll)bll).List(_filter);
Tablo.GridControl.DataSource = list;
if (!multiSelect)
{
return;
}
if (list.Any())
{
EklenebilecekEntityVar = true;
}
else
{
Messages.KartBulunamadiMesaji("Kart");
}
}
private void FormMain_Close(object sender, FormClosedEventArgs e)
{
Filter filter = new Filter();
filter.platform = comboBoxPlatform.SelectedValue == null ? "" : comboBoxPlatform.SelectedValue.ToString();
filter.label = comboBoxLabels.SelectedValue == null ? "" : comboBoxLabels.SelectedValue.ToString();
filter.genre = comboBoxGenre.SelectedValue == null ? "" : comboBoxGenre.SelectedValue.ToString();
filter.publisher = comboBoxPublisher.SelectedValue == null ? "" : comboBoxPublisher.SelectedValue.ToString();
filter.developer = comboBoxDeveloper.SelectedValue == null ? "" : comboBoxDeveloper.SelectedValue.ToString();
filter.year = comboBoxYearReleased.SelectedValue == null ? "" : comboBoxYearReleased.SelectedValue.ToString();
filter.romfile = dataGridView.SelectedRows.Count == 0 ? "" : ((Rom)dataGridView.SelectedRows[0].Tag).FileName;
filter.romplatform = dataGridView.SelectedRows.Count == 0 ? "" : ((Rom)dataGridView.SelectedRows[0].Tag).Platform.Name;
filter.text = textBoxFilter.Text;
filter.textType = comboBoxFilter.SelectedText;
filter.favorite = checkBoxFavorite.Checked;
filter.arcade = checkBoxArcade.Checked;
filter.console = checkBoxConsole.Checked;
filter.handheld = checkBoxHandheld.Checked;
filter.status = comboBoxStatus.Text;
filter.cd = checkBoxCD.Checked;
FilterFunctions.SaveFilter(filter);
}
public override void Yukle()
{
OldEntity = BaseIslemTuru == IslemTuru.EntityInsert ? new Rapor() : ((RaporBll)Bll).Single(FilterFunctions.Filter <Rapor>(Id));
NesneyiKontrollereBagla();
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(OldEntity);
txtKod.Text = ((RaporBll)Bll).YeniKodVer(x => x.RaporBolumTuru == _raporBolumTuru && x.RaporTuru == _raporTuru);
txtRaporAdi.Focus();
}
protected internal override void Yukle()
{
oldEntity = BaseIslemTuru == IslemTuru.EntityInsert ? new GecikmeAciklamalariS() : ((GecikmeAciklamalariBll)Bll).Single(FilterFunctions.Filter <GecikmeAciklamalari>(Id));
NesneyiKontrollereBagla();
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(oldEntity);
txtKod.Text = ((GecikmeAciklamalariBll)Bll).YeniKodVer(x => x.OdemeBilgileriId == _portfoyNo);
txtAciklama.Focus();
}
protected internal override void Yukle()
{
OldEntity = BaseIslemTuru == COMMON.Enums.IslemTuru.EntityInsert ? new Yakinlik() : ((YakinlikBll)Bll).Single(FilterFunctions.Filter <Yakinlik>(Id));
NesneyiControllereBagla();
if (BaseIslemTuru != COMMON.Enums.IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(OldEntity);
txtKod.Text = ((YakinlikBll)Bll).YeniKodVer();
txtYakinlikAdi.Focus();
}
public override void Yukle()
{
OldEntity = BaseIslemTuru == IslemTuru.EntityInsert ? new BankaSube() : ((BankaSubeBll)Bll).Single(FilterFunctions.Filter <BankaSube>(Id));
NesneyiKontrollereBagla();
Text = Text + $" - ( {_bankaAdi} )";
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(OldEntity);
txtKod.Text = ((BankaSubeBll)Bll).YeniKodVer(x => x.BankaId == _bankaId);
txtSubeAdi.Focus();
}
protected override void Listele()
{
Tablo.GridControl.DataSource = ((YakinlikBll)bll).List(FilterFunctions.Filter <Yakinlik>(aktifKartlariGoster));
}
protected internal override void Yukle()
{
OldEntity = BaseIslemTuru == COMMON.Enums.IslemTuru.EntityInsert ? new Servis() : ((ServisBll)Bll).Single(FilterFunctions.Filter <Servis>(Id));
NesneyiControllereBagla();
if (BaseIslemTuru != COMMON.Enums.IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(OldEntity);
//Evrak olarak veritabanına git Oradaki ŞubeID ve DonemId ile sorgulama yap eğer entity geliyorsa Enbuyuk koda sahip olanı al 1 arttır ve bunu kod text e aktar yoksada 001 ile aktar
//demiş olduk. yenikodver içeriisnde vardır.
txtKod.Text = ((ServisBll)Bll).YeniKodVer(x => x.SubeId == AnaForm.SubeId && x.DonemId == AnaForm.DonemId);
txtServisYeri.Focus();
}
protected override void Listele()
{
tablo.GridControl.DataSource = ((KontenjanBll)Bll).List(FilterFunctions.Filter <Kontenjan>(AktifKartlariGoster));
}
protected override void Listele() => Tablo.GridControl.DataSource = ((GorevBll)Bll).List(FilterFunctions.Filter <Gorev>(AktifKartlariGoster));
private ProcedureExpressionStatement CreateParameterTestStatement(ProcedureStatement parent, Parameter parameter, FilterFunctions op)
{
ProcedureExpressionStatement result = null;
TableRefColumn refColumn = new TableRefColumn(parameter.Column);
switch (op)
{
case FilterFunctions.Equals:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.Equals, refColumn, parameter);
break;
case FilterFunctions.NotEquals:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.NotEquals, refColumn, parameter);
break;
case FilterFunctions.IsLessThan:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.IsLesserThan, refColumn, parameter);
break;
case FilterFunctions.IsLessThanOrEqualTo:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.IsLesserThanOrEqualTo, refColumn, parameter);
break;
case FilterFunctions.IsGreaterThan:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.IsGreaterThan, refColumn, parameter);
break;
case FilterFunctions.IsGreaterThanOrEqualTo:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.IsGreaterThanOrEqualTo, refColumn, parameter);
break;
case FilterFunctions.FullTextContains:
case FilterFunctions.NotFullTextContains:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.Contains, refColumn, parameter);
break;
case FilterFunctions.FreeText:
case FilterFunctions.NotFreeText:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.FreeText, refColumn, parameter);
break;
case FilterFunctions.StartsWith:
result = new ProcedureExpressionStatement(
parent,
ProcedureOperationType.Like,
new ProcedureExpressionStatement(parent, refColumn),
CreateConcatStatement(parent, parameter, "%"));
break;
case FilterFunctions.EndsWith:
result = new ProcedureExpressionStatement(
parent,
ProcedureOperationType.Like,
new ProcedureExpressionStatement(parent, refColumn),
CreateConcatStatement(parent, "%", parameter));
break;
case FilterFunctions.Contains:
case FilterFunctions.NotContains:
result = new ProcedureExpressionStatement(
parent,
ProcedureOperationType.Like,
new ProcedureExpressionStatement(parent, refColumn),
CreateConcatStatement(parent, "%", parameter, "%"));
break;
}
// Negate statement if needed
switch (op)
{
case FilterFunctions.NotContains:
case FilterFunctions.NotFullTextContains:
case FilterFunctions.NotFreeText:
result = new ProcedureExpressionStatement(parent, ProcedureOperationType.Not, result, null);
break;
}
return result;
}
private bool IsSupported(FilterFunctions op, Procedure procedure, Parameter parameter)
{
if (op == FilterFunctions.None)
return false;
var fullTextFunctions = new[] {
FilterFunctions.FullTextContains,
FilterFunctions.NotFullTextContains,
FilterFunctions.FreeText,
FilterFunctions.NotFreeText
};
var likeFunctions = new[] {
FilterFunctions.StartsWith,
FilterFunctions.EndsWith,
FilterFunctions.Contains,
FilterFunctions.NotContains
};
var parameterFunctions = GetFilterFunctions(parameter);
if ((parameterFunctions & op) != op)
return false;
if (fullTextFunctions.Contains(op))
{
if (!IsFullTextCompatible(parameter.DbType))
return false;
}
if (op == FilterFunctions.StartsWith || op == FilterFunctions.EndsWith || op == FilterFunctions.Contains || op == FilterFunctions.NotContains)
{
if (!IsLikeCompatible(parameter.DbType))
return false;
}
return true;
}
protected internal override void Yukle()
{
oldEntity = BaseIslemTuru == IslemTuru.EntityInsert ? new OkulS() : ((OkulBll)Bll).Single(FilterFunctions.Filter <Okul>(Id));
NesneyiKontrollereBagla();
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(oldEntity);
txtKod.Text = ((OkulBll)Bll).YeniKodVer();
txtOkulAdi.Focus();
}
protected override void Lists()
{
table.GridControl.DataSource = ((CountryBll)bll).List(FilterFunctions.Filter <Country>(activeCardShow));
}
public override void Yukle()
{
OldEntity = BaseIslemTuru == IslemTuru.EntityInsert ? new SinifS() : ((SinifBll)Bll).Single(FilterFunctions.Filter <Sinif>(Id));
NesneyiKontrollereBagla();
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(OldEntity);
txtKod.Text = ((SinifBll)Bll).YeniKodVer(x => x.SubeId == AnaForm.SubeId);
txtSinifAdi.Focus();
}
protected internal override void Yukle()
{
oldEntity = BaseIslemTuru == IslemTuru.EntityInsert ? new Ilce() : ((IlceBll)Bll).Single(FilterFunctions.Filter <Ilce>(Id));
NesneyiKontrollereBagla();
Text = Text + $" - ( {_ilAdi} )";
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
Id = BaseIslemTuru.IdOlustur(oldEntity);
txtKod.Text = ((IlceBll)Bll).YeniKodVer(x => x.IlId == _ilId);
txtIlceAdi.Focus();
}
protected override void Listele()
{
Tablo.GridControl.DataSource = ((HizmetTuruBll)Bll).List(FilterFunctions.Filter <HizmetTuru>(AktifKartlariGoster));
}
protected internal override void Yukle()
{
oldEntity = BaseIslemTuru == IslemTuru.EntityInsert ? new AileBilgi() : ((AileBilgiBll)bll).Single(FilterFunctions.Filter <AileBilgi>(id));
NesneyiKontrollereBagla();
if (BaseIslemTuru != IslemTuru.EntityInsert)
{
return;
}
id = BaseIslemTuru.IdOlustur(oldEntity);
txtKod.Text = ((AileBilgiBll)bll).YeniKodVer();
txtBilgiAdi.Focus();
}
