public static void SeedCustomers()
{
// Read the contents of the file
string s = File.ReadAllText("..\\..\\..\\AdaMovieStoreSample\\App_Data\\customers.json");
// Parse the contents using JSON.NET
JArray data = (JArray)JsonConvert.DeserializeObject(s);
CustomerRepository repository = new CustomerRepository();
// Process the data
foreach (JToken token in data)
{
Customer c = new Customer();
c.Name = token["name"].Value<string>();
c.RegisteredAt = token["registered_at"].Value<string>();
c.Address = token["address"].Value<string>();
c.City = token["city"].Value<string>();
c.State = token["state"].Value<string>();
c.PostalCode = token["postal_code"].Value<string>();
c.Phone = token["phone"].Value<string>();
c.AccountCredit = token["account_credit"].Value<decimal>();
repository.Add(c);
}
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
Customer movie = new Customer();
CustomerRepository r = new CustomerRepository();
r.Remove(id);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult Create(FormCollection collection)
{
try
{
Customer customer = new Customer();
customer.Name = collection.GetValue("Name").AttemptedValue.ToString();
customer.RegisteredAt = collection.GetValue("RegisteredAt").AttemptedValue.ToString();
customer.Address = collection.GetValue("Address").AttemptedValue.ToString();
customer.City= collection.GetValue("City").AttemptedValue.ToString();
customer.State = collection.GetValue("State").AttemptedValue.ToString();
customer.PostalCode = collection.GetValue("PostalCode").AttemptedValue.ToString();
customer.Phone = collection.GetValue("Phone").AttemptedValue.ToString();
customer.AccountCredit = decimal.Parse(collection.GetValue("AccountCredit").AttemptedValue.ToString());
CustomerRepository r = new CustomerRepository();
r.Add(customer);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public void Add(Customer customer)
{
db.Open();
try
{
SqlCommand command = new SqlCommand(
"insert into customers (name, registeredAt, address, city, state, postalCode, phone, accountCredit) values (@name, @registered_at, @address, @city, @state, @postal_code, @phone, @account_credit)",
this.db);
command.Parameters.AddWithValue("@name", customer.Name);
command.Parameters.AddWithValue("@registered_at", customer.RegisteredAt);
command.Parameters.AddWithValue("@address", customer.Address);
command.Parameters.AddWithValue("@city", customer.City);
command.Parameters.AddWithValue("@state", customer.State);
command.Parameters.AddWithValue("@postal_code", customer.PostalCode);
command.Parameters.AddWithValue("@phone", customer.Phone);
command.Parameters.AddWithValue("@account_credit", customer.AccountCredit);
command.ExecuteNonQuery();
}
finally
{
db.Close();
}
}
public void Update(Customer customer)
{
db.Open();
try
{
SqlCommand command = new SqlCommand(
"update customers set name=@name, registeredAt=@registered_at, address=@address, city=@city, state=@state, postalCode=@postal_code, phone=@phone, accountCredit=@account_credit where id=@id",
this.db);
command.Parameters.AddWithValue("@name", customer.Name);
command.Parameters.AddWithValue("@registered_at", customer.RegisteredAt);
command.Parameters.AddWithValue("@address", customer.Address);
command.Parameters.AddWithValue("@city", customer.City);
command.Parameters.AddWithValue("@state", customer.State);
command.Parameters.AddWithValue("@postal_code", customer.PostalCode);
command.Parameters.AddWithValue("@phone", customer.Phone);
command.Parameters.AddWithValue("@account_credit", customer.AccountCredit);
command.Parameters.AddWithValue("@id", customer.Id);
command.ExecuteNonQuery();
}
finally
{
db.Close();
}
}
public void Save(Customer customer)
{
throw new NotImplementedException();
}
