private int getLastStatus(int IdPoz) { int res = 0; List <IHP_STATUSHISTORIA> stathists = context.IHP_STATUSHISTORIA.Where(x => x.ID_IHP_POZ == IdPoz).ToList(); if (stathists.Count > 0) { IHP_STATUSHISTORIA stathist = stathists.LastOrDefault(); if (stathist != null) { res = stathist.ID_IHP_DEFSTATUS; } } return(res); }
public void SaveStatus(int IdPoz, int StatusNew) { int StatusOld = getLastStatus(IdPoz); // ViewModelKafelkiOkno string LastMessage = string.Empty; try { IHP_DEFSTATUS stat = context.IHP_DEFSTATUS.First(x => x.ID_IHP_DEFSTATUS == StatusNew); IHP_POZDOK p = context.IHP_POZDOK.Find(IdPoz); if (p != null) { p.ID_IHP_DEFSTATUS = stat.ID_IHP_DEFSTATUS; context.IHP_POZDOK.Add(p); context.Entry(p).State = EntityState.Modified; context.SaveChanges(); } IHP_STATUSHISTORIA stathist = new IHP_STATUSHISTORIA() { ID_IHP_STATUSHISTORIA = GetIdStatusHist(), ID_IHP_DEFSTATUS = stat.ID_IHP_DEFSTATUS, ID_IHP_DEFSTATUSZ = StatusOld, // DATAWPISU = DateTime.Now, OPIS = stat.NAZWA, ID_IHP_POZ = IdPoz, ID_ARIT_ZAM_USERS = ProgramDataSotrage.User.ID_IHP_ZAM_USERS }; context.IHP_STATUSHISTORIA.Add(stathist); //ZamowieniaViewListaLst.FirstOrDefault(x => x.ID_POZ == _zamwoienieselected.ID_POZ).ID_DEFSTATUS = stat.ID_DEFSTATUS; //ZamowieniaViewListaLst.Where(x => x.ID_POZ == _zamwoienieselected.ID_POZ).FirstOrDefault().STATUS = stat.NAZWA; context.SaveChanges(); } catch (Exception ex) { LastMessage = ex.ToString(); LogManager.WriteLogMessage(LogManager.LogType.Error, LastMessage); throw ex; } }