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); } }