public void EditContributor(Contributor c) { using (SqlConnection connection = new SqlConnection(_conStr)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "UPDATE Contributors SET FirstName = @firstName , LastName = @lastName," + " CellNumber = @cellNumber, DateCreated = @date, AlwaysInclude = @alwaysInclude WHERE Id = @id"; command.Parameters.AddWithValue("@id", c.Id); command.Parameters.AddWithValue("@firstName", c.FirstName); command.Parameters.AddWithValue("@lastName", c.LastName); command.Parameters.AddWithValue("@cellNumber", c.CellNumber); command.Parameters.AddWithValue("@date", c.DateCreated); command.Parameters.AddWithValue("@alwaysInclude", c.AlwaysInclude); connection.Open(); command.ExecuteNonQuery(); } }
public int AddContributor(Contributor c) { int id = 0; using (SqlConnection connection = new SqlConnection(_conStr)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "INSERT INTO Contributors (FirstName, LastName, CellNumber, DateCreated, AlwaysInclude) " + " VALUES (@firstName, @lastName, @cellNumber, @date, @alwaysInclude)"; command.Parameters.AddWithValue("@firstName", c.FirstName); command.Parameters.AddWithValue("@lastName", c.LastName); command.Parameters.AddWithValue("@cellNumber", c.CellNumber); command.Parameters.AddWithValue("@date", c.DateCreated); command.Parameters.AddWithValue("@alwaysInclude", c.AlwaysInclude); connection.Open(); command.CommandText += " SELECT @@IDENTITY"; id = (int)(decimal)command.ExecuteScalar(); } return(id); }
public Contributor GetContributor(int id) { Contributor c = new Contributor(); using (SqlConnection connection = new SqlConnection(_conStr)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "SELECT * FROM Contributors WHERE Id = @id"; command.Parameters.AddWithValue("@id", id); connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); c.Id = (int)reader["Id"]; c.FirstName = (string)reader["FirstName"]; c.LastName = (string)reader["LastName"]; c.CellNumber = (string)reader["CellNumber"]; c.DateCreated = (DateTime)reader["DateCreated"]; c.AlwaysInclude = (bool)reader["AlwaysInclude"]; } return(c); }
public List <Contributor> GetContributors() { List <Contributor> result = new List <Contributor>(); using (SqlConnection connection = new SqlConnection(_conStr)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "SELECT * FROM Contributors"; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Contributor c = new Contributor(); c.Id = (int)reader["Id"]; c.FirstName = (string)reader["FirstName"]; c.LastName = (string)reader["LastName"]; c.CellNumber = (string)reader["CellNumber"]; c.DateCreated = (DateTime)reader["DateCreated"]; c.AlwaysInclude = (bool)reader["AlwaysInclude"]; result.Add(c); } } return(result); }