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 HttpResponseMessage GetCasesForNOTMacro(string HouseholdID = null, string HICN = null, string PlanContract = null, string PlanPBP = null, string EffectiveDate = null, string CaseType = null) { DOGEN_MacroServiceTrace objDOGEN_MacroServiceTrace = new DOGEN_MacroServiceTrace(); HttpContextBase abstractContext = new HttpContextWrapper(System.Web.HttpContext.Current); var url = abstractContext.Request.Url; HttpResponseMessage responseMessage = new HttpResponseMessage(); BLMacro objBLMacro = new BLMacro(); try { List <DOMacroData> lstDOMacroNotOpenData = new List <DOMacroData>(); string errorMessage = string.Empty; lstDOMacroNotOpenData = objBLMacro.GetOpenNotMacro(HouseholdID, HICN, PlanContract, PlanPBP, EffectiveDate, CaseType, out errorMessage); if (lstDOMacroNotOpenData.Count > 0) { var responseData = new { IsSuccess = true, Message = "", data = lstDOMacroNotOpenData }; objDOGEN_MacroServiceTrace.StatusLkup = (long)WebserviceStatus.Success; //success with data responseMessage = Request.CreateResponse(HttpStatusCode.OK, responseData, Configuration.Formatters.JsonFormatter); var output = JsonConvert.SerializeObject(lstDOMacroNotOpenData); objDOGEN_MacroServiceTrace.ResponseData = output.ToString(); } else { objDOGEN_MacroServiceTrace.StatusLkup = (long)WebserviceStatus.Failed; var responseData = new { IsSuccess = false, Message = "No records found for provided input", data = new List <string>() }; //success with no data responseMessage = Request.CreateResponse(HttpStatusCode.OK, responseData, Configuration.Formatters.JsonFormatter); objDOGEN_MacroServiceTrace.ResponseData = "No records found for provided input"; } } catch (Exception ex) { var responseData = new { IsSuccess = false, Message = ex.Message, data = new List <string>() }; BLCommon.LogError(1, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Macro, (long)ExceptionTypes.Uncategorized, string.Empty, ex.Message); responseMessage = Request.CreateResponse(HttpStatusCode.ExpectationFailed, responseData); } objDOGEN_MacroServiceTrace.MacroServiceMethodLkup = (long)MacroType.NOTMacro; objDOGEN_MacroServiceTrace.MacroServiceMethodName = MethodBase.GetCurrentMethod().Name; objDOGEN_MacroServiceTrace.RequestData = url.ToString(); TraceWebApi(objDOGEN_MacroServiceTrace); return(responseMessage); }
public void TraceWebApi(DOGEN_MacroServiceTrace objDOGEN_MacroServiceTrace) { BLServiceRequestResponse objBLServiceRequestResponse = new BLServiceRequestResponse(); objBLServiceRequestResponse.InsertMacroServiceTrace(objDOGEN_MacroServiceTrace); }
public ExceptionTypes InsertMacroServiceTrace(DOGEN_MacroServiceTrace objDOGEN_MacroServiceTrace) { long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; string errorMessage = string.Empty; try { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_QueueRef"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOGEN_MacroServiceTrace.GEN_QueueRef; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@MacroServiceMethodLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOGEN_MacroServiceTrace.MacroServiceMethodLkup; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@MacroServiceMethodName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_MacroServiceTrace.MacroServiceMethodName; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@RequestData"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_MacroServiceTrace.RequestData; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ResponseData"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_MacroServiceTrace.ResponseData; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_MacroServiceTrace.CreatedByRef; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@Statuslkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOGEN_MacroServiceTrace.StatusLkup; parameters.Add(sqlParam); long executionResult = 0; executionResult = _objDAHelper.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_GEN_MacroServiceTrace, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); if (executionResult == 0) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { return(ExceptionTypes.UnknownError); } }
public ExceptionTypes InsertMacroServiceTrace(DOGEN_MacroServiceTrace objDOGEN_MacroServiceTrace) { _retValue = new ExceptionTypes(); return(_retValue = _objDALServiceRequestResponse.InsertMacroServiceTrace(objDOGEN_MacroServiceTrace)); }