public IActionResult UpdateCoefficient([FromBody] CreateCoefficientDto createCoefficientDto)
{
try
{
bool res = _userRepository.UpdateCoefficient(createCoefficientDto);
if (res == true)
{
return(Ok(new
{
code = 200,
message = "ok"
}));
}
else
{
return(StatusCode(400, new
{
code = 400,
message = "fail",
}));
}
}
catch (Exception e)
{
return(StatusCode(400, new
{
code = 400,
message = e,
}));
}
}
public bool CreateCoefficient(CreateCoefficientDto createCoefficientDto)
{
DynamicParameters param = new DynamicParameters();
try
{
String sql = @"
INSERT INTO TITLE_CAMPAIGN_CATEGORY(ID,DELETED,CREATED_BY,DATE_ENTERED,MODIFIED_USER_ID,DATE_MODIFIED,DATE_MODIFIED_UTC,CAMPAIGN_CATEGORY_ID,TITLE_ID,COEFFICIENT,TOTAL_NUM,CONNECTED_NUM,AGREE_NUM)
VALUES(@id, @deleted, @createdBy, @dateEntered,@modifiedUserId,@dateModified,@dateModifiedUTC,@campaignCategoryId,@titleId,@coEfficient,@totalNum,@connectedNum,@agreeNum)";
param.Add("@id", createCoefficientDto.ID);
param.Add("@deleted", createCoefficientDto.DELETED);
param.Add("@createdBy", createCoefficientDto.CREATED_BY);
param.Add("@dateEntered", createCoefficientDto.DATE_ENTERED);
param.Add("@modifiedUserId", createCoefficientDto.MODIFIED_USER_ID);
param.Add("@dateModified", createCoefficientDto.DATE_MODIFIED);
param.Add("@dateModifiedUTC", createCoefficientDto.DATE_MODIFIED_UTC);
param.Add("@campaignCategoryId", createCoefficientDto.CAMPAIGN_CATEGORY_ID);
param.Add("@titleId", createCoefficientDto.TITLE_ID);
param.Add("@coEfficient", createCoefficientDto.COEFFICIENT);
param.Add("@totalNum", createCoefficientDto.TOTAL_NUM);
param.Add("@connectedNum", createCoefficientDto.CONNECTED_NUM);
param.Add("@agreeNum", createCoefficientDto.AGREE_NUM);
DapperORM.Execute(sql, param);
return(true);
}
catch (Exception e)
{
Console.WriteLine("ex:" + e);
return(false);
}
}
public bool UpdateCoefficient(CreateCoefficientDto createCoefficientDto)
{
DynamicParameters param = new DynamicParameters();
try
{
string sql = "update TITLE_CAMPAIGN_CATEGORY " +
"set DELETED = @deleted," +
" CREATED_BY = @createdBy," +
" DATE_ENTERED = @dateEntered, " +
" MODIFIED_USER_ID = @modifiedUserId," +
" DATE_MODIFIED = @dateModified," +
" DATE_MODIFIED_UTC = @dateModifiedUTC, " +
" CAMPAIGN_CATEGORY_ID = @campaignCategoryId, " +
" TITLE_ID =@titleId, " +
" COEFFICIENT=@coEfficient, " +
" TOTAL_NUM =@totalNum, " +
" CONNECTED_NUM = @connectedNum, " +
" AGREE_NUM = @agreeNum where ID = @id";
param.Add("@id", createCoefficientDto.ID);
param.Add("@deleted", createCoefficientDto.DELETED);
param.Add("@createdBy", createCoefficientDto.CREATED_BY);
param.Add("@dateEntered", createCoefficientDto.DATE_ENTERED);
param.Add("@modifiedUserId", createCoefficientDto.MODIFIED_USER_ID);
param.Add("@dateModified", createCoefficientDto.DATE_MODIFIED);
param.Add("@dateModifiedUTC", createCoefficientDto.DATE_MODIFIED_UTC);
param.Add("@campaignCategoryId", createCoefficientDto.CAMPAIGN_CATEGORY_ID);
param.Add("@titleId", createCoefficientDto.TITLE_ID);
param.Add("@coEfficient", createCoefficientDto.COEFFICIENT);
param.Add("@totalNum", createCoefficientDto.TOTAL_NUM);
param.Add("@connectedNum", createCoefficientDto.CONNECTED_NUM);
param.Add("@agreeNum", createCoefficientDto.AGREE_NUM);
DapperORM.Execute(sql, param);
return(true);
}
catch (Exception e)
{
Console.WriteLine("ex:" + e);
return(false);
}
}
public IActionResult CreateCoefficient([FromBody] CreateCoefficientDto createCoefficientDto)
{
var userID = User.FindFirst(ClaimTypes.NameIdentifier).Value; // modified_user_id
Guid newId = Guid.NewGuid();
createCoefficientDto.ID = newId;
createCoefficientDto.MODIFIED_USER_ID = new Guid(userID);
try
{
bool res = _userRepository.CreateCoefficient(createCoefficientDto);
if (res == true)
{
return(Ok(new
{
code = 200,
message = "ok"
}));
}
else
{
return(StatusCode(400, new
{
code = 400,
message = "fail",
}));
}
}
catch (Exception e)
{
return(StatusCode(400, new
{
code = 400,
message = e,
}));
}
}
