//public void PopulateVariables()
//{
// Variables.Add("@A1", "10");
// Variables.Add("@A2", "20");
// Variables.Add("@A3", "35");
// Variables.Add("@A4", "53");
//}
public void PopulateSysVariables()
{
var context = new Tempo2012.EntityFramework.TempoDataBaseContext();
ContoVars = context.GetOborotnaVedTemplate(new DateTime(ConfigTempoSinglenton.GetInstance().WorkDate.Year, 1, 1), new DateTime(ConfigTempoSinglenton.GetInstance().WorkDate.Year, 12, 31));
ContoVars.Add("@@FirmaName", Entrence.CurrentFirma.Name);
ContoVars.Add("@@FirmaBulstat", Entrence.CurrentFirma.Bulstad);
ContoVars.Add("@@FirmaAddress", Entrence.CurrentFirma.Address);
ContoVars.Add("@@Operator", Entrence.UserName);
}
public void PopulateConto()
{
Entrence.ConnectionString =
"User ID=sysdba;Password=masterkey;Database=localhost:E:\\Samples\\Tempo2012MVVM\\Tempo2012\\Tempo2012.UI.WPF\\bin\\Debug\\data\\TEMPO2012.FDB;DataSource=localhost;";
ObservableCollection <SaldoItem> ItemsCredit = new ObservableCollection <SaldoItem>();
ObservableCollection <SaldoItem> ItemsDebit = new ObservableCollection <SaldoItem>();
Tempo2012.EntityFramework.TempoDataBaseContext context =
new Tempo2012.EntityFramework.TempoDataBaseContext();
ObservableCollection <WraperConto> AllWrapedConto = new ObservableCollection <WraperConto>();
var AllAccountsK =
new ObservableCollection <AccountsModel>(
context.GetAllAccounts(1));
var Lookups = new ObservableCollection <LookUpMetaData>(context.GetAllLookups(" where NAMEENG='k'"));
var allconto = context.GetAllConto(1);
foreach (Conto conto in allconto)
{
var cont = conto.Clone();
cont.DataInvoise.AddDays(1);
AllWrapedConto.Add(new WraperConto(cont));
}
foreach (WraperConto wraperConto in AllWrapedConto)
{
ItemsCredit = new ObservableCollection <SaldoItem>(LoadDetails(wraperConto.CurrentConto.Id, 2, context));
ItemsDebit = new ObservableCollection <SaldoItem>(LoadDetails(wraperConto.CurrentConto.Id, 1, context));
var oldid = wraperConto.Id;
List <SaldoAnaliticModel> debit = new List <SaldoAnaliticModel>();
List <SaldoAnaliticModel> credit = new List <SaldoAnaliticModel>();
if (ItemsCredit != null)
{
foreach (SaldoItem currentsaldos in ItemsCredit)
{
SaldoAnaliticModel sa = new SaldoAnaliticModel();
sa.ACCFIELDKEY = currentsaldos.Fieldkey;
sa.ACCID = wraperConto.CurrentConto.CreditAccount;
sa.DATA = wraperConto.CurrentConto.DataInvoise;
sa.TYPEACCKEY = 0;
sa.VALUEDATE = currentsaldos.ValueDate;
sa.VAL = currentsaldos.Value;
sa.VALUEMONEY = currentsaldos.Valuedecimal;
sa.VALUENUM = currentsaldos.ValueInt;
sa.VALUED = currentsaldos.Valuedecimald;
sa.KURS = currentsaldos.IsKol?currentsaldos.OnePrice:currentsaldos.ValueKurs;
sa.VALVAL = currentsaldos.IsKol?currentsaldos.ValueKol:currentsaldos.ValueVal;
sa.KURSM = currentsaldos.MainKurs;
sa.KURSD = currentsaldos.KursDif;
sa.TYPE = 2;
sa.LOOKUPID = currentsaldos.Relookup;
sa.CONTOID = wraperConto.CurrentConto.Id;
//context.SaveContoMovement(sa);
debit.Add(sa);
}
}
if (ItemsDebit != null)
{
foreach (SaldoItem currentsaldos in ItemsDebit)
{
SaldoAnaliticModel sa = new SaldoAnaliticModel();
sa.ACCFIELDKEY = currentsaldos.Fieldkey;
sa.ACCID = wraperConto.CurrentConto.DebitAccount;
sa.DATA = DateTime.Now;
sa.TYPEACCKEY = 0;
sa.VALUEDATE = currentsaldos.ValueDate;
sa.VAL = currentsaldos.Value;
sa.VALUEMONEY = currentsaldos.Valuedecimal;
sa.VALUENUM = currentsaldos.ValueInt;
sa.VALUED = currentsaldos.Valuedecimald;
sa.KURS = currentsaldos.IsKol ? currentsaldos.OnePrice : currentsaldos.ValueKurs;
sa.VALVAL = currentsaldos.IsKol ? currentsaldos.ValueKol : currentsaldos.ValueVal;
sa.KURSM = currentsaldos.MainKurs;
sa.KURSD = currentsaldos.KursDif;
sa.TYPE = 1;
sa.LOOKUPID = currentsaldos.Relookup;
sa.CONTOID = wraperConto.CurrentConto.Id;
credit.Add(sa);
// context.SaveContoMovement(sa);
}
}
context.SaveConto(wraperConto.CurrentConto, debit, credit);
#region sells
if (wraperConto.IsSales)
{
DdsDnevnikModel ddsDnevnikModel = context.LoadDenevnicItem(oldid, 2);
//ddsDnevnikModel.DocId = CurrentWraperConto.CurrentConto.DocNum;
ddsDnevnikModel.Date = wraperConto.CurrentConto.Data;
ddsDnevnikModel.KindActivity = 2;
if (ddsDnevnikModel.LookupID == 0)
{
ddsDnevnikModel.CodeDoc = "01";
if (wraperConto.IsPurchases)
{
foreach (SaldoItem saldoItem in ItemsCredit)
{
if (saldoItem.IsLookUp)
{
ddsDnevnikModel.LookupID = saldoItem.Relookup;
if (saldoItem.SelectedLookupItem != null)
{
int lokalkey;
if (int.TryParse(saldoItem.SelectedLookupItem.Key, out lokalkey))
{
ddsDnevnikModel.LookupElementID = lokalkey;
}
}
}
if (saldoItem.Name.Contains("Дата на фактура"))
{
ddsDnevnikModel.DataF = saldoItem.ValueDate;
}
if (saldoItem.Name.Contains("Номер фактура"))
{
ddsDnevnikModel.DocId = saldoItem.Value;
}
}
}
else
{
foreach (SaldoItem saldoItem in ItemsDebit)
{
if (saldoItem.IsLookUp)
{
ddsDnevnikModel.LookupID = saldoItem.Relookup;
if (saldoItem.SelectedLookupItem != null)
{
int lokalkey;
if (int.TryParse(saldoItem.SelectedLookupItem.Key, out lokalkey))
{
ddsDnevnikModel.LookupElementID = lokalkey;
}
}
}
if (saldoItem.Name.Contains("Дата на фактура"))
{
ddsDnevnikModel.DataF = saldoItem.ValueDate;
}
if (saldoItem.Name.Contains("Номер фактура"))
{
ddsDnevnikModel.DocId = saldoItem.Value;
}
}
}
}
if (ddsDnevnikModel.LookupID > 0)
{
var SelectedLookup = new ObservableCollection <ContragentInfo>();
var Lookup = Lookups.FirstOrDefault(e => e.Id == ddsDnevnikModel.LookupID);
var list = context.GetLookup(Lookup.Tablename,
1);
foreach (List <string> li in list)
{
if (li != null && li.Count > 5)
{
SelectedLookup.Add(new ContragentInfo
{
Id = int.Parse(li[1]),
Name = li[2],
Bulstad = li[4],
Nzdds = li[5]
});
}
}
if (ddsDnevnikModel.LookupElementID > 0)
{
LookupElementInfo =
SelectedLookup.FirstOrDefault(e => e.Id == ddsDnevnikModel.LookupElementID);
ddsDnevnikModel.Num = wraperConto.CurrentConto.Id;
if (LookupElementInfo != null)
{
ddsDnevnikModel.LookupElementID = LookupElementInfo.Id;
ddsDnevnikModel.Bulstat = LookupElementInfo.Bulstad;
ddsDnevnikModel.Nzdds = LookupElementInfo.Nzdds;
ddsDnevnikModel.NameKontr = LookupElementInfo.Name;
}
}
}
ddsDnevnikModel.Num = wraperConto.CurrentConto.Id;
context.SaveDdsDnevnicModel(ddsDnevnikModel, ddsDnevnikModel.IsLinked);
}
#endregion
#region purchases
if (wraperConto.IsPurchases)
{
var ddsDnevnikModel = context.LoadDenevnicItem(oldid, 1);
//ddsDnevnikModel.DocId = CurrentWraperConto.CurrentConto.DocNum;
ddsDnevnikModel.Date = wraperConto.CurrentConto.Data;
ddsDnevnikModel.KindActivity = 1;
if (ddsDnevnikModel.LookupID == 0)
{
foreach (SaldoItem saldoItem in ItemsCredit)
{
if (saldoItem.IsLookUp)
{
ddsDnevnikModel.LookupID = saldoItem.Relookup;
}
if (saldoItem.Name.Contains("Дата на фактура"))
{
ddsDnevnikModel.DataF = saldoItem.ValueDate;
}
if (saldoItem.Name.Contains("Номер фактура"))
{
ddsDnevnikModel.DocId = saldoItem.Value;
}
}
}
if (ddsDnevnikModel.LookupID > 0)
{
var SelectedLookup = new ObservableCollection <ContragentInfo>();
var Lookup = Lookups.FirstOrDefault(e => e.Id == ddsDnevnikModel.LookupID);
var list = context.GetLookup(Lookup.Tablename,
1);
foreach (List <string> li in list)
{
if (li != null && li.Count > 5)
{
SelectedLookup.Add(new ContragentInfo
{
Id = int.Parse(li[1]),
Name = li[2],
Bulstad = li[4],
Nzdds = li[5]
});
}
}
if (ddsDnevnikModel.LookupElementID > 0)
{
LookupElementInfo =
SelectedLookup.FirstOrDefault(e => e.Id == ddsDnevnikModel.LookupElementID);
ddsDnevnikModel.Num = wraperConto.CurrentConto.Id;
if (LookupElementInfo != null)
{
ddsDnevnikModel.LookupElementID = LookupElementInfo.Id;
ddsDnevnikModel.Bulstat = LookupElementInfo.Bulstad;
ddsDnevnikModel.Nzdds = LookupElementInfo.Nzdds;
ddsDnevnikModel.NameKontr = LookupElementInfo.Name;
}
}
}
ddsDnevnikModel.Num = wraperConto.CurrentConto.Id;
context.SaveDdsDnevnicModel(ddsDnevnikModel, ddsDnevnikModel.IsLinked);
}
#endregion
}
}
