public ActionResult Index() { dapperHelper dh = new dapperHelper(); IEnumerable <CategoriesViewModel> ViewModel = dh.db.Query <CategoriesViewModel>("select * from Categories"); return(View(ViewModel.ToList())); }
public ActionResult AboutCheck(CategoriesViewModel viewModel) { Thread.Sleep(2000); dapperHelper dh = new dapperHelper(); if (ModelState.IsValid) { //int check = dh.db.Execute("insert into Categories (CategoryName,Description) values (@CategoryName,@Description)" // , new { viewModel.CategoryName, viewModel.Description }); //if (check > 0) return(Content(JsonConvert.SerializeObject(new { ststus = true, message = string.Empty }))); } //ViewBag.Valid = "帳號或密碼錯誤"; return(Content(JsonConvert.SerializeObject(new { ststus = false, message = "驗證失敗" }))); }