public object UpdateCallResult(CreateOrEditCallResultDto input, string UserId)
{
try
{
DynamicParameters param = new DynamicParameters();
string sql = "UPDATE CALL_RESULT SET " +
"NAME=@NAME," +
"NOTES=@NOTES," +
"CALL_CATEGORY_ID=@CALL_CATEGORY_ID," +
"STATUS=@STATUS," +
"DATE_MODIFIED=@DATE_MODIFIED," +
"MODIFIED_USER_ID=@MODIFIED_USER_ID " +
"Where ID=@ID ";
param.Add("@ID", input.ID);
param.Add("@NAME", input.NAME);
param.Add("@NOTES", input.NOTES);
param.Add("@CALL_CATEGORY_ID", input.CALL_CATEGORY_ID);
param.Add("@STATUS", input.STATUS);
param.Add("@DATE_MODIFIED", DateTime.Now);
param.Add("@MODIFIED_USER_ID", UserId);
DapperORM.Execute(sql, param);
return(new { data = input.ID });
}
catch (Exception ex)
{
return(new { data = new { Message = ex.Message, ErrorCode = 600 } });
}
}
public IActionResult CreateOrEditCallResult(CreateOrEditCallResultDto input)
{
if (input.ID == Guid.Empty.ToString() || string.IsNullOrEmpty(input.ID))
{
return(Ok(_callCategoryRepository.CreateCallResult(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
else
{
return(Ok(_callCategoryRepository.UpdateCallResult(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
}
public object CreateCallResult(CreateOrEditCallResultDto input, string UserId)
{
try
{
DynamicParameters param = new DynamicParameters();
String sql = "INSERT INTO CALL_RESULT (" +
"ID," +
"CREATED_BY," +
"DATE_ENTERED," +
"MODIFIED_USER_ID," +
"DATE_MODIFIED," +
"NAME," +
"NOTES," +
"CALL_CATEGORY_ID," +
"STATUS) " +
"VALUES (" +
"@ID," +
"@CREATED_BY," +
"@DATE_ENTERED," +
"@MODIFIED_USER_ID," +
"@DATE_MODIFIED," +
"@NAME," +
"@NOTES," +
"@CALL_CATEGORY_ID," +
"@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_CATEGORY_ID", input.CALL_CATEGORY_ID);
param.Add("@STATUS", input.STATUS);
DapperORM.Execute(sql, param);
sql = "INSERT INTO CALL_RESULT_CSTM (ID_C) VALUES(@ID)";
param = new DynamicParameters();
param.Add("@ID", Id);
DapperORM.Execute(sql, param);
return(new { data = Id });
}
catch (Exception ex)
{
return(new { data = new { Message = ex.Message, ErrorCode = 600 } });
}
}
