Example #1
0
 public IEnumerable <MasterMaritalStatus> GetMaritalStatus(MasterMaritalStatus objStatus)
 {
     try
     {
         using (sqlConnection = SqlUtility.GetConnection())
         {
             IEnumerable <MasterMaritalStatus> GetMaritalStatus = sqlConnection.Query <MasterMaritalStatus>("Usp_GetMstStateList", commandType: CommandType.StoredProcedure).ToList();
             return(GetMaritalStatus);
         }
     }
     catch (Exception ex) {
         throw ex;
     }
 }
Example #2
0
        public HttpResponseMessage GetMaritalStatus([FromBody] MasterMaritalStatus objstatus)
        {
            try
            {
                MaritalStatusContext objStateContext = new MaritalStatusContext();

                IEnumerable <MasterMaritalStatus> maritalStatuses = objStateContext.GetMaritalStatus(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"));
            }
        }