public HttpResponseMessage AddDassauGenOne(DassauGenOneDto dassauGenOne) { var repository = new DassauGenOneRepository(); var result = repository.Create(dassauGenOne); if (result) { return(Request.CreateResponse(HttpStatusCode.Created)); } return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Could not create Dassau Generation, please try again later")); }
public bool Create(DassauGenOneDto dassauGenOne) { using (var db = new SqlConnection(ConfigurationManager.ConnectionStrings["FamilyTree"].ConnectionString)) { db.Open(); var numberCreated = db.Execute(@"INSERT INTO [dbo].[DassauGenOne] ([FirstName] ,[MiddleName] ,[LastName] ,[BirthDate] ,[BirthCity] ,[BirthState]) VALUES (@FirstName ,@MiddleName ,@LastName ,@BirthDate ,@BirthCity ,@BirthState)", dassauGenOne); return(numberCreated == 1); } }