Пример #1
0
        public bool registerAdmin()
        {
            LogInInfo newInfo = new LogInInfo
            {
                ID        = 10,
                Username  = "******",
                Password  = "******",
                Type      = 1,
                IsBlocked = 0
            };

            PsDbContex db = new PsDbContex();

            db.LogInfos.Add(newInfo);
            db.SaveChanges();

            string           _username = "******";
            List <LogInInfo> logs;

            try
            {
                var res = from info in db.LogInfos
                          where info.Username == _username
                          select info;
                logs = res.ToList();
            }
            catch (Exception)
            {
                return(false);
            }

            if (logs.Count != 1)
            {
                return(false);
            }

            User newUser = new User
            {
                ID           = 10,
                UserId       = logs[0].ID,
                Email        = "*****@*****.**",
                Mobile       = "01674646624",
                CarModel     = "Toyota Premio 2017",
                LicensNumber = "KA-1234"
            };

            db.Users.Add(newUser);
            db.SaveChanges();

            return(true);
        }
Пример #2
0
        public int PlaceChk()
        {
            PlaceReview rev = new PlaceReview()
            {
                CarUserId = 2,
                Time      = DateTime.Today.Date,
                ToPlaceId = 7,
                Rating    = 5,
                Comment   = "OK"
            };
            PsDbContex db = new PsDbContex();
            var        x  = db.PlaceReviews.Add(rev);

            db.SaveChanges();
            return(x.ID);
        }
Пример #3
0
        public bool blockUser(int userId)
        {
            // Caution: Update May Not Work..
            PsDbContex db = new PsDbContex();

            LogInInfo el = db.LogInfos.SingleOrDefault(r => r.ID == userId);

            if (el == null)
            {
                return(false);
            }

            el.IsBlocked = 1;
            db.SaveChanges();

            return(true);
        }