/// <summary>
/// Method to update the cases for TRC155 Macro
/// </summary>
/// <param name="objDOMacroUpdate"></param>
/// <param name="userid"></param>
/// <returns></returns>
public long UpdateCaseForTRC155Macro(DOMacroUpdate objDOMacroUpdate, long userid, out string errorMessage)
{
DALMacro objDALMacro = new DALMacro();
ExceptionTypes result = new ExceptionTypes();
result = objDALMacro.UpdateCaseForTRC155Macro(objDOMacroUpdate, userid, out errorMessage);
return((long)result);
}
/// <summary>
/// Method to update the cases for TRC155 Macro
/// </summary>
/// <param name="objDOMacroUpdate"></param>
/// <param name="userid"></param>
/// <returns></returns>
public ExceptionTypes UpdateCaseForTRC155Macro(DOMacroUpdate objDOMacroUpdate, long userid, out string errormessage)
{
DAHelper dah = new DAHelper();
long lErrocode = 0;
long lErrorNumber = 0;
errormessage = string.Empty;
SqlParameter sqlParam = new SqlParameter();
List <SqlParameter> _lstParameters = new List <SqlParameter>();
//call function to map object properties to SQL parameters for query execution
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@GEN_QueueId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOMacroUpdate.GEN_QueueId;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@Status";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOMacroUpdate.Status;
_lstParameters.Add(sqlParam);
//sqlParam = new SqlParameter();
//sqlParam.ParameterName = "@CurrentUser";
//sqlParam.SqlDbType = SqlDbType.VarChar;
//sqlParam.Value = objDOMacroUpdate.LoginID;
//_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ErrorMessage";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = string.Empty;
sqlParam.Direction = ParameterDirection.Output;
sqlParam.Size = 2000;
_lstParameters.Add(sqlParam);
long executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_UPD_TRC155_Macro, _lstParameters.ToArray(), out lErrocode, out lErrorNumber, out long lRowsEffected, out string errorMessage);
sqlParam = _lstParameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage");
if (sqlParam != null && sqlParam.Value != null)
{
errormessage += sqlParam.Value.ToString();
}
if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage))
{
return(ExceptionTypes.Success);
}
else
{
return(ExceptionTypes.UnknownError);
}
}
public HttpResponseMessage UpdateCaseForTRC155Macro(JObject jObj)
{
HttpResponseMessage response = new HttpResponseMessage();
if (jObj != null && jObj.Count > 0)
{
DOGEN_MacroServiceTrace objDOGEN_MacroServiceTrace = new DOGEN_MacroServiceTrace();
DOMacroUpdate item = JsonConvert.DeserializeObject <DOMacroUpdate>(jObj.ToString());
objDOGEN_MacroServiceTrace.GEN_QueueRef = item.GEN_QueueId;
long userid = _userid;
string error = string.Empty;
try
{
DOMacroUpdate inputModelPostData = ValidateByBaseSchema(jObj.ToString(), PATH_AUTHORIZATIONSCHEMA);
if (inputModelPostData != null && inputModelPostData.IsValid)
{
BLMacro objBLMacro = new BLMacro();
long result = objBLMacro.UpdateCaseForTRC155Macro(inputModelPostData, userid, out error);
if (result == 0 && string.IsNullOrEmpty(error))
{
objDOGEN_MacroServiceTrace.StatusLkup = (long)WebserviceStatus.Success;
var responseData = new { IsSuccess = true, Message = "TRC155 Macro updated for Gen_Queue id - " + inputModelPostData.GEN_QueueId };
objDOGEN_MacroServiceTrace.ResponseData = responseData.ToString();
response = Request.CreateResponse(HttpStatusCode.OK, responseData, (MediaTypeFormatter)Configuration.Formatters.JsonFormatter);
}
else
{
objDOGEN_MacroServiceTrace.StatusLkup = (long)WebserviceStatus.Failed;
var responseData = new { IsSuccess = true, Message = error + " Gen_Queue id - " + inputModelPostData.GEN_QueueId };
objDOGEN_MacroServiceTrace.ResponseData = responseData.ToString();
response = Request.CreateResponse(HttpStatusCode.OK, responseData, (MediaTypeFormatter)Configuration.Formatters.JsonFormatter);
}
}
else
{
objDOGEN_MacroServiceTrace.StatusLkup = (long)WebserviceStatus.Failed;
var responseData = new { IsSuccess = true, Message = inputModelPostData.ValidationMessage };
objDOGEN_MacroServiceTrace.ResponseData = responseData.ToString();
response = Request.CreateResponse(HttpStatusCode.OK, responseData, (MediaTypeFormatter)Configuration.Formatters.JsonFormatter);
}
objDOGEN_MacroServiceTrace.GEN_QueueRef = inputModelPostData.GEN_QueueId;
objDOGEN_MacroServiceTrace.MacroServiceMethodLkup = (long)MacroType.TRC155Macro;
objDOGEN_MacroServiceTrace.MacroServiceMethodName = MethodBase.GetCurrentMethod().Name;
objDOGEN_MacroServiceTrace.RequestData = jObj.ToString();
TraceWebApi(objDOGEN_MacroServiceTrace);
}
catch (Exception ex)
{
BLCommon.LogError(1, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Macro, (long)ExceptionTypes.Uncategorized, string.Empty, ex.Message);
response = Request.CreateResponse(HttpStatusCode.NotFound, ex.Message, (MediaTypeFormatter)Configuration.Formatters.JsonFormatter);
}
}
return(response);
}
public static DOMacroUpdate ValidateByBaseSchema(string InputJsonString, string JsonSchemaPath)
{
DOMacroUpdate iModel = null;
JsonSerializer serializer = new JsonSerializer();
IList <string> messages;
try
{
using (TextReader Schemareader = File.OpenText(JsonSchemaPath))
{
iModel = new DOMacroUpdate();
JObject InputJson = JObject.Parse(InputJsonString);
JsonSchema Inputschema = JsonSchema.Read(new JsonTextReader(Schemareader));
JsonTextReader reader = new JsonTextReader(new StringReader(InputJsonString));
JsonValidatingReader validatingReader = new JsonValidatingReader(reader);
validatingReader.Schema = Inputschema;
bool IsValid = InputJson.IsValid(Inputschema, out messages);
if (IsValid)
{
iModel = serializer.Deserialize <DOMacroUpdate>(validatingReader);
iModel.IsValid = true;
}
else
{
iModel.IsValid = false;
iModel.ValidationMessage = String.Join(",", messages.ToArray());
}
}
return(iModel);
}
catch (Exception ex)
{
iModel.IsValid = false;
iModel.ValidationMessage = ex.Message;
return(iModel);
}
}