public ActionResult Save(string name, string address, string nopoint) { var db = new PeopleDb(@"Data Source=.\sqlexpress;Initial Catalog=Food;Integrated Security=True"); Customer c = new Customer(); c.Name = name; c.Address = address; db.Add(c); return RedirectToAction("Index"); }
public ActionResult Edit(string name, string address, int customerId) { var db = new PeopleDb(@"Data Source=.\sqlexpress;Initial Catalog=Food;Integrated Security=True"); Customer c = new Customer(); c.Name = name; c.Address = address; c.Id = customerId; db.Update(c); return RedirectToAction("Index"); }
public void Add(Customer c) { using (var sqlConnection = new SqlConnection(_connectionString)) using (var cmd = sqlConnection.CreateCommand()) { cmd.CommandText = "INSERT INTO Customers VALUES (@name, @address)"; cmd.Parameters.AddWithValue("@name", c.Name); cmd.Parameters.AddWithValue("@address", c.Address); sqlConnection.Open(); cmd.ExecuteNonQuery(); } }
public void Update(Customer c) { using (var sqlConnection = new SqlConnection(_connectionString)) using (var cmd = sqlConnection.CreateCommand()) { cmd.CommandText = "UPDATE Customers SET name = @name, address = @address WHERE Id = @id"; cmd.Parameters.AddWithValue("@name", c.Name); cmd.Parameters.AddWithValue("@address", c.Address); cmd.Parameters.AddWithValue("@id", c.Id); sqlConnection.Open(); cmd.ExecuteNonQuery(); } }
public Customer FindById(int id) { using (var sqlConnection = new SqlConnection(_connectionString)) using (var cmd = sqlConnection.CreateCommand()) { cmd.CommandText = "SELECT * FROM Customers WHERE Id = @id"; cmd.Parameters.AddWithValue("@id", id); sqlConnection.Open(); var reader = cmd.ExecuteReader(); reader.Read(); Customer c = new Customer(); c.Id = (int)reader["Id"]; c.Name = (string)reader["Name"]; c.Address = (string)reader["Address"]; return c; } }
public IEnumerable<Customer> GetAll() { List<Customer> result = new List<Customer>(); using (var sqlConnection = new SqlConnection(_connectionString)) using (var cmd = sqlConnection.CreateCommand()) { cmd.CommandText = "SELECT * FROM Customers"; sqlConnection.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { Customer c = new Customer(); c.Id = (int)reader["Id"]; c.Name = (string)reader["Name"]; c.Address = (string)reader["Address"]; result.Add(c); } } return result; }