public ActionResult SaveFormData(AccountInfoFormDataVM formData)
{
try
{
if (!ModelState.IsValid)
{
Response.StatusCode = 400;
return(Json(ErrorMessageVM.CHECK_DATA_FAIL));
}
using (var ctx = new MyDatabaseEntities())
using (var txn = ctx.Database.BeginTransaction())
{
//## 若已存在則更新，不存在則新增
var info = ctx.Account.Find(formData.accountInfo.name);
if (info != null)
{
//# 已存在則更新
//info.name = formData.accountInfo.name; // PK
info.email = formData.accountInfo.email ?? "";
info.mobilePhone = formData.accountInfo.mobilePhone ?? "";
info.birthday = formData.userInfo.birthday;
info.contactTime = formData.userInfo.contactTime;
info.remark = formData.userInfo.remark;
ctx.SaveChanges();
txn.Commit();
}
else
{
//# 不存在則新增
Account newInfo = new Account()
{
name = formData.accountInfo.name,
email = formData.accountInfo.email ?? "",
mobilePhone = formData.accountInfo.mobilePhone ?? "",
birthday = formData.userInfo.birthday,
contactTime = formData.userInfo.contactTime,
remark = formData.userInfo.remark
};
ctx.Account.Add(newInfo);
ctx.SaveChanges();
txn.Commit();
}
}
return(Json(ErrorMessageVM.SUCCESS));
}
catch (Exception ex)
{
Response.StatusCode = 500;
return(Json(new ErrorMessageVM(ex.Message)));
}
}
public ActionResult LoadFormData(string name)
{
try
{
if (!ModelState.IsValid)
{
Response.StatusCode = 400;
return(Json(ErrorMessageVM.CHECK_DATA_FAIL));
}
using (var ctx = new MyDatabaseEntities())
{
var info = ctx.Account.SingleOrDefault(c => c.name == name);
if (info == null)
{
Response.StatusCode = 500;
return(Json(new ErrorMessageVM("無資料。")));
}
AccountInfoFormDataVM formData = new AccountInfoFormDataVM()
{
accountInfo = new AccountInfoFormDataVM.AccountInfo
{
name = info.name,
email = info.email,
mobilePhone = info.mobilePhone
},
userInfo = new AccountInfoFormDataVM.UserInfo
{
birthday = info.birthday,
contactTime = info.contactTime,
remark = info.remark
}
};
return(Json(formData));
}
}
catch (Exception ex)
{
Response.StatusCode = 500;
return(Json(new ErrorMessageVM(ex.Message)));
}
}
