// GET api/values/
        public HttpResponseMessage Get(string email, string password)
        {
            try
            {

                using (SampleDbEntities entities = new SampleDbEntities())
                {

                    List<User> UsersList = entities.Users.ToList<User>();
                    User loginUser = UsersList.Where(u => u.Email == email && u.Password == password).FirstOrDefault();
                    if (loginUser == null)
                    {
                        return Request.CreateResponse(HttpStatusCode.InternalServerError, "Username or password is incorrect");
                    }
                    else if (loginUser.Active.Trim() == "y")
                    {
                        return Request.CreateResponse(HttpStatusCode.OK, "Success-" + loginUser.Username);
                    }
                    else
                    {
                        return Request.CreateResponse(HttpStatusCode.InternalServerError, "Please confirm your email. ");
                    }

                }
            }
            catch (Exception ex)
            {
                return Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message);
            }
        }
        // GET api/values
        public string Get(int userid)
        {
            using (SampleDbEntities entities = new SampleDbEntities())
            {
                User activateUser = entities.Users.Where(a => a.Id == userid).FirstOrDefault();
                if(activateUser != null)
                {
                    activateUser.Active = "y";
                    entities.SaveChanges();
                }
            }

            return string.Empty;
        }
        // POST api/values
        public HttpResponseMessage Post(User value)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    using (SampleDbEntities entities = new SampleDbEntities())
                    {
                        if (CheckForUsernameAlreadyExists(value, entities))
                        {
                            string error = string.Format("User with {0} username already exist", value.Username);
                            return Request.CreateResponse(HttpStatusCode.InternalServerError, error);
                        }
                        else if (CheckForEmailAlreadyExists(value, entities))
                        {
                            string error = string.Format("User with {0} email already exist", value.Email);
                            return Request.CreateResponse(HttpStatusCode.InternalServerError, error);
                        }
                        else
                        {
                            value.Active = "n";
                            entities.Users.Add(value);
                            entities.SaveChanges();
                            SendActiveLinkToUser(value);
                            return Request.CreateResponse(HttpStatusCode.OK, "Success");

                        }
                    }
                }
                else
                {
                    return Request.CreateResponse(HttpStatusCode.InternalServerError, "Model state is invalid");
                }
            }
            catch (Exception)
            {
                return Request.CreateResponse(HttpStatusCode.InternalServerError, "Some error occrued in registration" );
            }
        }
        private bool CheckForUsernameAlreadyExists(User user, SampleDbEntities entities)
        {
            bool isExists = false;
            try
            {
                List<User> UsersList = entities.Users.ToList<User>();
                User loginUser = UsersList.Where(u => u.Username == user.Username).FirstOrDefault();

                if (loginUser == null)
                    isExists = false;
                else
                    isExists = true;

            }
            catch (Exception)
            {
                isExists = true;
            }

            return isExists;
        }