public ActionResult Save()
{
string json;
Person person;
try
{
using (var reader = new StreamReader(Request.InputStream))
{
json = reader.ReadToEnd();
}
person = JsonConvert.DeserializeObject <Person>(json);
}
catch
{
return(new HttpStatusCodeResult(422));
}
using (var db = new AussieDiversEntities())
{
var obj = db.People.FirstOrDefault(x => x.PersonID == person.PersonID);
if (obj != null)
{
obj.PersonFirstName = person.PersonFirstName;
obj.PersonLastName = person.PersonLastName;
obj.PersonEmail = person.PersonEmail;
obj.PersonDOB = person.PersonDOB;
obj.PersonStreetAddress1 = person.PersonStreetAddress1;
obj.PersonStateProvinceTerritory = person.PersonStateProvinceTerritory;
obj.PersonCity = person.PersonCity;
obj.PersonCountry = person.PersonCountry;
obj.PersonPostalCode = person.PersonPostalCode;
}
else
{
db.People.Add(person);
}
try
{
db.SaveChanges();
}
catch
{
return(new HttpStatusCodeResult(500));
}
}
return(new HttpStatusCodeResult(200));
}
//
// GET: /Customer/
public ActionResult Index()
{
List<Person> customers;
ContentResult result = new ContentResult();
result.ContentEncoding = Encoding.UTF8;
result.ContentType = "application/json";
using (var db = new AussieDiversEntities())
{
customers = (from p in db.People
orderby p.PersonLastName
select p).ToList();
result.Content = JsonConvert.SerializeObject(customers, new JsonSerializerSettings {
//NullValueHandling = NullValueHandling.Ignore
});
}
return result;
}
//
// GET: /Customer/
public ActionResult Index()
{
List <Person> customers;
ContentResult result = new ContentResult();
result.ContentEncoding = Encoding.UTF8;
result.ContentType = "application/json";
using (var db = new AussieDiversEntities())
{
customers = (from p in db.People
orderby p.PersonLastName
select p).ToList();
result.Content = JsonConvert.SerializeObject(customers, new JsonSerializerSettings {
//NullValueHandling = NullValueHandling.Ignore
});
}
return(result);
}
public ActionResult Save()
{
string json;
Person person;
try
{
using (var reader = new StreamReader(Request.InputStream))
{
json = reader.ReadToEnd();
}
person = JsonConvert.DeserializeObject<Person>(json);
}
catch
{
return new HttpStatusCodeResult(422);
}
using (var db = new AussieDiversEntities())
{
var obj = db.People.FirstOrDefault(x => x.PersonID == person.PersonID);
if (obj != null)
{
obj.PersonFirstName = person.PersonFirstName;
obj.PersonLastName = person.PersonLastName;
obj.PersonEmail = person.PersonEmail;
obj.PersonDOB = person.PersonDOB;
obj.PersonStreetAddress1 = person.PersonStreetAddress1;
obj.PersonStateProvinceTerritory = person.PersonStateProvinceTerritory;
obj.PersonCity = person.PersonCity;
obj.PersonCountry = person.PersonCountry;
obj.PersonPostalCode = person.PersonPostalCode;
}
else
{
db.People.Add(person);
}
try
{
db.SaveChanges();
}
catch
{
return new HttpStatusCodeResult(500);
}
}
return new HttpStatusCodeResult(200);
}
