private void editdialog(bool state)
{
var lookup = context.GetLookup(Lookup.Id);
if ((this.CurrentRowIndex == -1) && state)
{
return;
}
List <FieldValuePair> current = new List <FieldValuePair>();
for (var i = 0; i < this.Fields[this.CurrentRowIndex + 1].Count; i++)
{
if (state)
{
current.Add(new FieldValuePair
{
Name = Fields[0][i],
Value = Fields[this.CurrentRowIndex + 1][i],
Length = lookup.Fields[i].Length,
ReadOnly = (lookup.Fields[i].NameEng == "Id") ? false : true
});
}
else
{
current.Add(new FieldValuePair
{
Name = Fields[0][i],
Value = "",
Length = lookup.Fields[i].Length,
ReadOnly = (lookup.Fields[i].NameEng == "Id") ? false : true
});
}
}
LookupsEdidViewModels vm = new LookupsEdidViewModels(current);
EditInsertLookups ds = new EditInsertLookups(vm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
if (state)
{
//update
context.UpdateRow(ds.GetNewFields(), lookup);
}
else
{
//nov red
context.SaveRow(ds.GetNewFields(), lookup);
}
CalculateFields();
OnPropertyChanged("Fields");
OnPropertyChanged("Lookup");
}
}
private void ButtonBase_OnClick(object sender, RoutedEventArgs e)
{
var Context = new TempoDataBaseContext();
var sen = (sender as Button);
if (sen != null)
{
var cp = sen.CommandParameter as SaldoItem;
if (cp != null && (cp.Relookup != 0 || cp.RCODELOOKUP != 0))
{
List <FieldValuePair> current = new List <FieldValuePair>();
LookupModel lookup = null;
if (cp.Relookup > 0)
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
else
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
int i = 0;
foreach (var item in lookup.Fields)
{
if (cp.SysLookup && i == 0)
{
i++;
continue;
}
current.Add(new FieldValuePair
{
Name = item.Name,
Value = "",
Length = item.Length,
ReadOnly = (item.NameEng == "Id") ? false : true,
IsRequared = item.IsRequared,
IsUnique = item.IsUnique,
RTABLENAME = item.RTABLENAME,
FieldName = item.NameEng
});
}
LookupsEdidViewModels vmm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, true);
EditInsertLookups ds = new EditInsertLookups(vmm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
//nov red
lookup.Fields.Add(new TableField {
DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер"
});
if (!Context.SaveRow(ds.GetNewFields(), lookup, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id))
{
MessageBoxWrapper.Show("Получвава се дублиране на елемент от номенклатура! Номенклатурата не е записана!");
}
else
{
var dc = DataContext as SaldoItem;
var dat = ds.GetNewFields();
if (dat != null)
{
if (dc != null)
{
dc.Value = dat[1];
dc.Lookupval = dat[2];
}
}
if (dat != null && dat.Count > 5)
{
if (dc != null)
{
dc.Bulstad = dat[3];
dc.Vat = dat[4];
}
}
OnRefreshExecuted(new FastLookupEventArgs(dc));
}
}
//cp.LookUp.Add(new SaldoItem { Value = ds.GetNewFields()[2], Key = ds.GetNewFields()[1] });
}
}
}
private void Calculate()
{
var Context = new TempoDataBaseContext();
var cp = this.DataContext as SaldoItem;
if (cp != null && (cp.Relookup != 0 || cp.RCODELOOKUP != 0))
{
string search = Entrence.ConfigFirmaToLookup.GetField(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id,
cp.Relookup);
List <FieldValuePair> current = new List <FieldValuePair>();
LookupModel lookup = null;
if (cp.Relookup > 0)
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup):Context.GetLookup(cp.Relookup);
}
else
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
int i = 0;
foreach (var item in lookup.Fields)
{
if (cp.SysLookup && i == 0)
{
i++;
continue;
}
var nf = new FieldValuePair
{
Name = item.Name,
Length = item.Length,
Value = i == 1 && string.IsNullOrWhiteSpace(search)?searcher.Text:"",
ReadOnly = item.NameEng != "Id",
IsRequared = item.IsRequared,
IsUnique = item.IsUnique,
RTABLENAME = item.RTABLENAME,
FieldName = item.NameEng
};
if (item.NameEng == search)
{
nf.Value = searcher.Text;
}
current.Add(nf);
}
LookupsEdidViewModels vmm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, true);
EditInsertLookups ds = new EditInsertLookups(vmm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
//nov red
if (!cp.SysLookup)
{
lookup.Fields.Add(new TableField
{
DbField = "integer",
GROUP = 4,
Id = 4,
Length = 4,
IsRequared = false,
NameEng = "FIRMAID",
Name = "Фирма Номер"
});
}
bool sys = cp.SysLookup?!Context.SaveRow(ds.GetNewFields(), lookup):!Context.SaveRow(ds.GetNewFields(), lookup, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
if (sys)
{
MessageBoxWrapper.Show(
"Получвава се дублиране на елемент от номенклатура! Номенклатурата не е записана!");
}
else
{
var dc = DataContext as SaldoItem;
var dat = ds.GetNewFields();
if (dat != null)
{
dc.Value = dat[1];
dc.Lookupval = dat[2];
}
if (dat != null && dat.Count > 5)
{
dc.Bulstad = dat[3];
dc.Vat = dat[4];
}
dc.LiD = 0;
OnRefreshExecuted(new FastLookupEventArgs(dc));
}
}
//cp.LookUp.Add(new SaldoItem { Value = ds.GetNewFields()[2], Key = ds.GetNewFields()[1] });
}
}
private void editdialog(bool state)
{
List <FieldValuePair> current = new List <FieldValuePair>();
LookupModel lookup = null;
if (Lookup != null)
{
if ((this.CurrentRowIndex == -1) && state)
{
return;
}
lookup = Context.GetSysLookup(Lookup.Id);
for (var i = 0; i < this.Fields[this.CurrentRowIndex + 1].Count; i++)
{
if (state)
{
current.Add(new FieldValuePair
{
Name = Fields[0][i],
Value = Fields[this.CurrentRowIndex + 1][i],
Length = lookup.Fields[i].Length,
ReadOnly = !(lookup.Fields[i].NameEng == "Id" || lookup.Fields[i].NameEng == "ID"),
IsRequared = lookup.Fields[i].IsRequared,
IsUnique = lookup.Fields[i].IsUnique,
RCODELOOKUP = lookup.Fields[i].RCODELOOKUP,
RFIELDNAME = lookup.Fields[i].RFIELDNAME,
RTABLENAME = lookup.Fields[i].RTABLENAME,
RFIELDKEY = lookup.Fields[i].RFIELDKEY,
Tn = lookup.Fields[i].Tn,
Type = lookup.Fields[i].DbField,
FieldName = lookup.Fields[i].NameEng
});
}
else
{
if (i > 0)
{
current.Add(new FieldValuePair
{
Name = Fields[0][i],
Value = "",
Length = lookup.Fields[i].Length,
ReadOnly =
(lookup.Fields[i].NameEng == "Id" || lookup.Fields[i].NameEng == "ID")
? false
: true,
IsRequared = lookup.Fields[i].IsRequared,
IsUnique = lookup.Fields[i].IsUnique,
RCODELOOKUP = lookup.Fields[i].RCODELOOKUP,
RFIELDNAME = lookup.Fields[i].RFIELDNAME,
RTABLENAME = lookup.Fields[i].RTABLENAME,
RFIELDKEY = lookup.Fields[i].RFIELDKEY,
Tn = lookup.Fields[i].Tn,
Type = lookup.Fields[i].DbField,
FieldName = lookup.Fields[i].NameEng
});
}
}
}
}
else
{
MessageBoxWrapper.Show(Resources.AnaliticManagerViewModel_editdialogres1);
return;
}
LookupsEdidViewModels vm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, false);
EditInsertLookups ds = new EditInsertLookups(vm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
if (state)
{
//update
Context.UpdateRowSys(ds.GetNewFields(), lookup);
}
else
{
//nov red
Context.SaveRow(ds.GetNewFields(), lookup);
}
CalculateFields();
OnPropertyChanged("Fields");
OnPropertyChanged("Lookup");
}
}
private void editdialog(bool state)
{
List <FieldValuePair> current = new List <FieldValuePair>();
if (Lookup != null)
{
if ((this.CurrentRowIndex == -1) && state)
{
return;
}
for (var i = 0; i < this.Fields[this.CurrentRowIndex + 1].Count - 1; i++)
{
if (state)
{
current.Add(new FieldValuePair
{
Name = Fields[0][i],
Value = Fields[this.CurrentRowIndex + 1][i],
Length = LookupModelm.Fields[i].Length,
ReadOnly = (LookupModelm.Fields[i].NameEng == "Id") ? false : true,
Type = LookupModelm.Fields[i].DbField,
IsRequared = LookupModelm.Fields[i].IsRequared,
IsUnique = LookupModelm.Fields[i].IsUnique,
Tn = LookupModelm.Fields[i].Tn,
RTABLENAME = LookupModelm.Fields[i].RTABLENAME,
FieldName = LookupModelm.Fields[i].NameEng
});
}
else
{
current.Add(new FieldValuePair
{
Name = Fields[0][i],
Value = "",
Length = LookupModelm.Fields[i].Length,
ReadOnly = (LookupModelm.Fields[i].NameEng == "Id") ? false : true,
Type = LookupModelm.Fields[i].DbField,
IsRequared = LookupModelm.Fields[i].IsRequared,
IsUnique = LookupModelm.Fields[i].IsUnique,
Tn = LookupModelm.Fields[i].Tn,
RTABLENAME = LookupModelm.Fields[i].RTABLENAME,
FieldName = LookupModelm.Fields[i].NameEng
});
}
}
}
else
{
MessageBoxWrapper.Show("Не е избрана номенклатура");
return;
}
LookupsEdidViewModels vm = new LookupsEdidViewModels(current, LookupModelm.LookUpMetaData.Tablename, !state);
EditInsertLookups ds = new EditInsertLookups(vm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
if (state)
{
//update
Context.UpdateRow(ds.GetNewFields(), LookupModelm);
}
else
{
//nov red
if (Context.CheckLookup(ds.GetNewFields(), LookupModelm))
{
var list = new List <string>(ds.GetNewFields());
Context.SaveRow(list, LookupModelm, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
}
else
{
MessageBoxWrapper.Show("Има поле ,за което не е спазено правилото за уникалност");
}
}
CalculateFields();
OnPropertyChanged("Fields");
OnPropertyChanged("Lookup");
}
}
