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 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));
}
}
}
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 void CacheItemRemoved(string k, object v, CacheItemRemovedReason r)
{
// do stuff here if it matches our taskname, like WebRequest
// re-add our task so it recurs
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
try
{
DateTime now = DateTime.Now.Date;
var ListMailsNotSend = ctx.MAILs.Where(x => x.Status == 0 && DbFunctions.TruncateTime(x.DeliverOn) == now).ToList();
if (ListMailsNotSend == null)
{
return;
}
SmtpClient mySmtpClient = new SmtpClient();
MailAddress from = new MailAddress("*****@*****.**", "Send2Future");
foreach(MAIL mail in ListMailsNotSend)
{
int status = mail.Status; // = 0
try
{
MailMessage email = new MailMessage();
email.From = from;
email.To.Add(mail.EmailTo.Trim());
email.Subject = mail.Subject.Trim();
email.SubjectEncoding = System.Text.Encoding.UTF8;
// set body-message and encoding
email.Body = mail.Letter.Trim();
email.BodyEncoding = System.Text.Encoding.UTF8;
// text or html
email.IsBodyHtml = true;
mySmtpClient.Send(email);
status = 1; // send
}
catch (SmtpException ex)
{
status = 3; // send error
//throw new ApplicationException("SmtpException has occured: " + ex.Message);
}
mail.Status = status;
int affected = ctx.SaveChanges();
}
}
catch (Exception ex)
{
//throw ex;
}
}
AddTask(k, Convert.ToInt32(v));
}
public HttpResponseMessage getUserId([FromBody] USER user)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var id = ctx.USERS.Where(x => x.Email == user.Email).FirstOrDefault().ID;
if (user == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
return(Request.CreateResponse(HttpStatusCode.OK, id));
}
}
public HttpResponseMessage signIn([FromBody] USER userData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var user = ctx.USERS.Where(x => x.Email == userData.Email && x.Password == userData.Password).FirstOrDefault();
if (user == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
var returnUser = new USER();
returnUser.Email = user.Email;
returnUser.ID = user.ID;
return(Request.CreateResponse(HttpStatusCode.OK, returnUser));
}
}
public HttpResponseMessage updatePassword([FromBody] USER UserData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var user = ctx.USERS.Where(x => x.ID == UserData.ID).FirstOrDefault();
if (user == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
user.Password = UserData.Password;
int affected = ctx.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, affected));
}
}
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);
}
}
public HttpResponseMessage googleSignIn([FromBody] USER userData)
{
var request = (HttpWebRequest)WebRequest.Create("https://www.googleapis.com/oauth2/v3/tokeninfo?id_token=" + userData.Password);
try
{
using (WebResponse response = request.GetResponse())
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
if (userData == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
var user = ctx.USERS.Where(x => x.Email == userData.Email).FirstOrDefault();
if (user == null)
{
try
{
USER u = new USER();
u.Email = userData.Email;
u.Password = userData.Password.Substring(0, 16);
ctx.USERS.Add(u);
ctx.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, e));
}
}
else
{
var returnUser = new USER();
returnUser.Email = user.Email;
returnUser.ID = user.ID;
return(Request.CreateResponse(HttpStatusCode.OK, returnUser));
}
}
}
}
catch (WebException e)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, e));
}
}
public HttpResponseMessage GetAll([FromBody] USER userEmail)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var user = ctx.USERS.Where(x => x.Email == userEmail.Email).FirstOrDefault();
if (user == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
var list = ctx.MAILs.Where(x => x.IDUser == user.ID).ToList();
for (int i = 0; i < list.Count; i++)
{
list[i].USER = null;
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
}
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));
}
}
public HttpResponseMessage addUser([FromBody] USER UserData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
try
{
USER user = new USER();
user.Email = UserData.Email;
user.Password = UserData.Password;
ctx.USERS.Add(user);
ctx.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, e));
}
}
}
public HttpResponseMessage addUser([FromBody] USER UserData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
try
{
USER user = new USER();
user.Email = UserData.Email;
user.Password = UserData.Password;
ctx.USERS.Add(user);
ctx.SaveChanges();
return Request.CreateResponse(HttpStatusCode.OK);
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
}
}
public HttpResponseMessage GetAll([FromBody] USER userEmail)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var user = ctx.USERS.Where(x => x.Email == userEmail.Email).FirstOrDefault();
if (user == null)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
var list = ctx.MAILs.Where(x => x.IDUser == user.ID).ToList();
for (int i = 0; i < list.Count; i++ )
{
list[i].USER = null;
}
return Request.CreateResponse(HttpStatusCode.OK, list);
}
}
public HttpResponseMessage getUserId([FromBody] USER user)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var id = ctx.USERS.Where(x => x.Email == user.Email).FirstOrDefault().ID;
if (user == null)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
return Request.CreateResponse(HttpStatusCode.OK, id);
}
}
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 updatePassword([FromBody] USER UserData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var user = ctx.USERS.Where(x => x.ID == UserData.ID).FirstOrDefault();
if (user == null)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
user.Password = UserData.Password;
int affected = ctx.SaveChanges();
return Request.CreateResponse(HttpStatusCode.OK, affected);
}
}
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);
}
}
}
public HttpResponseMessage signIn([FromBody] USER userData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var user = ctx.USERS.Where(x => x.Email == userData.Email && x.Password == userData.Password).FirstOrDefault();
if (user == null)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
var returnUser = new USER();
returnUser.Email = user.Email;
returnUser.ID = user.ID;
return Request.CreateResponse(HttpStatusCode.OK, returnUser);
}
}
public HttpResponseMessage googleSignIn([FromBody] USER userData)
{
var request = (HttpWebRequest)WebRequest.Create("https://www.googleapis.com/oauth2/v3/tokeninfo?id_token=" + userData.Password);
try
{
using (WebResponse response = request.GetResponse())
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
if (userData == null)
return Request.CreateResponse(HttpStatusCode.BadRequest);
var user = ctx.USERS.Where(x => x.Email == userData.Email).FirstOrDefault();
if (user == null)
{
try
{
USER u = new USER();
u.Email = userData.Email;
u.Password = userData.Password.Substring(0, 16);
ctx.USERS.Add(u);
ctx.SaveChanges();
return Request.CreateResponse(HttpStatusCode.OK);
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
}
else
{
var returnUser = new USER();
returnUser.Email = user.Email;
returnUser.ID = user.ID;
return Request.CreateResponse(HttpStatusCode.OK, returnUser);
}
}
}
}
catch (WebException e)
{
return Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
}
