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); }