コード例 #1
0
        public GetAgeCalculationDTO GetAgeCalculation(GetAgeDTO objGetAge)
        {
            GetAgeCalculationDTO age = new GetAgeCalculationDTO();

            using (DbLayer dbLayer = new DbLayer())
            {
                SqlCommand SqlCmd = new SqlCommand("spAgeCalculation");
                SqlCmd.Parameters.AddWithValue("@dob", objGetAge.DateofBirth);
                SqlCmd.CommandType = CommandType.StoredProcedure;
                age = dbLayer.GetEntityList <GetAgeCalculationDTO>(SqlCmd).FirstOrDefault();
            }
            return(age);
        }
コード例 #2
0
        public HttpResponseMessage GetAgeCalculation(GetAgeDTO objGetAge)
        {
            HttpResponseMessage message;

            try
            {
                // ManPowerDataAccessLayer dal = new ManPowerDataAccessLayer();
                var dynObj = new { result = _obj.GetAgeCalculation(objGetAge) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
                ErrorLog.CreateErrorMessage(ex, "ManPower", "GetAge");
            }
            return(message);
        }