public bool Insert(PersonClass person) { bool issuccess = false; SqlConnection conn = new SqlConnection(connstring); SqlCommand cmd = new SqlCommand("INSERT INTO Person(FirstName, LastName, Age) VALUES (@FirstName, @LastName, @Age)", conn); cmd.Parameters.AddWithValue("@FirstName", person.FirstName); cmd.Parameters.AddWithValue("@LastName", person.LastName); cmd.Parameters.AddWithValue("@Age", person.Age); conn.Open(); int rows = cmd.ExecuteNonQuery(); conn.Close(); if (rows > 0) { issuccess = true; return(issuccess); } return(issuccess); }
public bool Update(PersonClass person) { bool issuccess = false; SqlConnection conn = new SqlConnection(connstring); SqlCommand cmd = new SqlCommand("UPDATE Person SET FirstName=@FirstName, LastName=@LastName, Age=@Age WHERE Id=@Id", conn); cmd.Parameters.AddWithValue("@Id", person.Id); cmd.Parameters.AddWithValue("@FirstName", person.FirstName); cmd.Parameters.AddWithValue("@LastName", person.LastName); cmd.Parameters.AddWithValue("@Age", person.Age); conn.Open(); int rows = cmd.ExecuteNonQuery(); conn.Close(); if (rows > 0) { issuccess = true; return(issuccess); } return(issuccess); }