Esempio n. 1
0
        public JsonResult GetCustomers()
        {
            using (var db = new YleanaCEEntities())
            {
                try
                {
                    var customerList = (from customers in db.Customers
                                        select customers).ToList();
                    return Json(customerList);
                }
                catch(Exception e)
                {
                    return Json(new ResultMessageViewModel() { Result = "Error", Message = String.Format("An error occured: ({0}) {1}", e.Source, e.Message) });
                }

            }
        }
Esempio n. 2
0
 public JsonResult AddNewCustomer(CustomerViewModel customer)
 {
     using (var db = new YleanaCEEntities())
     {
         try
         {
             db.Customers.Add(new Customer()
             {
                 CustomerName = customer.CustomerName,
                 ContactName = customer.ContactName,
                 Address = customer.Address,
                 City = customer.City,
                 PostalCode = customer.PostalCode,
                 Country = customer.Country
             });
             db.SaveChanges();
         }
         catch(Exception e)
         {
             return Json(new ResultMessageViewModel() { Result = "Error", Message = String.Format("An error occured: ({0}) {1}", e.Source, e.Message) });
         }
     }
     return Json(new ResultMessageViewModel() { Result = "Success", Message = "Customer added succesfully" });
 }