/// <summary>
/// (非同步)將前端修改後的資料以交易方式，刪除資料庫資料。回傳為字串形式:"查無此筆資料"、"刪除成功"、Exception.Message
/// </summary>
/// <param name="singleMember"></param>
/// <returns></returns>
public Task <string> DeleteMember(BackendMemberViewModel.BackendSingleResult singleMember)
{
return(Task.Run(() =>
{
var querySingleResult = _repository.GetAll <Backendmember>().FirstOrDefault(B => B.MemberId == singleMember.MemberId);
if (querySingleResult == default)
{
return "查無此筆資料";
}
using (var transaction = _labContext.Database.BeginTransaction())
{
try
{
_repository.Delete <Backendmember>(querySingleResult);
transaction.Commit();
return "刪除成功";
}
catch (Exception ex)
{
transaction.Rollback();
return ex.Message;
}
}
}));
}
/// <summary>
/// (非同步)將前端修改後的資料以交易方式，變更資料庫資料。回傳為字串形式:"查無此筆資料"、"修改成功"、Exception.Message
/// </summary>
/// <param name="singleMember"></param>
/// <returns></returns>
public Task <string> EditMember(BackendMemberViewModel.BackendSingleResult singleMember)
{
return(Task.Run(() =>
{
var querySingleResult = _repository.GetAll <Backendmember>().FirstOrDefault(B => B.MemberId == singleMember.MemberId);
if (querySingleResult == default)
{
return "查無此筆資料";
}
querySingleResult.BackendIdentity = singleMember.BackendIdentity;
querySingleResult.MemberAddress = singleMember.MemberAddress;
querySingleResult.MemberName = singleMember.MemberName;
querySingleResult.MemberConEmail = singleMember.MemberConEmail;
querySingleResult.MemberBirth = DateTime.Parse(singleMember.MemberBirth);
querySingleResult.MemberPhone = singleMember.MemberPhone;
using (var transaction = _labContext.Database.BeginTransaction())
{
try
{
_repository.Update <Backendmember>(querySingleResult);
transaction.Commit();
return "修改成功";
}
catch (Exception ex)
{
transaction.Rollback();
return ex.Message;
}
}
}));
}
/// <summary>
/// (非同步)在資料庫中創建一筆後台會員資料，並返回該筆資料
/// </summary>
/// <param name="singleMember"></param>
/// <returns></returns>
public Task <BackendMemberViewModel.BackendSingleResult> CreateOneMember(BackendMemberViewModel.BackendSingleResult singleMember)
{
return(Task.Run(() =>
{
Backendmember newBackendmember = new Backendmember
{
LoginTime = DateTime.UtcNow.AddHours(08),
MemberName = singleMember.MemberName,
MemberAccount = singleMember.MemberAccount,
MemberAddress = singleMember.MemberAddress,
MemberBirth = DateTime.Parse(singleMember.MemberBirth),
BackendIdentity = singleMember.BackendIdentity,
MemberConEmail = singleMember.MemberConEmail,
MemberRegEmail = singleMember.MemberRegEmail,
MemberPassword = singleMember.MemberPassword,
MemberPhone = singleMember.MemberPhone,
};
_repository.Create(newBackendmember);
singleMember.MemberId = newBackendmember.MemberId;
return singleMember;
}));
}
/// <summary>
/// (非同步)從資料庫取得一筆後台會員資料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Task <BackendMemberViewModel.BackendSingleResult> GetOne(int id)
{
return(Task.Run(() =>
{
BackendMemberViewModel.BackendSingleResult result = new BackendMemberViewModel.BackendSingleResult();
var querySingleResult = _repository.GetAll <Backendmember>().FirstOrDefault(b => b.MemberId == id);
if (querySingleResult != default)
{
result.BackendIdentity = querySingleResult.BackendIdentity;
result.MemberAccount = querySingleResult.MemberAccount;
result.Gender = querySingleResult.Gender;
result.MemberAddress = querySingleResult.MemberAddress;
result.MemberBirth = querySingleResult.MemberBirth.ToString("d");
result.MemberRegEmail = querySingleResult.MemberRegEmail;
result.MemberConEmail = querySingleResult.MemberConEmail;
result.MemberId = querySingleResult.MemberId;
result.MemberMessage = querySingleResult.MemberMessage;
result.MemberPhone = querySingleResult.MemberPhone;
result.MemberMessage = querySingleResult.MemberMessage;
result.MemberName = querySingleResult.MemberName;
return result;
}
else
{
return null;
}
}));
}
public async Task <ActionResult <BaseModel.BaseResult <BackendMemberViewModel.BackendSingleResult> > > PostBackendMember([FromBody] BackendMemberViewModel.BackendSingleResult backendSingle)
{
var result = new BaseModel.BaseResult <BackendMemberViewModel.BackendSingleResult>();
_logger.LogWarning(2001, DateTime.Now.ToLongTimeString() + " BackendMembers控制器PostBackendMember方法被呼叫 ,傳入的資料為:" + System.Text.Json.JsonSerializer.Serialize(backendSingle));
try
{
result.Body = await _backendMemberService.CreateOneMember(backendSingle);
return(result);
}
catch (Exception ex)
{
result.Msg = ex.Message;
result.IsSuccess = false;
return(result);
}
}
public async Task <ActionResult <BaseModel.BaseResult <BackendMemberViewModel.BackendSingleResult> > > DeleteBackendMember([FromBody] BackendMemberViewModel.BackendSingleResult backendSingle)
{
_logger.LogWarning(2001, DateTime.Now.ToLongTimeString() + " BackendMembers控制器DeleteBackendMember方法被呼叫 ,傳入的資料為:" + $"Product controller Get called ,Parameter is {nameof(backendSingle.MemberId)} " + backendSingle.MemberId);
var result = new BaseModel.BaseResult <BackendMemberViewModel.BackendSingleResult>();
if (!ModelState.IsValid || backendSingle.MemberId == 2)
{
result.Msg = "查無此筆資料";
result.IsSuccess = false;
return(result);
}
var deleteResult = await _backendMemberService.DeleteMember(backendSingle);
result.Msg = deleteResult;
if (result.Msg == "查無此筆資料")
{
result.IsSuccess = false;
return(result);
}
else if (result.Msg == "刪除成功")
{
result.IsSuccess = true;
return(result);
}
else
{
result.IsSuccess = false;
return(result);
}
}
public async Task <ActionResult <BaseModel.BaseResult <BackendMemberViewModel.BackendSingleResult> > > PutBackendMember([FromBody] BackendMemberViewModel.BackendSingleResult backendSingle)
{
_logger.LogWarning(2001, DateTime.Now.ToLongTimeString() + " BackendMembers控制器PutBackendMember方法被呼叫 ,傳入的資料為:" + System.Text.Json.JsonSerializer.Serialize(backendSingle));
var result = new BaseModel.BaseResult <BackendMemberViewModel.BackendSingleResult>();
if (!ModelState.IsValid)
{
result.Msg = "查無此筆資料";
result.IsSuccess = false;
return(result);
}
var editResult = await _backendMemberService.EditMember(backendSingle);
result.Msg = editResult;
if (result.Msg == "查無此筆資料")
{
result.IsSuccess = false;
return(result);
}
else if (result.Msg == "修改成功")
{
result.IsSuccess = true;
return(result);
}
else
{
result.IsSuccess = false;
return(result);
}
}
