public object UpdateCallReasonFollow(CreateOrEditCallReasonFollowDto input, string UserId)
{
try
{
DynamicParameters param = new DynamicParameters();
String sql = "UPDATE CALL_REASON SET " +
"MODIFIED_USER_ID=@MODIFIED_USER_ID, " +
"DATE_MODIFIED=@DATE_MODIFIED," +
"NAME=@NAME," +
"CALL_RESULT_ID=@CALL_RESULT_ID," +
"NOTES=@NOTES," +
"STATUS=@STATUS " +
"WHERE ID=@ID";
param.Add("@MODIFIED_USER_ID", UserId);
param.Add("@DATE_MODIFIED", DateTime.Now);
param.Add("@ID", input.ID);
param.Add("@NAME", input.NAME);
param.Add("@NOTES", input.NOTES);
param.Add("@CALL_RESULT_ID", input.CALL_RESULT_ID);
param.Add("@STATUS", input.STATUS);
DapperORM.Execute(sql, param);
return(new { data = input.ID });
}
catch (Exception ex)
{
return(new { data = new { Message = ex.Message, ErrorCode = 600 } });
}
}
public IActionResult CreateOrEditCallReasonFollow(CreateOrEditCallReasonFollowDto input)
{
if (input.ID == Guid.Empty.ToString() || string.IsNullOrEmpty(input.ID))
{
return(Ok(_callCategoryRepository.CreateCallReasonFollow(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
else
{
return(Ok(_callCategoryRepository.UpdateCallReasonFollow(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
}
public object CreateCallReasonFollow(CreateOrEditCallReasonFollowDto input, string UserId)
{
try
{
DynamicParameters param = new DynamicParameters();
String sql = "INSERT INTO CALL_REASON (" +
"ID," +
"CREATED_BY," +
"DATE_ENTERED," +
"MODIFIED_USER_ID," +
"DATE_MODIFIED," +
"NAME," +
"CALL_RESULT_ID," +
"NOTES," +
"STATUS)" +
"VALUES (" +
"@ID," +
"@CREATED_BY," +
"@DATE_ENTERED," +
"@MODIFIED_USER_ID," +
"@DATE_MODIFIED," +
"@NAME," +
"@CALL_RESULT_ID," +
"@NOTES," +
"@STATUS)";
var Id = Guid.NewGuid().ToString();
param.Add("@ID", Id);
param.Add("@CREATED_BY", UserId);
param.Add("@DATE_ENTERED", DateTime.Now);
param.Add("@MODIFIED_USER_ID", UserId);
param.Add("@DATE_MODIFIED", DateTime.Now);
param.Add("@NAME", input.NAME);
param.Add("@NOTES", input.NOTES);
param.Add("@CALL_RESULT_ID", input.CALL_RESULT_ID);
param.Add("@STATUS", input.STATUS);
DapperORM.Execute(sql, param);
return(new { data = Id });
}
catch (Exception ex)
{
return(new { data = new { Message = ex.Message, ErrorCode = 600 } });
}
}
