private void Clear()
{
GrupaKart = null;
DefCeny = null;
LstCennik.Clear();
LstCennikHist.Clear();
}
private void GetCenyGrKart(int id_defceny, int idGrKart)
{
if (_defceny.ODNETTO == 1)
{
ReadonlyNetto = false;
ReadonlyBrutto = true;
}
if (_defceny.ODNETTO == 0)
{
ReadonlyNetto = true;
ReadonlyBrutto = false;
}
var query =
from a in Context.IHP_CENNIK
join k in Context.IHP_KARTOTEKA on a.ID_IHP_KARTOTEKA equals k.ID_IHP_KARTOTEKA
join s in Context.IHP_STAWKAVAT on k.ID_IHP_STAWKAVAT equals s.ID_IHP_STAWKAVAT
where (a.ID_IHP_DEFCENY == id_defceny)
select new
{
a.ID_IHP_CENNIK,
a.ID_IHP_DEFCENY,
a.ID_IHP_KARTOTEKA,
a.CENAN,
a.CENAB,
k.NAZWASKR,
k.INDEKS,
s.WARTOSC
};
LstCennik.Clear();
_lstItem.Clear();
_lstItem = Context.IHP_CENNIK.Where(x => x.ID_IHP_DEFCENY == id_defceny).ToList();
foreach (var item in query)
{
CennikView cc = new CennikView()
{
ID_IHP_CENNIK = item.ID_IHP_CENNIK,
NAZWASKR = item.NAZWASKR,
INDEKS = item.INDEKS,
CENAN = item.CENAN,
CENAB = item.CENAB,
ID_IHP_KARTOTEKA = item.ID_IHP_KARTOTEKA,
ID_IHP_DEFCENY = item.ID_IHP_DEFCENY,
VAT = item.WARTOSC
};
LstCennik.Add(cc);
}
RisePropertyChanged("LstCennik");
}
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;
}
}
