Exemplo n.º 1
0
        public string GetValidToken(long GuestID, string lang)
        {
            //var token = new ObjectParameter("ReturnToken", typeof(string));

            using (var db = new InnermetrixDBEntities())
            {
                DateTime cutOffDateTime = DateTime.Now.Subtract(TimeSpan.FromHours(1));
                var      data           = db.Tokens.Where(
                    r =>
                    (r.IsUsed ?? false) == false &&
                    ((r.IsLocked ?? false) == false || ((r.IsLocked ?? false) == true && r.DateLocked > cutOffDateTime)) &&
                    (r.IsArchived ?? false == false
                    ))
                                          .First();

                data.GuestId    = GuestID;
                data.IsLocked   = true;
                data.DateLocked = DateTime.Now;
                data.Lang       = lang;

                db.SaveChanges();
                return(data.Token1.ToString());
            }
        }