public ActionResult Opened(int?newsletterid, int?userid)
        {
            if (newsletterid == null || userid == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            NewsLetter newsLetter = db.newsletter.Find(newsletterid);
            user       user       = db.user.Find(userid);

            if (newsLetter == null || user == null)
            {
                return(HttpNotFound());
            }

            NewsLettersOpens open = new NewsLettersOpens();

            open.IdNewsletter = newsLetter;
            open.IdUser       = user;
            if (!nlos.checkopenedornot(open))
            {
                db.newsletteropens.Add(open);
                db.SaveChanges();
            }


            return(View( ));
        }
        public bool checkopenedornot(NewsLettersOpens nlo)
        {
            var query = from NewsLettersOpens in db.newsletteropens
                        where NewsLettersOpens.IdNewsletter.Id == nlo.IdNewsletter.Id & NewsLettersOpens.IdUser.id == nlo.IdUser.id
                        select NewsLettersOpens;

            if (query.Count() != 0)
            {
                return(true);
            }
            return(false);
        }