protected override void Save() { int sortorder = 0; foreach (var currentsaldos in Items) { int key = 0; if (!int.TryParse(currentsaldos.Key, out key)) { key = 0; } var saldo = new SaldoAnaliticModel(); saldo.ACCFIELDKEY = currentsaldos.Fieldkey; saldo.ACCID = AccID; saldo.DATA = DateTime.Now; saldo.SORTORDER = sortorder; sortorder++; int test; if (int.TryParse(currentsaldos.Key, out test)) { saldo.LOOKUPFIELDKEY = test; } saldo.TYPEACCKEY = typeAnaliticalKey; saldo.VALUEDATE = currentsaldos.ValueDate; if (currentsaldos.Type == SaldoItemTypes.Date) { if (string.IsNullOrWhiteSpace(currentsaldos.Value)) { currentsaldos.Value = currentsaldos.ValueDate.ToShortDateString(); } } saldo.VAL = currentsaldos.Value; saldo.VALS = currentsaldos.Lookupval; saldo.VALUENUM = currentsaldos.ValueInt; saldo.GROUP = this.GroupId; if (currentsaldos.IsDK) { saldo.VALKOLD = currentsaldos.Fieldkey == 31 ? currentsaldos.ValueDebit : 0; saldo.VALKOLK = currentsaldos.Fieldkey == 31 ? currentsaldos.ValueCredit : 0; saldo.VALVALK = currentsaldos.Fieldkey == 30 ? currentsaldos.ValueDebit : 0; saldo.VALVALD = currentsaldos.Fieldkey == 30 ? currentsaldos.ValueCredit : 0; saldo.VALUEMONEY = currentsaldos.Fieldkey == 29? currentsaldos.ValueCredit:0; saldo.VALUED = currentsaldos.Fieldkey == 29?currentsaldos.ValueDebit:0; } saldo.LOOKUPID = currentsaldos.Relookup; Context.SaveMovement(saldo); } }
protected override void Update() { foreach (var currentsaldos in Items) { if (!currentsaldos.IsDK) { continue; } var ni = new SaldoAnaliticModel { ACCFIELDKEY = currentsaldos.Fieldkey, ACCID = AccID, DATA = DateTime.Now, LOOKUPFIELDKEY = string.IsNullOrWhiteSpace(currentsaldos.Key) ? 0 : int.Parse(currentsaldos.Key), TYPEACCKEY = typeAnaliticalKey, VALUEDATE = currentsaldos.ValueDate, VAL = currentsaldos.Value, VALUEMONEY = 0, VALUENUM = currentsaldos.ValueInt, VALUED = 0, GROUP = this.GroupId, VALKOLD = 0, VALKOLK = 0, VALVALD = 0, VALVALK = 0, LOOKUPID = currentsaldos.Relookup, VALS = currentsaldos.Vals, }; if (currentsaldos.Fieldkey == 31) { ni.VALKOLD = currentsaldos.ValueDebit; ni.VALKOLK = currentsaldos.ValueCredit; } if (currentsaldos.Fieldkey == 30) { ni.VALVALD = currentsaldos.ValueDebit; ni.VALVALK = currentsaldos.ValueCredit; } if (currentsaldos.Fieldkey == 29) { ni.VALUED = currentsaldos.ValueDebit; ni.VALUEMONEY = currentsaldos.ValueCredit; } Context.UpdateMovement(ni); } }
public static void UpdateContoMovement(SaldoAnaliticModel saldoAnaliticModel) { var dbman = new DBManager(DataProvider.Firebird); dbman.ConnectionString = Entrence.ConnectionString; try { dbman.Open(); dbman.BeginTransaction(); dbman.CreateParameters(19); dbman.AddParameters(0, "@ACCID", saldoAnaliticModel.ACCID); dbman.AddParameters(1, "@ACCFIELDKEY", saldoAnaliticModel.ACCFIELDKEY); dbman.AddParameters(2, "@LOOKUPFIELDKEY", saldoAnaliticModel.LOOKUPFIELDKEY); dbman.AddParameters(3, "@VAL", saldoAnaliticModel.VAL); dbman.AddParameters(4, "@VALUEDATE", saldoAnaliticModel.VALUEDATE); dbman.AddParameters(5, "@VALUEMONEY", saldoAnaliticModel.VALUEMONEY); dbman.AddParameters(6, "@VALUENUM", saldoAnaliticModel.VALUENUM); dbman.AddParameters(7, "@TYPEACCKEY", saldoAnaliticModel.TYPEACCKEY); dbman.AddParameters(8, "@VALUED", saldoAnaliticModel.VALUED); dbman.AddParameters(9, "@LOOKUPID", saldoAnaliticModel.LOOKUPID); dbman.AddParameters(10, "@CONTOID", saldoAnaliticModel.CONTOID); dbman.AddParameters(11, "@TYPE", saldoAnaliticModel.TYPE); dbman.AddParameters(12, "@ID", saldoAnaliticModel.ID); dbman.AddParameters(13, "@KURS", saldoAnaliticModel.KURS); dbman.AddParameters(14, "@KURSD", saldoAnaliticModel.KURSD); dbman.AddParameters(15, "@KURSM", saldoAnaliticModel.KURSM); dbman.AddParameters(16, "@VALVAL", saldoAnaliticModel.VALVAL); dbman.AddParameters(17, "@LOOKUPVAL", saldoAnaliticModel.LOOKUPVAL); dbman.AddParameters(18, "@SORTORDER", saldoAnaliticModel.SORTORDER); dbman.ExecuteNonQuery(CommandType.StoredProcedure, "UPDATEMOVENTCONTO"); dbman.CommitTransaction(); } catch (Exception ex) { Logger.Instance().WriteLogError(ex.Message, "UpdateContoMovement"); dbman.RollBackTransaction(); } finally { dbman.Dispose(); } }
public static bool CheckMovement(SaldoAnaliticModel saldoAnaliticModel) { var dbman = new DBManager(DataProvider.Firebird); dbman.ConnectionString = Entrence.ConnectionString; bool result = true; try { dbman.Open(); dbman.BeginTransaction(); dbman.CreateParameters(11); dbman.AddParameters(0, "@ACCID", saldoAnaliticModel.ACCID); dbman.AddParameters(1, "@ACCFIELDKEY", saldoAnaliticModel.ACCFIELDKEY); dbman.AddParameters(2, "@LOOKUPFIELDKEY", saldoAnaliticModel.LOOKUPFIELDKEY); dbman.AddParameters(3, "@VAL", saldoAnaliticModel.VAL); dbman.AddParameters(4, "@VALUEDATE", saldoAnaliticModel.VALUEDATE); dbman.AddParameters(5, "@VALUEMONEY", saldoAnaliticModel.VALUEMONEY); dbman.AddParameters(6, "@VALUENUM", saldoAnaliticModel.VALUENUM); dbman.AddParameters(7, "@TYPEACCKEY", saldoAnaliticModel.TYPEACCKEY); dbman.AddParameters(8, "@VALUED", saldoAnaliticModel.VALUED); dbman.AddParameters(9, "@LOOKUPID", saldoAnaliticModel.LOOKUPID); dbman.AddOutputParameters(10, "@ISIN", saldoAnaliticModel.LOOKUPID); dbman.ExecuteNonQuery(CommandType.StoredProcedure, "CHECKMOVENT"); dbman.CommitTransaction(); result = (int)dbman.Parameters[10].Value == 0; } catch (Exception ex) { Logger.Instance().WriteLogError(ex.Message, "GetAllLookupsFields"); dbman.RollBackTransaction(); result = false; } finally { dbman.Dispose(); } return(result); }
private void SaveContoMovement(SaldoAnaliticModel saldoAnaliticModel) { DBManager.CreateParameters(17); DBManager.AddParameters(0, "@ACCID", saldoAnaliticModel.ACCID); DBManager.AddParameters(1, "@ACCFIELDKEY", saldoAnaliticModel.ACCFIELDKEY); DBManager.AddParameters(2, "@LOOKUPFIELDKEY", saldoAnaliticModel.LOOKUPFIELDKEY); DBManager.AddParameters(3, "@VAL", saldoAnaliticModel.VAL); DBManager.AddParameters(4, "@VALUEDATE", saldoAnaliticModel.VALUEDATE); DBManager.AddParameters(5, "@VALUEMONEY", saldoAnaliticModel.VALUEMONEY); DBManager.AddParameters(6, "@VALUENUM", saldoAnaliticModel.VALUENUM); DBManager.AddParameters(7, "@TYPEACCKEY", saldoAnaliticModel.TYPEACCKEY); DBManager.AddParameters(8, "@VALUED", saldoAnaliticModel.VALUED); DBManager.AddParameters(9, "@LOOKUPID", saldoAnaliticModel.LOOKUPID); DBManager.AddParameters(10, "@CONTOID", saldoAnaliticModel.CONTOID); DBManager.AddParameters(11, "@TYPE", saldoAnaliticModel.TYPE); DBManager.AddParameters(12, "@KURS", saldoAnaliticModel.KURS); DBManager.AddParameters(13, "@KURSD", saldoAnaliticModel.KURSD); DBManager.AddParameters(14, "@KURSM", saldoAnaliticModel.KURSM); DBManager.AddParameters(15, "@VALVAL", saldoAnaliticModel.VALVAL); DBManager.AddParameters(16, "@LOOKUPVAL", saldoAnaliticModel.LOOKUPVAL); DBManager.ExecuteNonQuery(CommandType.StoredProcedure, "ADDMOVENTCONTO"); }
public static void SaveContoMovementWithNo(SaldoAnaliticModel saldoAnaliticModel, DBManager dbman) { dbman.CreateParameters(18); dbman.AddParameters(0, "@ACCID", saldoAnaliticModel.ACCID); dbman.AddParameters(1, "@ACCFIELDKEY", saldoAnaliticModel.ACCFIELDKEY); dbman.AddParameters(2, "@LOOKUPFIELDKEY", saldoAnaliticModel.LOOKUPFIELDKEY); dbman.AddParameters(3, "@VAL", saldoAnaliticModel.VAL); dbman.AddParameters(4, "@VALUEDATE", saldoAnaliticModel.VALUEDATE); dbman.AddParameters(5, "@VALUEMONEY", saldoAnaliticModel.VALUEMONEY); dbman.AddParameters(6, "@VALUENUM", saldoAnaliticModel.VALUENUM); dbman.AddParameters(7, "@TYPEACCKEY", saldoAnaliticModel.TYPEACCKEY); dbman.AddParameters(8, "@VALUED", saldoAnaliticModel.VALUED); dbman.AddParameters(9, "@LOOKUPID", saldoAnaliticModel.LOOKUPID); dbman.AddParameters(10, "@CONTOID", saldoAnaliticModel.CONTOID); dbman.AddParameters(11, "@TYPE", saldoAnaliticModel.TYPE); dbman.AddParameters(12, "@KURS", saldoAnaliticModel.KURS); dbman.AddParameters(13, "@KURSD", saldoAnaliticModel.KURSD); dbman.AddParameters(14, "@KURSM", saldoAnaliticModel.KURSM); dbman.AddParameters(15, "@VALVAL", saldoAnaliticModel.VALVAL); dbman.AddParameters(16, "@LOOKUPVAL", saldoAnaliticModel.LOOKUPVAL); dbman.AddParameters(17, "@SORTORDER", saldoAnaliticModel.SORTORDER); dbman.ExecuteNonQuery(CommandType.StoredProcedure, "ADDMOVENTCONTO"); }
private void SaveConto(WrapConto CurrentConto) { CurrentConto.Conto.CDetails = ""; CurrentConto.Conto.DDetails = ""; foreach (SaldoItem currentsaldos in CurrentConto.ItemsCredits) { if (currentsaldos.Fieldkey == 30) { CurrentConto.Conto.OborotValutaK = currentsaldos.Valuedecimal; } if (currentsaldos.Fieldkey == 31) { CurrentConto.Conto.OborotKolK = currentsaldos.Valuedecimal; } CurrentConto.Conto.CDetails += string.Format("{0} - {1} {2}\n", currentsaldos.Name, currentsaldos.Value, currentsaldos.Lookupval); } foreach (SaldoItem currentsaldos in CurrentConto.ItemsDebits) { if (currentsaldos.Fieldkey == 30) { CurrentConto.Conto.OborotValutaD = currentsaldos.Valuedecimal; } if (currentsaldos.Fieldkey == 31) { CurrentConto.Conto.OborotKolD = currentsaldos.Valuedecimal; } CurrentConto.Conto.DDetails += string.Format("{0} - {1} {2}\n", currentsaldos.Name, currentsaldos.Value, currentsaldos.Lookupval); } SaveContoLocal(CurrentConto.Conto); if (CurrentConto.Conto.Id == 0) { return; } if (CurrentConto.ItemsCredits != null) { foreach (SaldoItem currentsaldos in CurrentConto.ItemsCredits) { SaldoAnaliticModel sa = new SaldoAnaliticModel(); sa.ACCFIELDKEY = currentsaldos.Fieldkey; sa.ACCID = CurrentConto.Conto.CreditAccount; sa.DATA = DateTime.Now; //if (currentsaldos.SelectedLookupItem != null && !string.IsNullOrWhiteSpace(currentsaldos.SelectedLookupItem.Key)) //{ // if (currentsaldos.SelectedLookupItem.Key != null) // { // int rez; // sa.LOOKUPFIELDKEY = int.TryParse(currentsaldos.SelectedLookupItem.Key,out rez)?rez:0; // sa.LOOKUPVAL = currentsaldos.SelectedLookupItem.Value; // } //} sa.LOOKUPFIELDKEY = currentsaldos.LiD; sa.LOOKUPVAL = currentsaldos.Lookupval; sa.TYPEACCKEY = 2; sa.VALUEDATE = currentsaldos.ValueDate; sa.VAL = currentsaldos.Value; sa.VALUEMONEY = currentsaldos.Valuedecimal; sa.VALUENUM = currentsaldos.ValueInt; sa.VALUED = currentsaldos.Valuedecimald; sa.KURS = currentsaldos.ValueKurs; sa.KURSM = currentsaldos.MainKurs; sa.VALVAL = currentsaldos.ValueVal; sa.KURSD = currentsaldos.KursDif; sa.TYPE = 2; sa.LOOKUPID = currentsaldos.Relookup; sa.CONTOID = CurrentConto.Conto.Id; SaveContoMovement(sa); } } if (CurrentConto.ItemsDebits != null) { foreach (SaldoItem currentsaldos in CurrentConto.ItemsDebits) { SaldoAnaliticModel sa = new SaldoAnaliticModel(); sa.ACCFIELDKEY = currentsaldos.Fieldkey; sa.ACCID = CurrentConto.Conto.DebitAccount; sa.DATA = DateTime.Now; //if (currentsaldos.SelectedLookupItem != null && !string.IsNullOrWhiteSpace(currentsaldos.SelectedLookupItem.Key)) //{ // if (currentsaldos.SelectedLookupItem.Key != null) // { // int rez; // sa.LOOKUPFIELDKEY = int.TryParse(currentsaldos.SelectedLookupItem.Key,out rez)?rez:0; // sa.LOOKUPVAL = currentsaldos.SelectedLookupItem.Value; // } //} sa.LOOKUPFIELDKEY = currentsaldos.LiD; sa.TYPEACCKEY = 1; sa.VALUEDATE = currentsaldos.ValueDate; sa.VAL = currentsaldos.Value; sa.VALUEMONEY = currentsaldos.Valuedecimal; sa.VALUENUM = currentsaldos.ValueInt; sa.VALUED = currentsaldos.Valuedecimald; sa.KURS = currentsaldos.ValueKurs; sa.KURSM = currentsaldos.MainKurs; sa.VALVAL = currentsaldos.ValueVal; sa.KURSD = currentsaldos.KursDif; sa.TYPE = 1; sa.LOOKUPID = currentsaldos.Relookup; sa.LOOKUPVAL = currentsaldos.Lookupval; sa.CONTOID = CurrentConto.Conto.Id; SaveContoMovement(sa); } } }
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 } }
private static void SaveMainConto(TempoDataBaseContext context, ContoAll allconto) { int ii = 0; List <SaldoAnaliticModel> debit = new List <SaldoAnaliticModel>(); List <SaldoAnaliticModel> credit = new List <SaldoAnaliticModel>(); if (allconto.ItemsCredit != null) { foreach (SaldoItem currentsaldos in allconto.ItemsCredit) { SaldoAnaliticModel sa = new SaldoAnaliticModel(); sa.ACCFIELDKEY = currentsaldos.Fieldkey; sa.ACCID = allconto.Conto.CreditAccount; sa.DATA = DateTime.Now; //if (currentsaldos.SelectedLookupItem != null && !string.IsNullOrWhiteSpace(currentsaldos.SelectedLookupItem.Key)) //{ // if (currentsaldos.SelectedLookupItem.Key != null) // { // int rez; // sa.LOOKUPFIELDKEY = int.TryParse(currentsaldos.SelectedLookupItem.Key,out rez)?rez:0; // sa.LOOKUPVAL = currentsaldos.SelectedLookupItem.Value; // } //} sa.LOOKUPFIELDKEY = currentsaldos.LiD; sa.LOOKUPVAL = currentsaldos.Lookupval; 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.KURSD = currentsaldos.KursDif; sa.TYPE = 2; sa.LOOKUPID = currentsaldos.Relookup; sa.CONTOID = allconto.Conto.Id; sa.SORTORDER = ii; debit.Add(sa); ii++; } } ii = 0; if (allconto.ItemsDebit != null) { foreach (SaldoItem currentsaldos in allconto.ItemsDebit) { SaldoAnaliticModel sa = new SaldoAnaliticModel(); sa.ACCFIELDKEY = currentsaldos.Fieldkey; sa.ACCID = allconto.Conto.DebitAccount; sa.DATA = DateTime.Now; sa.LOOKUPFIELDKEY = currentsaldos.LiD; 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.KURSD = currentsaldos.KursDif; sa.TYPE = 1; sa.LOOKUPID = currentsaldos.Relookup; sa.LOOKUPVAL = currentsaldos.Lookupval; sa.CONTOID = allconto.Conto.Id; sa.SORTORDER = ii; credit.Add(sa); ii++; } } context.SaveConto(allconto.Conto, debit, credit); }
public bool CheckMovement(SaldoAnaliticModel saldoAnaliticModel) { return(RealDataContext.CheckMovement(saldoAnaliticModel)); }
public void UpdateContoMovement(SaldoAnaliticModel sa) { RealDataContext.UpdateContoMovement(sa); }
public void SaveContoMovement(SaldoAnaliticModel saldoAnaliticModel) { RealDataContext.SaveContoMovement(saldoAnaliticModel); }
public virtual void UpdateMovement(SaldoAnaliticModel saldoAnaliticModel) { RealDataContext.UpdateMovement(saldoAnaliticModel); }