예제 #1
0
        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);
        }
예제 #2
0
        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;
            }
        }