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 = "我來自雲端１", isDone = false },
// new {title = "我來自雲端２", isDone = false },
// new {title = "我來自雲端３", isDone = true },
// new {title = "我來自雲端４", isDone = false },
// new {title = "我來自雲端５", isDone = false }
//};
//return Json(dataList);
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
