public HttpResponseMessage addEmail([FromBody] MailData mailData) { using (FutureMeProductEntities ctx = new FutureMeProductEntities()) { try { var id = ctx.USERS.Where(x => x.Email == mailData.userEmail).FirstOrDefault().ID; if (id == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } MAIL mail = new MAIL(); mail.IDUser = id; mail.EmailTo = mailData.EmailTo; mail.Subject = mailData.Subject; mail.Letter = mailData.Letter; mail.DeliverOn = mailData.DeliverOn; mail.Status = 0; // Store mail, not send yet mail.ViewStatus = mailData.ViewStatus; ctx.MAILs.Add(mail); ctx.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.BadRequest, e)); } } }
public HttpResponseMessage updateMail([FromBody] MailData mailData) { using (FutureMeProductEntities ctx = new FutureMeProductEntities()) { var id = ctx.USERS.Where(x => x.Email == mailData.userEmail).FirstOrDefault().ID; if (id == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } var mail = ctx.MAILs.Where(x => x.IDUser == id && x.ID == mailData.ID).FirstOrDefault(); if (mail == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } if (mail.ViewStatus == 1 && mail.Status == 0) { mail.EmailTo = mailData.EmailTo; mail.Subject = mailData.Subject; mail.Letter = mailData.Letter; mail.DeliverOn = mailData.DeliverOn; mail.ViewStatus = mailData.ViewStatus; int affected = ctx.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, affected)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } }