public HttpResponseMessage GetRelationship([FromBody] MasterRelationship objstatus) { try { RelationshipContext objStateContext = new RelationshipContext(); IEnumerable <MasterRelationship> maritalStatuses = objStateContext.GetRelationship(objstatus); return(Request.CreateResponse(HttpStatusCode.OK, maritalStatuses)); } catch (Exception ex) { //objErrorLogServices.LogError("Client", "GetClient", "", "", ex.Message.ToString()); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Internal Server Error")); } }
public IEnumerable <MasterRelationship> GetRelationship(MasterRelationship objStatus) { try { using (sqlConnection = SqlUtility.GetConnection()) { IEnumerable <MasterRelationship> GetRelationship = sqlConnection.Query <MasterRelationship>("Usp_GetMstStateList", commandType: CommandType.StoredProcedure).ToList(); return(GetRelationship); } } catch (Exception ex) { throw ex; } }