//DELETE public void DeleteNoteProc(InNoteViewModel noteViewModel) { try { Note note = new Note(); note.Id = noteViewModel.Id; inoteDAO.DeleteNote(note); } catch (Exception e) { throw new Exception(); } }
//CREATE public void CreateNoteProc(InNoteViewModel noteViewModel) { try { Note note = new Note(); note.Value1 = noteViewModel.Value1; note.Value2 = noteViewModel.Value2; inoteDAO.CreateNote(note); } catch (Exception e) { throw new Exception(); } }
public outUniResult Delete_DB([FromBody] InNoteViewModel noteViewModel) { outUniResult _outUniResult = new outUniResult(); try { iNoteBLO.DeleteNoteProc(noteViewModel); _outUniResult.StatusCode = 200; //<--這種常式盡量不要出現 _outUniResult.Result = null; _outUniResult.Error = null; return(_outUniResult); } catch (Exception e) { throw new Exception(); } }
//UPDATE public void UpdateNoteProc(InNoteViewModel noteViewModel) { try { DateTime dateTime = DateTime.UtcNow; Note note = new Note(); note.Id = noteViewModel.Id; note.Date = dateTime; note.Value1 = noteViewModel.Value1; note.Value2 = noteViewModel.Value2; inoteDAO.UpdateNote(note); } catch (Exception e) { throw new Exception(); } }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); Xamarin.Essentials.Platform.Init(this, savedInstanceState); SetContentView(Resource.Layout.activity_main); Android.Support.V7.Widget.Toolbar toolbar = FindViewById <Android.Support.V7.Widget.Toolbar>(Resource.Id.toolbar); SetSupportActionBar(toolbar); FloatingActionButton fab = FindViewById <FloatingActionButton>(Resource.Id.fab); fab.Click += FabOnClick; ContainerBuilder = new ContainerBuilder(); ContainerBuilder.RegisterModule <AutofacConfig>(); var container = ContainerBuilder.Build(); Button Btn_InsertData = FindViewById <Button>(Resource.Id.button1); Button Btn_SelectData = FindViewById <Button>(Resource.Id.button2); Button Btn_UpdateData = FindViewById <Button>(Resource.Id.button3); Button Btn_DeleteData = FindViewById <Button>(Resource.Id.button4); //VALUE1 VALUE2 EditText EditText1 = FindViewById <EditText>(Resource.Id.editText1); EditText EditText2 = FindViewById <EditText>(Resource.Id.editText2); //ID EditText EditText3 = FindViewById <EditText>(Resource.Id.editText3); //READ ListView listView1 = FindViewById <ListView>(Resource.Id.listView1); //ObservableCollection<Note> note2 = datalist; Btn_SelectData.Click += (s, e) => { datalist = container.Resolve <INoteBLO>().GetNoteProc(); //var myAdapter = new ArrayAdapter<string>(this, Android.Resource.Layout.SimpleExpandableListItem1, datalist); //listView1.Adapter = myAdapter; listView1.Adapter = new CustomListAdapter(this, datalist); // listView1.ItemClick += listView_ItemClick; listView1.ItemClick += listView_Click; Toast.MakeText(this, "查詢成功", ToastLength.Long).Show(); }; //CREATE Btn_InsertData.Click += (s, e) => { InNoteViewModel note = new InNoteViewModel(); note.Value1 = EditText1.Text; note.Value2 = EditText2.Text; container.Resolve <INoteBLO>().CreateNoteProc(note); Toast.MakeText(this, "新增成功", ToastLength.Long).Show(); }; //UPDATE Btn_UpdateData.Click += (s, e) => { InNoteViewModel note = new InNoteViewModel(); note.Value1 = EditText1.Text; note.Value2 = EditText2.Text; Guid guid = Guid.Parse(EditText3.Text); note.Id = guid; container.Resolve <INoteBLO>().UpdateNoteProc(note); Toast.MakeText(this, "更新成功", ToastLength.Long).Show(); }; //DELETE Btn_DeleteData.Click += (s, e) => { InNoteViewModel note = new InNoteViewModel(); Guid guid = Guid.Parse(EditText3.Text); note.Id = guid; container.Resolve <INoteBLO>().DeleteNoteProc(note); Toast.MakeText(this, "刪除成功", ToastLength.Long).Show(); }; }