public ActionResult SaveFormData(BranchFormDataVM formData) { try { if (!ModelState.IsValid) { Response.StatusCode = 400; return(Json(ErrorMessageVM.CHECK_DATA_FAIL)); } using (var ctx = new ReactPracticeEntities()) //context using (var txn = ctx.Database.BeginTransaction()) //啟動交易 txn == Transaction { //## 若已存在則更新,不存在則新增 //依照P KEY找資料 var info = ctx.Branch.Find("1000", formData.Branch_ID); if (info != null) { //# 已存在則更新 info.Branch_Name = formData.Branch_Name; info.Address = formData.Address; ctx.SaveChanges(); txn.Commit(); } else { //# 不存在則新增 Branch newInfo = new Branch() { Channel_ID = "1000", Branch_Type = "1", Branch_ID = formData.Branch_ID, Branch_Name = formData.Branch_Name, Supervisor = "ABC", Contact = "QQQ", Phone = "0987654321", Address_City = "台北市", Address_Dist = "信義區", Address_ZIP_code = "123", Address = formData.Address, Email = "*****@*****.**", //ModifiedDate = formData.ModifiedDate }; ctx.Branch.Add(newInfo); ctx.SaveChanges(); txn.Commit(); } } return(Json(ErrorMessageVM.SUCCESS)); } catch (Exception ex) { Response.StatusCode = 500; return(Json(new ErrorMessageVM(ex.Message))); } }
public ActionResult DelFormData(BranchFormDataVM formData) { try { if (!ModelState.IsValid) { Response.StatusCode = 400; return(Json(ErrorMessageVM.CHECK_DATA_FAIL)); } using (var ctx = new ReactPracticeEntities()) //context using (var txn = ctx.Database.BeginTransaction()) //啟動交易 txn == Transaction { //## 若已存在則刪除,不存在則顯示無該筆資料訊息 //依照P KEY找資料 var info = ctx.Branch.Find("1000", formData.Branch_ID); if (info != null) { //# 已存在則刪除 info.Branch_Name = formData.Branch_Name; info.Address = formData.Address; ctx.Branch.Remove(info); ctx.SaveChanges(); txn.Commit(); } else { //# 不存在則顯示無資料訊息 Branch newInfo = new Branch() { }; ctx.Branch.Add(newInfo); ctx.SaveChanges(); txn.Commit(); } } return(Json(ErrorMessageVM.SUCCESS)); } catch (Exception ex) { Response.StatusCode = 500; return(Json(new ErrorMessageVM(ex.Message))); } }
public JsonResult QryDataList(string title, bool isDone) { try { if (!ModelState.IsValid) { return(Json("Data Check Falsed!")); } //string connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["Branch"].ConnectionString; ReactPracticeEntities ctx = new ReactPracticeEntities(); { var dataList = ctx.Database.SqlQuery <Branch>("select Top 10 * from Branch").ToList(); return(Json(dataList)); } //## Biz Go // 模擬查詢結果 //改成SQL寫法 // var dataList = new[] // { // new {title = title, isDone = isDone }, // new {title = "我來自雲端1", isDone = false }, // new {title = "我來自雲端2", isDone = false }, // new {title = "我來自雲端3", isDone = true }, // new {title = "我來自雲端4", isDone = false }, // new {title = "我來自雲端5", isDone = false } //}; //return Json(dataList); } catch (Exception ex) { return(Json(ex.Message)); } }