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)));
}
}
