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 UpdateSV([FromBody] int userid, [FromBody] MAIL mailData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
int mailid = mailData.ID;
var mail = ctx.MAILs.Where(x => x.IDUser == userid && x.ID == mailid).FirstOrDefault();
if (mail == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
// Check status
if (mail.ViewStatus == 1 && mail.Status == 0)
{
mail.EmailTo = mailData.EmailTo;
mail.Subject = mailData.Subject;
mail.Letter = mailData.Letter;
mail.DeliverOn = mailData.DeliverOn;
int affected = ctx.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, affected));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
}
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 deleteMail([FromBody] MAIL mail)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var rs = ctx.MAILs.Where(x => x.IDUser == mail.IDUser && x.ID == mail.ID).FirstOrDefault();
if (rs == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
ctx.MAILs.Remove(rs);
int affected = ctx.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, affected));
}
}
