public InsurancePolicy Create(InsurancePolicy item) { try { using (SqlConnection con = new SqlConnection(_connectionString)) { con.Open(); return(con.QuerySingleOrDefault <InsurancePolicy>($@"INSERT INTO [InsurancePolicy] ([PersonId], [Number], [Company]) VALUES (@{nameof(InsurancePolicy.PersonId)}, @{nameof(InsurancePolicy.Number)}, @{nameof(InsurancePolicy.Company)})", item)); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool Update(InsurancePolicy item) { try { using (SqlConnection con = new SqlConnection(_connectionString)) { con.Open(); int rowsAffected = con.Execute($@"UPDATE [InsurancePolicy] SET [Number] = @{nameof(InsurancePolicy.Number)}, [Company] = @{nameof(InsurancePolicy.Company)} WHERE [PersonId] = @{nameof(InsurancePolicy.PersonId)}", item); return(rowsAffected > 0); } } catch (Exception ex) { throw new Exception(ex.Message); } }