// PUT api/Email/5
public IHttpActionResult PutEmailCorrespondence(int id, EmailCorrespondence emailcorrespondence)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != emailcorrespondence.Reg_ID)
{
return BadRequest();
}
db.Entry(emailcorrespondence).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmailCorrespondenceExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
public string GetEmailCorrespondence(string query, string para1,string para2, string para3, string para4,string para5)
{
if (query == "sendemail")
{
var row = from m in db.Event_Symposium_Email_Template
where m.Name == "submission"
select new { m.EmailFrom, m.EmailFromName, m.EmailCc, m.EmailBcc, m.EmailSubject, m.EmailBody };
foreach (var c in row)
{
var emailbody = c.EmailBody;
StringBuilder builder = new StringBuilder(emailbody);
builder.Replace("[[StudentFirstName]]", para2).Replace("[[StudentLastName]]", para3);
string emailBody = builder.ToString();
SendEmail(c.EmailFrom, c.EmailFromName, para1, c.EmailCc, "", c.EmailSubject, emailBody, false); // c.EmailBcc
return "emailsent";
}
return "emailsent";
}
else if (query == "sendemail1")
{
var row = from m in db.Event_Symposium_Email_Template
where m.Name == "applicationapproved"
select new { m.EmailFrom, m.EmailFromName, m.EmailCc, m.EmailBcc, m.EmailSubject, m.EmailBody };
foreach (var c in row)
{
var emailbody = c.EmailBody;
StringBuilder builder = new StringBuilder(emailbody);
builder.Replace("[[StudentFirstName]]", para2).Replace("[[StudentLastName]]", para3).Replace("[[ApplicationTitle]]", para4);
string emailBody = builder.ToString();
SendEmail(c.EmailFrom, c.EmailFromName, para1, c.EmailCc, "", c.EmailSubject, emailBody, false); // c.EmailBcc
return "emailsent1";
}
}
else if (query == "sendemail2")
{
var row = from m in db.Event_Symposium_Email_Template
where m.Name == "applicationdeclined"
select new { m.EmailFrom, m.EmailFromName, m.EmailCc, m.EmailBcc, m.EmailSubject, m.EmailBody };
foreach (var c in row)
{
var emailbody = c.EmailBody;
StringBuilder builder = new StringBuilder(emailbody);
builder.Replace("[[StudentFirstName]]", para2).Replace("[[StudentLastName]]", para3).Replace("[[ApplicationTitle]]", para4); ;
string emailBody = builder.ToString();
SendEmail(c.EmailFrom, c.EmailFromName, para1, c.EmailCc, "", c.EmailSubject, emailBody, false); // c.EmailBcc
return "emailsent2";
}
}
else if (query == "insertrecord")
{
EmailCorrespondence temp=new EmailCorrespondence();
temp.Ev_ID = Convert.ToInt32(para1);
temp.Reg_ID = Convert.ToInt32(para2);
temp.EmailTo = para3;
temp.EmailBcc = "[email protected];[email protected]";
temp.EmailSubject = "Annenberg Symposium Abstract Submission Confirmation";
temp.EmailBody = para4;
temp.dtDate = DateTime.Parse(para5);
PostEmailCorrespondence(temp);
return "recordinserted";
}
return "unsolved";
}
public IHttpActionResult PostEmailCorrespondence(EmailCorrespondence emailcorrespondence)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
db.EmailCorrespondences.Add(emailcorrespondence);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (EmailCorrespondenceExists(emailcorrespondence.Reg_ID))
{
return Conflict();
}
else
{
throw;
}
}
return CreatedAtRoute("DefaultApi", new { id = emailcorrespondence.Reg_ID }, emailcorrespondence);
}