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;
}
