private void Zaczytaj() { int autonumercennik = Context.IHP_NUMERACJA.FirstOrDefault(x => x.ID_TABELA == 3).NUMER; string LastMessage; try { var listKartotek = Context.IHP_KARTOTEKA.ToList(); _lstItem.Clear(); foreach (IHP_KARTOTEKA item in listKartotek) { if (!LstCennik.Any(x => x.ID_IHP_KARTOTEKA == item.ID_IHP_KARTOTEKA && x.ID_IHP_DEFCENY == _defceny.ID_IHP_DEFCENY)) { autonumercennik++; IHP_CENNIK cena = new IHP_CENNIK() { ID_IHP_CENNIK = autonumercennik, ID_IHP_KARTOTEKA = item.ID_IHP_KARTOTEKA, ID_IHP_DEFCENY = _defceny.ID_IHP_DEFCENY, CENAN = 0, CENAB = 0, IHP_KARTOTEKA = item, IHP_DEFCENY = _defceny }; _lstItem.Add(cena); } } Context.IHP_NUMERACJA.FirstOrDefault(x => x.ID_TABELA == 3).NUMER = autonumercennik; Context.IHP_CENNIK.AddRange(_lstItem); Context.SaveChanges(); GetCeny(_defceny.ID_IHP_DEFCENY); } catch (Exception ex) { LastMessage = ex.ToString(); if (LastMessage == String.Empty) { LastMessage = ex.InnerException.ToString(); } LogManager.WriteLogMessage(LogManager.LogType.Error, LastMessage); throw ex; } }
private void Item_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e) { decimal cenaold = 0; string LastMessage; try { CennikView row = (CennikView)sender; if (_oldrow != null) { if (_oldrow.ID_IHP_CENNIK == row.ID_IHP_CENNIK) { { //if (_defceny.ODNETTO == 1) //{ // if (_oldrow.CENAB == row.CENAB)&& (_oldrow.CENAN == row.CENAB)) // return; //} //if (_defceny.ODNETTO == 0) //{ if ((_oldrow.CENAN == row.CENAN) && (_oldrow.CENAB == row.CENAB)) { return; } } } } decimal Cenanetto = row.CENAN; int vat = row.VAT; decimal wartvat = 0; decimal vatvalue = 0m; decimal Cenabrutto = row.CENAB; if (vat > 0) { if (_defceny.ODNETTO == 1) { wartvat = (Cenanetto * vat) / 100; Cenabrutto = Cenanetto + wartvat; Cenabrutto = Math.Round(Cenabrutto, 2); _oldrow = new CennikView() { ID_IHP_CENNIK = row.ID_IHP_CENNIK, CENAB = Cenabrutto, CENAN = Cenanetto }; _lstcennik.FirstOrDefault(x => x.ID_IHP_CENNIK == row.ID_IHP_CENNIK).CENAB = Cenabrutto; } if (_defceny.ODNETTO == 0) { vatvalue = (Convert.ToDecimal(vat) / 100); vatvalue = 1 + vatvalue; Cenanetto = Cenabrutto / vatvalue; Cenanetto = Math.Round(Cenanetto, 2); wartvat = Cenabrutto - Cenanetto; _oldrow = new CennikView() { ID_IHP_CENNIK = row.ID_IHP_CENNIK, CENAN = Cenanetto, CENAB = Cenabrutto }; _lstcennik.FirstOrDefault(x => x.ID_IHP_CENNIK == row.ID_IHP_CENNIK).CENAN = Cenanetto; } } else { Cenabrutto = Cenanetto; } IHP_CENNIK cena = Context.IHP_CENNIK.Where(x => x.ID_IHP_CENNIK == row.ID_IHP_CENNIK).SingleOrDefault(); //wysylamy w eter if (cena != null) { _lstItem.FirstOrDefault(x => x.ID_IHP_CENNIK == row.ID_IHP_CENNIK).CENAN = Cenanetto; _lstItem.FirstOrDefault(x => x.ID_IHP_CENNIK == row.ID_IHP_CENNIK).CENAB = Cenabrutto; Messenger.Default.Send <List <IHP_CENNIK> >(_lstItem); } //zapisuejmy do bazy if (cena != null) { cena.CENAB = row.CENAB; cena.CENAN = row.CENAN; DodajHistoria(row.CENAN); Context.IHP_CENNIK.Attach(cena); Context.Entry(cena).State = EntityState.Modified; Context.SaveChanges(); LoadCollectionHist(); } } catch (Exception ex) { LastMessage = ex.ToString(); LogManager.WriteLogMessage(LogManager.LogType.Error, LastMessage); throw ex; } }