public object UpdateCallStatus(CreateOrEditCallStatusDto input, string UserId)
{
try
{
DynamicParameters param = new DynamicParameters();
string sql = "UPDATE CALL_CATEGORY SET " +
"NAME=@NAME," +
"NOTES=@NOTES," +
"CALL_TYPE=@CALL_TYPE," +
"CAMPAIGN_CATEGORY_ID=@CAMPAIGN_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_TYPE", input.CALL_TYPE);
param.Add("@CAMPAIGN_CATEGORY_ID", input.CAMPAIGN_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 object CreateCallStatus(CreateOrEditCallStatusDto input, string UserId)
{
try
{
DynamicParameters param = new DynamicParameters();
String sql = "INSERT INTO CALL_CATEGORY (" +
"ID," +
"CREATED_BY," +
"DATE_ENTERED," +
"MODIFIED_USER_ID," +
"DATE_MODIFIED," +
"NAME," +
"NOTES," +
"CALL_TYPE," +
"STATUS," +
"CAMPAIGN_CATEGORY_ID) " +
"VALUES(" +
"@ID," +
"@CREATED_BY," +
"@DATE_ENTERED," +
"@MODIFIED_USER_ID," +
"@DATE_MODIFIED," +
"@NAME," +
"@NOTES," +
"@CALL_TYPE," +
"@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("@CALL_TYPE", input.CALL_TYPE);
param.Add("@STATUS", input.STATUS);
param.Add("@CAMPAIGN_CATEGORY_ID", input.CAMPAIGN_CATEGORY_ID);
DapperORM.Execute(sql, param);
sql = "INSERT INTO CALL_CATEGORY_CSTM (ID_C,LIST_ORDER_C) VALUES(@ID,(SELECT MAX(CONVERT(INT,LIST_ORDER_C) + 1)AS MAX FROM vwCALL_CATEGORY))";
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 } });
}
}
public IActionResult CreateOrEditCallStatus(CreateOrEditCallStatusDto input)
{
if (input.ID == Guid.Empty.ToString() || string.IsNullOrEmpty(input.ID))
{
return(Ok(_callCategoryRepository.CreateCallStatus(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
else
{
return(Ok(_callCategoryRepository.UpdateCallStatus(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
}
