public ActionResult Create([Bind(Include = "Id,客戶名稱,統一編號,電話,傳真,地址,Email")] CustomerData customerData) { if (ModelState.IsValid) { db.CustomerData.Add(customerData); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customerData)); }
public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話")] CustomerContact customerContact) { if (ModelState.IsValid) { db.CustomerContact.Add(customerContact); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.客戶Id = new SelectList(db.CustomerData, "Id", "客戶名稱", customerContact.客戶Id); return(View(customerContact)); }
public ActionResult Create([Bind(Include = "Id,客戶Id,銀行名稱,銀行代碼,分行代碼,帳戶名稱,帳戶號碼")] CustomerBankInfo customerBankInfo) { if (ModelState.IsValid) { db.CustomerBankInfo.Add(customerBankInfo); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.客戶Id = new SelectList(db.CustomerData, "Id", "客戶名稱", customerBankInfo.客戶Id); return(View(customerBankInfo)); }
public Customer InsertCustomer(Customer _customer) { using (customerEntities entities = new customerEntities()) { entities.Customers.Add(_customer); entities.SaveChanges(); } return(_customer); }
public void DeleteCustomer(Customer _customer) { using (customerEntities entities = new customerEntities()) { Customer customer = (from c in entities.Customers where c.CustomerId == _customer.CustomerId select c).FirstOrDefault(); entities.Customers.Remove(customer); entities.SaveChanges(); } }
public bool UpdateCustomer(Customer _customer) { using (customerEntities entities = new customerEntities()) { Customer updatedCustomer = (from c in entities.Customers where c.CustomerId == _customer.CustomerId select c).FirstOrDefault(); updatedCustomer.Name = _customer.Name; updatedCustomer.Country = _customer.Country; entities.SaveChanges(); } return(true); }