public ProjectViewModel.ProjectSingleResult GetProjectById(int ProjectId)
{
var entity = _dbRepository.GetAll <Project>().FirstOrDefault(x => x.ProjectId == ProjectId);
var result = new ProjectViewModel.ProjectSingleResult
{
Category = entity.Category,
ProjectStatus = entity.ProjectStatus,
ProjectName = entity.ProjectName,
CreatorName = entity.CreatorName,
FundingAmount = entity.FundingAmount,
Fundedpeople = entity.Fundedpeople,
ProjectDescription = entity.ProjectDescription,
ProjectImgUrl = entity.ProjectImgUrl,
ProjectVideoUrl = entity.ProjectVideoUrl,
AmountThreshold = entity.AmountThreshold,
ProjectFAQList = ConvertProjectFAQList(entity.ProjectQuestion, entity.ProjectAnswer),
//Project_Question = entity.Project_Question,
//Project_Answer = entity.Project_Answer,
DateTimeEndDate = entity.EndDate,
DateTimeStartDate = entity.StartDate,
ProjectMainUrl = entity.ProjectMainUrl,
ProjectId = entity.ProjectId,
MemberId = entity.MemberId
};
return(result);
}
public Task <ProjectViewModel.ProjectSingleResult> GetById(ProjectViewModel.GetByIdRequest request)
{
return(Task.Run(() =>
{
var data = _dbRepository.GetAll <Project>()
.FirstOrDefault(x => x.ProjectId == request.ProjectId);
var result = new ProjectViewModel.ProjectSingleResult()
{
ProjectId = data.ProjectId,
ProjectName = data.ProjectName,
ProjectMainUrl = data.ProjectMainUrl,
Category = data.Category,
ProjectStatus = data.ProjectStatus,
CreatorName = data.CreatorName,
FundingAmount = data.FundingAmount,
AmountThreshold = data.AmountThreshold,
EndDate = data.EndDate.ToString("d"),
StartDate = data.StartDate.ToString("d"),
Fundedpeople = data.Fundedpeople,
};
return result;
}));
}
/// <summary>
/// 將前端修改後的資料以交易方式，變更資料庫資料。回傳為字串形式:"查無此筆資料"、"修改成功"、Exception.Message
/// </summary>
/// <param name="waitForPassProject"></param>
public Task <string> EditWaitForPassProject(ProjectViewModel.ProjectSingleResult waitForPassProject)
{
return(Task.Run(() =>
{
var querySingleResult = _dbRepository.GetAll <Project>().FirstOrDefault(x => x.ProjectId == waitForPassProject.ProjectId);
if (querySingleResult == default)
{
return "查無此筆資料";
}
if (waitForPassProject.ApprovingStatus == 2)
{
querySingleResult.ProjectStatus = "集資中";
querySingleResult.ApprovingStatus = 2;
}
else
{
querySingleResult.ProjectStatus = null;
querySingleResult.ApprovingStatus = 3;
}
using (var transaction = _labContext.Database.BeginTransaction())
{
try
{
_dbRepository.Update <Project>(querySingleResult);
transaction.Commit();
return "修改成功";
}
catch (Exception ex)
{
transaction.Rollback();
return ex.Message;
}
}
}));
}
public async Task <ActionResult <BaseModel.BaseResult <ProjectViewModel.ProjectSingleResult> > > EditWaitForPassProject([FromBody] ProjectViewModel.ProjectSingleResult waitForPassSingle)
{
_logger.LogWarning(2001, DateTime.Now.ToLongTimeString() + " BackendMembers控制器PutBackendMember方法被呼叫 ,傳入的資料為:" + System.Text.Json.JsonSerializer.Serialize(waitForPassSingle));
var result = new BaseModel.BaseResult <ProjectViewModel.ProjectSingleResult>();
var editResult = await _projectService.EditWaitForPassProject(waitForPassSingle);
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);
}
}
