public ApiStatusViewModel <CustomerDataServiceViewModel> CreateCustomerData(CustomerDataInViewModel model) { var connectString = ConfigurationManager.ConnectionStrings["CustomerApiConnection"].ConnectionString; var returnViewModel = new ApiStatusViewModel <CustomerDataServiceViewModel>(); try { DataClassCustomerDataContext CustomerDataContext = new DataClassCustomerDataContext(); CustomerData customer = new CustomerData(); customer.CustomerId = model.CustomerId; customer.CustomerName = model.CustomerName; customer.CustomerAddr = model.CustomerAddr; CustomerDataContext.CustomerData.InsertOnSubmit(customer); CustomerDataContext.SubmitChanges(); returnViewModel.code = "200"; returnViewModel.message = "建立顧客成功!!"; } catch (Exception e) { returnViewModel.code = "500"; returnViewModel.message = e.ToString(); } return(returnViewModel); }
public ApiStatusViewModel <CustomerDataServiceViewModel> EditCustomerData(CustomerDataInViewModel model) { var connectString = ConfigurationManager.ConnectionStrings["CustomerApiConnection"].ConnectionString; var returnViewModel = new ApiStatusViewModel <CustomerDataServiceViewModel>(); try { DataClassCustomerDataContext CustomerDataContext = new DataClassCustomerDataContext(); CustomerData customer = CustomerDataContext.CustomerData.Single(p => p.CustomerId == model.CustomerId); customer.CustomerName = "Andy"; CustomerDataContext.SubmitChanges(); returnViewModel.message = "修改顧客資料成功!!"; returnViewModel.code = "200"; } catch (Exception e) { returnViewModel.code = "500"; returnViewModel.message = e.ToString(); } return(returnViewModel); }
public ApiStatusViewModel <IEnumerable <CustomerDataServiceViewModel> > GetCustomerData(CustomerDataInViewModel model) { var returnViewModel = new ApiStatusViewModel <IEnumerable <CustomerDataServiceViewModel> >(); var connectString = ConfigurationManager.ConnectionStrings["CustomerApiConnection"].ConnectionString; try { DataClassCustomerDataContext CustomerDataContext = new DataClassCustomerDataContext(); var result = CustomerDataContext.CustomerData.AsEnumerable(); var finalresult = result.Select(p => new CustomerDataServiceViewModel() { CustomerName = p.CustomerName, CustomerId = p.CustomerId, CustomerAddr = p.CustomerAddr }); if (model.CustomerId.Trim() != "") { finalresult = finalresult.Where(p => p.CustomerId == model.CustomerId); } if (model.KeyWord != "") { finalresult = finalresult.Where(p => p.CustomerName.Contains(model.CustomerId)).AsQueryable(); } returnViewModel.Data = finalresult; returnViewModel.code = "200"; returnViewModel.message = "顧客資料存取成功!!"; } catch (Exception e) { returnViewModel.code = "500"; returnViewModel.message = e.ToString(); } return(returnViewModel); }