コード例 #1
0
        public List <NewEmployeeDTO> GetNewEmployeeList(GetNewEmployeeDTO objEmployee)
        {
            List <NewEmployeeDTO> employeelist = new List <NewEmployeeDTO>();

            using (DbLayer dbLayer = new DbLayer())
            {
                SqlCommand SqlCmd = new SqlCommand("spSelectLead");
                SqlCmd.CommandType = CommandType.StoredProcedure;
                SqlCmd.Parameters.AddWithValue("@State", objEmployee.State);
                SqlCmd.Parameters.AddWithValue("@OldLead", objEmployee.OldLead);
                SqlCmd.Parameters.AddWithValue("@ActionBy", objEmployee.ActionBy);
                employeelist = dbLayer.GetEntityList <NewEmployeeDTO>(SqlCmd);
            }
            return(employeelist);
        }
コード例 #2
0
        public HttpResponseMessage GetNewEmployeeList(GetNewEmployeeDTO objEmployee)
        {
            HttpResponseMessage message;

            try
            {
                // ClientLeadChangeDataAccessLayer dal = new ClientLeadChangeDataAccessLayer();
                var dynObj = new { result = _clientServices.GetNewEmployeeList(objEmployee) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" });
                ErrorLog.CreateErrorMessage(ex, "ClientLeadChange", "GetOldEmployeeList");
            }
            return(message);
        }