public IHttpActionResult PostEmailAddr(EmailAddr emailAddr)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.EmailAddrs.Add(emailAddr);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (EmailAddrExists(emailAddr.Emails))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = emailAddr.Emails }, emailAddr));
}
public IHttpActionResult PutEmailAddr(string id, EmailAddr emailAddr)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != emailAddr.Emails)
{
return(BadRequest());
}
db.Entry(emailAddr).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmailAddrExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetEmailAddr(string id)
{
EmailAddr emailAddr = db.EmailAddrs.Find(id);
if (emailAddr == null)
{
return(NotFound());
}
return(Ok(emailAddr));
}
public void DeleteEmailAddressOnPerson(ref EmailAddr emailAddr)
{
string deleteString = @"DELETE FROM EmailAddress Where (EmailID = @EmailID)";
using (SqlCommand cmd = new SqlCommand(deleteString, OpenConnection))
{
cmd.Parameters.AddWithValue("@EmailID", emailAddr.EmailID);
var count = cmd.ExecuteNonQuery();
emailAddr = null;
}
}
public HttpStatusCodeResult PostEmailAddr(EmailAddr emailAddr)
{
if (!ModelState.IsValid)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Bad Request"));
}
db.EmailAddr.Add(emailAddr);
db.SaveChanges();
return(new HttpStatusCodeResult(HttpStatusCode.OK, "OK"));
}
public void UpdateEmailAddressOnPerson(ref EmailAddr emailAddr)
{
string updateString = @" UPDATE EmailAddress
SET EmailAddress = @EmailAddress, IsPrimaryEmail = @IsPrimaryEmail
WHERE EmailID = @EmailID";
using (SqlCommand cmd = new SqlCommand(updateString, OpenConnection))
{
cmd.Parameters.AddWithValue("@EmailAddress", emailAddr.EmailAddress);
cmd.Parameters.AddWithValue("@IsPrimaryEmail", emailAddr.IsPrimaryEmail);
var count = cmd.ExecuteNonQuery();
}
}
public IHttpActionResult DeleteEmailAddr(string id)
{
EmailAddr emailAddr = db.EmailAddrs.Find(id);
if (emailAddr == null)
{
return(NotFound());
}
db.EmailAddrs.Remove(emailAddr);
db.SaveChanges();
return(Ok(emailAddr));
}
public HttpStatusCodeResult DeleteEmailAddr(int id)
{
EmailAddr emailAddr = db.EmailAddr.Find(id);
if (emailAddr == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound, "Not Found"));
}
db.EmailAddr.Remove(emailAddr);
db.SaveChanges();
return(new HttpStatusCodeResult(HttpStatusCode.OK, "OK"));
}
public void AddEmailAddressOnPerson(ref EmailAddr emailAddr)
{
string insertStringParam = @"INSERT INTO [EmailAddr] (EmailAddress, IsPrimaryEmail, PersonID)
OUTPUT INSERTED.EmailID
VALUES (@EmailAddress, @IsPrimaryEmail, @PersonID)";
using (SqlCommand cmd = new SqlCommand(insertStringParam, OpenConnection))
{
cmd.Parameters.AddWithValue("@EmailAddress", emailAddr.EmailAddress);
cmd.Parameters.AddWithValue("@IsPrimaryEmail", emailAddr.IsPrimaryEmail);
cmd.Parameters.AddWithValue("@PersonId", emailAddr.PersonID);
emailAddr.EmailID = (int)cmd.ExecuteScalar();
}
}
public List <EmailAddr> GetPersonsEmailAddrs(ref Person person)
{
string ListEmailAddys = @"SELECT * FROM [EmailAddr] WHERE ([Person] = @PersonID)";
using (var cmd = new SqlCommand(ListEmailAddys, OpenConnection))
{
SqlDataReader rdr = null;
cmd.Parameters.AddWithValue("@PersonID", person.PersonID);
rdr = cmd.ExecuteReader();
List <EmailAddr> MailAddyList = new List <EmailAddr>();
EmailAddr Emails = null;
while (rdr.Read())
{
Emails = new EmailAddr();
Emails.EmailID = (int)rdr["EmailID"];
Emails.IsPrimaryEmail = (bool)rdr["IsPrimaryEmail"];
Emails.EmailAddress = (string)rdr["EmailAddress"];
MailAddyList.Add(Emails);
}
return(MailAddyList);
}
}
