public IActionResult CreateOrEditCallReason(CreateOrEditCallReasonDto input)
{
if (input.ID == Guid.Empty.ToString() || string.IsNullOrEmpty(input.ID))
{
return(Ok(_callCategoryRepository.CreateCallReason(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
else
{
return(Ok(_callCategoryRepository.UpdateCallReason(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
}
public object UpdateCallReason(CreateOrEditCallReasonDto 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," +
"DO_NOT_CALL_LIST=@DO_NOT_CALL_LIST," +
"CALLBACK=@CALLBACK," +
"CIC=@CIC," +
"DURATION=@DURATION," +
"NOTES=@NOTES," +
"FOLLOW_UP=@FOLLOW_UP," +
"STATUS=@STATUS," +
"CAMPAIGN_CATEGORY_ID=@CAMPAIGN_CATEGORY_ID " +
"WHERE ID=@ID";
param.Add("@MODIFIED_USER_ID", UserId);
param.Add("@DATE_MODIFIED", DateTime.Now);
param.Add("@NAME", input.NAME);
param.Add("@NOTES", input.NOTES);
param.Add("@DO_NOT_CALL_LIST", input.DO_NOT_CALL_LIST);
param.Add("@CALLBACK", input.CALLBACK);
param.Add("@CIC", input.CIC);
param.Add("@DURATION", input.DURATION);
param.Add("@FOLLOW_UP", input.FOLLOW_UP);
param.Add("@CALL_RESULT_ID", input.CALL_RESULT_ID);
param.Add("@CAMPAIGN_CATEGORY_ID", (string.IsNullOrEmpty(input.CAMPAIGN_CATEGORY_ID) ? null : input.CAMPAIGN_CATEGORY_ID));
param.Add("@STATUS", input.STATUS);
param.Add("@ID", input.ID);
DapperORM.Execute(sql, param);
sql = "UPDATE CALL_REASON_CSTM SET " +
"RECALL_TIME_C=@RECALL_TIME_C " +
"WHERE ID_C=@ID";
param.Add("@ID", input.ID);
param.Add("@RECALL_TIME_C", input.RECALL_TIME_C);
DapperORM.Execute(sql, param);
return(new { data = input.ID });
}
catch (Exception ex)
{
return(new { data = new { Message = ex.Message, ErrorCode = 600 } });
}
}
public object CreateCallReason(CreateOrEditCallReasonDto 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," +
"DO_NOT_CALL_LIST," +
"CALLBACK," +
"CIC," +
"DURATION," +
"NOTES," +
"FOLLOW_UP," +
"STATUS," +
"CAMPAIGN_CATEGORY_ID) " +
"VALUES (" +
"@ID," +
"@CREATED_BY," +
"@DATE_ENTERED," +
"@MODIFIED_USER_ID," +
"@DATE_MODIFIED," +
"@NAME," +
"@CALL_RESULT_ID," +
"@DO_NOT_CALL_LIST," +
"@CALLBACK," +
"@CIC," +
"@DURATION," +
"@NOTES," +
"@FOLLOW_UP," +
"@STATUS," +
"@CAMPAIGN_CATEGORY_ID)";
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("@DO_NOT_CALL_LIST", input.DO_NOT_CALL_LIST);
param.Add("@CALLBACK", input.CALLBACK);
param.Add("@CIC", input.CIC);
param.Add("@DURATION", input.DURATION);
param.Add("@FOLLOW_UP", input.FOLLOW_UP);
param.Add("@CALL_RESULT_ID", input.CALL_RESULT_ID);
param.Add("@CAMPAIGN_CATEGORY_ID", (string.IsNullOrEmpty(input.CAMPAIGN_CATEGORY_ID) ? null : input.CAMPAIGN_CATEGORY_ID));
param.Add("@STATUS", input.STATUS);
DapperORM.Execute(sql, param);
sql = "INSERT INTO CALL_REASON_CSTM(ID_C,RECALL_TIME_C) Values(@ID,@RECALL_TIME_C)";
param.Add("@ID", Id);
param.Add("@RECALL_TIME_C", input.RECALL_TIME_C);
DapperORM.Execute(sql, param);
return(new { data = Id });
}
catch (Exception ex)
{
return(new { data = new { Message = ex.Message, ErrorCode = 600 } });
}
}